public JsonResult DebitList()
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.Debit_WorkBit
.Include(d => d.PZ_PlanZakaz.AspNetUsers)
.Include(d => d.PZ_PlanZakaz.PZ_Client)
.Include(d => d.PZ_PlanZakaz.PZ_Setup)
.Where(d => d.id_TaskForPZ == 15 || d.id_TaskForPZ == 38)
.ToList();
var data = query.Select(dataList => new
{
edit = "<a href =" + '\u0022' + "http://pserver/Deb/Upload/NewPlus/" + dataList.id + '\u0022' + " class=" + '\u0022' + "btn-xs btn-primary" + '\u0022' + "role =" + '\u0022' + "button" + '\u0022' + ">Внести</a>",
dataList.PZ_PlanZakaz.PlanZakaz,
Manager = dataList.PZ_PlanZakaz.AspNetUsers.CiliricalName,
Client = dataList.PZ_PlanZakaz.PZ_Client.NameSort,
dataList.PZ_PlanZakaz.PZ_Setup.First().KolVoDneyNaPrijemku,
dataList.PZ_PlanZakaz.PZ_Setup.First().PunktDogovoraOSrokahPriemki,
dataList.PZ_PlanZakaz.PZ_Setup.First().UslovieOplatyText,
status = GetStatusName(dataList)
});
return(Json(new { data }));
}
}
public ActionResult Index()
{
PortalKATEKEntities db = new PortalKATEKEntities();
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
ViewBag.PZ_PlanZakaz = new SelectList(db.PZ_PlanZakaz.Where(d => d.PlanZakaz < 7000).OrderByDescending(d => d.PlanZakaz), "Id", "PlanZakaz");
ViewBag.id_Reclamation_Type = new SelectList(db.Reclamation_Type.Where(d => d.activeService == true).OrderBy(d => d.name), "id", "name");
ViewBag.id_ServiceRemarksCause = new SelectList(db.ServiceRemarksCause.Where(d => d.active == true).OrderBy(d => d.name), "id", "name");
string login = HttpContext.User.Identity.Name;
int devisionUser = 0;
try
{
devisionUser = db.AspNetUsers.First(d => d.Email == login).Devision.Value;
}
catch
{
}
if (devisionUser == 28)
{
ViewBag.userGroupId = 1;
}
else
{
ViewBag.userGroupId = 0;
}
ViewBag.typeRem = new SelectList(db.Reclamation_Type.Where(d => d.activeService == true).OrderBy(d => d.name), "id", "name");
ViewBag.devRem = new SelectList(db.Devision.Where(d => d.OTK == true).OrderBy(d => d.name), "id", "name");
ViewBag.pfRem = new SelectList(db.PF.Where(d => d.active == true).OrderBy(d => d.name), "id", "name");
logger.Debug("Mark OTK: " + login);
return(View());
}
public JsonResult GetPositionsOrder(int id)
{
try
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.PlexiglassPositionsOrder
.AsNoTracking()
.Where(a => a.id_PlexiglassOrder == id)
.ToList();
var data = query.Select(dataList => new
{
dataList.positionNum,
dataList.id_PlexiglassOrder,
dataList.designation,
dataList.name,
dataList.index,
quentity = dataList.quentity.ToString(),
dataList.square,
dataList.barcode
});
return(Json(new { data }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
logger.Error("PlexiglasController / GetPositionsOrder: " + " | " + ex);
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
public void CreateOrder(int[] id_PlanZakaz, string login, HttpPostedFileBase[] fileUploadArray)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
this.fileUploadArray = fileUploadArray;
GetBasicFuild(login);
sandwichPanel.folder = "";
db.SandwichPanel.Add(sandwichPanel);
db.SaveChanges();
sandwichPanel.folder = CreateFolderAndFileForPreOrder(sandwichPanel.id);
sandwichPanel.onApprove = false;
sandwichPanel.onCustomer = true;
sandwichPanel.datetimeUploadNewVersion = DateTime.Now;
db.Entry(sandwichPanel).State = EntityState.Modified;
db.SaveChanges();
foreach (var dataPZ in id_PlanZakaz)
{
SandwichPanel_PZ sandwichPanel_PZ = new SandwichPanel_PZ();
sandwichPanel_PZ.id_PZ_PlanZakaz = dataPZ;
sandwichPanel_PZ.id_SandwichPanel = sandwichPanel.id;
db.SandwichPanel_PZ.Add(sandwichPanel_PZ);
db.SaveChanges();
}
try
{
new EmailSandwichPanel(sandwichPanel, login, 1);
logger.Debug("SandwichPanelCRUD / EmailSandwichPanel: " + sandwichPanel.id);
}
catch (Exception ex)
{
logger.Error("SandwichPanelCRUD / EmailSandwichPanel: " + sandwichPanel.id + " | " + ex);
}
}
}
private bool GetSubject()
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
subject = "Заказ №: " + db.ApproveCDOrders
.Find(approveCDOrdersId).PZ_PlanZakaz.PlanZakaz
.ToString();
if (stepNumber == 1)
{
subject += " - Отправлена черновая версия РКД в ТП";
}
if (stepNumber == 2)
{
subject += " - Получен ответ от Заказчика";
}
if (stepNumber == 3)
{
subject += " - Получено согласование РКД";
}
if (stepNumber == 0)
{
subject += " - РКД отправлено на доработку";
}
return(true);
}
}
public JsonResult List(string id)
{
string login = HttpContext.User.Identity.Name;
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
int idS = db.ProductionCalendar.AsNoTracking().First(d => d.period == id).id;
var query = db.DashboardKO_UsersMonthPlan
.AsNoTracking()
.Include(d => d.ProductionCalendar)
.Include(d => d.AspNetUsers.Devision1)
.Where(d => d.id_ProductionCalendar == idS)
.ToList();
var data = query.Select(dataList => new
{
editLink = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return getPoint('" + dataList.id + "')" + '\u0022' + "><span class=" + '\u0022' + "glyphicon glyphicon-pencil" + '\u0022' + "></span></a></td>",
name = dataList.AspNetUsers.CiliricalName,
devision = dataList.AspNetUsers.Devision1.name,
dataList.ProductionCalendar.period,
coefficient = dataList.k
});
return(Json(new { data, MaxJsonLength = int.MaxValue }));
}
}
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" }));
}
}
public JsonResult UpdateOTK(int id, DateTime?appDate, string appDescription)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
string login = HttpContext.User.Identity.Name;
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
PlanVerificationItems planVerificationItems = db.PlanVerificationItems.Find(id);
if (appDate != null)
{
planVerificationItems.appDate = appDate.Value;
}
if (appDescription != null)
{
planVerificationItems.appDescription = appDescription;
}
db.Entry(planVerificationItems).State = EntityState.Modified;
db.SaveChanges();
EmailVerifPlan dataMail = new EmailVerifPlan(planVerificationItems, login, 3);
PlanVerificationItemsLog planVerificationItemsLog = new PlanVerificationItemsLog();
planVerificationItemsLog.action = "Начата приемка изделия на проверку: " + planVerificationItems.appDate.Value.ToShortDateString();
planVerificationItemsLog.date = DateTime.Now;
planVerificationItemsLog.id_PlanVerificationItems = planVerificationItems.id;
planVerificationItemsLog.id_AspNetUsers = db.AspNetUsers.First(d => d.CiliricalName == "Погадо Евгений Владимирович").Id;
db.PlanVerificationItemsLog.Add(planVerificationItemsLog);
db.SaveChanges();
return(Json(1, JsonRequestBehavior.AllowGet));
}
}
public JsonResult ListClose()
{
JsonSerializerSettings settings = new JsonSerializerSettings {
DateFormatString = "yyyy.MM.dd"
};
string login = HttpContext.User.Identity.Name;
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.PlanVerificationItems
.AsNoTracking()
.Include(d => d.PZ_PlanZakaz)
.Where(d => d.PZ_PlanZakaz.dataOtgruzkiBP < DateTime.Now)
.ToList();
var data = query.Select(dataList => new
{
editLink = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return get('" + dataList.id + "')" + '\u0022' + "><span class=" + '\u0022' + "glyphicon glyphicon-pencil" + '\u0022' + "></span></a></td>",
id_PZ_PlanZakaz = dataList.PZ_PlanZakaz.PlanZakaz.ToString(),
planDate = JsonConvert.SerializeObject(dataList.planDate, settings).Replace(@"""", ""),
factDate = JsonConvert.SerializeObject(dataList.factDate, settings).Replace(@"""", ""),
appDate = JsonConvert.SerializeObject(dataList.appDate, settings).Replace(@"""", ""),
dataList.planDescription,
dataList.factDescription,
dataList.appDescription,
fixedDateForKO = JsonConvert.SerializeObject(dataList.fixedDateForKO, settings).Replace(@"""", ""),
verificationDateInPrj = JsonConvert.SerializeObject(dataList.verificationDateInPrj, settings).Replace(@"""", ""),
state = GetState(dataList)
});;
return(Json(new { data }));
}
}
public JsonResult Get(int id)
{
JsonSerializerSettings settings = new JsonSerializerSettings {
DateFormatString = "dd.MM.yyyy"
};
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.PlanVerificationItems
.AsNoTracking()
.Where(d => d.id == id)
.Include(d => d.PZ_PlanZakaz)
.ToList();
var data = query.Select(dataList => new
{
dataList.id,
id_PZ_PlanZakaz = dataList.PZ_PlanZakaz.PlanZakaz.ToString(),
dataList.@fixed,
state = GetState(dataList),
fixetFirstDate = JsonConvert.SerializeObject(dataList.fixetFirstDate, settings).Replace(@"""", ""),
planDate = JsonConvert.SerializeObject(dataList.planDate, settings).Replace(@"""", ""),
dataList.planDescription,
factDate = JsonConvert.SerializeObject(dataList.factDate, settings).Replace(@"""", ""),
dataList.factDescription,
appDate = JsonConvert.SerializeObject(dataList.appDate, settings).Replace(@"""", ""),
dataList.appDescription,
verificationDateInPrj = JsonConvert.SerializeObject(dataList.verificationDateInPrj, settings).Replace(@"""", ""),
fixedDateForKO = JsonConvert.SerializeObject(dataList.fixedDateForKO, settings).Replace(@"""", ""),
dateSh = JsonConvert.SerializeObject(dataList.PZ_PlanZakaz.dataOtgruzkiBP, settings).Replace(@"""", "")
});
return(Json(data.First(), JsonRequestBehavior.AllowGet));
}
}
public JsonResult UpdateTE(int id, DateTime?planDate, string planDescription)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
string login = HttpContext.User.Identity.Name;
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
PlanVerificationItems planVerificationItems = db.PlanVerificationItems.Find(id);
if (planDate != null)
{
planVerificationItems.planDate = planDate.Value;
planVerificationItems.@fixed = true;
}
if (planDescription != null)
{
planVerificationItems.planDescription = planDescription;
}
db.Entry(planVerificationItems).State = EntityState.Modified;
db.SaveChanges();
EmailVerifPlan dataMail = new EmailVerifPlan(planVerificationItems, login, 1);
ProjectServer_UpdateMustStartOnCRUD projectServer_UpdateMustStartOnCRUD = new ProjectServer_UpdateMustStartOnCRUD(planVerificationItems.id_PZ_PlanZakaz, "ПП", planVerificationItems.planDate.Value);
PlanVerificationItemsLog planVerificationItemsLog = new PlanVerificationItemsLog();
planVerificationItemsLog.action = "Установлен плановый срок проверки изделия: " + planVerificationItems.planDate.Value.ToShortDateString();
planVerificationItemsLog.date = DateTime.Now;
planVerificationItemsLog.id_PlanVerificationItems = planVerificationItems.id;
planVerificationItemsLog.id_AspNetUsers = db.AspNetUsers.First(d => d.CiliricalName == "Брель Андрей Викторович").Id;
db.PlanVerificationItemsLog.Add(planVerificationItemsLog);
db.SaveChanges();
return(Json(1, JsonRequestBehavior.AllowGet));
}
}
public JsonResult TasksCloseList()
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.Debit_WorkBit
.AsNoTracking()
.Include(d => d.TaskForPZ.AspNetUsers)
.Include(d => d.PZ_PlanZakaz.PZ_Client)
.Where(d => d.close == true)
.OrderBy(d => d.PZ_PlanZakaz.PlanZakaz)
.ToList();
var data = query.Select(dataList => new
{
editLink = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return getTask('" + dataList.id + "')" + '\u0022' + "><span class=" + '\u0022' + "glyphicon glyphicon-pencil" + '\u0022' + "></span></a></td>",
viewLink = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return getTask('" + dataList.id + "')" + '\u0022' + "><span class=" + '\u0022' + "glyphicon glyphicon-list-alt" + '\u0022' + "></span></a></td>",
order = dataList.PZ_PlanZakaz.PlanZakaz,
dataList.TaskForPZ.taskName,
client = dataList.PZ_PlanZakaz.PZ_Client.NameSort,
user = dataList.TaskForPZ.AspNetUsers.CiliricalName,
planDate = JsonConvert.SerializeObject(dataList.datePlan, shortSetting).Replace(@"""", "")
});
return(Json(new { data }));
}
}
public JsonResult GetSetup(int id)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.PZ_Setup
.Include(d => d.PZ_PlanZakaz)
.Where(d => d.id == id)
.ToList();
var data = query.Select(dataList => new
{
pzSetup = "Заказ №: " + dataList.PZ_PlanZakaz.PlanZakaz.ToString(),
idSetup = dataList.id,
dataList.id_PZ_PlanZakaz,
dataList.KolVoDneyNaPrijemku,
dataList.PunktDogovoraOSrokahPriemki,
dataList.UslovieOplatyText,
dataList.UslovieOplatyInt,
dataList.TimeNaRKD,
dataList.RassmotrenieRKD,
dataList.SrokZamechanieRKD,
dataList.userTP
});
return(Json(data.First(), JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetTEO(int id)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.PZ_TEO
.Where(d => d.id == id)
.Include(d => d.PZ_PlanZakaz)
.ToList();
var data = query.Select(dataList => new
{
idTEO = dataList.id,
dataList.Currency,
teoPlanZakaz = "Заказ №: " + dataList.PZ_PlanZakaz.PlanZakaz.ToString(),
dataList.Rate,
dataList.SSM,
dataList.SSR,
dataList.IzdKom,
dataList.IzdPPKredit,
dataList.PI,
dataList.NOP,
dataList.KI_S,
dataList.KI_prochee,
dataList.OtpuskChena,
dataList.KursValuti,
dataList.Id_PlanZakaz,
dataList.NDS
});
return(Json(data.First(), JsonRequestBehavior.AllowGet));
}
}
public JsonResult ListClose()
{
string login = HttpContext.User.Identity.Name;
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.OrdersTables
.AsNoTracking()
.Where(d => d.dateClose != null)
.ToList();
var data = query.Select(dataList => new
{
editLink = GetEditLink(dataList.id, login),
dataList.id,
orderNum = GetOrdersNum(dataList.id),
user = GetUserName(login),
dateCreate = JsonConvert.SerializeObject(dataList.dateCreate, settings).Replace(@"""", ""),
dateClose = JsonConvert.SerializeObject(dataList.dateClose, settings).Replace(@"""", ""),
dateRemove = JsonConvert.SerializeObject(dataList.dateRemove, settings).Replace(@"""", ""),
state = GetState(dataList),
removeLink = GetRemoveLink(dataList.id, login)
});
return(Json(new { data }));
}
}
public JsonResult GetOrder(int id)
{
try
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.PlexiglassOrder
.Include(a => a.CMO_TypeProduct)
.Include(a => a.PlexiglassCompany)
.Include(a => a.AspNetUsers)
.Where(a => a.id == id)
.ToList();
var data = query.Select(dataList => new
{
dataList.id,
PZ_PlanZakaz = GetPlanOrdersName(dataList.id),
CMO_TypeProduct = dataList.CMO_TypeProduct.name,
AspNetUsers = dataList.AspNetUsers.CiliricalName,
customerNewOrderId = GetCompanyNameId(dataList.id),
datetimeCreate = JsonConvert.SerializeObject(dataList.datetimeCreate, longSetting).Replace(@"""", ""),
continueDate = JsonConvert.SerializeObject(dataList.continueDate, shortDefaultSetting).Replace(@"""", ""),
finishDate = JsonConvert.SerializeObject(dataList.finishDate, shortDefaultSetting).Replace(@"""", ""),
dataList.note
});
return(Json(data.First(), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
logger.Error("PlexiglasController / GetOrder: " + " | " + ex);
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetList()
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.PZ_PlanZakaz
.AsNoTracking()
.Include(d => d.PZ_ProductType)
.Include(d => d.AspNetUsers)
.Include(d => d.PZ_Client)
.Include(d => d.CrossOrder)
.Where(d => d.CrossOrder.Count() > 0)
.ToList();
var data = query.Select(dataList => new
{
parent = dataList.PlanZakaz,
childs = GetChilds(dataList.Id),
customer = dataList.PZ_Client.NameSort,
name = dataList.Name,
dataList.nameTU,
manager = dataList.AspNetUsers.CiliricalName,
contract = dataList.timeContract,
contractDate = JsonConvert.SerializeObject(dataList.timeContractDate, shortSetting).Replace(@"""", ""),
spetification = dataList.timeArr,
spetificationDate = JsonConvert.SerializeObject(dataList.timeArrDate, shortSetting).Replace(@"""", ""),
shDate = JsonConvert.SerializeObject(dataList.dataOtgruzkiBP, shortSetting).Replace(@"""", ""),
removeLink = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return Remove('" + dataList.Id + "')" + '\u0022' + "><span class=" + '\u0022' + "glyphicon glyphicon-remove" + '\u0022' + "></span></a></td>",
});
return(Json(new { data }));
}
}
private string GetState(int order)
{
try
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
var ord = db.PlexiglassOrder.Find(order);
if (ord.remove == true)
{
return("Удален");
}
else if (ord.finishDate != null)
{
return("Поступил");
}
else if (ord.continueDate != null)
{
return("Изготавливается");
}
else
{
return("Не размещен");
}
}
}
catch (Exception ex)
{
logger.Error("PlexiglasController / GetState: " + " | " + ex + " | " + order);
return("");
}
}
public JsonResult GetId(int id)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.Debit_DataReportOprih
.AsNoTracking()
.Where(d => d.id_Debit_PeriodReportOprih == id)
.Include(d => d.Debit_WorkBit.PZ_PlanZakaz.PZ_Client)
.Include(d => d.Debit_WorkBit.PZ_PlanZakaz.AspNetUsers)
.ToList();
var data = query.Select(dataList => new
{
dataList.description,
dataList.oprihClose,
dateOprihPlanFact = JsonConvert.SerializeObject(dataList.dateOprihPlanFact, settings).Replace(@"""", ""),
dataList.Debit_WorkBit.PZ_PlanZakaz.PlanZakaz,
dataList.Debit_WorkBit.PZ_PlanZakaz.Name,
Manager = dataList.Debit_WorkBit.PZ_PlanZakaz.AspNetUsers.CiliricalName,
Client = dataList.Debit_WorkBit.PZ_PlanZakaz.PZ_Client.NameSort,
dataOtgruzkiBP = JsonConvert.SerializeObject(dataList.Debit_WorkBit.PZ_PlanZakaz.dataOtgruzkiBP, settings).Replace(@"""", ""),
DateSupply = JsonConvert.SerializeObject(dataList.Debit_WorkBit.PZ_PlanZakaz.DateSupply, settings).Replace(@"""", ""),
dataList.numberSF,
dataList.reclamation,
openReclamation = JsonConvert.SerializeObject(dataList.reclamationOpen, settings).Replace(@"""", ""),
closeReclamation = JsonConvert.SerializeObject(dataList.reclamationClose, settings).Replace(@"""", "")
});
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
private string GetRemoveLink(int order)
{
var login = HttpContext.User.Identity.Name;
var devision = GetDevision(login);
try
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
if (devision == 7 || login == "*****@*****.**")
{
return("<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return RemoveOrder('" + order + "')" + '\u0022' + "><span class=" + '\u0022' + "glyphicon glyphicon-remove" + '\u0022' + "></span></a></td>");
}
else
{
return("");
}
}
}
catch (Exception ex)
{
logger.Error("PlexiglasController / GetEditLink: " + " | " + ex + " | " + order);
return("");
}
}
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();
}
}
}
private string GetPlanOrdersName(int order)
{
System.Text.StringBuilder res = new System.Text.StringBuilder();
try
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
var que = db.PlexiglassOrdersPlans
.AsNoTracking()
.Include(a => a.PZ_PlanZakaz)
.Where(a => a.PlexiglassOrderId == order)
.ToList();
foreach (var data in que)
{
res.Append(data.PZ_PlanZakaz.PlanZakaz.ToString() + "; ");
}
return(res.ToString());
}
}
catch (Exception ex)
{
logger.Error("PlexiglasController / GetPlanOrdersName: " + " | " + ex + " | " + order);
return("");
}
}
public JsonResult List()
{
JsonSerializerSettings settings = new JsonSerializerSettings {
DateFormatString = "yyyy.MM.dd"
};
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.Debit_WorkBit
.AsNoTracking()
.Include(d => d.PZ_PlanZakaz.PZ_Client)
.Include(d => d.PZ_PlanZakaz.AspNetUsers)
.Where(d => d.close == false)
.Where(d => d.id_TaskForPZ == 28)
.ToList();
var data = query.Select(dataList => new
{
dataList.PZ_PlanZakaz.PlanZakaz,
dataList.PZ_PlanZakaz.Name,
Manager = dataList.PZ_PlanZakaz.AspNetUsers.CiliricalName,
Client = dataList.PZ_PlanZakaz.PZ_Client.NameSort,
dataOtgruzkiBP = JsonConvert.SerializeObject(dataList.PZ_PlanZakaz.dataOtgruzkiBP, settings).Replace(@"""", ""),
DateSupply = JsonConvert.SerializeObject(dataList.PZ_PlanZakaz.DateSupply, settings).Replace(@"""", "")
});
return(Json(new { data }));
}
}
public JsonResult GetTablePlanChack()
{
JsonSerializerSettings settings = new JsonSerializerSettings {
DateFormatString = "dd.MM.yyyy"
};
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.PlanVerificationItems
.AsNoTracking()
.Where(d => d.verificationDateInPrj > DateTime.Now && d.factDate == null && d.planDate != null)
.Include(d => d.PZ_PlanZakaz.PZ_Client)
.OrderBy(d => d.planDate.Value)
.ToList();
var data = query.Select(dataList => new
{
order = dataList.PZ_PlanZakaz.PlanZakaz,
customer = dataList.PZ_PlanZakaz.PZ_Client.NameSort,
planDate = JsonConvert.SerializeObject(dataList.planDate, settings).Replace(@"""", ""),
factDate = JsonConvert.SerializeObject(dataList.verificationDateInPrj, settings).Replace(@"""", ""),
deviation = GetDay(dataList.planDate.Value, dataList.verificationDateInPrj.Value)
});
return(Json(new { data }));
}
}
public JsonResult Get(int id)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.ServiceRemarks
.Include(d => d.ServiceRemarksPlanZakazs)
.Include(d => d.ServiceRemarksTypes)
.Include(d => d.ServiceRemarksCauses)
.Include(d => d.AspNetUsers)
.Where(d => d.id == id).ToList();
var data = query.Select(dataList => new
{
numberReclamation = "Рекламация №: " + dataList.id,
dataList.id,
pZ_PlanZakaz = GetPlanZakazArray(dataList.ServiceRemarksPlanZakazs.ToList()),
id_Reclamation_Type = GetTypesArray(dataList.ServiceRemarksTypes.ToList()),
id_ServiceRemarksCause = GetCausesArray(dataList.ServiceRemarksCauses.ToList()),
dateTimeCreate = JsonConvert.SerializeObject(dataList.dateTimeCreate, settings).Replace(@"""", ""),
userCreate = dataList.AspNetUsers.CiliricalName,
datePutToService = JsonConvert.SerializeObject(dataList.datePutToService, shortSettingLeftRight).Replace(@"""", ""),
dateClose = JsonConvert.SerializeObject(dataList.dateClose, shortSettingLeftRight).Replace(@"""", ""),
dataList.folder,
dataList.text,
dataList.description,
answerHistiryText = GetHistoryText(dataList.id)
});
return(Json(data.First(), JsonRequestBehavior.AllowGet));
}
}
private string[] GetArrayFileBodyCRD(int[] Id)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
List <string> dataList = new List <string>();
foreach (var data in Id)
{
var order = db.PZ_PlanZakaz.AsNoTracking().Include(a => a.PZ_ProductType).First(a => a.Id == data);
if (order.massa < 1000)
{
dataList.Add(" кг.");
}
else
{
dataList.Add(order.massa.ToString());
}
dataList.Add(order.Name);
dataList.Add(order.nameTU);
dataList.Add(order.PlanZakaz.ToString());
dataList.Add(order.PZ_ProductType.tu);
dataList.Add(DateTime.Now.Year.ToString());
}
return(dataList.ToArray());
}
}
bool UpdatePZList(int[] pZ_PlanZakaz, int id_Reclamation)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var listLastPz = db.ServiceRemarksPlanZakazs.Where(d => d.id_ServiceRemarks == id_Reclamation).ToList();
foreach (var lastReclamationPZ in listLastPz)
{
if (pZ_PlanZakaz.Where(d => d == lastReclamationPZ.id_PZ_PlanZakaz).Count() == 0)
{
db.ServiceRemarksPlanZakazs.Remove(lastReclamationPZ);
db.SaveChanges();
}
}
listLastPz = db.ServiceRemarksPlanZakazs.Where(d => d.id_ServiceRemarks == id_Reclamation).ToList();
foreach (var newReclamationPZ in pZ_PlanZakaz)
{
if (listLastPz.Where(d => d.id_PZ_PlanZakaz == newReclamationPZ).Count() == 0)
{
ServiceRemarksPlanZakazs reclamation_PZ = new ServiceRemarksPlanZakazs
{
id_PZ_PlanZakaz = newReclamationPZ,
id_ServiceRemarks = id_Reclamation
};
db.ServiceRemarksPlanZakazs.Add(reclamation_PZ);
db.SaveChanges();
}
}
}
return(true);
}
public JsonResult Update(int id_OrdersTables, int[] ordersList)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var posList = db.OrdersTablesPositions.Where(d => d.id_OrdersTables == id_OrdersTables).ToList();
foreach (var pos in posList)
{
if (ordersList.Where(d => d == pos.id_PZ_PlanZakaz).Count() == 0)
{
db.OrdersTablesPositions.Remove(pos);
db.SaveChanges();
}
}
posList = db.OrdersTablesPositions.Where(d => d.id_OrdersTables == id_OrdersTables).ToList();
foreach (var ord in ordersList)
{
if (posList.Where(d => d.id_PZ_PlanZakaz == ord).Count() == 0)
{
OrdersTablesPositions order = new OrdersTablesPositions
{
isActive = true,
id_PZ_PlanZakaz = ord,
id_OrdersTables = id_OrdersTables
};
db.OrdersTablesPositions.Add(order);
db.SaveChanges();
}
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
}
public JsonResult UpdateOrder(int id, DateTime?continueDate, DateTime?finishDate)
{
string login = HttpContext.User.Identity.Name;
try
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
PlexiglassOrder order = db.PlexiglassOrder.Find(id);
if (order.continueDate != continueDate)
{
order.continueDate = continueDate;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
}
if (order.finishDate != finishDate)
{
order.finishDate = finishDate;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
logger.Error("PlexiglasController / UpdateOrder: " + " | " + ex + " | " + login);
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
public JsonResult TEOList()
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var query = db.PZ_TEO
.AsNoTracking()
.Include(d => d.PZ_PlanZakaz)
.Include(d => d.PZ_Currency)
.OrderByDescending(d => d.PZ_PlanZakaz.PlanZakaz)
.ToList();
var data = query.Select(dataList => new
{
editLink = "<td><a href=" + '\u0022' + "#" + '\u0022' + " onclick=" + '\u0022' + "return getTEO('" + dataList.id + "')" + '\u0022' + "><span class=" + '\u0022' + "glyphicon glyphicon-pencil" + '\u0022' + "></span></a></td>",
order = dataList.PZ_PlanZakaz.PlanZakaz,
dataList.Rate,
dataList.SSM,
dataList.SSR,
dataList.IzdKom,
dataList.IzdPPKredit,
dataList.PI,
dataList.NOP,
dataList.KI_S,
dataList.KI_prochee,
dataList.OtpuskChena,
Currency = dataList.PZ_Currency.Name,
dataList.NDS
});
return(Json(new { data }));
}
}
