private void SetNullData <T>(T item, System.Reflection.PropertyInfo p, Models.DICHVU_VT_BKN DVVT, DateTime TIME_BILL)
{
if (p.PropertyType == typeof(Guid) || !p.CanWrite || !p.CanRead)
{
p.SetValue(item, Guid.NewGuid());
}
else if (p.PropertyType == typeof(int) || !p.CanWrite || !p.CanRead)
{
p.SetValue(item, DVVT.DICHVUVT_ID);
}
else if (p.PropertyType == typeof(DateTime) || !p.CanWrite || !p.CanRead)
{
p.SetValue(item, TIME_BILL);
}
}
private void SetNullData <T>(T item, System.Reflection.PropertyInfo p, Models.DICHVU_VT_BKN DVVT, DateTime TIME_BILL)
{
if (p.PropertyType == typeof(Guid) || !p.CanWrite || !p.CanRead)
{
p.SetValue(item, Guid.NewGuid());
}
else if (p.Name.ToUpper() == "TYPE_BILL" && p.PropertyType == typeof(int))
{
p.SetValue(item, DVVT.DICHVUVT_ID);
}
else if (p.Name.ToUpper() == "KYHOADON" && p.PropertyType == typeof(int))
{
p.SetValue(item, int.Parse(TIME_BILL.ToString("yyyyMM") + "01"));
}
else if (p.Name.ToUpper() == "TIME_BILL" && p.PropertyType == typeof(DateTime))
{
p.SetValue(item, TIME_BILL);
}
}
private string ImportData(Common.DefaultObj obj, Models.DICHVU_VT_BKN DVVT)
{
// var FoxPro = new TM.Connection.OleDBF(obj.DataSource);
// try
// {
// if (DVVT.TABLE_TARGET == "NET")
// {
// var qry = $"SELECT * FROM {DVVT.MA_DVVT}";
// var collection = FoxPro.Connection.Query<Models.NET>(qry).ToList();
// //
// var TABLE_FIELD_SET = DVVT.TABLE_FIELD_SET.Trim(',').Split(',');
// UpdateProperties(collection, TABLE_FIELD_SET, DVVT, obj.datetime);
// //Delete old
// _Con.Connection.Query($"DELETE {DVVT.TABLE_TARGET} WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'");
// //
// _Con.Connection.Insert(collection);
// }
// if (DVVT.TABLE_TARGET == "MEGA")
// {
// var qry = $"SELECT * FROM {DVVT.MA_DVVT}";
// var collection = FoxPro.Connection.Query<Models.MEGA>(qry).ToList();
// //
// var TABLE_FIELD_SET = DVVT.TABLE_FIELD_SET.Trim(',').Split(',');
// UpdateProperties(collection, TABLE_FIELD_SET, DVVT, obj.datetime);
// //Delete old
// _Con.Connection.Query($"DELETE {DVVT.TABLE_TARGET} WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'");
// //
// _Con.Connection.Insert(collection);
// }
// if (DVVT.TABLE_TARGET == "HD_NET")
// {
// //
// var TABLE_FIELD_SET = DVVT.TABLE_FIELD_SET.Trim(',').Split(',');
// var qry = $"SELECT * FROM {DVVT.MA_DVVT}";
// //
// var collection = FoxPro.Connection.Query<Models.HD_NET>(qry).ToList(); ;
// UpdateProperties(collection, TABLE_FIELD_SET, DVVT, obj.datetime);
// var collectionInsert = new List<Models.HD_NET>();
// //
// var new_dbkh = FoxPro.Connection.Query<Models.DB_THANHTOAN_BKN>(qry).ToList();
// UpdateProperties(new_dbkh, TABLE_FIELD_SET, DVVT, obj.datetime);
// var old_dbkh = _Con.Connection.Query<Models.DB_THANHTOAN_BKN>($"SELECT * FROM {Common.Objects.TYPE_HD.DB_THANHTOAN_BKN} WHERE FIX=1");
// var DataInsert = new List<Models.DB_THANHTOAN_BKN>();
// var DataUpdate = new List<Models.DB_THANHTOAN_BKN>();
// foreach (var i in new_dbkh)
// {
// var _tmp = old_dbkh.FirstOrDefault(d => d.ACCOUNT == i.ACCOUNT);
// var _tmp_collection = collection.FirstOrDefault(d => d.ACCOUNT == i.ACCOUNT);
// if (_tmp_collection != null)
// _tmp_collection.DBKH_ID = i.ID;
// collectionInsert.Add(_tmp_collection);
// if (_tmp != null)
// {
// if (!string.IsNullOrEmpty(i.MA_TB)) _tmp.MA_TB = i.MA_TB;
// if (!string.IsNullOrEmpty(i.TEN_TT)) _tmp.TEN_TT = i.TEN_TT.Trim();
// if (!string.IsNullOrEmpty(i.DIACHI_TT)) _tmp.DIACHI_TT = i.DIACHI_TT.Trim();
// if (!string.IsNullOrEmpty(i.DIENTHOAI)) _tmp.DIENTHOAI = i.DIENTHOAI.Trim();
// if (!string.IsNullOrEmpty(i.MA_DVI)) _tmp.MA_DVI = i.MA_DVI.Trim();
// if (!string.IsNullOrEmpty(i.MA_CBT)) _tmp.MA_CBT = i.MA_CBT.Trim();
// if (!string.IsNullOrEmpty(i.MA_TUYEN)) _tmp.MA_TUYEN = i.MA_TUYEN.Trim();
// if (!string.IsNullOrEmpty(i.MA_KH)) _tmp.MA_KH = i.MA_KH.Trim();
// if (!string.IsNullOrEmpty(i.MA_TT_HNI)) _tmp.MA_TT_HNI = i.MA_TT_HNI.Trim();
// if (!string.IsNullOrEmpty(i.MS_THUE)) _tmp.MS_THUE = i.MS_THUE.Trim();
// _tmp.MA_DT = i.MA_DT;
// _tmp.KHLON_ID = i.KHLON_ID;
// _tmp.LOAIKH_ID = i.LOAIKH_ID;
// _tmp.TH_SD = 1;
// _tmp.ISNULL = 0;
// _tmp.ISNULLMT = 0;
// _tmp.FIX = 1;
// _tmp.FLAG = 1;
// DataUpdate.Add(_tmp);
// }
// else
// {
// i.MA_DT = 1;
// i.TH_SD = 1;
// i.ISNULL = 1;
// i.ISNULLMT = 1;
// i.FIX = 1;
// i.FLAG = 1;
// DataInsert.Add(i);
// }
// }
// //Delete old
// _Con.Connection.Query($"DELETE {DVVT.TABLE_TARGET} WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'");
// //
// _Con.Connection.Insert(collectionInsert);
// _Con.Connection.Insert(DataInsert);
// _Con.Connection.Update(DataUpdate);
// }
// else if (DVVT.TABLE_TARGET == "MYTV")
// {
// var qry = $"SELECT * FROM {DVVT.MA_DVVT}";
// var collection = FoxPro.Connection.Query<Models.MYTV>(qry).ToList();
// //
// var TABLE_FIELD_SET = DVVT.TABLE_FIELD_SET.Trim(',').Split(',');
// UpdateProperties(collection, TABLE_FIELD_SET, DVVT, obj.datetime);
// //Delete old
// _Con.Connection.Query($"DELETE {DVVT.TABLE_TARGET} WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'");
// //
// _Con.Connection.Insert(collection);
// }
// else if (DVVT.TABLE_TARGET == "HD_MYTV")
// {
// var qry = $"SELECT * FROM {DVVT.MA_DVVT}";
// var collection = FoxPro.Connection.Query<Models.HD_MYTV>(qry).ToList();
// //
// var TABLE_FIELD_SET = DVVT.TABLE_FIELD_SET.Trim(',').Split(',');
// UpdateProperties(collection, TABLE_FIELD_SET, DVVT, obj.datetime);
// //Delete old
// _Con.Connection.Query($"DELETE {DVVT.TABLE_TARGET} WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'");
// //
// _Con.Connection.Insert(collection);
// }
// else if (DVVT.TABLE_TARGET == "DISCOUNT")
// {
// var qry = $"SELECT * FROM {DVVT.MA_DVVT}";
// var collection = FoxPro.Connection.Query<Models.DISCOUNT>(qry).ToList();
// //
// var TABLE_FIELD_SET = DVVT.TABLE_FIELD_SET.Trim(',').Split(',');
// UpdateProperties(collection, TABLE_FIELD_SET, DVVT, obj.datetime);
// //Delete old
// _Con.Connection.Query($"DELETE {DVVT.TABLE_TARGET} WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'");
// //
// _Con.Connection.Insert(collection);
// }
// else if (DVVT.TABLE_TARGET == "THANHTOANTRUOC")
// {
// var qry = $"SELECT a.*,a.MA_TB AS ACCOUNT FROM {DVVT.MA_DVVT} a";
// var collection = FoxPro.Connection.Query<Models.THANHTOANTRUOC>(qry).ToList();
// //
// var TABLE_FIELD_SET = DVVT.TABLE_FIELD_SET.Trim(',').Split(',');
// UpdateProperties(collection, TABLE_FIELD_SET, DVVT, obj.datetime);
// //Delete old
// _Con.Connection.Query($"DELETE {DVVT.TABLE_TARGET} WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'");
// //
// _Con.Connection.Insert(collection);
// //Update NGAY_BD
// qry = $"UPDATE THANHTOANTRUOC SET NGAY_BD=CAST(CAST(NAM AS varchar(4))+'-'+CAST(THANG AS varchar(2))+'-1' as datetime) WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
// _Con.Connection.Query(qry);
// //Update NGAY_KT
// qry = $"UPDATE THANHTOANTRUOC SET NGAY_KT=DATEADD(MONTH,SOTHANG,CAST(CAST(NAM as varchar(4))+'-'+CAST(THANG as varchar(2))+'-01' as datetime)) WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
// _Con.Connection.Query(qry);
// }
// else if (DVVT.TABLE_TARGET == "CD")
// {
// var qry = $"ALTER TABLE {DVVT.MA_DVVT} ALTER COLUMN dia_chi c(100)";
// FoxPro.Connection.Query(qry);
// qry = $"SELECT a.*,a.MA_KH1 AS MA_TT,a.TEN_CQ AS TEN_TT,a.DIA_CHI AS DIACHI_TT,a.MA_ST AS MS_THUE,a.dvql_id AS MA_DVI,a.TONG_CUOC AS TONGCONG FROM {DVVT.MA_DVVT} a";
// var collection = FoxPro.Connection.Query<Models.CD>(qry).ToList();
// //
// var TABLE_FIELD_SET = DVVT.TABLE_FIELD_SET.Trim(',').Split(',');
// UpdateProperties(collection, TABLE_FIELD_SET, DVVT, obj.datetime);
// //Delete old
// _Con.Connection.Query($"DELETE {DVVT.TABLE_TARGET} WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'");
// //
// _Con.Connection.Insert(collection);
// }
// else if (DVVT.TABLE_TARGET == "DD")
// {
// var qry = $"SELECT a.*,a.cuoc_cthue AS TONG,a.thue AS VAT,a.ma_cq AS MA_KH,a.ma_cq AS MA_TT,a.taikhoan AS BANKNUMBER,GIAMTRU AS GIAM_TRU FROM {DVVT.MA_DVVT} a";
// var collection = FoxPro.Connection.Query<Models.DD>(qry).ToList();
// //
// var TABLE_FIELD_SET = DVVT.TABLE_FIELD_SET.Trim(',').Split(',');
// UpdateProperties(collection, TABLE_FIELD_SET, DVVT, obj.datetime);
// //Delete old
// _Con.Connection.Query($"DELETE {DVVT.TABLE_TARGET} WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'");
// //
// _Con.Connection.Insert(collection);
// }
// else if (DVVT.TABLE_TARGET == "HD_TSL")
// {
// var qry = $"SELECT * FROM {DVVT.MA_DVVT}";
// var collection = FoxPro.Connection.Query<Models.HD_TSL>(qry).ToList();
// //
// var TABLE_FIELD_SET = DVVT.TABLE_FIELD_SET.Trim(',').Split(',');
// UpdateProperties(collection, TABLE_FIELD_SET, DVVT, obj.datetime);
// //Delete old
// _Con.Connection.Query($"DELETE {DVVT.TABLE_TARGET} WHERE TYPE_BILL={DVVT.DICHVUVT_ID} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'");
// //
// _Con.Connection.Insert(collection);
// }
// }
// catch (Exception) { throw; }
// finally { _Con.Close(); FoxPro.Close(); }
return(DVVT.TEN_DVVT);
}
private IEnumerable <T> UpdateProperties <T>(IEnumerable <T> collection, string[] TABLE_FIELD_SET, Models.DICHVU_VT_BKN DVVT, DateTime TIME_BILL)
{
foreach (var item in collection)
{
//1/1/0001 12:00:00 AM
var properties = typeof(T).GetProperties(System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance);
foreach (var p in properties)
{
if (TABLE_FIELD_SET.Contains(p.Name))
{
SetNullData(item, p, DVVT, TIME_BILL);
}
}
item.Trim().TCVN3ToUnicode().FixDateFoxPro();
}
return(collection);
}
