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); }