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(); } } }
// POST api/<controller> public void Post([FromBody] AddQueryBLL obj) { AddQueryDAL.AddQuery(obj); }