/// <summary> /// get KhachDat để chèn cuộc gọi (gán thêm line) /// </summary> private KhachDatBL GetKhachDat_Row_Line(DataRow row, string line) { KhachDatBL KhachDat = new KhachDatBL(); KhachDat.PK_KhachDatID = Convert.ToInt32(row["PK_KhachDatID"]); string ThoiDiemTiepNhan = row["ThoiDiemTiepNhan"].ToString(); if (!string.IsNullOrEmpty(ThoiDiemTiepNhan)) { KhachDat.ThoiDiemTiepNhan = Convert.ToDateTime(ThoiDiemTiepNhan); } KhachDat.TenKhachHang = row["TenKhachHang"].ToString(); KhachDat.SoDienThoai = row["SoDienThoai"].ToString(); KhachDat.DiaChi = row["DiaChiDon"].ToString(); KhachDat.Line = Convert.ToInt32(line); KhachDat.VungKenh = Convert.ToInt32(row["VungKenh"]); KhachDat.IsLapLai = Convert.ToBoolean(row["IsLapLai"]); string GioDon = row["GioDon"].ToString(); if (!string.IsNullOrEmpty(GioDon)) { KhachDat.GioDon = Convert.ToDateTime(GioDon); } string ThoiDiemBatDau = row["ThoiDiemBatDau"].ToString(); if (!string.IsNullOrEmpty(ThoiDiemBatDau)) { KhachDat.ThoiDiemBatDau = Convert.ToDateTime(ThoiDiemBatDau); } string ThoiDiemKetThuc = row["ThoiDiemKetThuc"].ToString(); if (!string.IsNullOrEmpty(ThoiDiemKetThuc)) { KhachDat.ThoiDiemKetThuc = Convert.ToDateTime(ThoiDiemKetThuc); } KhachDat.NgayTrongTuanLapLai = row["NgayTrongTuanLapLai"].ToString(); KhachDat.SoPhutBaoTruoc = Convert.ToInt32(row["SoPhutBaoTruoc"]); KhachDat.FK_CuocGoiID = row["FK_CuocGoiID"] == DBNull.Value ? 1 : Convert.ToInt64(row["FK_CuocGoiID"]); KhachDat.GhiChu = row["GhiChu"].ToString(); KhachDat.LoaiXe = row["LoaiXe"].ToString(); KhachDat.SoLuongXe = row["SoLuongXe"] == DBNull.Value ? 1 : Convert.ToInt32(row["SoLuongXe"]); KhachDat.DiaChiTra = row["DiaChiTra"] == DBNull.Value ? "" : row["DiaChiTra"].ToString(); KhachDat.SoKm = row["SoKm"] == DBNull.Value ? 1 : float.Parse(row["SoKm"].ToString()); KhachDat.FK_SystemBookID = row["FK_SystemBookID"] == DBNull.Value ? 1 : int.Parse(row["FK_SystemBookID"].ToString()); if (row["UpdatedDateKD"] != DBNull.Value) { KhachDat.UpdatedDateKD = Convert.ToDateTime(row["UpdatedDateKD"].ToString()); } KhachDat.StatusRow = row["StatusRow"] == DBNull.Value ? 0 : int.Parse(row["StatusRow"].ToString()); //KhachDat.KinhDo = return(KhachDat); }
private KhachDatBL GetKhachDat_Row(DataRow row) { KhachDatBL KhachDat = new KhachDatBL(); try { KhachDat.PK_KhachDatID = Convert.ToInt32(row["PK_KhachDatID"]); if (row["ThoiDiemTiepNhan"] != DBNull.Value) { KhachDat.ThoiDiemTiepNhan = Convert.ToDateTime(row["ThoiDiemTiepNhan"].ToString()); } KhachDat.TenKhachHang = row["TenKhachHang"].ToString(); KhachDat.SoDienThoai = row["SoDienThoai"].ToString(); KhachDat.DiaChi = row["DiaChiDon"].ToString(); KhachDat.VungKenh = Convert.ToInt32(row["VungKenh"]); KhachDat.IsLapLai = Convert.ToBoolean(row["IsLapLai"]); KhachDat.Line = 111; if (row["GioDon"] != DBNull.Value) { KhachDat.GioDon = Convert.ToDateTime(row["GioDon"].ToString()); } if (row["ThoiDiemBatDau"] != DBNull.Value) { KhachDat.ThoiDiemBatDau = Convert.ToDateTime(row["ThoiDiemBatDau"].ToString()); } if (row["ThoiDiemKetThuc"] != DBNull.Value) { KhachDat.ThoiDiemKetThuc = Convert.ToDateTime(row["ThoiDiemKetThuc"].ToString()); } KhachDat.NgayTrongTuanLapLai = row["NgayTrongTuanLapLai"].ToString(); KhachDat.SoPhutBaoTruoc = Convert.ToInt32(row["SoPhutBaoTruoc"]); KhachDat.FK_CuocGoiID = Convert.ToInt64(row["FK_CuocGoiID"]); KhachDat.GhiChu = row["GhiChu"].ToString(); KhachDat.LoaiXe = row["LoaiXe"].ToString(); KhachDat.SoLuongXe = Convert.ToInt32(row["SoLuongXe"]); KhachDat.CreatedBy = row["CreatedBy"].ToString(); KhachDat.FULLNAME = row["FULLNAME"].ToString(); KhachDat.KinhDo = row["KinhDo"] == DBNull.Value ? 0 : Convert.ToDouble(row["KinhDo"]); KhachDat.ViDo = row["ViDo"] == DBNull.Value ? 0 : Convert.ToDouble(row["ViDo"]); KhachDat.SoTien = row["SoTien"] == DBNull.Value ? 0 : Convert.ToDouble(row["SoTien"]); if (row.Table.Columns.Contains("TenLoaiXe")) { KhachDat.TenLoaiXe = row["TenLoaiXe"].ToString(); } else { KhachDat.TenLoaiXe = CommonBL.ListStaxiLoaiXe.FirstOrDefault(a => a.StaxiType.ToString() == KhachDat.LoaiXe).Name; } if (row.Table.Columns.Contains("DiaChiTra") && row["DiaChiTra"] != DBNull.Value) { KhachDat.DiaChiTra = row["DiaChiTra"].ToString(); } else { KhachDat.DiaChiTra = string.Empty; } if (row.Table.Columns.Contains("SoKm") && row["SoKm"] != DBNull.Value) { KhachDat.SoKm = float.Parse(row["SoKm"].ToString()); } else { KhachDat.SoKm = 0; } if (row.Table.Columns.Contains("FK_SystemBookID") && row["FK_SystemBookID"] != DBNull.Value) { KhachDat.FK_SystemBookID = int.Parse(row["FK_SystemBookID"].ToString()); } else { KhachDat.FK_SystemBookID = 0; } if (row["UpdatedDateKD"] != DBNull.Value) { KhachDat.UpdatedDateKD = Convert.ToDateTime(row["UpdatedDateKD"].ToString()); } KhachDat.StatusRow = row["StatusRow"] == DBNull.Value ? 0 : int.Parse(row["StatusRow"].ToString()); } catch (Exception exx) { LogError.WriteLogError("GetKhachDat_Row", exx); } return(KhachDat); }