public ActionResult ClosePeriod()
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
Debit_PeriodReportOprih debit_PeriodReportOprih = db.Debit_PeriodReportOprih.Find(db.Debit_PeriodReportOprih.Max(d => d.id));
bool valid = ValidationClosePeriod(debit_PeriodReportOprih.id);
if (valid == true)
{
debit_PeriodReportOprih.close = true;
debit_PeriodReportOprih.dateTimeClose = DateTime.Now;
db.Entry(debit_PeriodReportOprih).State = EntityState.Modified;
db.SaveChanges();
var listDate = db.Debit_DataReportOprih.Where(d => d.id_Debit_PeriodReportOprih == debit_PeriodReportOprih.id).ToList();
foreach (var data in listDate)
{
Debit_WorkBit debit_WorkBit = db.Debit_WorkBit.First(d => d.id == data.id_DebitWork);
debit_WorkBit.close = data.oprihClose;
debit_WorkBit.dateClose = data.dateOprihPlanFact;
db.Entry(debit_WorkBit).State = EntityState.Modified;
db.SaveChanges();
if (debit_WorkBit.close == true)
{
CreateNewTasks(28, debit_WorkBit.id_PlanZakaz);
}
ClosePredoplataTask(debit_WorkBit.id_PlanZakaz);
}
EmailDeb mail = new EmailDeb(debit_PeriodReportOprih.period);
mail.SendEmail();
}
return(RedirectToAction("Index", "ActiveReport", new { area = "Deb" }));
}
}
void CreateNewTasks(int predecessors, int idOrder)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
List <TaskForPZ> dateTaskWork = db.TaskForPZ.Where(w => w.Predecessors == predecessors).Where(z => z.id_TypeTaskForPZ == 1).ToList();
foreach (var data in dateTaskWork)
{
Debit_WorkBit newDebit_WorkBit = new Debit_WorkBit();
newDebit_WorkBit.dateCreate = DateTime.Now;
newDebit_WorkBit.close = false;
newDebit_WorkBit.id_PlanZakaz = idOrder;
newDebit_WorkBit.id_TaskForPZ = data.id;
newDebit_WorkBit.datePlanFirst = DateTime.Now.AddDays(data.time);
newDebit_WorkBit.datePlan = DateTime.Now.AddDays(data.time);
db.Debit_WorkBit.Add(new Debit_WorkBit()
{
close = false,
dateClose = null,
dateCreate = DateTime.Now,
datePlan = newDebit_WorkBit.datePlan,
datePlanFirst = newDebit_WorkBit.datePlanFirst,
id_PlanZakaz = newDebit_WorkBit.id_PlanZakaz,
id_TaskForPZ = newDebit_WorkBit.id_TaskForPZ
});
db.SaveChanges();
}
}
}
string GetStatusName(Debit_WorkBit debit_WorkBit)
{
string statusName = "Не оплачен";
if (debit_WorkBit.close == true)
{
statusName = "Оплачен";
}
if (debit_WorkBit.id_TaskForPZ == 38)
{
statusName = "Внести предоплату";
}
return(statusName);
}
public JsonResult UpdateLetter(int id, HttpPostedFileBase[] ofile1)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
Debit_WorkBit debit_WorkBit = db.Debit_WorkBit.Find(id);
debit_WorkBit.close = true;
debit_WorkBit.dateClose = DateTime.Now;
db.Entry(debit_WorkBit).State = EntityState.Modified;
db.SaveChanges();
return(Json(1, JsonRequestBehavior.AllowGet));
}
}
void ClosePredoplataTask(int planZakaz)
{
try
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
Debit_WorkBit debit_WorkBit = db.Debit_WorkBit.Where(d => d.id_TaskForPZ == 38).Where(d => d.id_PlanZakaz == planZakaz).First();
debit_WorkBit.close = true;
db.Entry(debit_WorkBit).State = EntityState.Modified;
db.SaveChanges();
}
}
catch
{
}
}
public JsonResult UpdateDefault(int id, bool checkedDefault)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
Debit_WorkBit debit_WorkBit = db.Debit_WorkBit.Find(id);
if (checkedDefault == true)
{
debit_WorkBit.close = true;
debit_WorkBit.dateClose = DateTime.Now;
db.Entry(debit_WorkBit).State = EntityState.Modified;
db.SaveChanges();
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Update(Debit_CostUpdate debit_CostUpdate, float mcost, DateTime mdateGetMoney)
{
Debit_CostUpdate newCost = db.Debit_CostUpdate.Find(debit_CostUpdate.id);
Debit_WorkBit debit_WorkBit = db.Debit_WorkBit.Where(d => d.id_PlanZakaz == newCost.id_PZ_PlanZakaz & d.id_TaskForPZ == 15).First();
if (mdateGetMoney.Year < 2010)
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
if (mcost == 0)
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
newCost.cost = mcost;
newCost.dateGetMoney = mdateGetMoney;
db.Entry(newCost).State = EntityState.Modified;
db.SaveChanges();
PZ_TEO pZ_TEO = db.PZ_TEO.Where(d => d.Id_PlanZakaz == newCost.id_PZ_PlanZakaz).First();
double nds = 0;
try
{
nds = (double)pZ_TEO.NDS;
}
catch
{
}
double costCorrect = nds + (double)pZ_TEO.OtpuskChena;
double costNow = 0;
foreach (var data in db.Debit_CostUpdate.Where(d => d.id_PZ_PlanZakaz == newCost.id_PZ_PlanZakaz))
{
costNow += data.cost;
}
if (costCorrect - costNow == 0)
{
debit_WorkBit.close = true;
debit_WorkBit.dateClose = DateTime.Now;
db.Entry(debit_WorkBit).State = EntityState.Modified;
db.SaveChanges();
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
public ActionResult NewPlus(Debit_CostUpdate debit_CostUpdate)
{
Debit_WorkBit debit_WorkBit = db.Debit_WorkBit.Where(d => d.id_PlanZakaz == debit_CostUpdate.id_PZ_PlanZakaz & d.id_TaskForPZ == 15).First();
if (debit_CostUpdate.dateGetMoney.Year < 2010)
{
return(RedirectToAction("NewPlus", "Upload", new { debit_WorkBit.id, area = "Deb" }));
}
if (debit_CostUpdate.cost == 0)
{
return(RedirectToAction("NewPlus", "Upload", new { debit_WorkBit.id, area = "Deb" }));
}
PZ_PlanZakaz pZ_PlanZakaz = db.PZ_PlanZakaz.Find(debit_CostUpdate.id_PZ_PlanZakaz);
debit_CostUpdate.id_PZ_PlanZakaz = pZ_PlanZakaz.Id;
debit_CostUpdate.dateCreate = DateTime.Now;
db.Debit_CostUpdate.Add(debit_CostUpdate);
db.SaveChanges();
PZ_TEO pZ_TEO = db.PZ_TEO.Where(d => d.Id_PlanZakaz == debit_CostUpdate.id_PZ_PlanZakaz).First();
double nds = 0;
try
{
nds = (double)pZ_TEO.NDS;
}
catch
{
}
double costCorrect = nds + (double)pZ_TEO.OtpuskChena;
double costNow = 0;
foreach (var data in db.Debit_CostUpdate.Where(d => d.id_PZ_PlanZakaz == debit_CostUpdate.id_PZ_PlanZakaz))
{
costNow += data.cost;
}
if (costCorrect - costNow == 0)
{
debit_WorkBit.close = true;
debit_WorkBit.dateClose = DateTime.Now;
db.Entry(debit_WorkBit).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index", "Upload", new { area = "Deb" }));
}
public JsonResult СreateTask38С(int[] PZ)
{
foreach (int data in PZ)
{
int countPZ = db.Debit_WorkBit.Where(d => d.id_TaskForPZ == 28 || d.id_TaskForPZ == 38).Where(d => d.id_PlanZakaz == data).Count();
if (countPZ == 0)
{
Debit_WorkBit debit_WorkBit = new Debit_WorkBit();
debit_WorkBit.id_PlanZakaz = data;
debit_WorkBit.close = false;
debit_WorkBit.dateCreate = DateTime.Now;
debit_WorkBit.datePlan = DateTime.Now;
debit_WorkBit.datePlanFirst = DateTime.Now;
debit_WorkBit.id_TaskForPZ = 38;
db.Debit_WorkBit.Add(debit_WorkBit);
db.SaveChanges();
}
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
public ActionResult NewPlus(int id)
{
double getCost = 0;
Debit_WorkBit debit_WorkBit = db.Debit_WorkBit.Find(id);
ViewBag.PlanZakaz = db.PZ_PlanZakaz.Find(debit_WorkBit.id_PlanZakaz).PlanZakaz.ToString();
ViewBag.idPlanZakaz = db.PZ_PlanZakaz.Find(debit_WorkBit.id_PlanZakaz).Id;
System.Globalization.NumberFormatInfo numForInf = new System.Globalization.CultureInfo("en-US", false).NumberFormat;
ViewBag.Cost = db.PZ_TEO.Where(d => d.Id_PlanZakaz == debit_WorkBit.id_PlanZakaz).First().OtpuskChena.ToString("N", numForInf);
ViewBag.Curency = db.PZ_TEO.Where(d => d.Id_PlanZakaz == debit_WorkBit.id_PlanZakaz).First().PZ_Currency.Name.ToString();
var listCost = db.Debit_CostUpdate.Where(d => d.id_PZ_PlanZakaz == debit_WorkBit.id_PlanZakaz).ToList();
foreach (var data in listCost)
{
getCost += data.cost;
}
ViewBag.GetCost = getCost.ToString("N", numForInf);
PZ_TEO pZ_TEO = db.PZ_TEO.Where(d => d.Id_PlanZakaz == debit_WorkBit.id_PlanZakaz).First();
double nds = 0;
double ndsCost = pZ_TEO.OtpuskChena;
if (pZ_TEO.NDS != null)
{
ndsCost += (double)pZ_TEO.NDS;
nds += (double)pZ_TEO.NDS;
}
ViewBag.NDS = nds.ToString("N", numForInf);
ViewBag.CostNDS = ndsCost.ToString("N", numForInf);
ViewBag.PostCost = (ndsCost - getCost).ToString("N", numForInf);
ViewBag.listCost = listCost.ToList();
PZ_Setup pZ_Setup = db.PZ_Setup.First(d => d.id_PZ_PlanZakaz == debit_WorkBit.id_PlanZakaz);
ViewBag.UslovieOplat = pZ_Setup.UslovieOplatyText;
ViewBag.UslovieOplat = pZ_Setup.PunktDogovoraOSrokahPriemki;
Debit_CostUpdate dc = new Debit_CostUpdate();
dc.id_PZ_PlanZakaz = debit_WorkBit.id_PlanZakaz;
return(View(dc));
}
public NewPlanZakaz(PZ_PlanZakaz pZ_PlanZakaz, bool addDebitWork)
{
int numberPZ = db.PZ_PlanZakaz.Where(d => d.PlanZakaz < 9000).Max(d => d.PlanZakaz) + 1;
PZ_PlanZakaz newPZ_PlanZakaz = new PZ_PlanZakaz()
{
PlanZakaz = numberPZ,
DateCreate = DateTime.Now,
MTR = pZ_PlanZakaz.MTR,
Name = pZ_PlanZakaz.Name,
OL = pZ_PlanZakaz.OL,
Zapros = pZ_PlanZakaz.Zapros,
DateSupply = pZ_PlanZakaz.DateSupply,
DateShipping = pZ_PlanZakaz.DateShipping,
Cost = pZ_PlanZakaz.Cost,
Description = pZ_PlanZakaz.Description,
ProductType = pZ_PlanZakaz.ProductType,
Dostavka = pZ_PlanZakaz.Dostavka,
Manager = pZ_PlanZakaz.Manager,
Client = pZ_PlanZakaz.Client,
Gruzopoluchatel = pZ_PlanZakaz.Gruzopoluchatel,
PostAdresGruzopoluchatel = pZ_PlanZakaz.PostAdresGruzopoluchatel,
INNGruzopoluchatel = pZ_PlanZakaz.INNGruzopoluchatel,
OKPOGruzopoluchatelya = pZ_PlanZakaz.OKPOGruzopoluchatelya,
KodGruzopoluchatela = pZ_PlanZakaz.KodGruzopoluchatela,
StantionGruzopoluchatel = pZ_PlanZakaz.StantionGruzopoluchatel,
KodStanciiGruzopoluchatelya = pZ_PlanZakaz.KodStanciiGruzopoluchatelya,
OsobieOtmetkiGruzopoluchatelya = pZ_PlanZakaz.OsobieOtmetkiGruzopoluchatelya,
DescriptionGruzopoluchatel = pZ_PlanZakaz.DescriptionGruzopoluchatel,
Folder = pZ_PlanZakaz.Folder,
Modul = pZ_PlanZakaz.Modul,
timeContract = pZ_PlanZakaz.timeContract,
timeContractDate = pZ_PlanZakaz.timeContractDate,
timeArr = pZ_PlanZakaz.timeArr,
timeArrDate = pZ_PlanZakaz.timeArrDate,
id_PZ_FIO = pZ_PlanZakaz.id_PZ_FIO,
numZakupki = pZ_PlanZakaz.numZakupki,
numLota = pZ_PlanZakaz.numLota,
dataOtgruzkiBP = pZ_PlanZakaz.dataOtgruzkiBP,
ProjectUID = pZ_PlanZakaz.ProjectUID,
nameTU = pZ_PlanZakaz.nameTU,
TypeShip = pZ_PlanZakaz.TypeShip,
criticalDateShip = pZ_PlanZakaz.criticalDateShip,
nomenklaturNumber = pZ_PlanZakaz.nomenklaturNumber,
costSMR = pZ_PlanZakaz.costSMR,
costPNR = pZ_PlanZakaz.costPNR,
id_PZ_OperatorDogovora = pZ_PlanZakaz.id_PZ_OperatorDogovora,
PowerST = pZ_PlanZakaz.PowerST,
VN_NN = pZ_PlanZakaz.VN_NN
};
db.PZ_PlanZakaz.Add(newPZ_PlanZakaz);
db.SaveChanges();
Reclamation_CloseOrder reclamation_CloseOrder = new Reclamation_CloseOrder
{
close = false,
dateTimeClose = DateTime.Now,
description = "",
id_PZ_PlanZakaz = newPZ_PlanZakaz.Id,
userClose = newPZ_PlanZakaz.Manager
};
db.Reclamation_CloseOrder.Add(reclamation_CloseOrder);
db.SaveChanges();
PZ_TEO pZ_TEO = new PZ_TEO
{
Currency = 1,
NDS = 0,
Rate = 0,
SSM = 0,
SSR = 0,
IzdKom = 0,
IzdPPKredit = 0,
PI = 0,
NOP = 0,
KI_S = 0,
KI_prochee = 0,
Id_PlanZakaz = newPZ_PlanZakaz.Id
};
db.PZ_TEO.Add(pZ_TEO);
db.SaveChanges();
PZ_Setup pZ_Setup = new PZ_Setup
{
KolVoDneyNaPrijemku = 0,
PunktDogovoraOSrokahPriemki = "",
RassmotrenieRKD = 0,
SrokZamechanieRKD = 0,
TimeNaRKD = 0,
UslovieOplatyInt = 0,
UslovieOplatyText = "",
id_PZ_PlanZakaz = newPZ_PlanZakaz.Id
};
db.PZ_Setup.Add(pZ_Setup);
db.SaveChanges();
Debit_Platform debit_Platform = new Debit_Platform
{
id_PlanZakaz = newPZ_PlanZakaz.Id,
countPlatform = 0,
gabar = "",
massa = 0,
numPlatform = "",
numPlomb = ""
};
db.Debit_Platform.Add(debit_Platform);
db.SaveChanges();
if (addDebitWork == true)
{
List <TaskForPZ> dateTaskWork = db.TaskForPZ.Where(w => w.step == 1).Where(z => z.id_TypeTaskForPZ == 1).ToList();
foreach (var data in dateTaskWork)
{
Debit_WorkBit newDebit_WorkBit = new Debit_WorkBit();
newDebit_WorkBit.dateCreate = DateTime.Now;
newDebit_WorkBit.close = false;
newDebit_WorkBit.id_PlanZakaz = newPZ_PlanZakaz.Id;
newDebit_WorkBit.id_TaskForPZ = (int)data.id;
newDebit_WorkBit.datePlanFirst = DateTime.Now.AddDays((double)data.time);
newDebit_WorkBit.datePlan = DateTime.Now.AddDays((double)data.time);
db.Debit_WorkBit.Add(new Debit_WorkBit()
{
close = false,
dateClose = null,
dateCreate = DateTime.Now,
datePlan = newDebit_WorkBit.datePlan,
datePlanFirst = newDebit_WorkBit.datePlanFirst,
id_PlanZakaz = newDebit_WorkBit.id_PlanZakaz,
id_TaskForPZ = newDebit_WorkBit.id_TaskForPZ
});
db.SaveChanges();
}
}
}
public NewPlanZakaz(PZ_PlanZakaz pZ_PlanZakaz, bool addDebitWork)
{
int numberPZ = db.PZ_PlanZakaz.Where(d => d.PlanZakaz < 9000).Max(d => d.PlanZakaz) + 1;
PZ_PlanZakaz newPZ_PlanZakaz = new PZ_PlanZakaz()
{
PZ_SMRId = pZ_PlanZakaz.PZ_SMRId,
id_CountryName = pZ_PlanZakaz.id_CountryName,
id_Provider = pZ_PlanZakaz.id_Provider,
PlanZakaz = numberPZ,
DateCreate = DateTime.Now,
MTR = pZ_PlanZakaz.MTR,
Name = pZ_PlanZakaz.Name,
OL = pZ_PlanZakaz.OL,
Zapros = pZ_PlanZakaz.Zapros,
DateSupply = pZ_PlanZakaz.DateSupply,
DateShipping = pZ_PlanZakaz.DateShipping,
Cost = pZ_PlanZakaz.Cost,
Description = pZ_PlanZakaz.Description,
ProductType = pZ_PlanZakaz.ProductType,
Dostavka = pZ_PlanZakaz.Dostavka,
Manager = pZ_PlanZakaz.Manager,
Client = pZ_PlanZakaz.Client,
Gruzopoluchatel = pZ_PlanZakaz.Gruzopoluchatel,
PostAdresGruzopoluchatel = pZ_PlanZakaz.PostAdresGruzopoluchatel,
INNGruzopoluchatel = pZ_PlanZakaz.INNGruzopoluchatel,
OKPOGruzopoluchatelya = pZ_PlanZakaz.OKPOGruzopoluchatelya,
KodGruzopoluchatela = pZ_PlanZakaz.KodGruzopoluchatela,
StantionGruzopoluchatel = pZ_PlanZakaz.StantionGruzopoluchatel,
KodStanciiGruzopoluchatelya = pZ_PlanZakaz.KodStanciiGruzopoluchatelya,
OsobieOtmetkiGruzopoluchatelya = pZ_PlanZakaz.OsobieOtmetkiGruzopoluchatelya,
DescriptionGruzopoluchatel = pZ_PlanZakaz.DescriptionGruzopoluchatel,
Folder = pZ_PlanZakaz.Folder,
Modul = pZ_PlanZakaz.Modul,
massa = 0,
timeContract = pZ_PlanZakaz.timeContract,
timeContractDate = pZ_PlanZakaz.timeContractDate,
timeArr = pZ_PlanZakaz.timeArr,
timeArrDate = pZ_PlanZakaz.timeArrDate,
id_PZ_FIO = pZ_PlanZakaz.id_PZ_FIO,
numZakupki = pZ_PlanZakaz.numZakupki,
numLota = pZ_PlanZakaz.numLota,
dataOtgruzkiBP = pZ_PlanZakaz.dataOtgruzkiBP,
ProjectUID = pZ_PlanZakaz.ProjectUID,
nameTU = pZ_PlanZakaz.nameTU,
TypeShip = pZ_PlanZakaz.TypeShip,
criticalDateShip = pZ_PlanZakaz.criticalDateShip,
nomenklaturNumber = pZ_PlanZakaz.nomenklaturNumber,
costSMR = pZ_PlanZakaz.costSMR,
costPNR = pZ_PlanZakaz.costPNR,
id_PZ_OperatorDogovora = pZ_PlanZakaz.id_PZ_OperatorDogovora,
PowerST = pZ_PlanZakaz.PowerST,
VN_NN = pZ_PlanZakaz.VN_NN,
objectOfExploitation = pZ_PlanZakaz.objectOfExploitation,
counterText = pZ_PlanZakaz.counterText,
coefM = 3.5,
coefE = 3.5
};
db.PZ_PlanZakaz.Add(newPZ_PlanZakaz);
db.SaveChanges();
Reclamation_CloseOrder reclamation_CloseOrder = new Reclamation_CloseOrder
{
close = false,
dateTimeClose = DateTime.Now,
description = "",
id_PZ_PlanZakaz = newPZ_PlanZakaz.Id,
userClose = newPZ_PlanZakaz.Manager
};
db.Reclamation_CloseOrder.Add(reclamation_CloseOrder);
db.SaveChanges();
PZ_TEO pZ_TEO = new PZ_TEO
{
Currency = 1,
NDS = 0,
Rate = 0,
SSM = 0,
SSR = 0,
IzdKom = 0,
IzdPPKredit = 0,
PI = 0,
NOP = 0,
KI_S = 0,
KI_prochee = 0,
Id_PlanZakaz = newPZ_PlanZakaz.Id,
OtpuskChena = 0,
KursValuti = 0,
SSRFact = 0,
percentYear = 0,
percentPI = 0,
durationBeforePay = 0,
SSMToBYN = 0,
SSMProduct = 0,
importDuty = 0,
importDutyPlan = 0
};
db.PZ_TEO.Add(pZ_TEO);
db.SaveChanges();
PZ_Setup pZ_Setup = new PZ_Setup
{
KolVoDneyNaPrijemku = 0,
PunktDogovoraOSrokahPriemki = "",
RassmotrenieRKD = 0,
SrokZamechanieRKD = 0,
TimeNaRKD = 0,
UslovieOplatyInt = 0,
UslovieOplatyText = "",
id_PZ_PlanZakaz = newPZ_PlanZakaz.Id
};
db.PZ_Setup.Add(pZ_Setup);
db.SaveChanges();
Debit_Platform debit_Platform = new Debit_Platform
{
id_PlanZakaz = newPZ_PlanZakaz.Id,
countPlatform = 0,
gabar = "",
massa = 0,
numPlatform = "",
numPlomb = ""
};
db.Debit_Platform.Add(debit_Platform);
db.SaveChanges();
PlanVerificationItems planVerificationItems = new PlanVerificationItems
{
id_PZ_PlanZakaz = newPZ_PlanZakaz.Id,
@fixed = false,
appDescription = "",
factDescription = "",
fixetFirstDate = false,
planDescription = "",
verificationDateInPrj = newPZ_PlanZakaz.dataOtgruzkiBP
};
db.PlanVerificationItems.Add(planVerificationItems);
db.SaveChanges();
ApproveCDOrders approveCDOrders = new ApproveCDOrders
{
id_PZ_PlanZakaz = newPZ_PlanZakaz.Id,
id_AspNetUsersM = "4f91324a-1918-4e62-b664-d8cd89a19d95",
id_AspNetUsersE = "8363828f-bba2-4a89-8ed8-d7f5623b4fa8",
description = "",
remove = false,
gHand = false,
isOpening = false
};
db.ApproveCDOrders.Add(approveCDOrders);
db.SaveChanges();
if (addDebitWork == true)
{
List <TaskForPZ> dateTaskWork = db.TaskForPZ.Where(w => w.step == 1).Where(z => z.id_TypeTaskForPZ == 1).ToList();
foreach (var data in dateTaskWork)
{
Debit_WorkBit newDebit_WorkBit = new Debit_WorkBit();
newDebit_WorkBit.dateCreate = DateTime.Now;
newDebit_WorkBit.close = false;
newDebit_WorkBit.id_PlanZakaz = newPZ_PlanZakaz.Id;
newDebit_WorkBit.id_TaskForPZ = (int)data.id;
newDebit_WorkBit.datePlanFirst = DateTime.Now.AddDays((double)data.time);
newDebit_WorkBit.datePlan = DateTime.Now.AddDays((double)data.time);
if (newDebit_WorkBit.id_TaskForPZ == 1)
{
newDebit_WorkBit.dateClose = DateTime.Now;
}
db.Debit_WorkBit.Add(new Debit_WorkBit()
{
close = false,
dateCreate = DateTime.Now,
datePlan = newDebit_WorkBit.datePlan,
datePlanFirst = newDebit_WorkBit.datePlanFirst,
id_PlanZakaz = newDebit_WorkBit.id_PlanZakaz,
id_TaskForPZ = newDebit_WorkBit.id_TaskForPZ,
dateClose = newDebit_WorkBit.dateClose
});
db.SaveChanges();
}
}
}