public static void AddQuery(AddQueryBLL obj) { string JobCardNo = obj.JobCardNo; using (var dbcontext = new BSSDBEntities()) { var Check = dbcontext.TblJobCardHdrs.Where(x => x.JobCardNo == JobCardNo).FirstOrDefault(); if (Check == null) { TblJobCardHdr TR = new TblJobCardHdr { JobCardNo = obj.JobCardNo, DateAndTime = DateTime.Now, CustomerName = obj.CustomerName, PhoneNo = obj.PhoneNo, CustomerCategory = obj.CustomerCategory, PSFStatus = obj.PSFStatus, RegistrationNo = obj.RegistrationNo, Model = obj.Model, SA = obj.SA, Technician = obj.Technician, Service = obj.Service, PromisedDate = obj.PromisedDate }; dbcontext.Entry(TR).State = EntityState.Added; dbcontext.SaveChanges(); var JobCardId = dbcontext.TblJobCardHdrs.Where(x => x.JobCardNo == JobCardNo).Select(s => s.JobCardId).FirstOrDefault(); TblJobCardDtl tb = new TblJobCardDtl { JobCardId = JobCardId, No_Of_Panel = obj.NoOfPanel, PanelReplaced = obj.PanelReplaced, //Status=obj.Status }; dbcontext.Entry(tb).State = EntityState.Added; dbcontext.SaveChanges(); } } }
public static void InsertData(DataTable info, SessionDataBLL obj) { using (var context = new BSSDBEntities()) { var dt1 = context.TblJobCardHdrs.ToList(); foreach (DataRow Dr in info.Rows) { string JobCardNo = Dr["Job Card No."].ToString().Trim(); if (JobCardNo != null && JobCardNo != string.Empty) { //LogService("JobCardNo: " + JobCardNo); //LogService("************************: " + DateTime.Now.ToString()); string DateAndTime1 = Convert.ToString(Dr["Date & Time"]); //LogService("DateAndTime1: " + DateAndTime1); //LogService("************************: " + DateTime.Now.ToString()); DateTime DateAndTime = Convert.ToDateTime(DateAndTime1); //LogService("DateAndTime: " + DateAndTime); //LogService("************************: " + DateTime.Now.ToString()); //DateTime DateAndTime = Convert.ToDateTime(Dr["Date & Time"]); string CustomerName = Convert.ToString(Dr["Customer Name"]); long PhoneNo = Convert.ToInt64(Dr["Phone & Mobile No."]); string CustomerCategory = Convert.ToString(Dr["Customer Catg."]); string PSFStatus = Convert.ToString(Dr["PSF Status"]); string RegistrationNo = Convert.ToString(Dr["Registration"]); string Model = Convert.ToString(Dr["Model"]); string SA = Convert.ToString(Dr["S.A"]); string Technician = Convert.ToString(Dr["Technician"]); string Service = Convert.ToString(Dr["Service"]); string PromisedDate = Convert.ToString(Dr["Promised Dt."]); //LogService("PromisedDate: " + PromisedDate); //LogService("************************: " + DateTime.Now.ToString()); string RevPromisedDate = Convert.ToString(Dr["Rev. Promised Dt."]);// Dr["Rev. Promised Dt."].ToString(); //LogService("RevPromisedDate: " + RevPromisedDate); //LogService("************************: " + DateTime.Now.ToString()); //DateTime RevDATE = Convert.ToDateTime(Dr["Rev. Promised Dt."]); string ReadyDateTime = Convert.ToString(Dr["Ready Date & Time"]); //LogService("ReadyDateTime: " + ReadyDateTime); //LogService("************************: " + DateTime.Now.ToString()); var Check = context.TblJobCardHdrs.Where(x => x.JobCardNo == JobCardNo && x.DealerID == obj.DealerID).FirstOrDefault(); if (Check == null) { TblJobCardHdr dt = new TblJobCardHdr { JobCardNo = JobCardNo, DateAndTime = DateAndTime, CustomerName = CustomerName, PhoneNo = PhoneNo, CustomerCategory = CustomerCategory, PSFStatus = PSFStatus, RegistrationNo = RegistrationNo, Model = Model, SA = SA, Technician = Technician, Service = Service, PromisedDate = PromisedDate, RevPromisedDate = RevPromisedDate, ReadyDateTime = ReadyDateTime, AccountID = obj.AccountId, DealerID = obj.DealerID, CreatedBy = obj.UserId, CreationDate = DateTime.Now }; context.Entry(dt).State = EntityState.Added; context.SaveChanges(); InsertIntoTblDtl(JobCardNo, obj); } else { continue; } } } } }