public CatalogueView GetCatalogue(int catalogueId, out string message) { CatalogueView result = new CatalogueView(); message = null; try { using (var db = new SqlConnection(conn)) { var parameters = new DynamicParameters(); string SqlQuery = "SELECT top 1 * FROM v_CatalogueInfo WHERE Id=@catalogueId"; if (catalogueId >= 0) { parameters.Add("@catalogueId", catalogueId); result = db.Query <CatalogueView>(SqlQuery, parameters).FirstOrDefault(); } else { message = String.Format(StaticResources.Resources.SYSTEM_ERROR_THE_PARAMETER_LARGE_ZERO, catalogueId); } } } catch (Exception ex) { string subject = "Error " + SiteSetting.SiteName + " at GetCatalogue at CatalogueRepo at Model.Repository"; message += subject + StringHelper.Parameters2ErrorString(ex, catalogueId); } return(result); }
/// <summary> /// Create a new catalogue /// </summary> /// <param name="model"></param> /// <param name="message"></param> /// <returns></returns> public CatalogueView CreateCatalogue(CatalogueView model, out string message) { CatalogueView result = new CatalogueView(); message = null; Catalogue catalogue = new Catalogue(); try { if (model != null) { ///site info /// catalogue.SiteName = model.SiteName; catalogue.SiteUrl = model.SiteUrl; catalogue.Name = model.CatalogueName; ///email catalogue.EmailSite = model.EmailSite; catalogue.EmailAdmin = model.EmailAdmin; ///address info catalogue.Address = model.Address; catalogue.Phones = model.Phones; ///seo catalogue.MetaKeywords = model.MetaKeywords; catalogue.MetaDescriptions = model.MetaDescriptions; catalogue.Facebook = model.Facebook; catalogue.Twitter = model.Twitter; catalogue.Youtube = model.Youtube; catalogue.GooglePlus = model.GooglePlus; //system catalogue.CreatedBy = model.CreatedById; catalogue.CreatedDate = DateTime.Now; catalogue.ModifiedDate = DateTime.Now; catalogue.ModifiedBy = model.ModifiedById; catalogue.Status = model.Status; catalogue = entities.Catalogues.Add(catalogue); if (entities.SaveChanges() > 0) { result = this.GetCatalogue(catalogue.Id, out message); } else { message = StaticResources.Resources.SYSTEM_ERROR_THE_UPDATING_WEBSITE_CONFI_HAS_BEEN_FINISHED; } } else { message = StaticResources.Resources.MSG_THE_CATEGORY_HAS_CREATED_UNSUCCESSFULLY; } } catch (Exception ex) { string subject = "Error " + SiteSetting.SiteName + " at CreateCatalogue at CatalogueRepo at Model.Repository. "; message += subject + StringHelper.Parameters2ErrorString(ex, model.Id); } return(result); }
public ActionResult SiteConfig(CatalogueView model) { CatalogueView remodel = new CatalogueView(); var actionStatus = new ActionResultHelper(); actionStatus.ActionStatus = ResultSubmit.failed; string errorString = ""; string message = ""; bool IsValid = true; //load site configtion if (ModelState.IsValid) { model.ModifiedById = 2; model.Id = SiteConfiguration.CatalogueId; remodel = _catalogueRepo.UpdateCatalogue(model, out message); //return RedirectToAction("SiteConfig"); if (String.IsNullOrWhiteSpace(message)) { actionStatus.ErrorReason = String.Format(SiteResource.HTML_ALERT_SUCCESS, SiteResource.MSG_THE_SITE_CONFIGUARATION_HAS_BEEN_UPDATED_SUCCESSFULLY); actionStatus.ActionStatus = ResultSubmit.success; Session["ACTION_STATUS"] = actionStatus; return(View(remodel)); } else { IsValid = false; errorString = message; goto actionError; } } else { IsValid = false; foreach (var item in ModelState.Values) { if (item.Errors.Count() > 0) { var errorItems = item.Errors.Where(f => !String.IsNullOrWhiteSpace(f.ErrorMessage)).ToList(); foreach (var erroritem in errorItems) { errorString += "<br />" + erroritem.ErrorMessage; } } } goto actionError; } actionError: if (!IsValid) { actionStatus.ErrorReason = String.Format(SiteResource.HTML_ALERT_ERROR, SiteResource.MSG_ERROR_ENTER_DATA_FOR_FORM + errorString); Session["ACTION_STATUS"] = actionStatus; } return(RedirectToAction("SiteConfig")); }
public ActionResult Create() { //load site configtion var model = new CatalogueView(); ViewBag.Title = "Tạo catalog mới"; ViewBag.Action = "Create"; return(View("Edit", model)); }
public ActionResult Edit(CatalogueView model, string saveclose, string savenew) { CatalogueView remodel = new CatalogueView(); var actionStatus = new ActionResultHelper(); actionStatus.ActionStatus = ResultSubmit.failed; string errorString = ""; string message = ""; bool IsValid = true; if (ModelState.IsValid) { model.ModifiedById = CurrentUser.ID; remodel = _catalogueRepo.UpdateCatalogue(model, out message); if (remodel != null && String.IsNullOrWhiteSpace(message)) { actionStatus.ErrorReason = String.Format(SiteResource.HTML_ALERT_SUCCESS, Resources.MSG_THE_SITE_CONFIGUARATION_HAS_BEEN_UPDATED_SUCCESSFULLY); actionStatus.ActionStatus = ResultSubmit.success; Session["ACTION_STATUS"] = actionStatus; if (!String.IsNullOrEmpty(saveclose)) { return(RedirectToAction("Index")); } else if (!String.IsNullOrWhiteSpace(savenew)) { return(RedirectToAction("Create")); } else { return(RedirectToAction("Edit", new { Id = remodel.Id })); } } else { IsValid = false; errorString = Resources.MSG_THE_SITE_CONFIGUARATION_HAS_BEEN_UPDATED_UNSUCCESSFULLY; goto actionError; } } actionError: if (!IsValid) { actionStatus.ErrorReason = String.Format(SiteResource.HTML_ALERT_ERROR, SiteResource.MSG_ERROR_ENTER_DATA_FOR_FORM + errorString); Session["ACTION_STATUS"] = actionStatus; } return(View(model)); }
public ActionResult Create(CatalogueView model, string saveclose = "", string savenew = "") { var actionStatus = new ActionResultHelper(); actionStatus.ActionStatus = ResultSubmit.failed; string message = ""; CatalogueView result = new CatalogueView(); if (ModelState.IsValid) { model.CreatedById = CurrentUser.UserID; model.ModifiedById = CurrentUser.UserID; result = _catalogueRepo.CreateCatalogue(model, out message); if (result != null && result.Id > 0) { actionStatus.ErrorReason = String.Format(SiteResource.HTML_ALERT_SUCCESS, Resources.MSG_THE_CATEGORY_HAS_CREATED_SUCCESSFULLY); actionStatus.ActionStatus = ResultSubmit.success; Session["ACTION_STATUS"] = actionStatus; if (!String.IsNullOrWhiteSpace(saveclose)) { return(RedirectToAction("Index")); } else if (!String.IsNullOrWhiteSpace(savenew)) { return(RedirectToAction("Create")); } else { return(RedirectToAction("Edit", new { id = result.Id })); } } else { ModelState.AddModelError("", Resources.MSG_THE_CATEGORY_HAS_CREATED_UNSUCCESSFULLY); } } //load site configtion ViewBag.Title = "Tạo catalog mới"; ViewBag.Action = "Create"; return(View("Edit", model)); }
/// <summary> /// Update Catalogue /// </summary> /// <param name="model"></param> /// <param name="message"></param> /// <returns></returns> public CatalogueView UpdateCatalogue(CatalogueView model, out string message) { CatalogueView result = new CatalogueView(); message = null; var config = new MapperConfiguration(cfg => { cfg.CreateMap <v_CatalogueInfo, CatalogueView>(); }); IMapper mapper = config.CreateMapper(); try { using (var entities = new Entities()) { var catalogue = entities.Catalogues.SingleOrDefault(s => s.Id == model.Id); if (catalogue == null) { message = StaticResources.Resources.MSG_THE_CATEGORY_HAS_NOT_FOUND; return(null); } ///site info catalogue.Name = model.CatalogueName; catalogue.SiteName = model.SiteName; catalogue.SiteUrl = model.SiteUrl; ///email catalogue.EmailSite = model.EmailSite; catalogue.EmailAdmin = model.EmailAdmin; ///address info catalogue.Address = model.Address; catalogue.Phones = model.Phones; ///seo catalogue.MetaKeywords = model.MetaKeywords; catalogue.MetaDescriptions = model.MetaDescriptions; catalogue.Facebook = model.Facebook; catalogue.Twitter = model.Twitter; catalogue.Youtube = model.Youtube; catalogue.GooglePlus = model.GooglePlus; //system catalogue.Status = model.Status; catalogue.ModifiedDate = DateTime.Now; catalogue.ModifiedBy = model.ModifiedById; if (catalogue != null && entities.SaveChanges() > 0) { v_CatalogueInfo catalogueInfo = entities.v_CatalogueInfo.Where(w => w.Id == catalogue.Id).FirstOrDefault(); result = mapper.Map <v_CatalogueInfo, CatalogueView>(catalogueInfo); } else { message = StaticResources.Resources.SYSTEM_ERROR_THE_UPDATING_WEBSITE_CONFI_HAS_BEEN_FINISHED; } } } catch (Exception ex) { string subject = "Error " + SiteSetting.SiteName + " at UpdateCatalogue at CatalogueRepo at Model.Repository. "; message += subject + StringHelper.Parameters2ErrorString(ex, model.Id); } return(result); }