public bool UpdateCategory(MS_Category category) { string sql = " Update MS_Category set CategoryName=@CategoryName,CategoryCode=@CategoryCode,OrganizationId=@OrganizationId," + " LastUpdatedBy=@LastUpdatedBy,LastUpdatedDate=@LastUpdatedDate" + " where CategoryId=@CategoryId"; using (var db = DbHelper.GetDBConnection()) { using (var trsn = new TransactionScope()) { //db.Execute(sql); var lst = db.Execute(sql, category); trsn.Complete(); db.Close(); if (lst > 0) { return(true); } else { return(false); } } } }
public bool InsertCategory(MS_Category category) { string sql = " Insert into MS_Category (CategoryName,CategoryCode,OrganizationId,EnteredBy,EnteredDate," + " LastUpdatedBy,LastUpdatedDate,IsDeleted,DeletedDate,DeletedBy) " + " values " + "(@CategoryName,@CategoryCode,@OrganizationId,@EnteredBy,@EnteredDate," + "0,null,0,null,0)"; using (var db = DbHelper.GetDBConnection()) { using (var trsn = new TransactionScope()) { //db.Execute(sql); var lst = db.Execute(sql, category); trsn.Complete(); db.Close(); if (lst > 0) { return(true); } else { return(false); } } } }
// GET: Category/Edit/5 public ActionResult Edit(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } MS_Category mS_Category = db.GetCategoryById((int)id); if (mS_Category == null) { return HttpNotFound(); } ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", mS_Category.OrganizationId); return View(mS_Category); }
public ActionResult Edit(FormCollection frm) { var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId); int orgid = ses.OrganizationId; MS_Category mS_Category = db.GetCategoryById(Convert.ToInt32(frm["CategoryId"])); mS_Category.CategoryName = frm["CategoryName"]; mS_Category.CategoryCode = frm["CategoryCode"]; mS_Category.OrganizationId = orgid;// Convert.ToInt32(frm["OrganizationId"]); mS_Category.LastUpdatedBy = (User as CustomPrincipal).UserId; mS_Category.LastUpdatedDate = DateTime.Now; if (ModelState.IsValid) { db.UpdateCategory(mS_Category); return RedirectToAction("Index"); } ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", mS_Category.OrganizationId); return View(mS_Category); }
public void CreateMsCategory(CreateCategoryInputDto input) { Logger.Info("CreateMsCategory() - Started."); Logger.DebugFormat("CreateMsCategory() - Start checking before insert Category. Parameters sent:{0}" + "categoryCode = {1}{0}" + "categoryName = {2}{0}" , Environment.NewLine, input.categoryCode, input.categoryName); bool checkCategory = (from A in _msCategoryRepo.GetAll() where A.categoryCode == input.categoryCode || A.categoryName == input.categoryName select A).Any(); Logger.DebugFormat("CreateMsCategory() - Ended checking before insert Category. Result = {0}", checkCategory); if (!checkCategory) { var createMsCategory = new MS_Category { categoryName = input.categoryName, categoryCode = input.categoryCode, projectField = "-", //hardcode for not null field areaField = "-", //hardcode for not null field categoryField = "-", //hardcode for not null field clusterField = "-", //hardcode for not null field productField = "-", //hardcode for not null field detailField = "-", //hardcode for not null field zoningField = "-", //hardcode for not null field facingField = "-", //hardcode for not null field roadField = "-", //hardcode for not null field kavNoField = "-" }; try { Logger.DebugFormat("CreateMsCategory() - Start insert Category. Parameters sent:{0}" + "categoryName = {1}{0}" + "categoryCode = {2}{0}" + "projectField = {3}{0}" + "areaField = {4}{0}" + "categoryField = {5}{0}" + "clusterField = {6}{0}" + "productField = {7}{0}" + "detailField = {8}{0}" + "zoningField = {9}{0}" + "facingField = {10}{0}" + "roadField = {11}{0}" + "kavNoField = {12}{0}" , Environment.NewLine, input.categoryName, input.categoryCode, "-", "-", "-", "-", "-" , "-", "-", "-", "-", "-"); _msCategoryRepo.Insert(createMsCategory); CurrentUnitOfWork.SaveChanges(); Logger.DebugFormat("CreateMsCategory() - Ended insert Category."); } /*catch (DbEntityValidationException ex) * { * var errorMessages = ex.EntityValidationErrors * .SelectMany(x => x.ValidationErrors) * .Select(x => x.ErrorMessage); * string fullErrorMessage = string.Join("; ", errorMessages); * string exceptionMessage = string.Concat("Validation Error: ", fullErrorMessage); * Logger.ErrorFormat("CreateMsCategory() - ERROR DbEntityValidationException. Result = {0}", exceptionMessage); * throw new UserFriendlyException(exceptionMessage); * }*/ catch (DataException ex) { Logger.ErrorFormat("CreateMsCategory() - ERROR DataException. Result = {0}", ex.Message); throw new UserFriendlyException("Db Error: " + ex.Message); } catch (Exception ex) { Logger.ErrorFormat("CreateMsCategory() - ERROR Exception. Result = {0}", ex.Message); throw new UserFriendlyException("Error: " + ex.Message); } } else { Logger.ErrorFormat("CreateMsCategory() - ERROR Exception.", "Category Code or Category Name Already Exist !"); throw new UserFriendlyException("Category Code or Category Name Already Exist !"); } Logger.Info("CreateMsCategory() - Finished."); }