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));
}
