/***************************CRUD*******************************************************************************/
public OperationResult AddEquipment(Models.Context.Equipment equipment)
{
try
{
equipment.EQID = emcs.SelectScalar <string>("select dbo.GenNewID('Equipment',@department)", new object[] { equipment.Department });
foreach (var manual in equipment.Manuals)
{
manual.EQID = equipment.EQID;
manual.Version = 1;
manual.State = "1";
}
foreach (var method in equipment.Methods)
{
method.EQID = equipment.EQID;
method.Version = 1;
method.State = "1";
}
foreach (var steq in equipment.StandardEQs)
{
steq.EQID = equipment.EQID;
}
emcs_context.Equipments.Add(equipment);
emcs_context.SaveChanges();
operationResult.Success = true;
operationResult.Message = "Added Successed!";
operationResult.Caption = "Successed!";
}
catch (Exception ex)
{
operationResult.Success = false;
operationResult.Message = "There are some things wrong: " + ex.ToString();
operationResult.Caption = "Error!";
Loger.Error(ex);
}
var loginfo = String.Format("EMCS - AddEquipment - {0}", equipment.EQID);
Console.WriteLine(loginfo);
Loger.Info(loginfo);
return(operationResult);
}
public IHttpActionResult UpdateEquipment(Models.Context.Equipment equipment) => Ok(_equipmentService.UpdateEquipment(equipment));
public OperationResult UpdateEquipment(Models.Context.Equipment e)
{
try
{
e.Stamp = DateTime.Now;
var currentManuals = emcs_context.Manuals.Where(x => x.EQID == e.EQID);
emcs_context.Manuals.RemoveRange(currentManuals);
if (e.Manuals.Count > 0)
{
foreach (var manual in e.Manuals)
{
manual.EQID = e.EQID;
manual.Version = 1;
manual.State = "1";
}
emcs_context.Manuals.AddRange(e.Manuals);
e.Manuals = null;
}
var currentMethods = emcs_context.Methods.Where(x => x.EQID == e.EQID);
emcs_context.Methods.RemoveRange(currentMethods);
if (e.Methods.Count > 0)
{
foreach (var method in e.Methods)
{
method.EQID = e.EQID;
method.Version = 1;
method.State = "1";
}
emcs_context.Methods.AddRange(e.Methods);
e.Methods = null;
}
var currentStandardEQs = emcs_context.StandardEQs.Where(x => x.EQID == e.EQID);
emcs_context.StandardEQs.RemoveRange(currentStandardEQs);
if (e.StandardEQs.Count > 0)
{
foreach (var steq in e.StandardEQs)
{
steq.EQID = e.EQID;
}
emcs_context.StandardEQs.AddRange(e.StandardEQs);
e.StandardEQs = null;
}
var current_e = emcs_context.Equipments.Find(e.EQID);
emcs_context.Entry(current_e).CurrentValues.SetValues(e);
emcs_context.SaveChanges();
operationResult.Success = true;
operationResult.Message = "Update Successed!";
operationResult.Caption = "Successed!";
}
catch (Exception ex)
{
operationResult.Success = false;
operationResult.Message = "There are some things wrong: " + ex.ToString();
operationResult.Caption = "Error!";
Loger.Error(ex);
}
var loginfo = String.Format("EMCS - UpdateEquipment - {0}", e.EQID);
Console.WriteLine(loginfo);
Loger.Info(loginfo);
return(operationResult);
}
