bool UpdateCause(int[] pZ_PlanZakaz, int id_Reclamation)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var listLastPz = db.ServiceRemarksCauses.Where(d => d.id_ServiceRemarks == id_Reclamation).ToList();
foreach (var lastReclamationPZ in listLastPz)
{
if (pZ_PlanZakaz.Where(d => d == lastReclamationPZ.id_ServiceRemarksCause).Count() == 0)
{
db.ServiceRemarksCauses.Remove(lastReclamationPZ);
db.SaveChanges();
}
}
listLastPz = db.ServiceRemarksCauses.Where(d => d.id_ServiceRemarks == id_Reclamation).ToList();
foreach (var newReclamationPZ in pZ_PlanZakaz)
{
if (listLastPz.Where(d => d.id_ServiceRemarksCause == newReclamationPZ).Count() == 0)
{
ServiceRemarksCauses reclamation_PZ = new ServiceRemarksCauses
{
id_ServiceRemarksCause = newReclamationPZ,
id_ServiceRemarks = id_Reclamation
};
db.ServiceRemarksCauses.Add(reclamation_PZ);
db.SaveChanges();
}
}
}
return(true);
}
public JsonResult Add(ServiceRemarks reclamation, int[] pZ_PlanZakaz, int[] id_Reclamation_Type, int[] id_ServiceRemarksCause)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
if (reclamation.description == null)
{
reclamation.description = "";
}
if (reclamation.folder == null)
{
reclamation.folder = "";
}
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
string login = HttpContext.User.Identity.Name;
reclamation.dateTimeCreate = DateTime.Now;
reclamation.userCreate = db.AspNetUsers.First(d => d.Email == login).Id;
if (reclamation.description == null)
{
reclamation.description = "";
}
if (reclamation.folder == null)
{
reclamation.folder = "";
}
db.ServiceRemarks.Add(reclamation);
db.SaveChanges();
string directory = @"\\192.168.1.30\m$\_ЗАКАЗЫ\Рекламации_Сервисного_Центра\" + reclamation.id.ToString();
Directory.CreateDirectory(directory);
reclamation.folder = @"\\192.168.1.30\m$\_ЗАКАЗЫ\Рекламации_Сервисного_Центра\" + reclamation.id.ToString() + @"\";
db.Entry(reclamation).State = EntityState.Modified;
db.SaveChanges();
foreach (var data in pZ_PlanZakaz)
{
ServiceRemarksPlanZakazs remarkOrder = new ServiceRemarksPlanZakazs();
remarkOrder.id_ServiceRemarks = reclamation.id;
remarkOrder.id_PZ_PlanZakaz = data;
db.ServiceRemarksPlanZakazs.Add(remarkOrder);
db.SaveChanges();
}
foreach (var data in id_Reclamation_Type)
{
ServiceRemarksTypes remarkOrder = new ServiceRemarksTypes();
remarkOrder.id_ServiceRemarks = reclamation.id;
remarkOrder.id_Reclamation_Type = data;
db.ServiceRemarksTypes.Add(remarkOrder);
db.SaveChanges();
}
foreach (var data in id_ServiceRemarksCause)
{
ServiceRemarksCauses remarkOrder = new ServiceRemarksCauses();
remarkOrder.id_ServiceRemarks = reclamation.id;
remarkOrder.id_ServiceRemarksCause = data;
db.ServiceRemarksCauses.Add(remarkOrder);
db.SaveChanges();
}
}
return(Json(reclamation.id, JsonRequestBehavior.AllowGet));
}
public JsonResult Remove(int id)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
try
{
var list = db.ServiceRemarksCauses.Where(a => a.id_ServiceRemarks == id).ToList();
foreach (var data in list)
{
ServiceRemarksCauses serviceRemarksCauses = db.ServiceRemarksCauses.Find(data.id);
db.ServiceRemarksCauses.Remove(serviceRemarksCauses);
db.SaveChanges();
}
}
catch { }
try
{
var listP = db.ServiceRemarksPlanZakazs.Where(a => a.id_ServiceRemarks == id).ToList();
foreach (var data in listP)
{
ServiceRemarksPlanZakazs rd = db.ServiceRemarksPlanZakazs.Find(data.id);
db.ServiceRemarksPlanZakazs.Remove(rd);
db.SaveChanges();
}
}
catch { }
try
{
var listA = db.ServiceRemarksActions.Where(a => a.id_ServiceRemarks == id).ToList();
foreach (var data in listA)
{
ServiceRemarksActions act = db.ServiceRemarksActions.Find(data.id);
db.ServiceRemarksActions.Remove(act);
db.SaveChanges();
}
}
catch { }
try
{
var listT = db.ServiceRemarksTypes.Where(a => a.id_ServiceRemarks == id).ToList();
foreach (var data in listT)
{
ServiceRemarksTypes type = db.ServiceRemarksTypes.Find(data.id);
db.ServiceRemarksTypes.Remove(type);
db.SaveChanges();
}
}
catch { }
ServiceRemarks serviceRemarks = db.ServiceRemarks.Find(id);
db.ServiceRemarks.Remove(serviceRemarks);
db.SaveChanges();
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
