public JsonResult Update(Reclamation_TechnicalAdvice ta)
{
Reclamation_TechnicalAdvice technicalAdvice = db.Reclamation_TechnicalAdvice.Find(ta.id);
if (ta.text != null)
{
technicalAdvice.text = ta.text;
}
if (ta.description != null)
{
technicalAdvice.description = ta.description;
}
technicalAdvice.close = ta.close;
if (ta.id_AspNetUserResponsible != null)
{
technicalAdvice.id_AspNetUserResponsible = ta.id_AspNetUserResponsible;
}
if (ta.deadline != null)
{
technicalAdvice.deadline = ta.deadline;
}
db.Entry(technicalAdvice).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Json(1, JsonRequestBehavior.AllowGet));
}
bool CreateTechnicalAdvice(int id_Reclamation, string id_AspNetUser)
{
Reclamation_TechnicalAdvice technicalAdvice = new Reclamation_TechnicalAdvice
{
description = "",
id_AspNetUsersCreate = id_AspNetUser,
id_Reclamation = id_Reclamation,
dateTimeCreate = DateTime.Now,
text = ""
};
db.Reclamation_TechnicalAdvice.Add(technicalAdvice);
db.SaveChanges();
return(true);
}
bool UpdateTechnicalAdvice(int id_Reclamation, string aspNetUser)
{
if (db.Reclamation_TechnicalAdvice.Where(d => d.id_Reclamation == id_Reclamation).Count() == 0)
{
Reclamation_TechnicalAdvice technicalAdvice = new Reclamation_TechnicalAdvice
{
description = "",
id_AspNetUsersCreate = aspNetUser,
id_Reclamation = id_Reclamation,
dateTimeCreate = DateTime.Now,
text = ""
};
db.Reclamation_TechnicalAdvice.Add(technicalAdvice);
db.SaveChanges();
}
return(true);
}
public JsonResult CreateNewProtocol()
{
DateTime dateClose = DateTime.Now;
Reclamation_TechnicalAdviceProtocol protocol = new Reclamation_TechnicalAdviceProtocol();
protocol.date = dateClose;
protocol.number = db.Reclamation_TechnicalAdviceProtocol.Select(p => p.number).DefaultIfEmpty(0).Max() + 1;
db.Reclamation_TechnicalAdviceProtocol.Add(protocol);
db.SaveChanges();
foreach (var data in db.Reclamation_TechnicalAdvice.Where(d => d.dateTimeClose == null).ToList())
{
Reclamation_TechnicalAdvice ta = db.Reclamation_TechnicalAdvice.Find(data.id);
ta.dateTimeClose = dateClose;
db.Entry(ta).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
Reclamation_TechnicalAdviceProtocolPosition position = new Reclamation_TechnicalAdviceProtocolPosition();
position.id_Reclamation_TechnicalAdvice = ta.id;
position.id_Reclamation_TechnicalAdviceProtocol = protocol.id;
db.Reclamation_TechnicalAdviceProtocolPosition.Add(position);
db.SaveChanges();
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
public TAEdit(int id)
{
reclamation_TechnicalAdvice = db.Reclamation_TechnicalAdvice.Find(id);
reclamation = new ReclamationViwers(reclamation_TechnicalAdvice.Reclamation);
}
