public void xoaKH(KHACHHANG_DTO dto) { conn.Open(); cmd = new SqlCommand("DELETE FROM KHACHHANG WHERE MAKH = '" + dto.makh + "'", conn); cmd.ExecuteNonQuery(); conn.Close(); }
private void dgvThongTinKhachHang_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { KHACHHANG_DTO _KHACHHANG_DTO = new KHACHHANG_DTO(); _KHACHHANG_DTO.MAKH = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["MAKH"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["MAKH"].Value.ToString() : ""; _KHACHHANG_DTO.TENKH = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["TENKH"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["TENKH"].Value.ToString() : ""; _KHACHHANG_DTO.DIACHI = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["DIACHI"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["DIACHI"].Value.ToString() : ""; _KHACHHANG_DTO.DIENTHOAI = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["DIENTHOAI"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["DIENTHOAI"].Value.ToString() : ""; _KHACHHANG_DTO.CMTND = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["CMTND"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["CMTND"].Value.ToString() : ""; _KHACHHANG_DTO.EMAIL = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["EMAIL"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["EMAIL"].Value.ToString() : ""; _KHACHHANG_DTO.HANGKHACHHANG = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["HANGKHACHHANG"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["HANGKHACHHANG"].Value.ToString() : ""; _KHACHHANG_DTO.HANGKHACHHANGCU = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["HANGKHACHHANGCU"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["HANGKHACHHANGCU"].Value.ToString() : ""; _KHACHHANG_DTO.NGAYCAPTHE = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["NGAYCAPTHE"].Value != null?DateTime.Parse(dgvThongTinKhachHang.Rows[e.RowIndex].Cells["NGAYCAPTHE"].Value.ToString()) : (DateTime?)null; _KHACHHANG_DTO.NGAYSINH = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["NGAYSINH"].Value != null?DateTime.Parse(dgvThongTinKhachHang.Rows[e.RowIndex].Cells["NGAYSINH"].Value.ToString()) : (DateTime?)null; decimal SODIEM = 0; if (dgvThongTinKhachHang.Rows[e.RowIndex].Cells["SODIEM"].Value != null) { decimal.TryParse(dgvThongTinKhachHang.Rows[e.RowIndex].Cells["SODIEM"].Value.ToString(), out SODIEM); } _KHACHHANG_DTO.SODIEM = SODIEM; decimal TONGTIEN = 0; if (dgvThongTinKhachHang.Rows[e.RowIndex].Cells["TONGTIEN"].Value != null) { decimal.TryParse(dgvThongTinKhachHang.Rows[e.RowIndex].Cells["TONGTIEN"].Value.ToString(), out TONGTIEN); } _KHACHHANG_DTO.TONGTIEN = TONGTIEN; statusTimKiemKhachHang(_KHACHHANG_DTO); this.Close(); this.Dispose(); }
public void capnhatKH(KHACHHANG_DTO dto) { conn.Open(); sql = "UPDATE KHACHHANG SET TENKH = N'" + dto.tenkh + "',MAHANG = '" + dto.mahang + "',SDT= '" + dto.sdt + "',DIEMTL= '" + dto.diemtichluy + "'WHERE MAKH='" + dto.makh + "'"; cmd = new SqlCommand(sql, conn); cmd.ExecuteNonQuery(); conn.Close(); }
//Thêm khách hàng. public static KHACHHANG_DTO ThemKhachHang(BANG_KHACHHANG kh) { QuanLyShop = new QUANLYCUAHANGEntities(); kh = QuanLyShop.BANG_KHACHHANG.Add(kh); QuanLyShop.SaveChanges(); KHACHHANG_DTO khDTO = ConvertDTO(kh); return(khDTO); }
private void bt_ThemDonDatXe_Click(object sender, EventArgs e) { if (rd_KhachHangCu.Checked) { if (KhachHang == null) { MessageBox.Show("Chưa có thông tin Khách Hàng", "Thiếu Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (grid_DanhSachXeDat.Rows.Count == 0) { MessageBox.Show("Chưa chọn Xe muốn đặt", "Thiếu Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } ThemDonDatHang(); } else { if (txt_HoTen.Text == "") { MessageBox.Show("Thiếu Họ Tên Khách Hàng", "Thiếu Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Error); txt_HoTen.Focus(); return; } if (txt_CMND.Text == "") { MessageBox.Show("Thiếu CMND Khách Hàng", "Thiếu Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Error); txt_CMND.Focus(); return; } if (txt_DiaChi.Text == "") { MessageBox.Show("Thiếu Địa Chỉ Khách Hàng", "Thiếu Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Error); txt_DiaChi.Focus(); return; } KHACHHANG_DTO KhacHang = new KHACHHANG_DTO(); KhachHang.HoTen = txt_HoTen.Text; KhachHang.DiaChi = txt_DiaChi.Text; KhachHang.DienThoai = txt_DienThoai.Text.Trim(); KhachHang.LoaiKhachHang = false; if (combo_Phai.SelectedItem.ToString() == "Nam") { KhachHang.Phai = true; } else { KhachHang.Phai = false; } KHACHHANG_BUS BUS_KhachHang = new KHACHHANG_BUS(); BUS_KhachHang.Insert(KhachHang); ThemDonDatHang(); } }
private void bt_Tim_Click(object sender, EventArgs e) { KhachHang = null; if (rd_MaKhachHang.Checked) { if (txt_MaKhachHang.Text == "") { MessageBox.Show("Chưa nhập Mã Khách Hàng", "Thiếu Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Error); txt_MaKhachHang.Focus(); return; } int Ma = 0; try { Ma = int.Parse(txt_MaKhachHang.Text); } catch (System.Exception ex) { MessageBox.Show("Mã Khách Hàng là số nguyên dương", "Lỗi Dữ Liệu", MessageBoxButtons.OK, MessageBoxIcon.Error); txt_MaKhachHang.SelectAll(); txt_MaKhachHang.Focus(); return; } KhachHang = new KHACHHANG_BUS().Select(Ma); Close(); } else { if (txt_HoTen.Text == "") { MessageBox.Show("Phải nhập Họ Tên Khách Hàng", "Thiếu Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Error); txt_HoTen.Focus(); return; } int Dem = 0; if (txt_CMND.Text == "") { Dem++; } if (txt_DiaChi.Text == "") { Dem++; } if (Dem == 2) { MessageBox.Show("Phải nhập tối thiểu CMND or Địa Chỉ", "Thiếu Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Error); txt_CMND.Focus(); return; } KhachHang = new KHACHHANG_BUS().SelectByThongTin(txt_HoTen.Text, txt_DiaChi.Text, txt_CMND.Text); Close(); } }
private void btnCapNhat_Click(object sender, EventArgs e) { if (txtTen.Text != "" && cbHang.Text != "" && txtSDT.Text != "" && txtDTL.Text != "") { dto = new KHACHHANG_DTO(txtMaKH.Text, txtTen.Text, int.Parse(cbHang.SelectedValue.ToString()), txtSDT.Text, txtDTL.Text); bus.updateKH(dto); } else { MessageBox.Show("Vui lòng nhập đầy đủ thông tin"); } dtgvKH.DataSource = bus.show(); }
private void bt_Tim_Click(object sender, EventArgs e) { TimKhachHang.ShowDialog(this); if (TimKhachHang.KhachHang != null) { KhachHang = TimKhachHang.KhachHang; txt_HoTen.Text = KhachHang.HoTen; txt_CMND.Text = KhachHang.Cmnd; txt_DiaChi.Text = KhachHang.DiaChi; txt_DienThoai.Text = KhachHang.DienThoai; combo_Phai.SelectedItem = KhachHang.PhaiChu; } }
public void themKH(KHACHHANG_DTO dto) { conn.Open(); sql = "INSERT INTO KHACHHANG VALUES (@MAKH, @TENKH,@MAHANG, @SDT, @DIEMTL)"; cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@MAKH", dto.makh); cmd.Parameters.AddWithValue("@TENKH", dto.tenkh); cmd.Parameters.AddWithValue("@MAHANG", dto.mahang); cmd.Parameters.AddWithValue("@SDT", dto.sdt); cmd.Parameters.AddWithValue("@DIEMTL", dto.diemtichluy); cmd.ExecuteNonQuery(); conn.Close(); }
private void bt_Huy_Click(object sender, EventArgs e) { grid_DanhSachXeDat.Rows.Clear(); KhachHang = null; txt_HoTen.Text = ""; txt_CMND.Text = ""; txt_DiaChi.Text = ""; txt_DienThoai.Text = ""; txt_ro_Thue.Text = "0"; txt_ro_TienConLai.Text = "0"; txt_ro_TongTien.Text = "0"; txt_ro_TongTienTruocThue.Text = "0"; txt_TienTraTruoc.Text = "0"; }
/// <summary> /// Selects all records from the KHACH_HANG table. /// </summary> public List <KHACHHANG_DTO> SelectAll() { using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(m_ConnectionString, CommandType.StoredProcedure, "PROC_KhachHang_SelectAll")) { List <KHACHHANG_DTO> KhachHangList = new List <KHACHHANG_DTO>(); while (dataReader.Read()) { KHACHHANG_DTO KhachHang = MakeKHACHHANG_DTO(dataReader); KhachHangList.Add(KhachHang); } return(KhachHangList); } }
private void bt_Huy_Click(object sender, EventArgs e) { grid_DanhSachXeMua.Rows.Clear(); KhachHang = null; txt_HoTen.Text = ""; txt_CMND.Text = ""; txt_DiaChi.Text = ""; txt_DienThoai.Text = ""; txt_ro_Thue.Text = "0"; txt_ro_TongTien.Text = "0"; txt_ro_TongTienTruocThue.Text = "0"; txt_ro_TienTraMoiDot.Text = "0"; combo_HinhThucThanToan.SelectedIndex = 0; updown_SoLanThanhToan.Enabled = false; }
private void btnXoa_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Bạn có chắc muốn xóa", "Lưu ý") == DialogResult.OK) { dto = new KHACHHANG_DTO(txtMaKH.Text); bus.deleteKH(dto); } } catch (Exception) { MessageBox.Show("Chưa được hệ thống xử lí\n Vui lòng thao tác lại"); } dtgvKH.DataSource = bus.show(); }
public static KHACHHANG_DTO ConvertDTO(BANG_KHACHHANG kh) { KHACHHANG_DTO khDTO = new KHACHHANG_DTO(); khDTO.idkhachhang = kh.idkhachhang; khDTO.name = kh.name; khDTO.phonenumber = kh.phonenumber; khDTO.address = kh.address; khDTO.idkhuyenmai = kh.idkhuyenmai; khDTO.gender = kh.gender; khDTO.Old = kh.Old; khDTO.Chitiet = kh.Chitiet; khDTO.createdate = kh.createdate; return(khDTO); }
/// <summary> /// Saves a record to the KHACH_HANG table. /// </summary> public void Insert(KHACHHANG_DTO KhachHang) { ValidationUtility.ValidateArgument("KhachHang", KhachHang); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@HO_TEN", KhachHang.HoTen), new SqlParameter("@PHAI", KhachHang.Phai), new SqlParameter("@DIA_CHI", KhachHang.DiaChi), new SqlParameter("@DIEN_THOAI", KhachHang.DienThoai), new SqlParameter("@CMND", KhachHang.Cmnd), new SqlParameter("@LOAI_KHACH_HANG", KhachHang.LoaiKhachHang) }; KhachHang.Ma = (int)SqlClientUtility.ExecuteScalar(m_ConnectionString, CommandType.StoredProcedure, "PROC_KhachHang_Insert", parameters); }
private void btnLuu_Click(object sender, EventArgs e) { if (txtTen.Text != "" && txtSDT.Text != "" && cbHang.Text != "" && txtDTL.Text != "") { string ngay = DateTime.Now.Day.ToString(); string thang = DateTime.Now.Month.ToString(); string nam = DateTime.Now.Year.ToString(); string gio = DateTime.Now.Hour.ToString(); string phut = DateTime.Now.Minute.ToString(); string giay = DateTime.Now.Second.ToString(); txtMaKH.Text = "KH" + ngay + thang + nam + gio + phut + giay; dto = new KHACHHANG_DTO(txtMaKH.Text, txtTen.Text, int.Parse(cbHang.SelectedValue.ToString()), txtSDT.Text, txtDTL.Text); bus.addKH(dto); } else { MessageBox.Show("Vui lòng nhập đầy đủ thông tin"); } dtgvKH.DataSource = bus.show(); }
private void dgvThongTinKhachHang_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { KHACHHANG_DTO _KHACHHANG_DTO = new KHACHHANG_DTO(); _KHACHHANG_DTO.MAKHACHHANG = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["MAKHACHHANG"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["MAKHACHHANG"].Value.ToString() : ""; _KHACHHANG_DTO.TENKHACHHANG = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["TENKHACHHANG"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["TENKHACHHANG"].Value.ToString() : ""; _KHACHHANG_DTO.DIACHI = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["DIACHI"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["DIACHI"].Value.ToString() : ""; _KHACHHANG_DTO.DIENTHOAI = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["DIENTHOAI"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["DIENTHOAI"].Value.ToString() : ""; _KHACHHANG_DTO.CANCUOC_CONGDAN = dgvThongTinKhachHang.Rows[e.RowIndex].Cells["CANCUOC_CONGDAN"].Value != null ? dgvThongTinKhachHang.Rows[e.RowIndex].Cells["CANCUOC_CONGDAN"].Value.ToString() : ""; DateTime NGAYSINH; if (dgvThongTinKhachHang.Rows[e.RowIndex].Cells["NGAYSINH"].Value != null) { NGAYSINH = DateTime.ParseExact(dgvThongTinKhachHang.Rows[e.RowIndex].Cells["NGAYSINH"].Value.ToString(), "dd/MM/yyyy", null); _KHACHHANG_DTO.NGAYSINH = NGAYSINH; } //DateTime NGAYDACBIET; //if (dgvThongTinKhachHang.Rows[e.RowIndex].Cells["NGAYDACBIET"].Value != null) //{ // NGAYDACBIET = DateTime.ParseExact(dgvThongTinKhachHang.Rows[e.RowIndex].Cells["NGAYDACBIET"].Value.ToString(), "dd/MM/yyyy", null); // _KHACHHANG_DTO.NGAYDACBIET = NGAYDACBIET; //} decimal SODIEM = 0; if (dgvThongTinKhachHang.Rows[e.RowIndex].Cells["SODIEM"].Value != null) { decimal.TryParse(dgvThongTinKhachHang.Rows[e.RowIndex].Cells["SODIEM"].Value.ToString(), out SODIEM); } _KHACHHANG_DTO.SODIEM = SODIEM; decimal TONGTIEN = 0; if (dgvThongTinKhachHang.Rows[e.RowIndex].Cells["TONGTIEN"].Value != null) { decimal.TryParse(dgvThongTinKhachHang.Rows[e.RowIndex].Cells["TONGTIEN"].Value.ToString(), out TONGTIEN); } _KHACHHANG_DTO.TONGTIEN = TONGTIEN; statusTimKiemKhachHang(_KHACHHANG_DTO); this.Close(); this.Dispose(); }
/// <summary> /// Creates a new instance of the KHACH_HANG class and populates it with data from the specified SqlDataReader. /// </summary> private KHACHHANG_DTO MakeKHACHHANG_DTO(SqlDataReader dataReader) { KHACHHANG_DTO KhachHang = new KHACHHANG_DTO(); KhachHang.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0); KhachHang.HoTen = SqlClientUtility.GetString(dataReader, "HO_TEN", String.Empty); KhachHang.Phai = SqlClientUtility.GetBoolean(dataReader, "PHAI", false); if (KhachHang.Phai) { KhachHang.PhaiChu = "Nam"; } else { KhachHang.PhaiChu = "Nữ"; } KhachHang.DiaChi = SqlClientUtility.GetString(dataReader, "DIA_CHI", String.Empty); KhachHang.DienThoai = SqlClientUtility.GetString(dataReader, "DIEN_THOAI", String.Empty); KhachHang.Cmnd = SqlClientUtility.GetString(dataReader, "CMND", String.Empty); KhachHang.LoaiKhachHang = SqlClientUtility.GetBoolean(dataReader, "LOAI_KHACH_HANG", false); return(KhachHang); }
//Sửa thông tin khách hàng. public static KHACHHANG_DTO SuaKhachHang(BANG_KHACHHANG Kh) { BANG_KHACHHANG khUpdate = QuanLyShop.BANG_KHACHHANG.SingleOrDefault(k => k.idkhachhang == Kh.idkhachhang); if (khUpdate != null) { khUpdate.idkhachhang = Kh.idkhachhang; khUpdate.name = Kh.name; khUpdate.phonenumber = Kh.phonenumber; khUpdate.address = Kh.address; khUpdate.idkhuyenmai = Kh.idkhuyenmai; khUpdate.gender = Kh.gender; khUpdate.Old = Kh.Old; khUpdate.createdate = Kh.createdate; khUpdate.Chitiet = khUpdate.Chitiet + "\n" + Kh.Chitiet; QuanLyShop.SaveChanges(); KHACHHANG_DTO khDTO = ConvertDTO(khUpdate); return(khDTO); } return(null); }
public void deleteKH(KHACHHANG_DTO dto) { dao.xoaKH(dto); }
public int SAVE_DATA_KHACHHANG_TO_ORACLE() { int RESULT = 0; //SAVE ORACLE string MAKHACHHANG = SAVE_MAKHACHHANG_TO_ORACLE(); using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString)) { connection.Open(); if (connection.State == ConnectionState.Open) { try { KHACHHANG_DTO _KHACHHANG_DTO = new KHACHHANG_DTO(); _KHACHHANG_DTO.MAKH = MAKHACHHANG; _KHACHHANG_DTO.TENKH = txtTenKhachHang.Text; _KHACHHANG_DTO.DIACHI = txtDiaChi.Text; _KHACHHANG_DTO.DIENTHOAI = txtDienThoai.Text; _KHACHHANG_DTO.CMTND = txtChungMinhThu.Text; _KHACHHANG_DTO.EMAIL = ""; _KHACHHANG_DTO.SODIEM = 0; _KHACHHANG_DTO.TONGTIEN = 0; _KHACHHANG_DTO.NGAYCAPTHE = DateTime.Now; _KHACHHANG_DTO.NGAYHETHAN = DateTime.Now.AddYears(1); _KHACHHANG_DTO.NGAYSINH = dateNgaySinh.Value; _KHACHHANG_DTO.UNITCODE = Session.Session.CurrentUnitCode; _KHACHHANG_DTO.MATHE = txtMaThe.Text; OracleCommand command = new OracleCommand(); command.Connection = connection; string queryInsertItem = string.Format(@"INSERT INTO DM_KHACHHANG (ID,MAKH,TENKH,DIACHI,DIENTHOAI,CMTND,SODIEM,TONGTIEN,NGAYCAPTHE,NGAYHETHAN,NGAYSINH,UNITCODE,TRANGTHAI,MATHE) VALUES (:ID,:MAKH,:TENKH,:DIACHI,:DIENTHOAI,:CMTND,:SODIEM,:TONGTIEN,:NGAYCAPTHE,:NGAYHETHAN,:NGAYSINH,:UNITCODE,:TRANGTHAI,:MATHE)"); command.CommandText = queryInsertItem; command.CommandType = CommandType.Text; command.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = Guid.NewGuid(); command.Parameters.Add("MAKH", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.MAKH; command.Parameters.Add("TENKH", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.TENKH; command.Parameters.Add("DIACHI", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.DIACHI; command.Parameters.Add("DIENTHOAI", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.DIENTHOAI; command.Parameters.Add("CMTND", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.CMTND; command.Parameters.Add("SODIEM", OracleDbType.Decimal).Value = _KHACHHANG_DTO.SODIEM; command.Parameters.Add("TONGTIEN", OracleDbType.Decimal).Value = _KHACHHANG_DTO.TONGTIEN; command.Parameters.Add("NGAYCAPTHE", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYCAPTHE; command.Parameters.Add("NGAYHETHAN", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYHETHAN; command.Parameters.Add("NGAYSINH", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYSINH; command.Parameters.Add("UNITCODE", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.UNITCODE; command.Parameters.Add("TRANGTHAI", OracleDbType.Int32).Value = 10; command.Parameters.Add("MATHE", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.MATHE; try { if (command.ExecuteNonQuery() > 0) { RESULT++; } _STATUS_THEMMOI_KHACHHANG(_KHACHHANG_DTO); } catch (Exception e) { WriteLogs.LogError(e); NotificationLauncher.ShowNotificationError("THÔNG BÁO", "XẢY RA LỖI KHI LƯU THÔNG TIN KHÁCH HÀNG", 1, "0x1", "0x8", "normal"); } } catch (Exception ex) { WriteLogs.LogError(ex); } finally { connection.Close(); connection.Dispose(); } } else { NotificationLauncher.ShowNotificationError("THÔNG BÁO", "KHÔNG CÓ KẾT NỐI VỚI CƠ SỞ DỮ LIỆU TỚI ORACLE", 1, "0x1", "0x8", "normal"); } } return(RESULT); }
public static List <KHACHHANG_DTO> TIMKIEM_KHACHHANG_FROM_ORACLE(string P_KEYSEARCH, int P_USE_TIMKIEM_ALL, int P_DIEUKIEN_TIMKIEM, string UNITCODE) { List <KHACHHANG_DTO> _LST_KHACHHANG_DTO = new List <KHACHHANG_DTO>(); try { using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString)) { try { connection.Open(); if (connection.State == ConnectionState.Open) { OracleCommand cmd = new OracleCommand(); cmd.Connection = connection; cmd.InitialLONGFetchSize = 1000; cmd.CommandText = "TIMKIEM_KHACHHANG"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("P_KEYSEARCH", OracleDbType.Varchar2).Value = P_KEYSEARCH; cmd.Parameters.Add("P_UNITCODE", OracleDbType.Varchar2).Value = UNITCODE; cmd.Parameters.Add("P_USE_TIMKIEM_ALL", OracleDbType.Int32).Value = P_USE_TIMKIEM_ALL; cmd.Parameters.Add("P_DIEUKIEN_TIMKIEM", OracleDbType.Int32).Value = P_DIEUKIEN_TIMKIEM; cmd.Parameters.Add("CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output; OracleDataReader dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { KHACHHANG_DTO _KHACHHANG_DTO = new KHACHHANG_DTO(); _KHACHHANG_DTO.MAKH = dataReader["MAKH"] != null ? dataReader["MAKH"].ToString().Trim() : ""; _KHACHHANG_DTO.TENKH = dataReader["TENKH"] != null ? dataReader["TENKH"].ToString().Trim() : ""; _KHACHHANG_DTO.DIACHI = dataReader["DIACHI"] != null ? dataReader["DIACHI"].ToString().Trim() : ""; _KHACHHANG_DTO.DIENTHOAI = dataReader["DIENTHOAI"] != null ? dataReader["DIENTHOAI"].ToString().Trim() : ""; _KHACHHANG_DTO.CMTND = dataReader["CMTND"] != null ? dataReader["CMTND"].ToString().Trim() : ""; _KHACHHANG_DTO.EMAIL = dataReader["EMAIL"] != null ? dataReader["EMAIL"].ToString().Trim() : ""; _KHACHHANG_DTO.HANGKHACHHANG = dataReader["HANGKHACHHANG"] != null ? dataReader["HANGKHACHHANG"].ToString().Trim() : ""; _KHACHHANG_DTO.HANGKHACHHANGCU = dataReader["HANGKHACHHANGCU"] != null ? dataReader["HANGKHACHHANGCU"].ToString().Trim() : ""; decimal SODIEM = 0; if (dataReader["SODIEM"] != null) { decimal.TryParse(dataReader["SODIEM"].ToString(), out SODIEM); } decimal TONGTIEN = 0; if (dataReader["TONGTIEN"] != null) { decimal.TryParse(dataReader["TONGTIEN"].ToString(), out TONGTIEN); } _KHACHHANG_DTO.SODIEM = SODIEM; _KHACHHANG_DTO.TONGTIEN = TONGTIEN; if (dataReader["NGAYCAPTHE"] != null) { DateTime?NGAYCAPTHE = string.IsNullOrEmpty(dataReader["NGAYCAPTHE"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["NGAYCAPTHE"].ToString()); _KHACHHANG_DTO.NGAYCAPTHE = NGAYCAPTHE; } if (dataReader["NGAYHETHAN"] != null) { DateTime?NGAYHETHAN = string.IsNullOrEmpty(dataReader["NGAYHETHAN"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["NGAYHETHAN"].ToString()); _KHACHHANG_DTO.NGAYHETHAN = NGAYHETHAN; } if (dataReader["NGAYSINH"] != null) { DateTime?NGAYSINH = string.IsNullOrEmpty(dataReader["NGAYSINH"].ToString()) ? (DateTime?)null : DateTime.Parse(dataReader["NGAYSINH"].ToString()); _KHACHHANG_DTO.NGAYSINH = NGAYSINH; } _KHACHHANG_DTO.UNITCODE = dataReader["UNITCODE"] != null ? dataReader["UNITCODE"].ToString().Trim() : ""; _LST_KHACHHANG_DTO.Add(_KHACHHANG_DTO); } } } } catch { NotificationLauncher.ShowNotificationWarning("THÔNG BÁO", "KHÔNG TÌM THẤY THÔNG TIN KHÁCH HÀNG", 1, "0x1", "0x8", "normal"); } finally { connection.Close(); connection.Dispose(); } } } catch (Exception ex) { WriteLogs.LogError(ex); NotificationLauncher.ShowNotificationError("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal"); } return(_LST_KHACHHANG_DTO); }
/// <summary> /// Updates a record in the KHACH_HANG table. /// </summary> public void Update(KHACHHANG_DTO KhachHang) { ValidationUtility.ValidateArgument("KhachHang", KhachHang); new KHACHHANG_DAO().Update(KhachHang); }
public int SAVE_DATA_KHACHHANG_TO_ORACLE() { int RESULT = 0; //SAVE ORACLE string MAKHACHHANG = SAVE_MAKHACHHANG_TO_ORACLE(); using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString)) { connection.Open(); if (connection.State == ConnectionState.Open) { try { KHACHHANG_DTO _KHACHHANG_DTO = new KHACHHANG_DTO(); _KHACHHANG_DTO.MAKHACHHANG = txtMaKhachHang.Text; _KHACHHANG_DTO.TENKHACHHANG = txtTenKhachHang.Text; _KHACHHANG_DTO.DIACHI = txtDiaChi.Text; _KHACHHANG_DTO.DIENTHOAI = txtDienThoai.Text; _KHACHHANG_DTO.CANCUOC_CONGDAN = txtChungMinhThu.Text; _KHACHHANG_DTO.NGAYSINH = dateNgaySinh.Value; _KHACHHANG_DTO.NGAYDACBIET = dateNgayDacBiet.Value; _KHACHHANG_DTO.MATHE = txtMaThe.Text; _KHACHHANG_DTO.SODIEM = 0; _KHACHHANG_DTO.TONGTIEN = 0; _KHACHHANG_DTO.DIENGIAI = txtDienGiai.Text; _KHACHHANG_DTO.TRANGTHAI = 10; _KHACHHANG_DTO.I_CREATE_DATE = DateTime.Now; _KHACHHANG_DTO.I_CREATE_BY = Session.Session.CurrentMaNhanVien; _KHACHHANG_DTO.I_STATE = "X"; _KHACHHANG_DTO.UNITCODE = Session.Session.CurrentUnitCode;; OracleCommand command = new OracleCommand(); command.Connection = connection; string queryInsertItem = string.Format(@"INSERT INTO KHACHHANG (ID,MAKHACHHANG,TENKHACHHANG,DIACHI,DIENTHOAI,CANCUOC_CONGDAN,NGAYSINH,NGAYDACBIET,MATHE,SODIEM,TONGTIEN,DIENGIAI,TRANGTHAI,I_CREATE_DATE,I_CREATE_BY,I_STATE,UNITCODE) VALUES (:ID,:MAKHACHHANG,:TENKHACHHANG,:DIACHI,:DIENTHOAI,:CANCUOC_CONGDAN,:NGAYSINH,:NGAYDACBIET,:MATHE,:SODIEM,:TONGTIEN,:DIENGIAI,:TRANGTHAI,:I_CREATE_DATE,:I_CREATE_BY,:I_STATE,:UNITCODE)"); command.CommandText = queryInsertItem; command.CommandType = CommandType.Text; command.Parameters.Add("ID", OracleDbType.NVarchar2, 50).Value = Guid.NewGuid(); command.Parameters.Add("MAKHACHHANG", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.MAKHACHHANG; command.Parameters.Add("TENKHACHHANG", OracleDbType.NVarchar2, 300).Value = _KHACHHANG_DTO.TENKHACHHANG; command.Parameters.Add("DIACHI", OracleDbType.NVarchar2, 300).Value = _KHACHHANG_DTO.DIACHI; command.Parameters.Add("DIENTHOAI", OracleDbType.NVarchar2, 20).Value = _KHACHHANG_DTO.DIENTHOAI; command.Parameters.Add("CANCUOC_CONGDAN", OracleDbType.NVarchar2, 20).Value = _KHACHHANG_DTO.CANCUOC_CONGDAN; command.Parameters.Add("NGAYSINH", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYSINH; command.Parameters.Add("NGAYDACBIET", OracleDbType.Date).Value = _KHACHHANG_DTO.NGAYDACBIET; command.Parameters.Add("MATHE", OracleDbType.NVarchar2, 20).Value = _KHACHHANG_DTO.MATHE; command.Parameters.Add("SODIEM", OracleDbType.Decimal).Value = _KHACHHANG_DTO.SODIEM; command.Parameters.Add("TONGTIEN", OracleDbType.Decimal).Value = _KHACHHANG_DTO.TONGTIEN; command.Parameters.Add("DIENGIAI", OracleDbType.NVarchar2, 300).Value = _KHACHHANG_DTO.DIENGIAI; command.Parameters.Add("TRANGTHAI", OracleDbType.Int32).Value = _KHACHHANG_DTO.TRANGTHAI; command.Parameters.Add("I_CREATE_DATE", OracleDbType.Date).Value = _KHACHHANG_DTO.I_CREATE_DATE; command.Parameters.Add("I_CREATE_BY", OracleDbType.Varchar2, 50).Value = _KHACHHANG_DTO.I_CREATE_BY; command.Parameters.Add("I_STATE", OracleDbType.Varchar2, 1).Value = _KHACHHANG_DTO.I_STATE; command.Parameters.Add("UNITCODE", OracleDbType.NVarchar2, 50).Value = _KHACHHANG_DTO.UNITCODE; try { if (command.ExecuteNonQuery() > 0) { RESULT++; } _STATUS_THEMMOI_KHACHHANG(_KHACHHANG_DTO); } catch (Exception e) { WriteLogs.LogError(e); NotificationLauncher.ShowNotificationError("THÔNG BÁO", "XẢY RA LỖI KHI LƯU THÔNG TIN KHÁCH HÀNG", 1, "0x1", "0x8", "normal"); } } catch (Exception ex) { WriteLogs.LogError(ex); } finally { connection.Close(); connection.Dispose(); } } else { NotificationLauncher.ShowNotificationError("THÔNG BÁO", "KHÔNG CÓ KẾT NỐI VỚI CƠ SỞ DỮ LIỆU TỚI ORACLE", 1, "0x1", "0x8", "normal"); } } return(RESULT); }
public void addKH(KHACHHANG_DTO dto) { dao.themKH(dto); }
public void updateKH(KHACHHANG_DTO dto) { dao.capnhatKH(dto); }