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 RemoveAnsw(int idAnsw)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
ServiceRemarksActions serviceRemarksActions = db.ServiceRemarksActions.Find(idAnsw);
db.ServiceRemarksActions.Remove(serviceRemarksActions);
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));
}
}
public JsonResult UpdateAnsw(int idAnsw, string textAnws)
{
using (PortalKATEKEntities db = new PortalKATEKEntities())
{
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
ServiceRemarksActions serviceRemarksActions = db.ServiceRemarksActions.Find(idAnsw);
if (textAnws != null && textAnws != "")
{
serviceRemarksActions.text = textAnws;
db.Entry(serviceRemarksActions).State = EntityState.Modified;
db.SaveChanges();
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
}
