private SMRPNR_Order CreateDefaultSMRPNR_Order(PZ_PlanZakaz idPZ_PlanZakaz)
{
try
{
SMRPNR_Order sMRPNR_Order = new SMRPNR_Order();
sMRPNR_Order.id_PZ_PlanZakaz = idPZ_PlanZakaz.Id;
if (idPZ_PlanZakaz.Naznachenie == null)
{
sMRPNR_Order.@object = "";
}
else
{
sMRPNR_Order.@object = idPZ_PlanZakaz.Naznachenie;
}
sMRPNR_Order.adress = "";
sMRPNR_Order.oneContractToSMRPNR = false;
sMRPNR_Order.costWhisNDS = 0;
sMRPNR_Order.costWhisNDSPNR = 0;
sMRPNR_Order.description = "";
sMRPNR_Order.complited = false;
sMRPNR_Order.pNRnull = false;
logger.Debug(goodMethod + " (Modul SMRPNR - CreateDefaultSMRPNR_Order(PZ_PlanZakaz idPZ_PlanZakaz) идем следующий шаг");
return(sMRPNR_Order);
}
catch (Exception ex)
{
logger.Error(badMethod + " (Modul SMRPNR - CreateDefaultSMRPNR_Order(PZ_PlanZakaz idPZ_PlanZakaz)" + ex.Message.ToString());
return(null);
}
}
public JsonResult GetGP(string Id)
{
List <PZ_PlanZakaz> query = new List <PZ_PlanZakaz>();
PZ_PlanZakaz pZ_PlanZakaz = new PZ_PlanZakaz();
try
{
pZ_PlanZakaz = db.PZ_PlanZakaz.Where(d => d.Gruzopoluchatel.Replace(" ", "").Replace("\"", "") == Id).OrderByDescending(d => d.dataOtgruzkiBP).First();
}
catch
{
}
query.Add(pZ_PlanZakaz);
var data = query.Select(dataList => new
{
dataList.PostAdresGruzopoluchatel,
dataList.INNGruzopoluchatel,
dataList.OKPOGruzopoluchatelya,
dataList.KodGruzopoluchatela,
dataList.StantionGruzopoluchatel,
dataList.KodStanciiGruzopoluchatelya,
dataList.OsobieOtmetkiGruzopoluchatelya,
dataList.DescriptionGruzopoluchatel
});
return(Json(data.First(), JsonRequestBehavior.AllowGet));
}
private void CreateThree(PZ_PlanZakaz idPZ_PlanZakaz)
{
try
{
SMRPNR_Order sMRPNR_Order = CreateDefaultSMRPNR_Order(idPZ_PlanZakaz);
db.SMRPNR_Order.Add(sMRPNR_Order);
db.SaveChanges();
SMRPNR_Work sMR_Work = GetNewTaskSMRPNR(sMRPNR_Order, db.PZ_PlanZakaz.Find(idPZ_PlanZakaz));
sMR_Work.contract = "";
sMR_Work.contractAtt = "";
sMR_Work.dateContract = null;
sMR_Work.dateContractAtt = null;
db.SMRPNR_Work.Add(sMR_Work);
db.SaveChanges();
SMRPNR_Work pNR_Work = GetNewTaskSMRPNR(sMRPNR_Order, db.PZ_PlanZakaz.Find(idPZ_PlanZakaz));
pNR_Work.contract = "";
pNR_Work.contractAtt = "";
pNR_Work.dateContract = null;
pNR_Work.dateContractAtt = null;
pNR_Work.id_SMRPNR_TypeWork = 2;
db.SMRPNR_Work.Add(pNR_Work);
db.SaveChanges();
logger.Debug(goodDB + " (Modul SMRPNR - CreateThree(PZ_PlanZakaz idPZ_PlanZakaz)");
}
catch (Exception ex)
{
logger.Error(badDB + " (Modul SMRPNR - CreateThree(PZ_PlanZakaz idPZ_PlanZakaz)" + ex.Message.ToString());
}
}
private void UpdateFour(PZ_PlanZakaz idPZ_PlanZakaz)
{
try
{
SMRPNR_Order sMRPNR_Order = db.SMRPNR_Order.Where(d => d.id_PZ_PlanZakaz == idPZ_PlanZakaz.Id).First();
PZ_PlanZakaz pZ_PlanZakaz = db.PZ_PlanZakaz.Find(idPZ_PlanZakaz);
sMRPNR_Order = UpdateDefaultSMRPNR_Order(pZ_PlanZakaz, sMRPNR_Order);
db.Entry(sMRPNR_Order).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
SMRPNR_Work sMR_Work = db.SMRPNR_Work.Where(d => d.id_SMRPNR_Order == sMRPNR_Order.id & d.id_SMRPNR_TypeWork == 1).First();
sMR_Work.id_PZ_Client = pZ_PlanZakaz.Client;
sMR_Work.contract = pZ_PlanZakaz.timeContract;
sMR_Work.dateContract = pZ_PlanZakaz.timeContractDate;
sMR_Work.contractAtt = pZ_PlanZakaz.timeContract;
sMR_Work.dateContractAtt = pZ_PlanZakaz.timeArrDate;
db.Entry(sMR_Work).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
SMRPNR_Work pNR_Work = db.SMRPNR_Work.Where(d => d.id_SMRPNR_Order == sMRPNR_Order.id & d.id_SMRPNR_TypeWork == 2).First();
pNR_Work.id_PZ_Client = pZ_PlanZakaz.Client;
pNR_Work.contract = pZ_PlanZakaz.timeContract;
pNR_Work.dateContract = pZ_PlanZakaz.timeContractDate;
pNR_Work.contractAtt = pZ_PlanZakaz.timeContract;
pNR_Work.dateContractAtt = pZ_PlanZakaz.timeArrDate;
db.Entry(pNR_Work).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
logger.Debug(goodDB + " (Modul SMRPNR - UpdateTwo(PZ_PlanZakaz idPZ_PlanZakaz)");
}
catch (Exception ex)
{
logger.Error(badDB + " (Modul SMRPNR - UpdateTwo(PZ_PlanZakaz idPZ_PlanZakaz)" + ex.Message.ToString());
}
}
public SMRPNR(int idPZ_PlanZakaz)
{
PZ_PlanZakaz pZ_PlanZakaz = db.PZ_PlanZakaz.Find(idPZ_PlanZakaz);
try
{
if (pZ_PlanZakaz.SMRPNR != 1)
{
if (db.SMRPNR_Order.Where(d => d.id_PZ_PlanZakaz == pZ_PlanZakaz.Id).Count() > 0)
{
GetTypeUpdate(pZ_PlanZakaz);
}
else
{
GetTypeCreate(pZ_PlanZakaz);
}
}
else
{
logger.Debug(badConstructor + " (Modul SMRPNR - SMRPNR(int idPZ_PlanZakaz); задание на ШМР и ПНР не создано, в связи с тем, что ШМР и ПНР не выполняется");
}
logger.Debug(badConstructor + " (Modul SMRPNR - SMRPNR(int idPZ_PlanZakaz); следующий шаг");
}
catch (Exception ex)
{
logger.Error(goodConstructor + " (Modul SMRPNR - SMRPNR(int idPZ_PlanZakaz);" + ex.Message.ToString());
}
}
public CorrectOrderList(PZ_PlanZakaz pZ_PlanZakazs)
{
this.PZ = pZ_PlanZakazs;
if (pZ_PlanZakazs.timeArrDate != null)
{
SortDate = pZ_PlanZakazs.timeArrDate.Value;
}
else
{
SortDate = pZ_PlanZakazs.timeContractDate.Value;
}
}
PZ_PlanZakaz GetUpdateGP(PZ_PlanZakaz queryFirst, PZ_PlanZakaz pZ_PlanZakaz)
{
queryFirst.PostAdresGruzopoluchatel = pZ_PlanZakaz.PostAdresGruzopoluchatel;
queryFirst.INNGruzopoluchatel = pZ_PlanZakaz.INNGruzopoluchatel;
queryFirst.OKPOGruzopoluchatelya = pZ_PlanZakaz.OKPOGruzopoluchatelya;
queryFirst.KodGruzopoluchatela = pZ_PlanZakaz.KodGruzopoluchatela;
queryFirst.StantionGruzopoluchatel = pZ_PlanZakaz.StantionGruzopoluchatel;
queryFirst.KodStanciiGruzopoluchatelya = pZ_PlanZakaz.KodGruzopoluchatela;
queryFirst.OsobieOtmetkiGruzopoluchatelya = pZ_PlanZakaz.OsobieOtmetkiGruzopoluchatelya;
queryFirst.DescriptionGruzopoluchatel = pZ_PlanZakaz.DescriptionGruzopoluchatel;
return(queryFirst);
}
public JsonResult Add(PZ_PlanZakaz pZ_PlanZakaz, int[] countOrders)
{
CorrectPlanZakaz correctPlanZakaz = new CorrectPlanZakaz(pZ_PlanZakaz);
pZ_PlanZakaz = correctPlanZakaz.PZ_PlanZakaz;
int count = countOrders[0];
for (int i = 0; i < count; i++)
{
NewPlanZakaz pz = new NewPlanZakaz(pZ_PlanZakaz, true);
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
private void GetId_RKD_Order()
{
try
{
PZ_PlanZakaz pZ_PlanZakaz = db.PZ_PlanZakaz.Where(d => d.Id == id_PZ_PlaznZakaz).First();
id_RKD_Order = db.RKD_Order.Where(d => d.id_PZ_PlanZakaz == id_PZ_PlaznZakaz).First().id;
projectUID = pZ_PlanZakaz.ProjectUID.Value;
logger.Debug(goodConstructor + " (Modul RKD - GetId_RKD_Order()");
}
catch (Exception ex)
{
logger.Error(badConstructor + " (Modul RKD - GetId_RKD_Order(); " + ex.Message.ToString());
}
}
public void UpdateCriticalDateClose()
{
NetworkCredential cred = new NetworkCredential();
cred.Domain = "KATEK";
cred.UserName = "******";
cred.Password = "******";
projContext.Credentials = cred;
projContext.Load(projContext.Projects);
projContext.Load(projContext.CustomFields);
projContext.ExecuteQuery();
foreach (var pubProj in projContext.Projects)
{
int planZakazNumber = 0;
try
{
planZakazNumber = Convert.ToInt32(pubProj.Name.Substring(0, 4));
}
catch
{
}
if (planZakazNumber != 0 && planZakazNumber > 1734)
{
try
{
Console.WriteLine("Update: {0}", planZakazNumber);
PZ_PlanZakaz pZ_PlanZakaz = _dbPortal.PZ_PlanZakaz.First(d => d.PlanZakaz == planZakazNumber);
if (pZ_PlanZakaz.dataOtgruzkiBP > DateTime.Now)
{
DateTime criticalDateClose = _dbPortal.PZ_PlanZakaz.First(d => d.PlanZakaz == planZakazNumber).DateSupply;
DraftProject projectDraft = pubProj.CheckOut();
projContext.Load(projectDraft);
projContext.Load(projectDraft.CustomFields);
projContext.ExecuteQuery();
CustomField cField = projContext.CustomFields.First(c => c.Name == "CriticalDateClose");
projectDraft[cField.InternalName] = criticalDateClose;
projectDraft.Update();
QueueJob job = projectDraft.Update();
job = projectDraft.Publish(true);
projContext.ExecuteQuery();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
}
private void GetTypeCreate(PZ_PlanZakaz pZ_PlanZakaz)
{
if (pZ_PlanZakaz.SMRPNR == 2)
{
CreateTwo(pZ_PlanZakaz);
}
if (pZ_PlanZakaz.SMRPNR == 3)
{
CreateThree(pZ_PlanZakaz);
}
if (pZ_PlanZakaz.SMRPNR == 4)
{
CreateFour(pZ_PlanZakaz);
}
}
string GetLinkForEdit(PZ_PlanZakaz pZ_PlanZakaz, string linkPartOne, string linkPartTwo)
{
int closeOrder = db.Debit_WorkBit.Where(d => d.id_PlanZakaz == pZ_PlanZakaz.Id).Where(d => d.id_TaskForPZ == 15).Where(d => d.close == true).Count();
string link = linkPartOne + pZ_PlanZakaz.Id + linkPartTwo;
if (closeOrder > 0)
{
link = "<td><span class=" + '\u0022' + "glyphicon glyphicon-remove-circle" + '\u0022' + "></span></td>";
}
if (linkPartOne == "")
{
link = "<td></td>";
}
return(link);
}
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 AddRemToOrder(PZ_PlanZakaz pZ_PlanZakaz, string textRem)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
PZ_Notes pZ_Notes = new PZ_Notes
{
note = textRem,
dateTimeCreate = DateTime.Now,
id_AspNetUsersCreate = db.AspNetUsers.First(d => d.Email == HttpContext.User.Identity.Name).Id
};
db.PZ_Notes.Add(pZ_Notes);
db.SaveChanges();
PZ_PZNotes pZ_PZNotes = new PZ_PZNotes();
pZ_PZNotes.id_PZ_Notes = pZ_Notes.id;
pZ_PZNotes.id_PZ_PlanZakaz = pZ_PlanZakaz.Id;
db.PZ_PZNotes.Add(pZ_PZNotes);
db.SaveChanges();
return(Json(pZ_PlanZakaz.Id, JsonRequestBehavior.AllowGet));
}
}
private SMRPNR_Work GetNewTaskSMRPNR(SMRPNR_Order sMRPNR_Order, PZ_PlanZakaz pZ_PlanZakaz)
{
try
{
SMRPNR_Work sMRPNR_Work = new SMRPNR_Work();
sMRPNR_Work.id_SMRPNR_TypeWork = 1;
sMRPNR_Work.id_SMRPNR_Order = sMRPNR_Order.id;
sMRPNR_Work.id_SMRPNR_SMRState = 1;
sMRPNR_Work.id_PZ_Client = pZ_PlanZakaz.Client;
sMRPNR_Work.contract = pZ_PlanZakaz.timeContract;
sMRPNR_Work.dateContract = Convert.ToDateTime(pZ_PlanZakaz.timeContractDate);
sMRPNR_Work.contractAtt = pZ_PlanZakaz.timeArr;
sMRPNR_Work.dateContractAtt = Convert.ToDateTime(pZ_PlanZakaz.timeArrDate);
logger.Debug(goodMethod + " (Modul SMRPNR - GetNewTaskSMRPNR(SMRPNR_Order sMRPNR_Order, PZ_PlanZakaz pZ_PlanZakaz) идем следующий шаг");
return(sMRPNR_Work);
}
catch (Exception ex)
{
logger.Error(badMethod + " (Modul SMRPNR - GetNewTaskSMRPNR(SMRPNR_Order sMRPNR_Order, PZ_PlanZakaz pZ_PlanZakaz)" + ex.Message.ToString());
return(null);
}
}
private SMRPNR_Order UpdateDefaultSMRPNR_Order(PZ_PlanZakaz idPZ_PlanZakaz, SMRPNR_Order sMRPNR_Order)
{
try
{
if (idPZ_PlanZakaz.Naznachenie == null)
{
sMRPNR_Order.@object = "";
}
else
{
sMRPNR_Order.@object = idPZ_PlanZakaz.Naznachenie;
}
sMRPNR_Order.oneContractToSMRPNR = false;
logger.Debug(goodMethod + " (Modul SMRPNR - UpdateDefaultSMRPNR_Order(PZ_PlanZakaz idPZ_PlanZakaz, SMRPNR_Order sMRPNR_Order) идем следующий шаг");
return(sMRPNR_Order);
}
catch (Exception ex)
{
logger.Error(badMethod + " (Modul SMRPNR - UpdateDefaultSMRPNR_Order(PZ_PlanZakaz idPZ_PlanZakaz, SMRPNR_Order sMRPNR_Order)" + ex.Message.ToString());
return(null);
}
}
public JsonResult UpdateKO(PZ_PlanZakaz pZ_PlanZakaz)
{
string login = HttpContext.User.Identity.Name;
PZ_PlanZakaz editPZ = db.PZ_PlanZakaz.First(d => d.PlanZakaz == pZ_PlanZakaz.PlanZakaz);
if (editPZ.nameTU != pZ_PlanZakaz.nameTU)
{
//EmailRename emailRename = new EmailRename(editPZ.PlanZakaz.ToString(), editPZ.nameTU, pZ_PlanZakaz.nameTU, login, true);
//emailRename.SendEmail();
editPZ.nameTU = pZ_PlanZakaz.nameTU;
editPZ.ProductType = pZ_PlanZakaz.ProductType;
}
if (editPZ.ProductType != pZ_PlanZakaz.ProductType)
{
editPZ.ProductType = pZ_PlanZakaz.ProductType;
}
CorrectPlanZakaz correctPlanZakaz = new CorrectPlanZakaz(editPZ);
editPZ = correctPlanZakaz.PZ_PlanZakaz;
db.Entry(editPZ).State = EntityState.Modified;
db.SaveChanges();
return(Json(1, JsonRequestBehavior.AllowGet));
}
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();
}
}
}
bool GetMailList()
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
int approveCDOrdersId = db.ApproveCDQuestions.Find(queId).id_ApproveCDOrders;
mailToList = new List <MailList>();
mailToList.Add(new MailList {
mail = "*****@*****.**"
});
mailToList.Add(new MailList {
mail = "*****@*****.**"
});
mailToList.Add(new MailList {
mail = "*****@*****.**"
});
mailToList.Add(new MailList {
mail = "*****@*****.**"
});
mailToList.Add(new MailList {
mail = "*****@*****.**"
});
string mailToG = "";
ApproveCDOrders approveCDOrders = db.ApproveCDOrders.Find(approveCDOrdersId);
PZ_PlanZakaz pz = db.PZ_PlanZakaz.Find(approveCDOrders.id_PZ_PlanZakaz);
mailToList.Add(pz.Manager == "a94f65df-4580-4729-9541-446ebee13c1e"
? new MailList {
mail = "*****@*****.**"
}
: new MailList {
mail = "*****@*****.**"
});
try
{
if (approveCDOrders.id_AspNetUsersM != "8363828f-bba2-4a89-8ed8-d7f5623b4fa8")
{
mailToG = db.AspNetUsers.Find(approveCDOrders.id_AspNetUsersM).Email;
if (mailToList.Where(a => a.mail == mailToG).ToList().Count == 0)
{
MailList mailList = new MailList();
mailList.mail = mailToG;
mailToList.Add(mailList);
}
}
}
catch
{
}
try
{
if (approveCDOrders.id_AspNetUsersE != "8363828f-bba2-4a89-8ed8-d7f5623b4fa8")
{
mailToG = db.AspNetUsers.Find(approveCDOrders.id_AspNetUsersE).Email;
if (mailToList.Where(a => a.mail == mailToG).ToList().Count == 0)
{
MailList mailList = new MailList();
mailList.mail = mailToG;
mailToList.Add(mailList);
}
}
}
catch
{
}
try
{
MailList mailList = new MailList();
mailList.mail = db.ApproveCDOrders.Find(approveCDOrdersId).PZ_PlanZakaz.AspNetUsers.Email;
mailToList.Add(mailList);
}
catch
{
}
foreach (var dataList in mailToList)
{
mail.To.Add(new MailAddress(dataList.mail));
}
return(true);
}
}
public CorrectPlanZakaz(PZ_PlanZakaz pZ_PlanZakaz)
{
this.pZ_PlanZakaz = pZ_PlanZakaz;
if (pZ_PlanZakaz.MTR == null)
{
pZ_PlanZakaz.MTR = "";
}
if (pZ_PlanZakaz.OL == null)
{
pZ_PlanZakaz.OL = "";
}
if (pZ_PlanZakaz.Description == null)
{
pZ_PlanZakaz.Description = "";
}
if (pZ_PlanZakaz.Gruzopoluchatel == null)
{
pZ_PlanZakaz.Gruzopoluchatel = "";
}
if (pZ_PlanZakaz.PostAdresGruzopoluchatel == null)
{
pZ_PlanZakaz.PostAdresGruzopoluchatel = "";
}
if (pZ_PlanZakaz.INNGruzopoluchatel == null)
{
pZ_PlanZakaz.INNGruzopoluchatel = "";
}
if (pZ_PlanZakaz.OKPOGruzopoluchatelya == null)
{
pZ_PlanZakaz.OKPOGruzopoluchatelya = "";
}
if (pZ_PlanZakaz.KodGruzopoluchatela == null)
{
pZ_PlanZakaz.KodGruzopoluchatela = "";
}
if (pZ_PlanZakaz.StantionGruzopoluchatel == null)
{
pZ_PlanZakaz.StantionGruzopoluchatel = "";
}
if (pZ_PlanZakaz.KodStanciiGruzopoluchatelya == null)
{
pZ_PlanZakaz.KodStanciiGruzopoluchatelya = "";
}
if (pZ_PlanZakaz.OsobieOtmetkiGruzopoluchatelya == null)
{
pZ_PlanZakaz.OsobieOtmetkiGruzopoluchatelya = "";
}
if (pZ_PlanZakaz.DescriptionGruzopoluchatel == null)
{
pZ_PlanZakaz.DescriptionGruzopoluchatel = "";
}
if (pZ_PlanZakaz.Folder == null)
{
pZ_PlanZakaz.Folder = "";
}
if (pZ_PlanZakaz.Modul == null)
{
pZ_PlanZakaz.Modul = "";
}
if (pZ_PlanZakaz.timeContract == null)
{
pZ_PlanZakaz.timeContract = "";
}
if (pZ_PlanZakaz.timeArr == null)
{
pZ_PlanZakaz.timeArr = "";
}
if (pZ_PlanZakaz.numZakupki == null)
{
pZ_PlanZakaz.numZakupki = "";
}
if (pZ_PlanZakaz.numLota == null)
{
pZ_PlanZakaz.numLota = "";
}
if (pZ_PlanZakaz.dataOtgruzkiBP == null)
{
DateTime today = DateTime.Now;
DateTime answer = today.AddDays(90);
pZ_PlanZakaz.dataOtgruzkiBP = answer;
}
if (pZ_PlanZakaz.dataOtgruzkiBP.Year < 2010)
{
DateTime today = DateTime.Now;
DateTime answer = today.AddDays(90);
pZ_PlanZakaz.dataOtgruzkiBP = answer;
}
if (pZ_PlanZakaz.nameTU == null)
{
pZ_PlanZakaz.nameTU = "";
}
if (pZ_PlanZakaz.TypeShip == 0)
{
pZ_PlanZakaz.TypeShip = 1;
}
if (pZ_PlanZakaz.nomenklaturNumber == null)
{
pZ_PlanZakaz.nomenklaturNumber = "";
}
if (pZ_PlanZakaz.id_PZ_OperatorDogovora == 0)
{
pZ_PlanZakaz.id_PZ_OperatorDogovora = 1;
}
if (pZ_PlanZakaz.id_PZ_FIO == 0)
{
pZ_PlanZakaz.id_PZ_FIO = 7;
}
if (pZ_PlanZakaz.PowerST == null)
{
pZ_PlanZakaz.PowerST = "";
}
if (pZ_PlanZakaz.VN_NN == null)
{
pZ_PlanZakaz.VN_NN = "";
}
if (pZ_PlanZakaz.objectOfExploitation == null)
{
pZ_PlanZakaz.objectOfExploitation = "";
}
if (pZ_PlanZakaz.counterText == null)
{
pZ_PlanZakaz.counterText = "";
}
if (pZ_PlanZakaz.TypeShip == 0)
{
pZ_PlanZakaz.TypeShip = 1;
}
if (pZ_PlanZakaz.PZ_SMRId == 0)
{
pZ_PlanZakaz.PZ_SMRId = 1;
}
}
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();
}
}
}
public JsonResult Update(PZ_PlanZakaz pZ_PlanZakaz)
{
string login = HttpContext.User.Identity.Name;
PZ_PlanZakaz editPZ = db.PZ_PlanZakaz.First(d => d.PlanZakaz == pZ_PlanZakaz.PlanZakaz);
if (editPZ.Manager != pZ_PlanZakaz.Manager)
{
editPZ.Manager = pZ_PlanZakaz.Manager;
}
if (editPZ.Client != pZ_PlanZakaz.Client)
{
editPZ.Client = pZ_PlanZakaz.Client;
}
if (editPZ.id_PZ_OperatorDogovora != pZ_PlanZakaz.id_PZ_OperatorDogovora)
{
editPZ.id_PZ_OperatorDogovora = pZ_PlanZakaz.id_PZ_OperatorDogovora;
}
if (editPZ.id_PZ_FIO != pZ_PlanZakaz.id_PZ_FIO)
{
editPZ.id_PZ_FIO = pZ_PlanZakaz.id_PZ_FIO;
}
if (editPZ.Name != pZ_PlanZakaz.Name)
{
EmailRename emailRename = new EmailRename(editPZ.PlanZakaz.ToString(), editPZ.Name, pZ_PlanZakaz.Name, login, false);
emailRename.SendEmail();
editPZ.Name = pZ_PlanZakaz.Name;
}
if (editPZ.Description != pZ_PlanZakaz.Description)
{
editPZ.Description = pZ_PlanZakaz.Description;
}
if (editPZ.MTR != pZ_PlanZakaz.MTR)
{
editPZ.MTR = pZ_PlanZakaz.MTR;
}
if (editPZ.nomenklaturNumber != pZ_PlanZakaz.nomenklaturNumber)
{
editPZ.nomenklaturNumber = pZ_PlanZakaz.nomenklaturNumber;
}
if (editPZ.timeContract != pZ_PlanZakaz.timeContract)
{
editPZ.timeContract = pZ_PlanZakaz.timeContract;
}
if (editPZ.timeContractDate != pZ_PlanZakaz.timeContractDate)
{
editPZ.timeContractDate = pZ_PlanZakaz.timeContractDate;
}
if (editPZ.timeArr != pZ_PlanZakaz.timeArr)
{
editPZ.timeArr = pZ_PlanZakaz.timeArr;
}
if (editPZ.timeArrDate != pZ_PlanZakaz.timeArrDate)
{
editPZ.timeArrDate = pZ_PlanZakaz.timeArrDate;
}
if (editPZ.DateShipping != pZ_PlanZakaz.DateShipping)
{
editPZ.DateShipping = pZ_PlanZakaz.DateShipping;
}
if (editPZ.DateSupply != pZ_PlanZakaz.DateSupply)
{
editPZ.DateSupply = pZ_PlanZakaz.DateSupply;
}
if (editPZ.Dostavka != pZ_PlanZakaz.Dostavka)
{
editPZ.Dostavka = pZ_PlanZakaz.Dostavka;
}
if (editPZ.Cost != pZ_PlanZakaz.Cost)
{
editPZ.Cost = pZ_PlanZakaz.Cost;
}
if (editPZ.costSMR != pZ_PlanZakaz.costSMR)
{
editPZ.costSMR = pZ_PlanZakaz.costSMR;
}
if (editPZ.costPNR != pZ_PlanZakaz.costPNR)
{
editPZ.costPNR = pZ_PlanZakaz.costPNR;
}
if (editPZ.ProductType != pZ_PlanZakaz.ProductType)
{
editPZ.ProductType = pZ_PlanZakaz.ProductType;
}
if (editPZ.OL != pZ_PlanZakaz.OL)
{
editPZ.OL = pZ_PlanZakaz.OL;
}
if (editPZ.Zapros != pZ_PlanZakaz.Zapros)
{
editPZ.Zapros = pZ_PlanZakaz.Zapros;
}
if (editPZ.numZakupki != pZ_PlanZakaz.numZakupki)
{
editPZ.numZakupki = pZ_PlanZakaz.numZakupki;
}
if (editPZ.numLota != pZ_PlanZakaz.numLota)
{
editPZ.numLota = pZ_PlanZakaz.numLota;
}
if (editPZ.TypeShip != pZ_PlanZakaz.TypeShip)
{
editPZ.TypeShip = pZ_PlanZakaz.TypeShip;
}
if (editPZ.criticalDateShip != pZ_PlanZakaz.criticalDateShip)
{
editPZ.criticalDateShip = pZ_PlanZakaz.criticalDateShip;
}
if (editPZ.PowerST != pZ_PlanZakaz.PowerST)
{
editPZ.PowerST = pZ_PlanZakaz.PowerST;
}
if (editPZ.VN_NN != pZ_PlanZakaz.VN_NN)
{
editPZ.VN_NN = pZ_PlanZakaz.VN_NN;
}
if (editPZ.Modul != pZ_PlanZakaz.Modul)
{
editPZ.Modul = pZ_PlanZakaz.Modul;
}
if (editPZ.Gruzopoluchatel != pZ_PlanZakaz.Gruzopoluchatel)
{
editPZ.Gruzopoluchatel = pZ_PlanZakaz.Gruzopoluchatel;
}
if (editPZ.PostAdresGruzopoluchatel != pZ_PlanZakaz.PostAdresGruzopoluchatel)
{
editPZ.PostAdresGruzopoluchatel = pZ_PlanZakaz.PostAdresGruzopoluchatel;
}
if (editPZ.INNGruzopoluchatel != pZ_PlanZakaz.INNGruzopoluchatel)
{
editPZ.INNGruzopoluchatel = pZ_PlanZakaz.INNGruzopoluchatel;
}
if (editPZ.OKPOGruzopoluchatelya != pZ_PlanZakaz.OKPOGruzopoluchatelya)
{
editPZ.OKPOGruzopoluchatelya = pZ_PlanZakaz.OKPOGruzopoluchatelya;
}
if (editPZ.KodGruzopoluchatela != pZ_PlanZakaz.KodGruzopoluchatela)
{
editPZ.KodGruzopoluchatela = pZ_PlanZakaz.KodGruzopoluchatela;
}
if (editPZ.StantionGruzopoluchatel != pZ_PlanZakaz.StantionGruzopoluchatel)
{
editPZ.StantionGruzopoluchatel = pZ_PlanZakaz.StantionGruzopoluchatel;
}
if (editPZ.KodStanciiGruzopoluchatelya != pZ_PlanZakaz.KodStanciiGruzopoluchatelya)
{
editPZ.KodStanciiGruzopoluchatelya = pZ_PlanZakaz.KodStanciiGruzopoluchatelya;
}
if (editPZ.OsobieOtmetkiGruzopoluchatelya != pZ_PlanZakaz.OsobieOtmetkiGruzopoluchatelya)
{
editPZ.OsobieOtmetkiGruzopoluchatelya = pZ_PlanZakaz.OsobieOtmetkiGruzopoluchatelya;
}
if (editPZ.DescriptionGruzopoluchatel != pZ_PlanZakaz.DescriptionGruzopoluchatel)
{
editPZ.DescriptionGruzopoluchatel = pZ_PlanZakaz.DescriptionGruzopoluchatel;
}
CorrectPlanZakaz correctPlanZakaz = new CorrectPlanZakaz(editPZ);
editPZ = correctPlanZakaz.PZ_PlanZakaz;
db.Entry(editPZ).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Json(1, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateOrders(PZ_PlanZakaz pZ_PlanZakaz, int[] Orders)
{
string login = HttpContext.User.Identity.Name;
if (Orders == null)
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
for (int i = 0; i < Orders.Length; i++)
{
PZ_PlanZakaz editPZ = db.PZ_PlanZakaz.Find(Orders[i]);
if (pZ_PlanZakaz.Manager != null)
{
editPZ.Manager = pZ_PlanZakaz.Manager;
}
if (pZ_PlanZakaz.Client != 0)
{
editPZ.Client = pZ_PlanZakaz.Client;
}
if (pZ_PlanZakaz.id_PZ_OperatorDogovora != 0)
{
editPZ.id_PZ_OperatorDogovora = pZ_PlanZakaz.id_PZ_OperatorDogovora;
}
if (pZ_PlanZakaz.id_PZ_FIO != 0)
{
editPZ.id_PZ_FIO = pZ_PlanZakaz.id_PZ_FIO;
}
if (pZ_PlanZakaz.Name != null)
{
if (editPZ.Name.Replace(" ", "") != pZ_PlanZakaz.Name.Replace(" ", ""))
{
EmailRename emailRename = new EmailRename(editPZ.PlanZakaz.ToString(), editPZ.Name, pZ_PlanZakaz.Name, login, false);
emailRename.SendEmail();
editPZ.Name = pZ_PlanZakaz.Name;
}
}
if (pZ_PlanZakaz.Description != null)
{
editPZ.Description = pZ_PlanZakaz.Description;
}
if (pZ_PlanZakaz.MTR != null)
{
editPZ.MTR = pZ_PlanZakaz.MTR;
}
if (pZ_PlanZakaz.nomenklaturNumber != null)
{
editPZ.nomenklaturNumber = pZ_PlanZakaz.nomenklaturNumber;
}
if (pZ_PlanZakaz.timeContract != null)
{
editPZ.timeContract = pZ_PlanZakaz.timeContract;
}
if (pZ_PlanZakaz.timeContractDate != null && pZ_PlanZakaz.timeContractDate.Value.Year > 2000)
{
editPZ.timeContractDate = pZ_PlanZakaz.timeContractDate;
}
if (pZ_PlanZakaz.timeArr != null)
{
editPZ.timeArr = pZ_PlanZakaz.timeArr;
}
if (pZ_PlanZakaz.timeArrDate != null && pZ_PlanZakaz.timeArrDate.Value.Year > 2000)
{
editPZ.timeArrDate = pZ_PlanZakaz.timeArrDate;
}
if (pZ_PlanZakaz.DateShipping != null && pZ_PlanZakaz.DateShipping.Year > 2000)
{
editPZ.DateShipping = pZ_PlanZakaz.DateShipping;
}
if (pZ_PlanZakaz.DateSupply != null && pZ_PlanZakaz.DateSupply.Year > 2000)
{
editPZ.DateSupply = pZ_PlanZakaz.DateSupply;
}
if (pZ_PlanZakaz.Dostavka != 0)
{
editPZ.Dostavka = pZ_PlanZakaz.Dostavka;
}
if (pZ_PlanZakaz.Cost != 0)
{
editPZ.Cost = pZ_PlanZakaz.Cost;
}
if (pZ_PlanZakaz.costSMR != 0)
{
editPZ.costSMR = pZ_PlanZakaz.costSMR;
}
if (pZ_PlanZakaz.costPNR != 0)
{
editPZ.costPNR = pZ_PlanZakaz.costPNR;
}
if (pZ_PlanZakaz.ProductType != 0)
{
editPZ.ProductType = pZ_PlanZakaz.ProductType;
}
if (pZ_PlanZakaz.OL != null)
{
editPZ.OL = pZ_PlanZakaz.OL;
}
if (pZ_PlanZakaz.Zapros != 0)
{
editPZ.Zapros = pZ_PlanZakaz.Zapros;
}
if (pZ_PlanZakaz.numZakupki != null)
{
editPZ.numZakupki = pZ_PlanZakaz.numZakupki;
}
if (pZ_PlanZakaz.numLota != null)
{
editPZ.numLota = pZ_PlanZakaz.numLota;
}
if (pZ_PlanZakaz.TypeShip != 0)
{
editPZ.TypeShip = pZ_PlanZakaz.TypeShip;
}
if (pZ_PlanZakaz.criticalDateShip != null && pZ_PlanZakaz.criticalDateShip.Value.Year > 2000)
{
editPZ.criticalDateShip = pZ_PlanZakaz.criticalDateShip;
}
if (pZ_PlanZakaz.PowerST != null)
{
editPZ.PowerST = pZ_PlanZakaz.PowerST;
}
if (pZ_PlanZakaz.VN_NN != null)
{
editPZ.VN_NN = pZ_PlanZakaz.VN_NN;
}
if (pZ_PlanZakaz.Modul != null)
{
editPZ.Modul = pZ_PlanZakaz.Modul;
}
if (pZ_PlanZakaz.Gruzopoluchatel != null)
{
editPZ.Gruzopoluchatel = pZ_PlanZakaz.Gruzopoluchatel;
}
if (pZ_PlanZakaz.PostAdresGruzopoluchatel != null)
{
editPZ.PostAdresGruzopoluchatel = pZ_PlanZakaz.PostAdresGruzopoluchatel;
}
if (pZ_PlanZakaz.INNGruzopoluchatel != null)
{
editPZ.INNGruzopoluchatel = pZ_PlanZakaz.INNGruzopoluchatel;
}
if (pZ_PlanZakaz.OKPOGruzopoluchatelya != null)
{
editPZ.OKPOGruzopoluchatelya = pZ_PlanZakaz.OKPOGruzopoluchatelya;
}
if (pZ_PlanZakaz.KodGruzopoluchatela != null)
{
editPZ.KodGruzopoluchatela = pZ_PlanZakaz.KodGruzopoluchatela;
}
if (pZ_PlanZakaz.StantionGruzopoluchatel != null)
{
editPZ.StantionGruzopoluchatel = pZ_PlanZakaz.StantionGruzopoluchatel;
}
if (pZ_PlanZakaz.KodStanciiGruzopoluchatelya != null)
{
editPZ.KodStanciiGruzopoluchatelya = pZ_PlanZakaz.KodStanciiGruzopoluchatelya;
}
if (pZ_PlanZakaz.OsobieOtmetkiGruzopoluchatelya != null)
{
editPZ.OsobieOtmetkiGruzopoluchatelya = pZ_PlanZakaz.OsobieOtmetkiGruzopoluchatelya;
}
if (pZ_PlanZakaz.DescriptionGruzopoluchatel != null)
{
editPZ.DescriptionGruzopoluchatel = pZ_PlanZakaz.DescriptionGruzopoluchatel;
}
CorrectPlanZakaz correctPlanZakaz = new CorrectPlanZakaz(editPZ);
editPZ = correctPlanZakaz.PZ_PlanZakaz;
db.Entry(editPZ).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
