bool UpdateReclamation_PZ(int[] pZ_PlanZakaz, int id_Reclamation)
{
var listLastPz = db.Reclamation_PZ.Where(d => d.id_Reclamation == id_Reclamation).ToList();
foreach (var lastReclamationPZ in listLastPz)
{
if (pZ_PlanZakaz.Where(d => d == lastReclamationPZ.id_PZ_PlanZakaz).Count() == 0)
{
db.Reclamation_PZ.Remove(lastReclamationPZ);
db.SaveChanges();
}
}
listLastPz = db.Reclamation_PZ.Where(d => d.id_Reclamation == id_Reclamation).ToList();
foreach (var newReclamationPZ in pZ_PlanZakaz)
{
if (listLastPz.Where(d => d.id_PZ_PlanZakaz == newReclamationPZ).Count() == 0)
{
Reclamation_PZ reclamation_PZ = new Reclamation_PZ
{
id_PZ_PlanZakaz = newReclamationPZ,
id_Reclamation = id_Reclamation
};
db.Reclamation_PZ.Add(reclamation_PZ);
db.SaveChanges();
}
}
return(true);
}
public JsonResult AddRem(int id, int[] pZ_PlanZakaz, int typeRem, int devRem, string textRem,
int pfRem, bool technicalAdviceRem)
{
string login = HttpContext.User.Identity.Name;
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
Wiki.Reclamation reclamation = new Wiki.Reclamation
{
id_Reclamation_Type = typeRem,
id_DevisionReclamation = devRem,
id_Reclamation_CountErrorFinal = 1,
id_Reclamation_CountErrorFirst = 1,
id_AspNetUsersCreate = db.AspNetUsers.First(d => d.Email == login).Id,
id_DevisionCreate = db.AspNetUsers.First(d => d.Email == login).Devision.Value,
dateTimeCreate = DateTime.Now,
text = textRem,
description = "",
timeToSearch = 0,
timeToEliminate = 0,
close = true,
gip = false,
closeDevision = false,
PCAM = "",
editManufacturing = false,
id_PF = pfRem,
technicalAdvice = technicalAdviceRem,
closeMKO = false,
closeKO = false,
fixedExpert = false,
id_ReclamationTypeKB = 26
};
db.Reclamation.Add(reclamation);
db.SaveChanges();
ServiceRemarksReclamations serviceRemarksReclamations = new ServiceRemarksReclamations
{
id_Reclamation = reclamation.id,
id_ServiceRemarks = id
};
db.ServiceRemarksReclamations.Add(serviceRemarksReclamations);
db.SaveChanges();
foreach (var data in pZ_PlanZakaz)
{
Reclamation_PZ reclamation_PZ = new Reclamation_PZ
{
id_PZ_PlanZakaz = data,
id_Reclamation = reclamation.id
};
db.Reclamation_PZ.Add(reclamation_PZ);
db.SaveChanges();
}
}
return(Json(id, JsonRequestBehavior.AllowGet));
}
bool CreateReclamation_PZ(int[] pZ_PlanZakaz, int id_Reclamation)
{
foreach (var pz in pZ_PlanZakaz)
{
Reclamation_PZ reclamation_PZ = new Reclamation_PZ
{
id_PZ_PlanZakaz = pz,
id_Reclamation = id_Reclamation
};
db.Reclamation_PZ.Add(reclamation_PZ);
db.SaveChanges();
}
return(true);
}
