public UpdateDesignationViewModel GetDesignationForUpdateById(short DesignationRowID) { try { UpdateDesignationViewModel model = new UpdateDesignationViewModel(); var entity = db.MasterDesignations.Find(DesignationRowID); if (entity != null) { model.DesignationRowID = entity.DesignationRowID; model.DesignationName = entity.DesignationName; model.DepartmentRowID = entity.DepartmentRowID; model.Status = entity.Status; } else { throw new Exception("Invalid Id!"); } return(model); } catch (Exception) { throw; } }
public void UpdateDesignation(UpdateDesignationViewModel model) { try { if (model != null && model.DesignationRowID > 0) { db.MasterDesignations.Single(c => c.DesignationRowID == model.DesignationRowID).DesignationName = model.DesignationName; db.MasterDesignations.Single(c => c.DesignationRowID == model.DesignationRowID).DepartmentRowID = model.DepartmentRowID; } else { throw new Exception("Designation could not be blank!"); } } catch (Exception) { throw; } }
public bool IsDesignationExist(UpdateDesignationViewModel model) { try { var Designation = db.MasterDesignations.Where(c => c.DesignationName.Trim().ToLower() == model.DesignationName.Trim().ToLower() && c.DepartmentRowID == model.DepartmentRowID && c.DesignationRowID != model.DesignationRowID).FirstOrDefault(); if (Designation != null) { return(true); } else { return(false); } } catch (Exception) { throw; } }