public DecisionMessage(int EquipmentID)
{
db = new TExpEntities();
Equipment = db.t_Equipment.Find(EquipmentID);
Message = db.t_Message.FirstOrDefault();
CostOfRepair = db.t_CostOfRepair.Find(EquipmentID);
}
public IHttpActionResult Putt_Message(int id, t_Message t_Message)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != t_Message.MessageId)
{
return(BadRequest());
}
db.Entry(t_Message).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!t_MessageExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Gett_Message(int id)
{
t_Message t_Message = db.t_Message.Find(id);
if (t_Message == null)
{
return(NotFound());
}
return(Ok(t_Message));
}
public IHttpActionResult Deletet_Message(int id)
{
t_Message t_Message = db.t_Message.Find(id);
if (t_Message == null)
{
return(NotFound());
}
db.t_Message.Remove(t_Message);
db.SaveChanges();
return(Ok(t_Message));
}
public IHttpActionResult Postt_Message(t_Message t_Message)
{
#if DEBUG
Debug.WriteLine("Postt_Message");
#endif
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
#if DEBUG
//Debug.WriteLine(String.Format("MessageId={0}"),t_Message.MessageId.ToString());
#endif
db.t_Message.Add(t_Message);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = t_Message.MessageId }, t_Message));
}
public IHttpActionResult Put(int id, ExpertiseModel expertiseModel)
{
#if DEBUG
Debug.WriteLine(String.Format("Id={0},Staff={1}", expertiseModel.ExpertiseId.ToString(), expertiseModel.Staff));
#endif
//ExpertiseModel expertise = db.t_Expertise.Where(w => w.EquipmentId == expertiseModel.EquipmentId).Select(s => new ExpertiseModel() {EquipmentId=s.EquipmentId,Staff=s.Staff,Reason=s.Reason,Conclusion=s.Conclusion }).FirstOrDefault();
t_Expertise expertise = db.t_Expertise.Find(expertiseModel.ExpertiseId);
//t_Expertise expertise = db.t_Expertise.Find(id);
// if expertise is null then new act of expertise
if (expertise == null)
{
expertise = new t_Expertise();
//expertise.EquipmentId = id;
expertise.Conclusion = expertiseModel.Conclusion;
expertise.Reason = expertiseModel.Reason;
expertise.Staff = expertiseModel.Staff; //user
expertise.NumberExp = expertiseModel.NumberExp;
#if DEBUG
Debug.WriteLine("expertise == null expertiseModel.DateExp=" + expertiseModel.DateExp);
//Debug.WriteLine(DateTimeOffset.Parse(expertiseModel.DateExp).ToString());
#endif
expertise.DateExp = expertiseModel.DateExp; //new DateTimeOffset()
expertise.Staff2 = expertiseModel.Staff2; // customer
expertise.RequestId = expertiseModel.RequestId;
#if DEBUG
Debug.WriteLine("expertiseModel.IsServiceableEquipment=" + expertiseModel.IsServiceableEquipment.ToString());
//Debug.WriteLine("^^^^^ FIO=" + user.FIO);
#endif
expertise.IsServiceableEquipment = expertiseModel.IsServiceableEquipment;
expertise.IsWarrantyRepair = expertiseModel.IsWarrantyRepair;
expertise.IsOrganizationRepair = expertiseModel.IsOrganizationRepair;
expertise.IsPartsSupply = expertiseModel.IsPartsSupply;
expertise.IsServiceable = expertiseModel.IsServiceable;
expertise.IsForWriteoff = expertiseModel.IsForWriteoff;
db.t_Expertise.Add(expertise);
db.SaveChanges();
db.Entry(expertise).GetDatabaseValues();
t_Equipment equipment = db.t_Equipment.Find(id);
if (equipment != null)
{
equipment.t_Expertise.Add(expertise);
db.SaveChanges();
}
#if DEBUG
else
{
Debug.WriteLine("equipment is null!");
}
#endif
// fill table t_UserExpertise
var user = _userManager.FindByName(_userName);
if (user != null)
{
ExpertiseUser expertiseUser = new ExpertiseUser();
expertiseUser.AddUserToExpertise(expertise.ExpertiseId, user.UserID);
}
#if DEBUG
else
{
Debug.WriteLine("user is null!");
}
#endif
try
{
t_Message message = db.t_Message.FirstOrDefault();
if (message != null)
{
message.LastNumber = expertiseModel.NumberExp;
db.Entry(message).State = EntityState.Modified;
db.SaveChanges();
}
#if DEBUG
else
{
Debug.WriteLine("message is null");
}
#endif
}
catch (Exception)
{
throw;
}
}
else
{
expertise.Conclusion = expertiseModel.Conclusion;
expertise.Reason = expertiseModel.Reason;
expertise.Staff = expertiseModel.Staff;
expertise.NumberExp = expertiseModel.NumberExp;
expertise.DateExp = expertiseModel.DateExp;
expertise.Staff2 = expertiseModel.Staff2;
expertise.RequestId = expertiseModel.RequestId;
expertise.IsServiceableEquipment = expertiseModel.IsServiceableEquipment;
expertise.IsWarrantyRepair = expertiseModel.IsWarrantyRepair;
expertise.IsOrganizationRepair = expertiseModel.IsOrganizationRepair;
expertise.IsPartsSupply = expertiseModel.IsPartsSupply;
expertise.IsServiceable = expertiseModel.IsServiceable;
expertise.IsForWriteoff = expertiseModel.IsForWriteoff;
db.Entry(expertise).State = EntityState.Modified;
db.SaveChanges();
}
return(StatusCode(HttpStatusCode.NoContent));
}
