protected void btnSubmit_Click(object sender, EventArgs e)
{
if (_PackageID > 0)
{
string packageName = string.Empty;
model = bll.GetModel(_PackageID, packageName, 1, 1);
}
string _PackageName = Input.SetString(txtPackageName.Text.Trim());
int _UnitPrice = Input.SetInt(txtUnitPrice.Text.Trim());
int _ServiceFee= Input.SetInt(txtServiceFee.Text.Trim());
int _ServiceLength= Input.SetInt(txtServiceLen.Text.Trim());
int _BookHoldingLength= Input.SetInt(txtBookHoldingLen.Text.Trim());
int _MaxTryOrder= Input.SetInt(txtMaxTryOrder.Text.Trim());
int _MaxBorrowBook= Input.SetInt(txtMaxBorrowBook.Text.Trim());
int _Active = int.Parse(rbActivePackage.SelectedValue);
string _Intro= Input.SetString(txtDesc.Text);
string _ChangeBy = string.Empty;
int _ErrCode = 0;
if (Utils.GetCookie(PTSKeys.ADMIN_NAME, PTSKeys.CDL_CMS_KEY) != null)
{
_ChangeBy = Utils.GetCookie(PTSKeys.ADMIN_NAME, PTSKeys.CDL_CMS_KEY);
}
int _error_code = 0;
int _rows_effect = 0;
bll.Update(ref _PackageID,_PackageName,
_UnitPrice,
_ServiceFee,
_ServiceLength,
_BookHoldingLength,
_MaxTryOrder,
_MaxBorrowBook,
_Active,
_Intro,
_ChangeBy,
ref _ErrCode,
ref _rows_effect);
if (_rows_effect > 0)
{
JscriptMsg("Cập nhật thành công !", "List.aspx", "Success");
}
else
{
JscriptMsg("Lỗi xảy ra: " + _error_code.ToString(), "", "Error");
}
}
public Model.PackageDetail GetModel(long _PackageDetailID, string _PackageName, int _Start, int _Limit)
{
try
{
Model.PackageDetail model = new Model.PackageDetail();
SqlParameter[] p = {
new SqlParameter("@PackageDetailID", SqlDbType.BigInt, 8),
new SqlParameter("@PackageName", SqlDbType.NVarChar, 500),
new SqlParameter("@Start", SqlDbType.Int, 4),
new SqlParameter("@Limit", SqlDbType.Int, 4)
};
p[0].Value = _PackageDetailID;
p[1].Value = _PackageName;
p[2].Value = _Start;
p[3].Value = _Limit;
DataTable dt = db.ExcuteSelectReturnDataTable("dbo.PackageDetail_Select", CommandType.StoredProcedure, p);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model.Ind = Convert.ToInt32(dr["Ind"].ToString());
model.PackageDetailID = Convert.ToInt32(dr["PackageDetailID"].ToString());
model.UnitPrice = Convert.ToInt32(dr["UnitPrice"].ToString());
model.ServiceFee = Convert.ToInt32(dr["ServiceFee"].ToString());
model.ServiceLength = Convert.ToInt32(dr["ServiceLength"].ToString());
model.Refunable = Convert.ToInt32(dr["Refunable"].ToString());
model.BookHoldingLength = Convert.ToInt32(dr["BookHoldingLength"].ToString());
model.MaxTryOrder = Convert.ToInt32(dr["MaxTryOrder"].ToString());
model.MaxBorrowBook = Convert.ToInt32(dr["MaxBorrowBook"].ToString());
model.Intro = dr["Intro"].ToString();
model.CreateBy = dr["CreateBy"].ToString();
model.CreateTime = dr["CreateTime"].ToString();
model.UpdateBy = dr["UpdateBy"].ToString();
model.UpdateTime = dr["UpdateTime"].ToString();
model.PackageName = dr["PackageName"].ToString();
model.PackageID = Convert.ToInt32(dr["PackageID"].ToString());
model.TotalRow = Convert.ToInt32(dr["TotalRow"].ToString());
}
return model;
}
else
{
return null;
}
}
catch (Exception ex)
{
PTSLog.Error(ex.Message);
return null;
}
}
