private void SaveData() { try { if (Request.QueryString["id"] != null) { int id = int.Parse(Request.QueryString["id"].ToString()); int code = -1; string msg = ""; FeeManager feeManager = new FeeManager(); FeeBase fee = new FeeBase(); fee.FeeId = id; fee.FeeTypeId = int.Parse(ddlFeeType.SelectedValue); fee.Amount = decimal.Parse(txtAmount.Text.Trim().Replace(",", "")); fee.UserName = txtUserName.Text.Trim(); fee.Note = txtNote.Text.Trim(); fee.FeeStatus = int.Parse(ddlFeeStatus.SelectedValue); fee.UpdateDate = DateTime.Now; fee.UpdateUser = User.Identity.Name; feeManager.Fee_Update(fee, ref code, ref msg); if (code == 0) { ErrorBox.Message = string.Empty; NotifyBox.Message = "Lưu dữ liệu thành công"; } else { ErrorBox.Message = "Lưu dữ liệu thất bại"; NotifyBox.Message = string.Empty; } SaveActionLog("Cập nhật", string.Format("code: {0}; msg: {1}; id: {2}", code, msg, id)); } else { ErrorBox.Message = "Không lấy được dữ liệu"; NotifyBox.Message = string.Empty; } } catch (Exception ex) { ErrorBox.Message = "Lỗi chức năng"; NotifyBox.Message = string.Empty; SaveErrorLog(ex); } }
private void SaveData() { try { int code = -1; string msg = ""; FeeManager feeManager = new FeeManager(); FeeBase fee = new FeeBase(); fee.FeeTypeId = int.Parse(ddlFeeType.SelectedValue); fee.Amount = decimal.Parse(txtAmount.Text.Trim().Replace(",", "")); fee.UserName = txtUserName.Text.Trim(); fee.Note = txtNote.Text.Trim(); fee.FeeStatus = int.Parse(ddlFeeStatus.SelectedValue); fee.CreateDate = DateTime.Now; fee.CreateUser = User.Identity.Name; feeManager.Fee_Insert(fee, ref code, ref msg); if (code == 0) { ErrorBox.Message = string.Empty; NotifyBox.Message = "Lưu dữ liệu thành công"; } else { ErrorBox.Message = "Lưu dữ liệu thất bại"; NotifyBox.Message = string.Empty; } SaveActionLog("Thêm mới", string.Format("code: {0}; msg: {1}", code, msg)); } catch (Exception ex) { ErrorBox.Message = "Lỗi chức năng"; NotifyBox.Message = string.Empty; SaveErrorLog(ex); } }
public void Fee_Update(FeeBase fee, ref int code, ref string msg) { adapter.Fee_Update(fee, ref code, ref msg); }
public void Fee_Update(FeeBase fee, ref int code, ref string msg) { try { List <SqlParameter> paramList = new List <SqlParameter>(); SqlParameter param; param = new SqlParameter("@FeeId", SqlDbType.Int, 4); param.Direction = ParameterDirection.Input; param.Value = fee.FeeId; paramList.Add(param); param = new SqlParameter("@FeeTypeId", SqlDbType.Int, 4); param.Direction = ParameterDirection.Input; param.Value = fee.FeeTypeId; paramList.Add(param); param = new SqlParameter("@Amount", SqlDbType.Decimal); param.Direction = ParameterDirection.Input; param.Value = fee.Amount; paramList.Add(param); param = new SqlParameter("@UserName", SqlDbType.NVarChar, 50); param.Direction = ParameterDirection.Input; param.Value = fee.UserName; paramList.Add(param); param = new SqlParameter("@Note", SqlDbType.NVarChar, 500); param.Direction = ParameterDirection.Input; param.Value = fee.Note; paramList.Add(param); param = new SqlParameter("@FeeStatus", SqlDbType.Int, 4); param.Direction = ParameterDirection.Input; param.Value = fee.FeeStatus; paramList.Add(param); param = new SqlParameter("@UpdateDate", SqlDbType.DateTime); param.Direction = ParameterDirection.Input; param.Value = fee.UpdateDate; paramList.Add(param); param = new SqlParameter("@UpdateUser", SqlDbType.VarChar, 50); param.Direction = ParameterDirection.Input; param.Value = fee.UpdateUser; paramList.Add(param); using (SqlDataReader dr = (SqlDataReader)Database.ExecuteReader("usp_Fee_Update", CommandType.StoredProcedure, paramList.ToArray())) { if (dr.HasRows) { DataTable dt = new DataTable("dt"); dt.Load(dr); DataRow row = dt.Rows[0]; code = int.Parse(row["code"].ToString()); msg = row["msg"].ToString(); } Database.CloseConn(); } } catch (Exception ex) { throw ex; } }
public void Fee_Insert(FeeBase fee, ref int code, ref string msg) { adapter.Fee_Insert(fee, ref code, ref msg); }