public bool Update(int id, JobRequestClose model) { throw new NotImplementedException(); }
public IHttpActionResult PostJobReqClose(JobRequestClose obj) { return(Ok(jobRequestcloseService.Insert(obj))); }
public bool Insert(JobRequestClose model) { using (var dbTransaction = context.Database.BeginTransaction()) { try { if (model != null) { var update = context.JobRequestClose.Where(x => x.JobRequestCloseID == model.JobRequestCloseID).FirstOrDefault(); if (update != null) { update.AmountMounth = model.AmountMounth; update.CompanyName = model.CompanyName; update.ContactFax = model.ContactFax; update.ContactFax = model.ContactFax; update.ContactMobile = model.ContactMobile; update.ContactName = model.ContactName; update.ContactTel = model.ContactTel; update.DocDeliverAddress = model.DocDeliverAddress; update.ConditionBill = model.ConditionBill; update.ConditionPayBill = model.ConditionPayBill; update.PeriodPay = model.PeriodPay; update.Location = model.Location; update.Remark = model.Remark; update.serviceChargeNextDate = model.serviceChargeNextDate; update.serviceChargePMonthStartDate = model.serviceChargePMonthStartDate; update.serviceChargePYearStartDate = model.serviceChargePYearStartDate; update.serviceChargeRentStartDate = model.serviceChargeRentStartDate; update.TaxID = model.TaxID; update.UpdBy = model.UpdBy; update.UpdDateTime = DateTime.Now; foreach (InstallMent item in model.InstallMent) { var updateinstallment = context.InstallMent.Where(x => x.InstallMentID == item.InstallMentID).FirstOrDefault(); if (updateinstallment != null) { updateinstallment.PayDate = item.PayDate; updateinstallment.Price = item.Price; updateinstallment.UpdBy = item.UpdBy; updateinstallment.UpdDateTime = DateTime.Now; } } foreach (ServiceCharge item in model.ServiceCharge) { var updateservice = context.ServiceCharge.Where(x => x.ServiceID == item.ServiceID).FirstOrDefault(); if (updateservice != null) { updateservice.Amount = item.Amount; updateservice.OptionID = item.OptionID; updateservice.Price = item.Price; updateservice.ServiceChargeID = item.ServiceChargeID; updateservice.TotalPricee = item.TotalPricee; updateservice.UpdBy = item.UpdBy; updateservice.UpdDateTime = DateTime.Now; } } //foreach (string carid in model.CarIDs.Split(',').Where(x => x != "" || x != null)) //{ // Car c = context.Car.Find(Convert.ToInt32(carid)); // if (c != null) // { // context.Car.Remove(c); // } //} //foreach (string boxid in model.BoxIDs.Split(',').Where(x => x != "" || x != null)) //{ // Box c = context.Box.Find(Convert.ToInt32(boxid)); // if (c != null) // { // context.Box.Remove(c); // } //} } else { model.InsDateTime = DateTime.Now; //var jobtype = context.Master_D.Where(x => x.prmid == model.JobRequestType).Select(x => x.endesc).FirstOrDefault(); model.JobRequestCloseNo = GenerateJobCodeDB(); context.JobRequestClose.Add(model); context.SaveChanges(); for (int i = 0; i < model.ServiceCharge.Count; i++) { model.ServiceCharge[i].JobRequestCloseID = model.JobRequestCloseID; model.ServiceCharge[i].Seq = i + 1; model.ServiceCharge[i].InsDateTime = DateTime.Now; context.ServiceCharge.Add(model.ServiceCharge[i]); context.SaveChanges(); } for (int i = 0; i < model.InstallMent.Count; i++) { model.InstallMent[i].Seq = i + 1; model.InstallMent[i].InsDateTime = DateTime.Now; model.InstallMent[i].JobRequestCloseID = model.JobRequestCloseID; context.InstallMent.Add(model.InstallMent[i]); context.SaveChanges(); } } foreach (Car item in model.Car) { var updatecar = context.Car.Where(x => x.CarID == item.CarID).FirstOrDefault(); if (updatecar != null) { updatecar.ServiceReportBookNo = item.ServiceReportBookNo; updatecar.ServiceRportNo = item.ServiceRportNo; updatecar.NewServiceReportBookNo = item.NewServiceReportBookNo; updatecar.NewServiceRportNo = item.NewServiceRportNo; updatecar.UpdBy = item.UpdBy; updatecar.UpdDateTime = DateTime.Now; } } foreach (Box item in model.Box) { var updatebox = context.Box.Where(x => x.BoxID == item.BoxID).FirstOrDefault(); if (updatebox != null) { //updatebox.AmountCameraDVR = item.AmountCameraDVR; //updatebox.APN = item.APN; //updatebox.BatteryID = item.BatteryID; //updatebox.CarID = item.CarID; //updatebox.DeviceID = item.DeviceID; //updatebox.ElectricVoltID = item.ElectricVoltID; //updatebox.FirmWareID = item.FirmWareID; //updatebox.IP = item.IP; //updatebox.LimitSpeedID = item.LimitSpeedID; //updatebox.Password = item.Password; //updatebox.Port = item.Port; //updatebox.SerialDVRNumber = item.SerialDVRNumber; updatebox.SerialNumber = item.SerialNumber; //updatebox.SimTypeID = item.SimTypeID; //updatebox.SoundAlertID = item.SoundAlertID; //updatebox.TimeSendDataID = item.TimeSendDataID; updatebox.UpdBy = item.UpdBy; updatebox.UpdDateTime = DateTime.Now; //updatebox.Username = item.Username; updatebox.VID = item.VID; updatebox.InstallDate = item.InstallDate; updatebox.UnstallDate = item.UnstallDate; //updatebox.warrantydateEnd = item.warrantydateEnd; //updatebox.warrantydateStart = item.warrantydateStart; } } context.SaveChanges(); dbTransaction.Commit(); } } catch (Exception e) { var joke = e.Message.ToString(); dbTransaction.Rollback(); return(false); } } return(true); }
public bool Insert(JobRequestClose model) { return(jobRequestCloseRepository.Insert(model)); }