public ServiceCategoryModel GetServiceCategoryInfo(int ID = 0) { ShomaRMEntities db = new ShomaRMEntities(); ServiceCategoryModel model = new ServiceCategoryModel(); var ServiceCategory = db.tbl_ServiceIssue.Where(p => p.ServiceIssueID == ID).FirstOrDefault(); if (ServiceCategory != null) { model.ServiceIssueID = ServiceCategory.ServiceIssueID; model.ServiceIssue = ServiceCategory.ServiceIssue; } return(model); }
public long SaveUpdateServiceCategory(ServiceCategoryModel model) { ShomaRMEntities db = new ShomaRMEntities(); var userNameExists = db.tbl_ServiceIssue.Where(p => p.ServiceIssueID != model.ServiceIssueID && p.ServiceIssue == model.ServiceIssue).FirstOrDefault(); if (userNameExists == null) { if (model.ServiceIssueID == 0) { var ServiceData = new tbl_ServiceIssue() { ServiceIssue = model.ServiceIssue }; db.tbl_ServiceIssue.Add(ServiceData); db.SaveChanges(); model.ServiceIssueID = ServiceData.ServiceIssueID; } else { var ServiceIssueData = db.tbl_ServiceIssue.Where(p => p.ServiceIssueID == model.ServiceIssueID).FirstOrDefault(); if (ServiceIssueData != null) { ServiceIssueData.ServiceIssue = model.ServiceIssue; db.SaveChanges(); } else { throw new Exception(model.ServiceIssue + " not exists in the system."); } } return(model.ServiceIssueID); } else { throw new Exception(model.ServiceIssue + " already exists in the system."); } }