public ActionResult EditMeasurementType(string MUID)
{
EtronixValidation EV = new EtronixValidation();
int alert = -1;
string vMessage = null;
Entities _contextEntities;
UpdateMeasurementTypeViewModel vUpdateMeasurementTypeViewModel = new UpdateMeasurementTypeViewModel();
try
{
_contextEntities = new Entities();
var vParameter = new SqlParameter("@MUID", MUID);
Procedures.MeasurementUnitTypes vMeasurementType =
_contextEntities.Database.SqlQuery <Procedures.MeasurementUnitTypes>(
"GetMeasurementType " + "@MUID ",
vParameter).SingleOrDefault();
vUpdateMeasurementTypeViewModel.Id = vMeasurementType.Id.ToString();
vUpdateMeasurementTypeViewModel.Type = vMeasurementType.Type;
vUpdateMeasurementTypeViewModel.NewType = "";
vUpdateMeasurementTypeViewModel.EtronixValidation = EV;
}
catch (Exception exception)
{
//Console.WriteLine(exception.Message);
alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger;
vMessage = exception.Message + Environment.NewLine;
EV.ValidationCode = EtronixValidationCode.ValidationDic[alert];
EV.AddToList(vMessage);
vUpdateMeasurementTypeViewModel.EtronixValidation = EV;
}
return(View(vUpdateMeasurementTypeViewModel));
}
public ActionResult AddType(MeasurementTypeViewModel pDataViewModel)
{
Entities _contextEntities;
MeasurementTypeViewModel measurementTypeViewModel = new MeasurementTypeViewModel();
measurementTypeViewModel.Id = pDataViewModel.Id;
measurementTypeViewModel.Type = pDataViewModel.Type;
EtronixValidation EV = new EtronixValidation();
int alert = -1;
string vMessage = null;
if (ModelState["Type"].Errors.Count == 0)
{
try
{
//get details of the changing person
_contextEntities = new Entities();
var vMeasurementType = new SqlParameter("@Type", pDataViewModel.Type);
Procedures.MeasurementUnitTypes vMeasurementUnitTypes = _contextEntities.Database.SqlQuery <Procedures.MeasurementUnitTypes>(
"InsertMeasurementType " + "@Type ",
vMeasurementType).SingleOrDefault();
//2 commands clear the field of Unit_type
measurementTypeViewModel.Type = null;
ModelState.Clear();
}
catch (Exception exception)
{
alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger;
vMessage = exception.Message;
EV.ValidationCode = EtronixValidationCode.ValidationDic[alert];
EV.AddToList(vMessage);
measurementTypeViewModel.EtronixValidation = EV;
goto End;
}
alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_success;
vMessage = "The measurement type was successfully added";
EV.ValidationCode = EtronixValidationCode.ValidationDic[alert];
EV.AddToList(vMessage);
measurementTypeViewModel.EtronixValidation = EV;
}
else
{
List <string> mE = ModelState.Values.SelectMany(x => x.Errors).Select(e => e.ErrorMessage).ToList();
alert = (int)EtronixValidationCode.ValidationCodeEnum.alert_danger;
EV.ValidationCode = EtronixValidationCode.ValidationDic[alert];
foreach (var msg in mE)
{
EV.AddToList(msg);
}
measurementTypeViewModel.EtronixValidation = EV;
}
//return RedirectToAction("Index", new RouteValueDictionary(new {Type ="haha"}));
End:
return(View("Index", measurementTypeViewModel));
}
