public ChiTietTaiKhoanSmsMODEL getChiTietTaiKhoanSMSByID(int id)
{
ChiTietTaiKhoanSmsMODEL chiTietTaiKhoanModel = new ChiTietTaiKhoanSmsMODEL();
//String sql = ConfigurationManager.AppSettings["sql.getChiTietTaiKhoanSMSByID"];
//SqlCommand objCommand = new SqlCommand(sql);
//objCommand.Parameters.AddWithValue("@id", id);
//DataTable result = DataUtil.executeQuery(objCommand);
SqlParameter[] parameter = new SqlParameter[1];
int i = 0;
parameter[i] = new SqlParameter("Ma_tai_khoan_SMS", SqlDbType.NVarChar);
parameter[i++].Value = id;
DataTable result = DataUtil.executeStore("sp_getChiTietTaiKhoanSMSByID", parameter);
foreach (DataRow row in result.Rows)
{
chiTietTaiKhoanModel.Id = row["ID"].ToString();
chiTietTaiKhoanModel.Ma_Tai_Khoan_Sms = row["Ma_tai_khoan_SMS"].ToString();
chiTietTaiKhoanModel.Dang_Ki_Thang = row["Dang_ky_thang"].ToString();
chiTietTaiKhoanModel.Dang_Ki_Nam = row["Dang_ky_nam"].ToString();
chiTietTaiKhoanModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString();
chiTietTaiKhoanModel.User11 = row["User1"].ToString();
chiTietTaiKhoanModel.User21 = row["User2"].ToString();
chiTietTaiKhoanModel.User31 = row["User3"].ToString();
chiTietTaiKhoanModel.User41 = row["User4"].ToString();
chiTietTaiKhoanModel.User51 = row["User5"].ToString();
}
return(chiTietTaiKhoanModel);
}
public Boolean updateChiTietTaiKhoanSMS(ChiTietTaiKhoanSmsMODEL chiTietTaiKhoanSMSModel)
{
try
{
SqlParameter[] parameter = new SqlParameter[10];
int i = 0;
parameter[i] = new SqlParameter("ID", SqlDbType.NVarChar);
parameter[i++].Value = chiTietTaiKhoanSMSModel.Id;
parameter[i] = new SqlParameter("Ma_tai_khoan_sms", SqlDbType.NVarChar);
parameter[i++].Value = chiTietTaiKhoanSMSModel.Ma_Tai_Khoan_Sms;
parameter[i] = new SqlParameter("Dang_ky_thang", SqlDbType.NVarChar);
parameter[i++].Value = chiTietTaiKhoanSMSModel.Dang_Ki_Thang;
parameter[i] = new SqlParameter("Dang_ky_nam", SqlDbType.NVarChar);
parameter[i++].Value = chiTietTaiKhoanSMSModel.Dang_Ki_Nam;
parameter[i] = new SqlParameter("Ngay_cap_nhat_cuoi", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User1", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User2", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User3", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User4", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User5", SqlDbType.NVarChar);
parameter[i++].Value = "";
Boolean kq = DataUtil.executeNonStore("sp_SMS_UpdateChiTietTaiKhoanByID", parameter);
return(kq);
}
catch (Exception)
{
throw;
}
}
private void but_Edit_Click(object sender, EventArgs e)
{
if (common.Constants.idDetail.Equals(""))
{
MessageBox.Show("Bạn chưa chọn dòng để cập nhật. Vui lòng chọn lại: ");
}
else
{
pnl_Add.Visible = true;
lb_tilte.Text = "Cập Nhật Thông Tin TK";
but_Ok.Text = "Cập Nhật";
ctTaiKhoanSMSModel = ctTaiKhoanSMSDao.getChiTietTaiKhoanSMSByID(Convert.ToInt32(common.Constants.idDetail));
txt_RegistrationMonth.Text = ctTaiKhoanSMSModel.Dang_Ki_Thang;
txt_Registrationyear.Text = ctTaiKhoanSMSModel.Dang_Ki_Nam;
common.Constants.idDetail = "";
common.Constants.chooseUpdate = 1;
lblYouChoose.Text = "Bạn chọn dòng: ";
but_Delete.Enabled = false;
but_Edit.Enabled = false;
}
}
