public static List <DanhBaKhachQuen> GetKhachQuens_LastUpdate(DateTime LastUpdate)
{
try
{
List <DanhBaKhachQuen> lstKhachQuen = new List <DanhBaKhachQuen>();
DataTable dt = new DataTable();
dt = new Data.DanhBaKhachQuen().GetKhachQuens_LastUpdate(LastUpdate);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
lstKhachQuen.Add(GetKhachQuen_Row(dr));
}
dt.Dispose();
dt = null;
}
return(lstKhachQuen);
}
catch (Exception ex)
{
LogError.WriteLogError("GetKhachQuens_LastUpdate", ex);
return(new List <DanhBaKhachQuen>());
}
}
/// <summary>
/// Load danh sách xe hiện có trên hệ thống
/// </summary>
public static void LoadVehicles()
{
try
{
Vehicles_Active_LastUpdate = DateTime.Now;
DicXe = new Dictionary <string, string>();
DicObjecXe = new Dictionary <string, Data.BanCo.Entity.DM.DMXe>();
ListXe = new Data.BanCo.Entity.DM.DMXe().GetListAll();
foreach (var item in ListXe)
{
if (!DicXe.ContainsKey(item.PK_SoHieuXe))
{
DicXe.Add(item.PK_SoHieuXe, item.BienKiemSoat);
}
else
{
DicXe[item.PK_SoHieuXe] = item.BienKiemSoat;
}
if (!DicObjecXe.ContainsKey(item.PK_SoHieuXe))
{
DicObjecXe.Add(item.PK_SoHieuXe, item);
}
else
{
DicObjecXe[item.PK_SoHieuXe] = item;
}
}
}
catch (Exception ex)
{
LogError.WriteLogError("Lỗi Load Danh sách xe hệ thống", ex);
}
}
public static List <DanhBaKhachQuen_Rank> GetDanhSachKhachQuen_Rank()
{
try
{
List <DanhBaKhachQuen_Rank> listKhachQuen_Rank = new List <DanhBaKhachQuen_Rank>();
DataTable dt = new DataTable();
dt = new Data.DanhBaKhachQuen().GetDanhBaKhachQuen_Rank_ID("");
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
listKhachQuen_Rank.Add(GetKhachQuen_Rank_Row(dr));
}
}
dt.Dispose();
dt = null;
return(listKhachQuen_Rank);
}
catch (Exception ex)
{
LogError.WriteLogError("GetDanhSachKhachQuen_Rank: ", ex);
return(new List <DanhBaKhachQuen_Rank>());
}
}
public static DanhBaEx GetDanhBaEx_Row(DataRow dr)
{
try
{
DanhBaEx objKhachQuen = new DanhBaEx();
objKhachQuen.MaDoiTac = dr["MaKH"].ToString();
objKhachQuen.PhoneNumber = dr["Phones"].ToString();
objKhachQuen.Name = dr["Name"].ToString();
objKhachQuen.Address = dr["Address"].ToString();
objKhachQuen.IsActive = Convert.ToBoolean(dr["IsActive"]);
objKhachQuen.GhiChuTiepNhan = dr["Notes"].ToString();
int Type = dr["Type"] == DBNull.Value ? 0 : Convert.ToInt16(dr["Type"]);
if (Type == 1)
{
objKhachQuen.KieuKHGoiDen = KieuKhachHangGoiDen.KhachHangVIP;
}
else if (Type == 2)
{
objKhachQuen.KieuKHGoiDen = KieuKhachHangGoiDen.KhachHangBinhThuong;
}
else if (Type == 3)
{
objKhachQuen.KieuKHGoiDen = KieuKhachHangGoiDen.KhachHangBinhThuong;
}
objKhachQuen.KieuDanhBa = KieuDanhBa.ThanThiet;
objKhachQuen.GPS_KinhDo = dr["KinhDo"] == DBNull.Value ? 0 : (float)dr["KinhDo"];
objKhachQuen.GPS_ViDo = dr["ViDo"] == DBNull.Value ? 0 : (float)dr["ViDo"];
return(objKhachQuen);
}
catch (Exception ex)
{
LogError.WriteLogError("GetDanhBaEx_Row: ", ex);
return(null);
}
}
public DataTable GetDataTable(DateTime start, DateTime end, string phoneNumber, string diaChi, string line, string vung, string IDCuoc, string pBookID)
{
try
{
DateTime from = start;
DateTime to = end;
DataTable dtAll = new DataTable();
int countMinute = (to - from).TotalMinutes.To <int>() / 10;
for (int i = 1; i <= countMinute + 1; i++)
{
try
{
dtAll.Merge(this.ExeStore("sp_TaxiperationHistory_GetData", from, from.AddMinutes(10), phoneNumber, diaChi, line, vung, IDCuoc, pBookID));
}
catch (Exception ex)
{
LogError.WriteLogError("GetDataTable: ", ex);
}
from = from.AddMinutes(10);
Thread.Sleep(50);
}
return(dtAll);
}
catch (Exception ex)
{
LogError.WriteLogError("GetDataTable: ", ex);
return(new DataTable());
}
}
public static DanhBaKhachQuenEx GetKhachQuenEx_Row(DataRow dr)
{
try
{
DanhBaKhachQuenEx objKhachQuen = new DanhBaKhachQuenEx();
objKhachQuen.MaKH = dr["MaKH"].ToString();
objKhachQuen.Phones = dr["Phones"].ToString();
objKhachQuen.Name = dr["Name"].ToString();
objKhachQuen.Address = dr["Address"].ToString();
objKhachQuen.BirthDay = dr["BirthDay"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr["BirthDay"]);
objKhachQuen.Email = dr["Email"].ToString();
objKhachQuen.Fax = dr["Fax"].ToString();
objKhachQuen.IsActive = Convert.ToBoolean(dr["IsActive"]);
objKhachQuen.Notes = dr["Notes"].ToString();
objKhachQuen.Rank = 0; // dr["Rank"] == DBNull.Value ? 0 : Convert.ToInt16(dr["Rank"].ToString());
objKhachQuen.Type = 0; // dr["Type"] == DBNull.Value ? 0 : Convert.ToInt16(dr["Type"]);
objKhachQuen.RankName = string.Empty; //dr["RankName"] == DBNull.Value ? string.Empty : dr["RankName"].ToString();
objKhachQuen.TypeName = string.Empty; // dr["TypeName"] == DBNull.Value ? string.Empty : dr["TypeName"].ToString();
objKhachQuen.TrangThaiGoi = dr["TrangThaiGoi"] == DBNull.Value ? (byte)0 : byte.Parse(dr["TrangThaiGoi"].ToString());
objKhachQuen.ThoiDiemGoiGanDay = dr["ThoiDiemGoi"] == DBNull.Value ? new DateTime(2000, 1, 1, 0, 0, 0) : DateTime.Parse(dr["ThoiDiemGoi"].ToString());
objKhachQuen.GhiChuGoi = dr["GhiChu"] == DBNull.Value ? string.Empty : dr["GhiChu"].ToString();
objKhachQuen.ThangNam = dr["ThangNam"] == DBNull.Value ? string.Empty : dr["ThangNam"].ToString();
objKhachQuen.SoLanGoiTrongThang = dr["SoLanGoi"] == DBNull.Value ? 0 : int.Parse(dr["SoLanGoi"].ToString());
objKhachQuen.KinhDo = dr["KinhDo"] == DBNull.Value ? 0 : (float)dr["KinhDo"];
objKhachQuen.ViDo = dr["ViDo"] == DBNull.Value ? 0 : (float)dr["ViDo"];
return(objKhachQuen);
}
catch (Exception ex)
{
LogError.WriteLogError("GetKhachQuenEx_Row: ", ex);
return(null);
}
}
public static List <DoiTac> GetDoiTacs(string strSQL)
{
try
{
List <DoiTac> lstDoiTac = new List <DoiTac>();
DataTable dt = new DataTable();
dt = new Data.DM.DoiTac().GetDoiTacs(strSQL);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
lstDoiTac.Add(DoiTac.GetDoiTacByRow(dr));
}
}
dt.Dispose();
dt = null;
return(lstDoiTac);
}
catch (Exception ex)
{
LogError.WriteLogError("GetDoiTacs: ", ex);
return(new List <DoiTac>());
}
}
private void KhoiTaoDanhBaOnMEM_CongTy_GetLast(DateTime LastUpdate)
{
try
{
List <DanhBaEx> listDBCongTy = new List <DanhBaEx>();
listDBCongTy = DanhBaEx.GetDanhBaCONGTY_GetLast(LastUpdate);
// thêm vào dic
foreach (DanhBaEx dbcty in listDBCongTy)
{
// chưa tồn tài thì thêm vào ds
if (!dicDanhBaCongTy.ContainsKey(dbcty.PhoneNumber))
{
dicDanhBaCongTy.TryAdd(dbcty.PhoneNumber, dbcty);
}
else
{
dicDanhBaCongTy[dbcty.PhoneNumber] = dbcty;
}
if (Global.IsDebug)
{
LogError.WriteLogInfo("KhoiTaoDanhBaOnMEM_CongTy_GetLast:" + dbcty.PhoneNumber + "-" + dbcty.Address);
}
}
}
catch (Exception ex)
{
LogError.WriteLogError("KhoiTaoDanhBaOnMEM_CongTy_GetLast.", ex);
}
}
void timerCapture_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
try
{
g_iCount_GetCuocGoi++;
if (g_iCount_GetCuocGoi >= 60)
{
KhoiTaoCuocKhachOnlineLenMEM();
g_iCount_GetCuocGoi = 0;
}
g_iCount_GetDanhBa++;
if (g_iCount_GetDanhBa >= 300) // 5phut
{
KhoiTaoDanhBaOnMEM_KhachHang_GetLast(g_ThoiDiemLayTruoc_KhachHang);
KhoiTaoDanhBaOnMEM_DoiTac_GetLast(g_ThoiDiemLayTruoc_DoiTac);
KhoiTaoDanhBaOnMEM_CongTy_GetLast(g_ThoiDiemLayTruoc_CongTy);
g_iCount_GetDanhBa = 0;
}
}
catch (Exception ex)
{
LogError.WriteLogError("Loi trong timer.", ex);
}
}
private void KhoiTaoDanhBaOnMEM_KhachHang_GetLast(DateTime LastUpdate)
{
try
{
List <DanhBaEx> lstKhachVip = DanhBaKhachQuen.GetKhachQuens_LastUpdate_V2(LastUpdate);
if (lstKhachVip != null && lstKhachVip.Count > 0)
{
g_ThoiDiemLayTruoc_KhachHang = DateTime.Now;
foreach (var item in lstKhachVip)
{
if (dicKhachQuen.ContainsKey(item.PhoneNumber))
{
dicKhachQuen[item.PhoneNumber] = item;
}
else
{
dicKhachQuen.TryAdd(item.PhoneNumber, item);
}
if (Global.IsDebug)
{
LogError.WriteLogInfo("KhoiTaoDanhBaOnMEM_KhachHang_GetLast:" + item.PhoneNumber + "-" + item.Address);
}
}
}
}
catch (Exception ex)
{
LogError.WriteLogError("KhoiTaoDanhBaOnMEM_KhachHang_GetLast.", ex);
}
}
/// <summary>
/// Load danh bạ công ty, khách ảo
/// </summary>
private void KhoiTaoDanhBaOnMEM()
{
try
{
List <DanhBaEx> listDBMoiGioi = DanhBaEx.GetDanhBaMoiGioi();
if (dicMoiGioi == null)
{
dicMoiGioi = new ConcurrentDictionary <string, DanhBaEx>();
}
foreach (DanhBaEx dbex in listDBMoiGioi)
{
if (!dicMoiGioi.ContainsKey(dbex.PhoneNumber))
{
dicMoiGioi.TryAdd(dbex.PhoneNumber, dbex);
}
}
List <DanhBaEx> listDBCongTy = new List <DanhBaEx>();
listDBCongTy = DanhBaEx.GetDanhBaCongTy();
foreach (DanhBaEx dbcty in listDBCongTy)
{
if (!dicDanhBaCongTy.ContainsKey(dbcty.PhoneNumber))
{
dicDanhBaCongTy.TryAdd(dbcty.PhoneNumber, dbcty);
}
}
}
catch (Exception ex)
{
LogError.WriteLogError("KhoiTaoDanhBaOnMEM: ", ex);
}
}
private void bwSync_LoadDanhBaKhachQuen_DoWork(object sender, DoWorkEventArgs e)
{
try
{
List <DanhBaEx> lstKhachVip = DanhBaKhachQuen.GetAllKhachQuens_V2();
if (lstKhachVip != null && lstKhachVip.Count > 0)
{
DanhBaEx dicRet = new DanhBaEx();
foreach (DanhBaEx item in lstKhachVip)
{
if (dicKhachQuen.ContainsKey(dicRet.PhoneNumber))
{
continue;
}
dicKhachQuen.TryAdd(dicRet.PhoneNumber, dicRet);
if (Global.IsDebug)
{
LogError.WriteLogInfo("bwSync_LoadDanhBaKhachQuen_DoWork:" + dicRet.PhoneNumber + "-" + dicRet.Address);
}
}
}
}
catch (Exception ex)
{
LogError.WriteLogError("bwSync_LoadDanhBaKhachQuen_DoWork.", ex);
}
}
public static DanhBaKhachQuen GetKhachQuen_Row(DataRow dr)
{
try
{
DanhBaKhachQuen objKhachQuen = new DanhBaKhachQuen();
objKhachQuen.MaKH = dr.Table.Columns.Contains("MaKH") && dr["MaKH"] != DBNull.Value ? dr["MaKH"].ToString() : string.Empty;
objKhachQuen.Phones = dr.Table.Columns.Contains("Phones") && dr["Phones"] != DBNull.Value ? dr["Phones"].ToString() : string.Empty; //dr["Phones"].ToString();
objKhachQuen.Name = dr.Table.Columns.Contains("Name") && dr["Name"] != DBNull.Value ? dr["Name"].ToString() : string.Empty; //dr["Name"].ToString();
objKhachQuen.Address = dr.Table.Columns.Contains("Address") && dr["Address"] != DBNull.Value ? dr["Address"].ToString() : string.Empty; //dr["Address"].ToString();
objKhachQuen.BirthDay = !dr.Table.Columns.Contains("BirthDay") || dr["BirthDay"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr["BirthDay"]);
objKhachQuen.Email = dr.Table.Columns.Contains("Email") && dr["Email"] != DBNull.Value ? dr["Email"].ToString() : string.Empty; //dr["Email"].ToString();
objKhachQuen.Fax = dr.Table.Columns.Contains("Fax") && dr["Fax"] != DBNull.Value ? dr["Fax"].ToString() : string.Empty; //dr["Fax"].ToString();
objKhachQuen.IsActive = dr.Table.Columns.Contains("IsActive") && dr["IsActive"] != DBNull.Value && Convert.ToBoolean(dr["IsActive"]);
objKhachQuen.Notes = dr.Table.Columns.Contains("Notes") && dr["Notes"] != DBNull.Value ? dr["Notes"].ToString() : string.Empty; //dr["Notes"].ToString();
objKhachQuen.Rank = !dr.Table.Columns.Contains("Rank") || dr["Rank"] == DBNull.Value ? 0 : Convert.ToInt16(dr["Rank"].ToString());
objKhachQuen.Type = !dr.Table.Columns.Contains("Type") || dr["Type"] == DBNull.Value ? 0 : Convert.ToInt16(dr["Type"]);
objKhachQuen.RankName = dr.Table.Columns.Contains("RankName") && dr["RankName"] != DBNull.Value ? dr["RankName"].ToString() : string.Empty; // dr["RankName"] == DBNull.Value ? string.Empty : dr["RankName"].ToString();
objKhachQuen.TypeName = dr.Table.Columns.Contains("TypeName") && dr["TypeName"] != DBNull.Value ? dr["TypeName"].ToString() : string.Empty; // dr["TypeName"] == DBNull.Value ? string.Empty : dr["TypeName"].ToString();
objKhachQuen.KinhDo = !dr.Table.Columns.Contains("KinhDo") || dr["KinhDo"] == DBNull.Value ? 0 : float.Parse(dr["KinhDo"].ToString());
objKhachQuen.ViDo = !dr.Table.Columns.Contains("ViDo") || dr["ViDo"] == DBNull.Value ? 0 : float.Parse(dr["ViDo"].ToString());
return(objKhachQuen);
}
catch (Exception ex)
{
LogError.WriteLogError("GetKhachQuen_Row", ex);
return(new DanhBaKhachQuen());
}
}
/// <summary>
/// hàm thực hiện lấy danh bạ công ty.
/// </summary>
public static List <DanhBaEx> GetDanhBaCongTy()
{
//Ds danh bạ mở rộng trả về
List <DanhBaEx> listRet = new List <DanhBaEx>();
try
{
List <DanhBaCongTy> listDanhBa = DanhBaCongTy.GetDanhSachDanhBaCongTy();
foreach (DanhBaCongTy dbcty in listDanhBa)
{
string Name = dbcty.Name.Length > 0 ? "[" + dbcty.Name + "] " : "";
DanhBaEx dtx = new DanhBaEx()
{
PhoneNumber = dbcty.PhoneNumber,
Address = Name + dbcty.Address,
KieuDanhBa = KieuDanhBa.CongTy,
KieuKHGoiDen = KieuKhachHangGoiDen.KhachHangBinhThuong,
IsActive = true
};
listRet.Add(dtx);
}
}
catch (Exception ex)
{
LogError.WriteLogError("GetDanhBaCongTy: ", ex);
}
return(listRet);
}
/// <summary>
/// Get danh bạ đối tác có sự thay đổi
/// </summary>
public static List <DanhBaEx> GetDanhBaMoiGioi_LastUpdate(DateTime LastUpdate)
{
List <DanhBaEx> listRet = new List <DanhBaEx>();
try
{
DoiTac dt = new DoiTac();
List <DoiTac> listDT = dt.GetCacDoiTacs_LastUpdate(LastUpdate);
foreach (DoiTac doiTac in listDT)
{
// tác số điện thoại
string[] arrDienThoai = doiTac.Phones.Split(";".ToCharArray());
for (int i = 0; i < arrDienThoai.Length; i++)
{
DanhBaEx dtx = new DanhBaEx(arrDienThoai[i], doiTac.Name + " - " + doiTac.Address, KieuDanhBa.MoiGioi, doiTac.MaDoiTac, doiTac.Vung, "", doiTac.IsActive, "", doiTac.KinhDo, doiTac.ViDo, "");
listRet.Add(dtx);
}
}
}
catch (Exception ex)
{
LogError.WriteLogError("GetDanhBaMoiGioi_LastUpdate ", ex);
}
return(listRet);
}
/// <summary>
/// Check license
/// </summary>
public void CheckLicense()
{
//if (Debugger.IsAttached) return;//*sign
if (ExceptionCompany())
{
return;
}
try
{
string message = "";
LicenseEntity objLicense = new LicenseEntity();
string pCode = string.Empty;
string pKey = string.Empty;
DateTime pDate = CommonBL.GetTimeServer();
DataTable dtTemp = objLicense.GetAll();
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
pCode = dtTemp.Rows[0]["LicenseCode"].ToString();
pKey = dtTemp.Rows[0]["LicenseKey"].ToString();
//pDate = dtTemp.Rows[0]["CreatedDate"].To<DateTime>();
string strCPUID = "";
string strMacAddress = objLicense.GetServerInformation(out strCPUID);
var hasValid = BALicenseManager.CheckValidateLicense(pCode, pKey, pDate, strMacAddress, strCPUID);
if (hasValid < 0)
{
message = string.Format("{0}:Mã xác thực License Key không hợp lệ. Vui lòng liên hệ nhà cung cấp", hasValid);
new MessageBoxBA().Show(message, "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Error);
Application.Exit();
}
else if (hasValid > 1)
{
message = string.Format("Bản quyền còn {0} ngày nữa sẽ hết hạn. Vui lòng liên hệ nhà cung cấp", hasValid);
new MessageBoxBA().Show(message, "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Warning);
}
else if (hasValid == 0)
{
message = string.Format("Phần mềm đã hết hạn sử dụng. Bạn không được sử dụng phần mềm này nữa");
new MessageBoxBA().Show(message, "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Error);
Application.Exit();
}
}
else
{
message = "Phần mềm đang chưa có bản quyền.";
new MessageBoxBA().Show(message, "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Error);
Application.Exit();
}
}
catch (Exception ex)
{
LogError.WriteLogError("LicenseBL CheckLicense", ex);
new MessageBoxBA().Show("Lỗi.Phần mềm đang chưa có bản quyền.", "Thông báo", MessageBoxButtonsBA.OK, MessageBoxIconBA.Error);
Application.Exit();
}
}
public static void LoadVehicles_Active_LastUpdate()
{
try
{
if ((Vehicles_Active_LastUpdate == DateTime.MinValue) && DicObjecXe != null && DicObjecXe.Count > 0)
{
Vehicles_Active_LastUpdate = DicObjecXe.Max(p => p.Value.LastUpdate);
}
if ((Vehicles_Active_LastUpdate == null || Vehicles_Active_LastUpdate == DateTime.MinValue))
{
Vehicles_Active_LastUpdate = DieuHanhTaxi.GetTimeServer();
}
if ((Vehicles_Active_LastUpdate == null || Vehicles_Active_LastUpdate == DateTime.MinValue))
{
Vehicles_Active_LastUpdate = DateTime.Now;
}
var ListXeUpdate = Data.BanCo.Entity.DM.DMXe.Inst.GetLastUpdate(Vehicles_Active_LastUpdate);
if (ListXeUpdate != null && ListXeUpdate.Count > 0)
{
foreach (var item in ListXeUpdate)
{
if (item.LastUpdate > Vehicles_Active_LastUpdate)
{
Vehicles_Active_LastUpdate = item.LastUpdate;
}
if (!DicXe.ContainsKey(item.PK_SoHieuXe))
{
DicXe.Add(item.PK_SoHieuXe, item.BienKiemSoat);
}
else
{
DicXe[item.PK_SoHieuXe] = item.BienKiemSoat;
}
if (!DicObjecXe.ContainsKey(item.PK_SoHieuXe))
{
DicObjecXe.Add(item.PK_SoHieuXe, item);
}
else
{
DicObjecXe[item.PK_SoHieuXe] = item;
}
}
if (DicObjecXe != null)
{
ListXe = DicObjecXe.Select(p => p.Value).ToList();
}
}
}
catch (Exception ex)
{
LogError.WriteLogError("LoadVehicles_Active_LastUpdate", ex);
}
}
public bool Update()
{
try
{
return(new Data.DanhBaKhachQuen().Update(this.MaKH, this.Phones, this.Name, this.Address, this.BirthDay, this.Email, this.Fax, this.IsActive, this.Notes, this.Rank, this.Type));
}
catch (Exception ex)
{
LogError.WriteLogError("DanhBaKhachQuen.Insert", ex);
return(false);
}
}
public bool Insert()
{
try
{
return(new Data.TinhTienTheoKm().Insert(this.KmMoCua, this.GiaMoCua, this.KmNguong1, this.GiaNguong1, this.KmNguong2, this.GiaNguong2, this.KmNguong3, this.GiaNguong3, this.N1_ChieuDiTu, this.N1_ChieuDiDen, this.N1_Giam, this.N2_ChieuDiTu, this.N2_Giam, this.IsAll, this.KmNguong2Chieu, this.TiLeGiamGia2Chieu, this.LoaiXe, this.ThongTinThueBao));
}
catch (Exception ex)
{
LogError.WriteLogError("TinhTienTheoKm.Insert", ex);
return(false);
}
}
public DataTable GetAllLoaiXe_Truck()
{
try
{
return(new Data.TinhTienTheoKm().GetAllLoaiXe_Truck());
}
catch (Exception ex)
{
LogError.WriteLogError("TinhTienTheoKm.GetAllLoaiXe", ex);
return(null);
}
}
public bool Delete(string maKhachHang)
{
try
{
return(new Data.DanhBaKhachQuen().Delete(maKhachHang));
}
catch (Exception ex)
{
LogError.WriteLogError("DanhBaKhachQuen.Delete", ex);
return(false);
}
}
public bool Update()
{
try
{
return(new Data.TinhTienTheoKm().Update(this.KmMoCua, this.GiaMoCua, this.KmNguong1, this.GiaNguong1, this.GiaNguong2, this.KmNguong2Chieu, this.TiLeGiamGia2Chieu, this.LoaiXe, this.ThongTinThueBao, this.LoaiCuoc));
}
catch (Exception ex)
{
LogError.WriteLogError("TinhTienTheoKm.Update", ex);
return(false);
}
}
/// <summary>
/// Convert Từ số hiệu sang biển số
/// </summary>
/// <param name="soHieuXe">Số hiệu xe</param>
/// <param name="soLan">Số lần</param>
/// <returns>Biển số xe</returns>
public static string ConvertSangBienSo(string soHieuXe, int soLan = 0)
{
try
{
if (DicXe != null && DicXe.Count > 0)
{
if (DicXe.ContainsKey(soHieuXe) && DicXe[soHieuXe].Trim().Length > 0)
{
return(DicXe[soHieuXe]);
}
}
if (soLan < 2)
{
var xe = Data.BanCo.Entity.DM.DMXe.Inst.GetDMXeTheoSoXe(soHieuXe);
if (xe != null)
// return ConvertSangBienSo(soHieuXe, soLan++);
//else
{
if (DicObjecXe != null)
{
if (DicObjecXe.ContainsKey(xe.PK_SoHieuXe))
{
DicObjecXe[xe.PK_SoHieuXe] = xe;
}
else
{
DicObjecXe.Add(xe.PK_SoHieuXe, xe);
}
}
if (DicXe != null)
{
if (DicXe.ContainsKey(xe.PK_SoHieuXe))
{
DicXe[xe.PK_SoHieuXe] = xe.BienKiemSoat;
}
else
{
DicXe.Add(xe.PK_SoHieuXe, xe.BienKiemSoat);
}
return(xe.BienKiemSoat);
}
}
}
}
catch (Exception ex)
{
LogError.WriteLogError(string.Format("ConvertSangBienSo:{0}-{1}", soHieuXe, soLan), ex);
//return ConvertSangBienSo(soHieuXe, soLan++);
}
return(string.Empty);
}
/// <summary>
/// Lưu thông tin license vào DB
/// </summary>
public int AuthoriseLicenseKey(params object[] parInput)//5 tham số!
{
try
{
var temp = this.ExeStoreWithOutput("sp_AuthoriseLicenseKey", parInput);
return(temp.Value["pResult"].To <int>());
}
catch (Exception ex)
{
LogError.WriteLogError("AuthoriseLicenseKey: ", ex);
return(-1);//Lỗi kết nối cơ sở dữ liệu!
}
}
public DataTable LayDanhSachNguoiNhan(params object[] pInput)
{
DataTable result = new DataTable();
try
{
result = Inst.ExeStore("sp_LayDanhSachNguoiNhan", pInput);
}
catch (Exception ex)
{
LogError.WriteLogError("LayDanhSachNguoiNhan: ", ex);
}
return(result);
}
public static DanhBaKhachQuen_Type GetKhachQuen_Type_Row(DataRow dr)
{
try
{
DanhBaKhachQuen_Type objKhachQuen_Type = new DanhBaKhachQuen_Type();
objKhachQuen_Type.ID = Convert.ToInt16(dr["ID"]);
objKhachQuen_Type.Notes = dr["Notes"].ToString();
objKhachQuen_Type.Type = dr["Type"].ToString();
return(objKhachQuen_Type);
}
catch (Exception ex)
{
LogError.WriteLogError("GetKhachQuen_Type_Row: ", ex);
return(new DanhBaKhachQuen_Type());
}
}
public static DanhBaKhachQuen_Rank GetKhachQuen_Rank_Row(DataRow dr)
{
try
{
DanhBaKhachQuen_Rank objKhachQuen_Rank = new DanhBaKhachQuen_Rank();
objKhachQuen_Rank.ID = Convert.ToInt16(dr["ID"]);
objKhachQuen_Rank.Notes = dr["Notes"].ToString();
objKhachQuen_Rank.Rank = dr["Rank"].ToString();
return(objKhachQuen_Rank);
}
catch (Exception ex)
{
LogError.WriteLogError("GetKhachQuen_Rank_Row: ", ex);
return(new DanhBaKhachQuen_Rank());
}
}
/// <summary>
/// Lưu thông tin sử dụng xe
/// </summary>
/// <returns></returns>
public bool Save()
{
try
{
if (this.ID > 0)
{
return(new TinhTien_SuDung().Update(this.ID, this.LoaiXe, this.Km_Tu, this.Km_Den, this.Vtb, this.TG));
}
else
{
return(new TinhTien_SuDung().Insert(this.LoaiXe, this.Km_Tu, this.Km_Den, this.Vtb, this.TG));
}
}
catch (Exception ex)
{
LogError.WriteLogError("TinhTien_SuDungXe.Save", ex);
return(false);
}
}
public GlobalContacts()
{
try
{
bwSync_LoadDanhBaBuuDien.DoWork += bwSync_LoadDanhBaBuuDien_DoWork;
bwSync_LoadDanhBaKhachQuen.DoWork += bwSync_LoadDanhBaKhachQuen_DoWork;
g_ThoiDiemLayTruoc_KhachHang = DateTime.Now;
g_ThoiDiemLayTruoc_DoiTac = DateTime.Now;
g_ThoiDiemLayTruoc_CongTy = DateTime.Now;
G_TimerCapture = new System.Timers.Timer(1000);
G_TimerCapture.Elapsed += timerCapture_Elapsed;
}
catch (Exception ex)
{
LogError.WriteLogError("GlobalContacts Init:", ex);
}
}
/// <summary>
/// Tra ve dia chi cua so dien thoai
/// </summary>
public static string GetAddress(string PhoneNumber)
{
try
{
DataTable dt = new DataTable();
dt = new Data.DanhBaKhachQuen().GetAddress_Phones(PhoneNumber);
if (dt.Rows.Count > 0)
{
return(dt.Rows[0]["Address"].ToString());
}
dt.Dispose();
dt = null;
return(string.Empty);
}
catch (Exception ex)
{
LogError.WriteLogError("GetAddress: ", ex);
return(string.Empty);
}
}
