public bool isError(Measure_model Model, int action, out List <string> lstMessgae) { bool isError = false; lstMessgae = new List <string>(); if ((int)Common.ActionType.Add == action) { var result = db.Query <Measure_model>("SELECT * FROM `product_measure` WHERE `code` = @code", new { code = Model.code.Trim() }).ToList(); if (result.Count != 0) { isError = true; lstMessgae.Add("[Code] is duplicate!"); } } if ((int)Common.ActionType.Update == action) { var result = db.Query <Measure_model>("SELECT * FROM `product_measure` WHERE `code` = @code AND `id` <> @id", new { code = Model.code.Trim(), id = Model.id }).ToList(); if (result.Count != 0) { isError = true; lstMessgae.Add("[Code] is duplicate!"); } } return(isError); }
public ActionResult Index(Measure_model Model, int?page) { var pageNumber = page ?? 1; List <Measure_model> lstModel = new List <Measure_model>(); int total = new int(); if (!string.IsNullOrEmpty(Session["m_code"] as string)) { Model.code = Session["m_code"].ToString(); } if (!string.IsNullOrEmpty(Session["m_name"] as string)) { Model.name = Session["m_name"].ToString(); } _measureBLL.Search(Model, out lstModel, out total, pageNumber); var list = new StaticPagedList <Measure_model>(lstModel, pageNumber, 15, total); ViewBag.ListSearch = lstModel.OrderByDescending(x => x.id); ViewBag.page = 0; if (page != null) { ViewBag.page = pageNumber - 1; } return(View(new Tuple <Measure_model, IPagedList <Measure_model> >(Model, list))); }
public int Search(Measure_model searchCondition, out List <Measure_model> lstModel, out int total, int _page) { int returnCode = (int)Common.ReturnCode.Succeed; lstModel = new List <Measure_model>(); _page = _page * 15 - 15; total = new int(); try { string sql = "SELECT `id`, `code`, `name`, `description` FROM `product_measure` WHERE TRUE "; string _sql = "SELECT COUNT(`id`) FROM product_measure AS i WHERE TRUE "; if (!string.IsNullOrEmpty(searchCondition.code)) { sql += "AND `code` LIKE @code "; _sql += "AND `code` LIKE @code "; } if (!string.IsNullOrEmpty(searchCondition.name)) { sql += "AND `name` LIKE @name "; _sql += "AND `name` LIKE @name "; } sql += " LIMIT @page,15 "; lstModel = db.Query <Measure_model>(sql, new { code = '%' + searchCondition.code + '%', name = '%' + searchCondition.name + '%', page = _page }).ToList(); total = db.ExecuteScalar <int>(_sql, new { code = '%' + searchCondition.code + '%', name = '%' + searchCondition.name + '%' }); return(returnCode); } catch (Exception ex) { return(returnCode = (int)Common.ReturnCode.UnSuccess); } }
public ActionResult Edit(Measure_model Model) { if (string.IsNullOrEmpty(Model.id.ToString())) { TempData["Error"] = "Data has already been deleted by other user!"; return(RedirectToAction("Index")); } List <string> lstMsg = new List <string>(); int returnCode = _measureBLL.Update(Model, out lstMsg); if (ModelState.IsValid) { if (!((int)Common.ReturnCode.Succeed == returnCode)) { if (lstMsg != null) { for (int i = 0; i < lstMsg.Count(); i++) { ModelState.AddModelError(string.Empty, lstMsg[i]); } } return(View(Model)); } TempData["Success"] = "Updated Successfully!"; return(RedirectToAction("Index")); } return(View()); }
public ActionResult IndexPost(Measure_model Model, int?page) { var pageNumber = page ?? 1; List <Measure_model> lstModel = new List <Measure_model>(); int total = new int(); _measureBLL.Search(Model, out lstModel, out total, pageNumber); var list = new StaticPagedList <Measure_model>(lstModel, pageNumber, 15, total); ViewBag.ListSearch = lstModel.OrderByDescending(x => x.id); Session["m_code"] = Model.code; Session["m_name"] = Model.name; TempData["CountResult"] = total.ToString() + " row(s) found!"; return(View(new Tuple <Measure_model, IPagedList <Measure_model> >(Model, list))); }
public int GetDetail(int id, out Measure_model Model) { int returnCode = (int)Common.ReturnCode.Succeed; Model = new Measure_model(); try { if (id != 0) { string sql = "SELECT `id`, `code`, `name`, `description` FROM `product_measure` WHERE `id` = @id"; Model = db.Query <Measure_model>(sql, new { id = id }).SingleOrDefault(); } } catch (Exception ex) { return((int)Common.ReturnCode.UnSuccess); } return(returnCode); }
public int Update(Measure_model Model, out List <string> lstMsg) { int returnCode = (int)Common.ReturnCode.Succeed; lstMsg = new List <string>(); try { if (isError(Model, (int)Common.ActionType.Update, out lstMsg)) { returnCode = (int)Common.ReturnCode.UnSuccess; } string sql = "UPDATE `product_measure` SET `code` = @code, `name` = @name, `description` = @description WHERE `id` = @id"; db.Execute(sql, new { code = Model.code, name = Model.name, description = Model.description, id = Model.id }); } catch (Exception ex) { returnCode = (int)Common.ReturnCode.UnSuccess; } return(returnCode); }
public int Insert(Measure_model Model, out List <string> lstMsg) { int returnCode = (int)Common.ReturnCode.Succeed; lstMsg = new List <string>(); try { if (isError(Model, (int)Common.ActionType.Add, out lstMsg)) { return((int)Common.ReturnCode.UnSuccess); } string sql = "INSERT INTO `product_measure` (`code`, `name`, `description`) VALUES (@code, @name, @description)"; db.Execute(sql, new { code = Model.code.Trim(), name = Model.name.Trim(), description = Model.description.Trim() }); } catch (Exception ex) { return((int)Common.ReturnCode.UnSuccess); } return(returnCode); }
public ActionResult View(int id) { if (string.IsNullOrEmpty(id.ToString())) { TempData["Error"] = "Data has already been deleted by other user!"; return(RedirectToAction("Index")); } Measure_model Model = new Measure_model(); int returnCode = _measureBLL.GetDetail(id, out Model); if (Model == null) { TempData["Error"] = "Data has already been deleted by other user!"; return(RedirectToAction("Index")); } if (!((int)Common.ReturnCode.Succeed == returnCode)) { Model = new Measure_model(); } return(View(Model)); }
public ActionResult Add(Measure_model Model) { List <string> lstMsg = new List <string>(); int returnCode = _measureBLL.Insert(Model, out lstMsg); if (ModelState.IsValid) { if (!((int)Common.ReturnCode.Succeed == returnCode)) { if (lstMsg != null) { for (int i = 0; i < lstMsg.Count(); i++) { ModelState.AddModelError(string.Empty, lstMsg[i]); } } return(View(Model)); } TempData["Success"] = "Inserted Successfully!"; return(RedirectToAction("Index")); } return(View()); }
public int GetDetail(int id, out Measure_model model) { return(measure_bll.GetDetail(id, out model)); }
public int Update(Measure_model model, out List <string> lstMsg) { return(measure_bll.Update(model, out lstMsg)); }
public int Insert(Measure_model model, out List <string> lstMsg) { return(measure_bll.Insert(model, out lstMsg)); }
public int Search(Measure_model model, out List <Measure_model> lstmodel, out int total, int _page) { return(measure_bll.Search(model, out lstmodel, out total, _page)); }
public ActionResult Add() { Measure_model Model = new Measure_model(); return(View(Model)); }