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