public JsonResult UpdateSetup(PZ_Setup pZ_Setup) { using (PortalKATEKEntities db = new PortalKATEKEntities()) { db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; db.Entry(pZ_Setup).State = EntityState.Modified; 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(); } } }