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));
}
