public ReturnResult <MucDoTinCay> EditMucDoTinCay(MucDoTinCay MucDoTinCay) { ReturnResult <MucDoTinCay> result; DbProvider db; try { result = new ReturnResult <MucDoTinCay>(); db = new DbProvider(); db.SetQuery("MucDoTinCay_EDIT", CommandType.StoredProcedure) .SetParameter("MucDoTinCayID", SqlDbType.Int, MucDoTinCay.MucDoTinCayID, ParameterDirection.Input) .SetParameter("LoaiMucDoTinCay", SqlDbType.NVarChar, MucDoTinCay.LoaiMucDoTinCay, 50, ParameterDirection.Input) .SetParameter("ErrorCode", SqlDbType.Int, DBNull.Value, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output) .ExcuteNonQuery() .Complete(); db.GetOutValue("ErrorCode", out string errorCode) .GetOutValue("ErrorMessage", out string errorMessage); if (errorCode.ToString() == "0") { result.ErrorCode = "0"; result.ErrorMessage = ""; } else { result.Failed(errorCode, errorMessage); } } catch (Exception ex) { throw ex; } return(result); }
public ReturnResult <MucDoTinCay> GetMucDoTinCayByID(int MucDoTinCayId) { var result = new ReturnResult <MucDoTinCay>(); MucDoTinCay item = new MucDoTinCay(); DbProvider dbProvider = new DbProvider(); string outCode = String.Empty; string outMessage = String.Empty; int totalRows = 0; try { dbProvider.SetQuery("MucDoTinCay_GET_BY_ID", CommandType.StoredProcedure) .SetParameter("MucDoTinCayID", SqlDbType.Int, MucDoTinCayId, ParameterDirection.Input) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output) .GetSingle <MucDoTinCay>(out item) .Complete(); } catch (Exception ex) { throw; } dbProvider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); return(new ReturnResult <MucDoTinCay>() { Item = item, ErrorCode = outCode, ErrorMessage = outMessage, TotalRows = totalRows }); }
protected void btAddApprover_Click(object sender, EventArgs e) { try { if (!isUpdate()) { sec = new MucDoTinCay(); sec.Name = tbxName.Text; sec.Description = tbxDescription.Text; } else { sec.Name = tbxName.Text; sec.Description = tbxDescription.Text; } if (!isUpdate()) { if (validateSecurity(sec)) { um.addMucDoTinCay(sec); tbxDescription.Text = ""; tbxName.Text = ""; } else { Logger.logmessage(classobject, "btAddApprover_Click", "Validate fail 4 inssert " + sec.Name); } } else { if (um.validateSecName4Update(sec.Name, sec.ID)) { um.updateMucDoTinCay(sec); tbxDescription.Text = ""; tbxName.Text = ""; } else { Logger.logmessage(classobject, "btAddApprover_Click", "Validate fail 4 update " + sec.Name); } } Session[Su_MucDoTinCayLogic.SESSION_SEC_ID] = null; Response.Redirect("QLMucDoTinCay.aspx", false); } catch (Exception ex) { Logger.logmessage(classobject, "btAddApprover_Click", ex.Message + ex.StackTrace); Response.Redirect("~/ThongBaoLoi.aspx", false); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { try { if (Session[Su_MucDoTinCayLogic.SESSION_SEC_ID] != null) { btAddApprover.Text = "Cập nhật"; sec = um.getMucDoTinCay(Int32.Parse(Session[Su_MucDoTinCayLogic.SESSION_SEC_ID].ToString())); if (sec != null) { tbxName.Text = sec.Name; tbxDescription.Text = sec.Description; } } else { sec = new MucDoTinCay(); } listAllSec(); } catch (Exception ex) { Logger.logmessage(classobject, "Page_Load", ex.Message + ex.StackTrace); Response.Redirect("~/ThongBaoLoi.aspx", false); } } else { string tId = ""; if (Session[Su_MucDoTinCayLogic.SESSION_SEC_ID] != null) { tId = Session[Su_MucDoTinCayLogic.SESSION_SEC_ID].ToString(); sec = new MucDoTinCay(); int iId = 0; Int32.TryParse(tId, out iId); sec.ID = iId; sec.Name = tbxName.Text; sec.Description = tbxDescription.Text; } } }
protected bool validateSecurity(MucDoTinCay sec) { bool result = true; if (!um.validateSecName(sec.Name)) { result = false; Response.Write("<script language='javascript'> { alert('Tên này đã có trong hệ thống. Xin chọn một tên khác');}</script>"); } if (!um.validateSecNameNull(sec.Name)) { result = false; Response.Write("<script language='javascript'> { alert('Tên không được phép để trống');}</script>"); } if (!um.validateSecNameNull(sec.Description)) { result = false; Response.Write("<script language='javascript'> { alert('Mô tả không được phép để trống');}</script>"); } return(result); }
public ReturnResult <MucDoTinCay> CreateMucDoTinCay(MucDoTinCay MucDoTinCay) { DbProvider provider = new DbProvider(); var result = new ReturnResult <MucDoTinCay>(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; try { provider.SetQuery("MucDoTinCay_CREATE", System.Data.CommandType.StoredProcedure) .SetParameter("LoaiMucDoTinCay", SqlDbType.NVarChar, MucDoTinCay.LoaiMucDoTinCay, 50, ParameterDirection.Input) .SetParameter("ErrorCode", System.Data.SqlDbType.NVarChar, DBNull.Value, 100, System.Data.ParameterDirection.Output) .SetParameter("ErrorMessage", System.Data.SqlDbType.NVarChar, DBNull.Value, 4000, System.Data.ParameterDirection.Output) .GetSingle <MucDoTinCay>(out MucDoTinCay).Complete(); provider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode != "0" || outCode == "") { result.ErrorCode = outCode; result.ErrorMessage = outMessage; } else { result.Item = MucDoTinCay; result.ErrorCode = outCode; result.ErrorMessage = outMessage; } } catch (Exception ex) { throw ex; } return(result); }
public ReturnResult <MucDoTinCay> DeleteMucDoTinCay(int id) { DbProvider provider = new DbProvider(); var result = new ReturnResult <MucDoTinCay>(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; MucDoTinCay item = new MucDoTinCay(); try { provider.SetQuery("MucDoTinCay_DELETE", CommandType.StoredProcedure) .SetParameter("MucDoTinCayID", SqlDbType.Int, id, ParameterDirection.Input) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, System.Data.ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, System.Data.ParameterDirection.Output) .ExcuteNonQuery().Complete(); provider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode != "0") { result.Failed(outCode, outMessage); } else { result.ErrorCode = "0"; result.ErrorMessage = ""; } } catch (Exception ex) { throw ex; } return(result); }
public IActionResult UpdateMucDoTinCay(MucDoTinCay MucDoTinCay) { var result = mucDoTinCayBUS.EditMucDoTinCay(MucDoTinCay); return(Ok(result)); }
public IActionResult CreateMucDoTinCay(MucDoTinCay MucDoTinCay) { var result = mucDoTinCayBUS.CreateMucDoTinCay(MucDoTinCay); return(Ok(result)); }
public ReturnResult <MucDoTinCay> EditMucDoTinCay(MucDoTinCay MucDoTinCay) { return(mucDoTinCayDAL.EditMucDoTinCay(MucDoTinCay)); }
public ReturnResult <MucDoTinCay> CreateMucDoTinCay(MucDoTinCay MucDoTinCay) { return(mucDoTinCayDAL.CreateMucDoTinCay(MucDoTinCay)); }