public string DeleteParameters(LakeParameter item) { string msg = string.Empty; item.ParameterActive = false; try { if (ModelState.IsValid) { _LakeSvc.InactivateParameter(item); msg = "Parameters inactivated succesfully"; } else { msg = "Data validation not successfull"; } } catch (Exception e) { msg = "Delete Parameters. An error has ocurred"; } return(msg); }
public bool UpdateParameter(LakeParameter item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Lake_Parameter efItem = context.Lake_Parameter.Where(b => b.ParameterID == item.ParameterID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.ParameterActive = item.ParameterActive; efItem.ParameterFullName = item.ParameterFullName; efItem.ParameterName = item.ParameterName; efItem.ParameterTestMethod = item.ParameterTestMethod; efItem.ParameterUnit = item.ParameterUnit; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public string CreateParameters([Bind(Exclude = "ParametersID")] LakeParameter item) { string msg = string.Empty; try { if (ModelState.IsValid) { _LakeSvc.CreateParameter(item); msg = "Parameters created succesfully"; } else { msg = "Data validation not successfull"; } } catch (Exception e) { msg = "Create Parameters. An error has ocurred"; } return(msg); }
public int CreateParameter(LakeParameter item) { byte newid = 0; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { var lastItem = context.Lake_Parameter.OrderByDescending(u => u.ParameterID).FirstOrDefault(); if (lastItem != null) { newid = lastItem.ParameterID; newid++; } Lake_Parameter efItem = new Lake_Parameter() { ParameterActive = item.ParameterActive, ParameterFullName = item.ParameterFullName, ParameterID = newid, ParameterName = item.ParameterName, ParameterTestMethod = item.ParameterTestMethod, ParameterUnit = item.ParameterUnit }; context.Lake_Parameter.Add(efItem); if (context.SaveChanges() > 0) { return(newid); } } } catch (Exception e) { throw e; } return(newid); }
public string EditParameters(LakeParameter item) { string msg = "Edit Parameters. An error has ocurred"; try { if (!ModelState.IsValid) { msg = "Data validation not successfull"; return(msg); } if (_LakeSvc.UpdateParameter(item)) { msg = "Parameters saved succesfully"; } } catch (Exception e) { msg = "Edit Parameters. An error has ocurred"; } return(msg); }
public bool InactivateParameter(LakeParameter item) { return(_LakeRepo.InactivateParameter(item)); }
public int CreateParameter(LakeParameter item) { return(_LakeRepo.CreateParameter(item)); }
public bool UpdateParameter(LakeParameter item) { return(_LakeRepo.UpdateParameter(item)); }