public static ArrayList getAllTaiKhoanSMS()
{
ArrayList listTaiKhoanSMS = new ArrayList();
String sql = ConfigurationManager.AppSettings["sql.getAllTaiKhoanSMS"];
SqlCommand objCommand = new SqlCommand(sql);
DataTable result = DataUtil.executeQuery(objCommand);
foreach (DataRow row in result.Rows)
{
TaiKhoanSmsMODEL taiKhoanSMSModel = new TaiKhoanSmsMODEL();
taiKhoanSMSModel.Id = row["ID"].ToString();
taiKhoanSMSModel.So_Dien_Thoai = row["So_dien_thoai"].ToString();
taiKhoanSMSModel.Ma_Sinh_Vien = row["Ma_sinh_vien"].ToString();
taiKhoanSMSModel.Loai_Tai_Khoan = row["Loai_tai_khoan"].ToString();
taiKhoanSMSModel.Ngay_Dang_Ki = row["Ngay_dang_ki"].ToString();
taiKhoanSMSModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString();
taiKhoanSMSModel.User11 = row["User1"].ToString();
taiKhoanSMSModel.User21 = row["User2"].ToString();
taiKhoanSMSModel.User31 = row["User3"].ToString();
taiKhoanSMSModel.User41 = row["User4"].ToString();
taiKhoanSMSModel.User51 = row["User5"].ToString();
listTaiKhoanSMS.Add(taiKhoanSMSModel);
}
return(listTaiKhoanSMS);
}
public TaiKhoanSmsMODEL getTaiKhoanSMSByID(int Ma_tai_khoan_SMS)
{
TaiKhoanSmsMODEL taiKhoanSMSModel = new TaiKhoanSmsMODEL();
//String sql = ConfigurationManager.AppSettings["sql.getTaiKhoanSMSByID"];
//SqlCommand objCommand = new SqlCommand(sql);
//objCommand.Parameters.AddWithValue("@Ma_tai_khoan_SMS", Ma_tai_khoan_SMS);
//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 = Ma_tai_khoan_SMS;
DataTable result = DataUtil.executeStore("sp_getTaiKhoanSMSByID", parameter);
foreach (DataRow row in result.Rows)
{
taiKhoanSMSModel.Id = row["ID"].ToString();
taiKhoanSMSModel.So_Dien_Thoai = row["So_dien_thoai"].ToString();
taiKhoanSMSModel.Ma_Sinh_Vien = row["Ma_sinh_vien"].ToString();
taiKhoanSMSModel.Loai_Tai_Khoan = row["Loai_tai_khoan"].ToString();
taiKhoanSMSModel.Ngay_Dang_Ki = row["Ngay_dang_kY"].ToString();
taiKhoanSMSModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString();
taiKhoanSMSModel.User11 = row["User1"].ToString();
taiKhoanSMSModel.User21 = row["User2"].ToString();
taiKhoanSMSModel.User31 = row["User3"].ToString();
taiKhoanSMSModel.User41 = row["User4"].ToString();
taiKhoanSMSModel.User51 = row["User5"].ToString();
}
return(taiKhoanSMSModel);
}
private void loaddata()
{
taiKhoanSMSModel = taiKhoanSMSDao.getTaiKhoanSMSByID(Convert.ToInt32(Constants.id));
txt_NumberPhone.Text = taiKhoanSMSModel.So_Dien_Thoai;
txt_StudentID.Text = taiKhoanSMSModel.Ma_Sinh_Vien;
dtp_NgayDangKy.Text = taiKhoanSMSModel.Ngay_Dang_Ki;
// kiện selected cua cbo_AccountType
loaiTaiKhoanSMSModel = loaiTaiKhoanSMSDao.getLoaiTaiKhoanSMSByID(Convert.ToInt32(taiKhoanSMSModel.Loai_Tai_Khoan));
cbo_AccountType.SelectedText = loaiTaiKhoanSMSModel.Ten.ToString();
txt_ServiceCharges.Text = loaiTaiKhoanSMSModel.Phi_Dich_Vu;
txt_Note.Text = loaiTaiKhoanSMSModel.Ghi_Chu;
}
public Boolean updateTaiKhoanSMSById(TaiKhoanSmsMODEL taiKhoanSMSModel)
{
try
{
SqlParameter[] parameter = new SqlParameter[11];
int i = 0;
parameter[i] = new SqlParameter("ID", SqlDbType.NVarChar);
parameter[i++].Value = taiKhoanSMSModel.Id;
parameter[i] = new SqlParameter("So_dien_thoai", SqlDbType.NVarChar);
parameter[i++].Value = taiKhoanSMSModel.So_Dien_Thoai;
parameter[i] = new SqlParameter("Ma_sinh_vien", SqlDbType.NVarChar);
parameter[i++].Value = taiKhoanSMSModel.Ma_Sinh_Vien;
parameter[i] = new SqlParameter("Loai_tai_khoan", SqlDbType.NVarChar);
parameter[i++].Value = taiKhoanSMSModel.Loai_Tai_Khoan;
parameter[i] = new SqlParameter("Ngay_dang_ky", SqlDbType.NVarChar);
parameter[i++].Value = taiKhoanSMSModel.Ngay_Dang_Ki;
parameter[i] = new SqlParameter("Ngay_cap_nhat_cuoi", SqlDbType.NVarChar);
parameter[i++].Value = "";
parameter[i] = new SqlParameter("User1", SqlDbType.VarChar);
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_UpdateTaiKhoanSMSByID", parameter);
return(kq);
}
catch (Exception)
{
throw;
}
}