Esempio n. 1
0
        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);
 }