public StateModel GetStateInfo(int ID = 0) { ShomaRMEntities db = new ShomaRMEntities(); StateModel model = new StateModel(); model.ID = 0; model.StateName = ""; model.Abbreviation = ""; var stateInfo = db.tbl_State.Where(p => p.ID == ID).FirstOrDefault(); if (stateInfo != null) { model.ID = stateInfo.ID; model.StateName = stateInfo.StateName; model.Abbreviation = stateInfo.Abbreviation; } return(model); }
public long SaveUpdateState(StateModel model) { ShomaRMEntities db = new ShomaRMEntities(); var userNameExists = db.tbl_State.Where(p => p.ID != model.ID && p.StateName == model.StateName).FirstOrDefault(); if (userNameExists == null) { if (model.ID == 0) { var userData = new tbl_State() { StateName = model.StateName, Abbreviation = model.Abbreviation, }; db.tbl_State.Add(userData); db.SaveChanges(); model.ID = userData.ID; } else { var stateInfo = db.tbl_State.Where(p => p.ID == model.ID).FirstOrDefault(); if (stateInfo != null) { stateInfo.StateName = model.StateName; stateInfo.Abbreviation = model.Abbreviation; db.SaveChanges(); } else { throw new Exception(model.StateName + " not exists in the system."); } } return(model.ID); } else { throw new Exception(model.StateName + " already exists in the system."); } }