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));
}
public JsonResult Update(ServiceRemarks reclamation, int[] pZ_PlanZakaz, int[] id_Reclamation_Type, int[] id_ServiceRemarksCause, string answerText)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
ServiceRemarks beforeUpdateRemark = db.ServiceRemarks.Find(reclamation.id);
try
{
beforeUpdateRemark.dateClose = reclamation.dateClose;
}
catch
{
}
if (reclamation.description == null)
{
reclamation.description = "";
}
if (reclamation.contacts == null)
{
reclamation.contacts = "";
}
if (reclamation.folder == null)
{
reclamation.folder = "";
}
beforeUpdateRemark.datePutToService = reclamation.datePutToService;
beforeUpdateRemark.description = reclamation.description;
beforeUpdateRemark.folder = reclamation.folder;
beforeUpdateRemark.text = reclamation.text;
beforeUpdateRemark.contacts = reclamation.contacts;
db.Entry(beforeUpdateRemark).State = EntityState.Modified;
db.SaveChanges();
if (answerText != "")
{
string login = HttpContext.User.Identity.Name;
ServiceRemarksActions serviceRemarksActions = new ServiceRemarksActions();
serviceRemarksActions.dateTimeCreate = DateTime.Now;
serviceRemarksActions.id_AspNetUsersCreate = db.AspNetUsers.First(d => d.Email == login).Id;
serviceRemarksActions.id_ServiceRemarks = beforeUpdateRemark.id;
serviceRemarksActions.text = answerText;
db.ServiceRemarksActions.Add(serviceRemarksActions);
db.SaveChanges();
}
UpdatePZList(pZ_PlanZakaz, beforeUpdateRemark.id);
UpdateTypes(id_Reclamation_Type, beforeUpdateRemark.id);
UpdateCause(id_ServiceRemarksCause, beforeUpdateRemark.id);
return(Json(beforeUpdateRemark.id, JsonRequestBehavior.AllowGet));
}
}
