public static List<LoaiTienTeDTO> LayDanhSach()
{
SqlConnection cnn = KetNoiCSDL.TaoKetNoi();
string query = "select * from Loai_Tien_Te";
SqlCommand cmd = new SqlCommand(query, cnn);
cnn.Open();
List<LoaiTienTeDTO> lstLoaiTienTe = new List<LoaiTienTeDTO>();
try
{
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
LoaiTienTeDTO loaiTienTeDto = new LoaiTienTeDTO();
loaiTienTeDto.MaLoaiTienTe = (int)dr["MaLoaiTienTe"];
loaiTienTeDto.TenLoaiTienTe = dr["TenLoaiTienTe"].ToString();
lstLoaiTienTe.Add(loaiTienTeDto);
}
cnn.Close();
return lstLoaiTienTe;
}
catch (Exception ex)
{
if (cnn.State == ConnectionState.Open)
cnn.Close();
throw ex;
}
}
public static int Them(KhachHangDTO chuSoHuuDto, KhachHangDTO dongSoHuuDto, LoaiTienTeDTO loaiTTDto)
{
SqlConnection cnn = KetNoiCSDL.TaoKetNoi();
SqlCommand cmd = new SqlCommand("sp_MoTKDongSoHuu", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@HoTenCSH", SqlDbType.NVarChar);
cmd.Parameters.Add("@CMNDCSH", SqlDbType.VarChar);
cmd.Parameters.Add("@NgayCapCMNDCSH", SqlDbType.Date);
cmd.Parameters.Add("@NoiCapCMNDCSH", SqlDbType.NVarChar);
cmd.Parameters.Add("@DiaChiCSH", SqlDbType.NVarChar);
cmd.Parameters.Add("@SoDtCSH", SqlDbType.VarChar);
cmd.Parameters.Add("@HoTenDSH", SqlDbType.NVarChar);
cmd.Parameters.Add("@CMNDDSH", SqlDbType.VarChar);
cmd.Parameters.Add("@NgayCapCMNDDSH", SqlDbType.Date);
cmd.Parameters.Add("@NoiCapCMNDDSH", SqlDbType.NVarChar);
cmd.Parameters.Add("@DiaChiDSH", SqlDbType.NVarChar);
cmd.Parameters.Add("@SoDtDSH", SqlDbType.VarChar);
cmd.Parameters.Add("@LoaiTienTe", SqlDbType.Int);
cmd.Parameters["@HoTenCSH"].Value = chuSoHuuDto.HoTen;
cmd.Parameters["@CMNDCSH"].Value = chuSoHuuDto.CMND;
cmd.Parameters["@NgayCapCMNDCSH"].Value = chuSoHuuDto.NgayCapCMND;
cmd.Parameters["@NoiCapCMNDCSH"].Value = chuSoHuuDto.NoiCapCMND;
cmd.Parameters["@DiaChiCSH"].Value = chuSoHuuDto.DiaChi;
cmd.Parameters["@SoDtCSH"].Value = chuSoHuuDto.SoDT;
cmd.Parameters["@HoTenDSH"].Value = dongSoHuuDto.HoTen;
cmd.Parameters["@CMNDDSH"].Value = dongSoHuuDto.CMND;
cmd.Parameters["@NgayCapCMNDDSH"].Value = dongSoHuuDto.NgayCapCMND;
cmd.Parameters["@NoiCapCMNDDSH"].Value = dongSoHuuDto.NoiCapCMND;
cmd.Parameters["@DiaChiDSH"].Value = dongSoHuuDto.DiaChi;
cmd.Parameters["@SoDtDSH"].Value = dongSoHuuDto.SoDT;
cmd.Parameters["@LoaiTienTe"].Value = loaiTTDto.MaLoaiTienTe;
cnn.Open();
int rs = 0;
try
{
rs = (int)cmd.ExecuteNonQuery();
cnn.Close();
return rs;
}
catch (Exception ex)
{
if (cnn.State == ConnectionState.Open)
cnn.Close();
throw ex;
}
}
public static int Them(KhachHangDTO khDto, LoaiTienTeDTO loaiTTDto, string recentUser, int kihan)
{
SqlConnection cnn = KetNoiCSDL.TaoKetNoi();
SqlCommand cmd = new SqlCommand("sp_MoTKTKCoKiHan", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@HoTen", SqlDbType.NVarChar);
cmd.Parameters.Add("@CMND", SqlDbType.VarChar);
cmd.Parameters.Add("@NgayCapCMND", SqlDbType.Date);
cmd.Parameters.Add("@NoiCapCMND", SqlDbType.NVarChar);
cmd.Parameters.Add("@DiaChi", SqlDbType.NVarChar);
cmd.Parameters.Add("@SoDt", SqlDbType.VarChar);
cmd.Parameters.Add("@ChiNhanhGD", SqlDbType.Int);
cmd.Parameters.Add("@LoaiTienTe", SqlDbType.Int);
cmd.Parameters.Add("@kihan", SqlDbType.Int);
cmd.Parameters["@HoTen"].Value = khDto.HoTen;
cmd.Parameters["@CMND"].Value = khDto.CMND;
cmd.Parameters["@NgayCapCMND"].Value = khDto.NgayCapCMND;
cmd.Parameters["@NoiCapCMND"].Value = khDto.NoiCapCMND;
cmd.Parameters["@DiaChiC"].Value = khDto.DiaChi;
cmd.Parameters["@SoDt"].Value = khDto.SoDT;
cmd.Parameters["@ChiNhanhGD"].Value = NhanVienDAO.LayChiNhanhGD(recentUser);
cmd.Parameters["@LoaiTienTe"].Value = loaiTTDto.MaLoaiTienTe;
cmd.Parameters["@kihan"].Value = kihan;
cnn.Open();
int rs = 0;
try
{
rs = (int)cmd.ExecuteNonQuery();
cnn.Close();
return rs;
}
catch (Exception ex)
{
if (cnn.State == ConnectionState.Open)
cnn.Close();
throw ex;
}
}
public static int Them(KhachHangDTO khDto, LoaiTienTeDTO loaiTTDto, string recentUser, int kihan)
{
return MoTKTKCoKiHanDAO.Them(khDto, loaiTTDto, recentUser, kihan);
}
//0712455
private void MoTKDongSoHuu()
{
string chuoi_loi = KiemTraHopLeDuLieuNhapPanelMoTaiKhoanDSH();
if (chuoi_loi == "")
{
KhachHangDTO ChuSoHuuDto = new KhachHangDTO();
KhachHangDTO DongSoHuuDto = new KhachHangDTO();
ChuSoHuuDto.HoTen = tb_DSH_CSH_HoTen.Text.Trim();
ChuSoHuuDto.CMND = tb_DSH_CSH_CMND.Text.Trim();
ChuSoHuuDto.NgayCapCMND = Convert.ToDateTime(tb_DSH_CSH_NgayCap.Text);
ChuSoHuuDto.NoiCapCMND = tb_DSH_CSH_NoiCap.Text.Trim();
ChuSoHuuDto.DiaChi = tb_DSH_CSH_DiaChi.Text.Trim();
ChuSoHuuDto.SoDT = tb_DSH_CSH_DienThoai.Text.Trim();
DongSoHuuDto.HoTen = tb_DSH_DSH_HoTen.Text.Trim();
DongSoHuuDto.CMND = tb_DSH_DSH_CMND.Text.Trim();
DongSoHuuDto.NgayCapCMND = Convert.ToDateTime(tb_DSH_DSH_NgayCap.Text);
DongSoHuuDto.NoiCapCMND = tb_DSH_DSH_NoiCap.Text.Trim();
DongSoHuuDto.DiaChi = tb_DSH_DSH_DiaChi.Text.Trim();
DongSoHuuDto.SoDT = tb_DSH_DSH_DienThoai.Text.Trim();
LoaiTienTeDTO loaiTTDto = new LoaiTienTeDTO();
loaiTTDto = (LoaiTienTeDTO)cb_MTKTGTT_LoaiTienTe.SelectedItem;
try
{
MoTKDongSoHuuBUS.Them(ChuSoHuuDto, DongSoHuuDto, loaiTTDto);
MessageBox.Show("Đã mở tài khoản thành công");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show(chuoi_loi);
}
}
//0712455
private void MoTaiKhoanTKKhongKiHan()
{
string chuoi_loi = KiemTraHopLeDuLieuNhapPanelMoTKTKKhongKiHan();
if (chuoi_loi == "")
{
KhachHangDTO khDto = new KhachHangDTO();
khDto.HoTen = tb_MoTKTKKKH_HoTen.Text.Trim();
khDto.CMND = tb_MoTKTKKKH_CMND.Text.Trim();
khDto.NgayCapCMND = Convert.ToDateTime(tb_MoTKTKKKH_NgayCap.Text.Trim());
khDto.NoiCapCMND = tb_MoTKTKKKH_NoiCap.Text.Trim();
khDto.DiaChi = tb_MoTKTKKKH_DiaChi.Text.Trim();
khDto.SoDT = tb_MoTKTKKKH_DienThoai.Text.Trim();
LoaiTienTeDTO loaiTTDto = new LoaiTienTeDTO();
loaiTTDto = (LoaiTienTeDTO)cb_MTKTKKKH_LoaiTienTe.SelectedItem;
try
{
MoTKTKKhongKiHanBUS.Them(khDto, loaiTTDto, recentUser);
MessageBox.Show("Đã mở tài khoản thành công");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show(chuoi_loi);
}
}
public static int Them(KhachHangDTO khDto, LoaiTienTeDTO loaiTTDto, string recentUser)
{
return MoTKTienGuiThanhToanDAO.Them(khDto, loaiTTDto, recentUser);
}
public static int Them(KhachHangDTO chuSoHuuDto, KhachHangDTO dongSoHuuDto, LoaiTienTeDTO loaiTTDto)
{
return MoTKDongSoHuuDAO.Them(chuSoHuuDto, dongSoHuuDto, loaiTTDto);
}
