foreach (var itemsubClass in showfareDetail.BindClass) { if (itemsubClass.Active == 1) { var checkDetail = session.Query().Where(x => x.ProjectID.Equals(loginInfo.ProjectID) && x.PlazaID.Equals(loginInfo.PlazaID) && x.ID == newFare.ID && x.PaymentMeansID == itemsubClass.PaymentMeansID && x.ClassID == itemsubClass.ClassID && x.SUBClassID == itemsubClass.SubClassID).FirstOrDefault(); // check source and destination plaza. if (checkDetail == null) // no exist fare. { addedDate = addedDate.AddSeconds(1); NewFareDetail detail = new NewFareDetail(); detail.ProjectID = loginInfo.ProjectID; detail.PlazaID = loginInfo.PlazaID; detail.CPlazaID = loginInfo.PlazaID; detail.DPlazaID = loginInfo.PlazaID; detail.ID = insertID; detail.PaymentMeansID = itemsubClass.PaymentMeansID; detail.ClassID = itemsubClass.ClassID; detail.SUBClassID = itemsubClass.SubClassID; detail.Amount = 0.00M; detail.BaseFare = 0.00M; detail.AddedDate = addedDate; session.Merge(detail); } else { } } } 1 this.ClassID + '_' + 2 this.SubClassID + '_' + 3 getAllData.JurneyType[idx].PaymentMeansID + '_' + 4 EditRow.ProjectID + '_' + 5 EditRow.CPlazaID + '_' + 6 EditRow.PlazaID + '_' + 7 EditRow.ID + '_' + 8 this.IsExempted + '_' + 9 this.Description; 10 tripid