public LoaiTaiKhoanSmsMODEL getLoaiTaiKhoanSMSByID(int id)
{
LoaiTaiKhoanSmsMODEL loaiTaiKhoanSMSModel = new LoaiTaiKhoanSmsMODEL();
//String sql = ConfigurationManager.AppSettings["sql.getLoaiTaiKhoanSMSByID"];
//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("ID", SqlDbType.NVarChar);
parameter[i++].Value = id;
DataTable result = DataUtil.executeStore("sp_getLoaiTaiKhoanSMSByID", parameter);
foreach (DataRow row in result.Rows)
{
loaiTaiKhoanSMSModel.Id = row["ID"].ToString();
loaiTaiKhoanSMSModel.Ten = row["Ten"].ToString();
loaiTaiKhoanSMSModel.Phi_Dich_Vu = row["Phi_dich_vu"].ToString();
loaiTaiKhoanSMSModel.Ghi_Chu = row["Ghi_chu"].ToString();
loaiTaiKhoanSMSModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString();
loaiTaiKhoanSMSModel.User11 = row["User1"].ToString();
loaiTaiKhoanSMSModel.User21 = row["User2"].ToString();
loaiTaiKhoanSMSModel.User31 = row["User3"].ToString();
loaiTaiKhoanSMSModel.User41 = row["User4"].ToString();
loaiTaiKhoanSMSModel.User51 = row["User5"].ToString();
}
return(loaiTaiKhoanSMSModel);
}
public ArrayList getAllLoaiTaiKhoanSMS()
{
LoaiTaiKhoanSmsMODEL loaiTaiKhoanSMSModel;
try
{
ArrayList listLoaiTaiKhoanSMS = new ArrayList();
//String sql = ConfigurationManager.AppSettings["sql.getAllLoaiTaiKhoanSMS"];
//SqlCommand objCommand = new SqlCommand(sql);
//DataTable result = DataUtil.executeQuery(objCommand);
DataTable result = DataUtil.executeStore("sp_getAllLoaiTaiKhoanSMS", null);
foreach (DataRow row in result.Rows)
{
loaiTaiKhoanSMSModel = new LoaiTaiKhoanSmsMODEL();
loaiTaiKhoanSMSModel.Id = row["ID"].ToString();
loaiTaiKhoanSMSModel.Ten = row["Ten"].ToString();
loaiTaiKhoanSMSModel.Phi_Dich_Vu = row["Phi_dich_vu"].ToString();
loaiTaiKhoanSMSModel.Ghi_Chu = row["Ghi_chu"].ToString();
listLoaiTaiKhoanSMS.Add(loaiTaiKhoanSMSModel);
}
return(listLoaiTaiKhoanSMS);
}
catch (Exception)
{
throw;
}
}
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 insertLoaiTaiKhoanSMS(LoaiTaiKhoanSmsMODEL loaiTaiKhoanSMSModel)
{
try
{
SqlParameter[] parameter = new SqlParameter[9];
int i = 0;
//parameter[i] = new SqlParameter("ID", SqlDbType.NVarChar);
//parameter[i++].Value = loaiTaiKhoanSMSModel.Id;
parameter[i] = new SqlParameter("Ten", SqlDbType.NVarChar);
parameter[i++].Value = loaiTaiKhoanSMSModel.Ten;
parameter[i] = new SqlParameter("Phi_dich_vu", SqlDbType.NVarChar);
parameter[i++].Value = loaiTaiKhoanSMSModel.Phi_Dich_Vu;
parameter[i] = new SqlParameter("Ghi_chu", SqlDbType.NVarChar);
parameter[i++].Value = loaiTaiKhoanSMSModel.Ghi_Chu;
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_InertLoaiTaiKhoanSMS", parameter);
return(kq);
}
catch (Exception)
{
throw;
}
}
private void cbo_AccountType_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbo_AccountType.Text.Equals("[ Thêm mới ]"))
{
FormAddTypeSMS fr = new FormAddTypeSMS();
fr.MdiParent = this.MdiParent;
fr.Show();
}
else
{
KeyValuePair objKeyValuePair = (KeyValuePair)cbo_AccountType.SelectedItem;
int id = Convert.ToInt32(objKeyValuePair.m_objKey.ToString());
taiKhoanSMSModel.Loai_Tai_Khoan = objKeyValuePair.m_objKey.ToString();
loaiTaiKhoanSMSModel = loaiTaiKhoanSMSDao.getLoaiTaiKhoanSMSByID(id);
txt_ServiceCharges.Text = loaiTaiKhoanSMSModel.Phi_Dich_Vu;
txt_Note.Text = loaiTaiKhoanSMSModel.Ghi_Chu;
}
dtp_NgayDangKy.Enabled = true;
}
