public void Save(OutletCategoryViewModel outletCategoryViewModel) { OutletCategory outletCat = new OutletCategory(outletCategoryViewModel.Id) { Name = outletCategoryViewModel.Name, Code=outletCategoryViewModel.code }; _outletCategoryRepository.Save(outletCat); }
public ActionResult EditOutletCategory(OutletCategoryViewModel vm) { try { _outletCategoryViewModelBuilder.Save(vm); return RedirectToAction("listoutletcategories"); } catch (DomainValidationException ve) { ValidationSummary.DomainValidationErrors(ve, ModelState); return View(); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); return View(); } }
public ActionResult CreateOutletCategory(OutletCategoryViewModel outletCategoryViewModel) { try { string Create = Request.Params["Create"]; string process = Request.Params["process"]; _outletCategoryViewModelBuilder.Save(outletCategoryViewModel); return RedirectToAction("listoutletcategories"); } catch (DomainValidationException ve) { ValidationSummary.DomainValidationErrors(ve, ModelState); return View(outletCategoryViewModel); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); return View(outletCategoryViewModel); } }
public ActionResult ImportOutletCategory(HttpPostedFileBase file) { try { var fileName = Path.GetFileName(file.FileName); var directory = Server.MapPath("~/Uploads"); if (Directory.Exists(directory) == false) { Directory.CreateDirectory(directory); } var path = Server.MapPath("~/Uploads") + "\\" + fileName; file.SaveAs(path); string fileExtension = Path.GetExtension(fileName); if (fileExtension == ".xlsx") { ViewBag.msg = "Please wait. Upload in progress"; string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties='Excel 12.0;HDR=YES;'"; OleDbConnection conn = new OleDbConnection(connectionString); try { conn.Open(); OleDbCommand command = new OleDbCommand("SELECT code,name FROM [Sheet1$]", conn); OleDbDataReader reader = command.ExecuteReader(); OutletCategoryViewModel pdvm = new OutletCategoryViewModel(); while (reader.Read()) { string code = reader["code"].ToString(); string name = reader["name"].ToString(); bool hasDuplicateName = _outletCategoryViewModelBuilder.GetAll() .Any(p => p.Name == name); if (hasDuplicateName) { } else { pdvm.Name = name; pdvm.code = code; _outletCategoryViewModelBuilder.Save(pdvm); } } } catch (OleDbException ex) { ViewBag.msg = ex.ToString(); return View(); } finally { conn.Close(); } fi = new FileInfo(path); fi.Delete(); _auditLogViewModelBuilder.AddAuditLog(this.User.Identity.Name, "Import", "Outlet Category", DateTime.Now); ViewBag.msg = "Upload Successful"; return RedirectToAction("ListOutletCategories"); } else { fi = new FileInfo(path); fi.Delete(); ViewBag.msg = "Please upload excel file with extension .xlsx"; return View(); } } catch (Exception ex) { ViewBag.msg = ex.ToString(); return View(); } }
public ActionResult CreateOutletCategory(OutletCategoryViewModel outletCategoryViewModel) { try { string Create = Request.Params["Create"]; string process = Request.Params["process"]; outletCategoryViewModel.Id = Guid.NewGuid(); _outletCategoryViewModelBuilder.Save(outletCategoryViewModel); TempData["msg"] = "Outlet Category Successfully Created"; _auditLogViewModelBuilder.AddAuditLog(this.User.Identity.Name, "Create", "Outlet Category", DateTime.Now); return RedirectToAction("listoutletcategories"); } catch (DomainValidationException ve) { ValidationSummary.DomainValidationErrors(ve, ModelState); _log.Debug("Failed to create outlet categories " + ve.Message); _log.Error("Failed to create outlet categories" + ve.ToString()); return View(outletCategoryViewModel); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); _log.Debug("Failed to create outlet categories " + ex.Message); _log.Error("Failed to create outlet categories" + ex.ToString()); return View(outletCategoryViewModel); } }
public ActionResult EditOutletCategory(OutletCategoryViewModel vm) { try { _outletCategoryViewModelBuilder.Save(vm); TempData["msg"] = "Outlet Category Successfully Edited"; _auditLogViewModelBuilder.AddAuditLog(this.User.Identity.Name, "Edit", "Outlet Category", DateTime.Now); return RedirectToAction("listoutletcategories"); } catch (DomainValidationException ve) { ValidationSummary.DomainValidationErrors(ve, ModelState); _log.Debug("Failed to edit outlet categories " + ve.Message); _log.Error("Failed to edit outlet categories" + ve.ToString()); return View(); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); _log.Debug("Failed to edit outlet categories " + ex.Message); _log.Error("Failed to edit outlet categories" + ex.ToString()); return View(); } }