public static void MigrateByDate <T>(DateTime st_, DateTime fn_) where T : class, IEntity, IDate { try { DWH_entities dwh = new DWH_entities(); SQL_entity sql = new SQL_entity(); sql.Database.Initialize(true); Repository <T> acq_rep_dwh = new Repository <T>(dwh); Repository <T> acq_rep_sql = new Repository <T>(sql); IQueryable <T> a = acq_rep_dwh.DWHGetByDate(st_, fn_); int cnt = a.Count(); foreach (var t in a) { acq_rep_sql.Add(t); acq_rep_sql.Save(); } } catch (Exception e) { } }
public Edit_UOF() { ent = new SQL_entity(); ACQ_D = new EditRepo <T_ACQ_D>(ent); REFMERCHANTS = new UserFilterRepo <DAL.REFMERCHANTS>(ent); KK = new SectorFilterRepo <KEY_CLIENTS>(ent); }
public static dynamic RepoFromString(string name_, SQL_entity ent) { dynamic result = null; switch (name_) { case "TEMP_ACQ_D": result = new Repo.Repository <TEMP_ACQ_D>(ent); break; case "TEMP_ACQ_M": result = new Repo.Repository <TEMP_ACQ_M>(ent); break; case "TEMP_ECOMM_D": result = new Repo.Repository <TEMP_ECOMM_D>(ent); break; case "TEMP_ACQ": result = new Repo.Repository <TEMP_ACQ>(ent); break; case "TEMP_CTL_D": result = new Repo.Repository <TEMP_ACQ>(ent); break; default: result = null; break; } return(result); }
public static void ReadRepoCheck() { SQL_entity ent = new SQL_entity(); ReadRepo <T_ACQ_D> readRep = new ReadRepo <T_ACQ_D>(ent); MerchantFilterRepo <KEY_CLIENTS, REFMERCHANTS> filtRep = new MerchantFilterRepo <KEY_CLIENTS, REFMERCHANTS>(ent); DateFilterRepo <T_ACQ_D> dateFilter = new DateFilterRepo <T_ACQ_D>(ent); ChainingRepo <TEMP_ACQ_D> chainRep = new ChainingRepo <TEMP_ACQ_D>(ent); DateTime stDt = new DateTime(2016, 08, 21, 00, 00, 00); DateTime fnDt = new DateTime(2016, 08, 22, 00, 00, 00); DateTime st = new DateTime(2016, 02, 01, 00, 00, 00); DateTime fn = new DateTime(2016, 06, 01, 00, 00, 00); //48 int cnt_1 = readRep.GetByFilter <T_ACQ_D>(s => s.MERCHANT == 9294109921).Count(); //50830 int cnt_2 = dateFilter.GetByDate(stDt, fnDt).Count(); //128 int cnt_3 = filtRep.GetByMerchantFilter <T_ACQ_D>().Count(); //2042 int cnt_4 = chainRep.FilterByDate(st, fn)._result.Count(); //597 int cnt_5 = chainRep.FilterByMerchants <REFMERCHANTS>()._result.Count(); }
public void MerchantsCheck() { SQL_entity ent = new SQL_entity(); Repository <TEMP_ACQ_D> rep = new Repository <TEMP_ACQ_D>(ent); var a = rep.SQLGetList(); int cnt = a.Count(); }
public UtilityRepository(SQL_entity ent) { this.context = ent; REFMERCHANTS = context.Set <REFMERCHANTS>(); KEY_CLIENTS = context.Set <KEY_CLIENTS>(); SECTOR_NAMES = context.Set <SECTOR>(); SECTOR_MASKS = context.Set <SECTOR_MASK>(); //Masks_Init(); Entity_check(); }
//>>!!! To Unit Test public static void TypeInsertCheck() { SQL_entity ent = new SQL_entity(); EditRepo <KEY_CLIENTS> editRep = new EditRepo <KEY_CLIENTS>(ent); UnitOfWorkGeneric uof = new UnitOfWorkGeneric(ent); uof.RefreshValues(); EntityInitialization entityInit = new EntityInitialization(); entityInit.KEY_CLIENTS_add(uof, 9290000009, 9, "ABCD"); var a = editRep.GetByFilter <KEY_CLIENTS>(s => s.ID != null).Count(); }
public void Chainingcheck() { SQL_entity ent = new SQL_entity(); Repository <TEMP_ACQ_D> rep = new Repository <TEMP_ACQ_D>(ent); rep.SQLGetByDay(st, fn); //chn.GetByMerchant(); var a = rep.GetResult(); int c = a.Count(); }
public void SQL_cehck() { SQL_entity ent = new SQL_entity(); Repository <TEMP_ACQ_D> rp = new Repository <TEMP_ACQ_D>(ent); var a = from s in rp.SQLGetByMonth(st, fn) select s; int b = a.Count(); var a_ = from s in ent.TEMP_ACQ_D where DbFunctions.CreateDateTime(s.DATE.Value.Year, s.DATE.Value.Month, s.DATE.Value.Day, 00, 00, 00) == st select s; int b_ = a_.Count(); }
public void KeyClientsInsertCheck() { SQL_entity ent = new SQL_entity(); UtilityRepository ur = new UtilityRepository(ent); KEY_CLIENTS kk = new DAL.KEY_CLIENTS { SECTOR_ID = 2, SE_NUMBER = 929001 }; ur.MerchantsCount(); ur.Key_Clients_Insert(kk); ur.contextSaveChanges(); ur.Key_Clients_DeleteAll(); ur.contextSaveChanges(); }
public void TypeCheck(string typename_) { SQL_entity ent = new SQL_entity(); var a = ent.GetType(); PropertyInfo[] b = a.GetProperties(); foreach (PropertyInfo c in b) { if (c.Name == typename_) { //Repository<a> rep = new Repository<a>(); } } }
public void CallDisconnectedProcedureTest() { SQL_entity ent = new SQL_entity(); UnitOfWorkGeneric uof = new UnitOfWorkGeneric(ent); uof.RefreshValues(); /* * * //12 * var a = uof.GetByDate<T_ACQ_D>(st, fn).Count(); * //5 * var b = uof.GetByMerchants<KEY_CLIENTS>().Count(); * //10 * var c = uof.MerchantListCount(); * * * ReadRepo<KEY_CLIENTS> kkRead = new ReadRepo<KEY_CLIENTS>(ent); * //5 * var d = uof.GetByMerchants<KEY_CLIENTS>().Count(); * uof.DeleteBySector(2); * uof.SaveAll(); * //4 * var e = uof.GetByMerchants<KEY_CLIENTS>().Count(); * * * EditRepo<REFMERCHANTS> rfEdit = new EditRepo<REFMERCHANTS>(ent); * //10 * var f = uof.MerchantListCount(); * uof.DeleteByUserID(0); * uof.SaveAll(); * //9 * var g = uof.MerchantListCount(); * * uof.RefreshValues(); * * //27 * var h = * uof.GetByDate<T_ACQ_D>(st, fn).Count() + uof.GetByMerchants<KEY_CLIENTS>().Count() + uof.MerchantListCount(); + */ Assert.Fail(); }
//>>!!! To Unit Test public static void UOWcheck() { SQL_entity ent = new SQL_entity(); UnitOfWorkGeneric uof = new UnitOfWorkGeneric(ent); //12 var a = uof.GetByDate <T_ACQ_D>(st, fn).Count(); //5 var b = uof.GetByMerchants <KEY_CLIENTS>().Count(); //10 var c = uof.MerchantListCount(); ReadRepo <KEY_CLIENTS> kkRead = new ReadRepo <KEY_CLIENTS>(ent); //5 var d = uof.GetByMerchants <KEY_CLIENTS>().Count(); uof.DeleteBySector(2); uof.SaveAll(); //4 var e = uof.GetByMerchants <KEY_CLIENTS>().Count(); EditRepo <REFMERCHANTS> rfEdit = new EditRepo <REFMERCHANTS>(ent); //10 var f = uof.MerchantListCount(); uof.DeleteByUserID(0); uof.SaveAll(); //9 var g = uof.MerchantListCount(); uof.RefreshValues(); //27 var h = uof.GetByDate <T_ACQ_D>(st, fn).Count() + uof.GetByMerchants <KEY_CLIENTS>().Count() + uof.MerchantListCount(); }
//>>!!! To Unit Test public static void UOFinsertCheck() { SQL_entity ent = new SQL_entity(); EditRepo <KEY_CLIENTS> editRep = new EditRepo <KEY_CLIENTS>(ent); UnitOfWorkGeneric uof = new UnitOfWorkGeneric(ent); uof.RefreshValues(); KEY_CLIENTS kk = new KEY_CLIENTS { SE_NUMBER = 9290000009, MERCHANT = 9290000009, SECTOR_ID = 9 }; //5 var a = editRep.GetByFilter <KEY_CLIENTS>(s => s.ID != null).Count(); uof.Add <KEY_CLIENTS>(kk); //6 var b = editRep.GetByFilter <KEY_CLIENTS>(s => s.ID != null).Count(); uof.RefreshValues(); //5 var c = editRep.GetByFilter <KEY_CLIENTS>(s => s.ID != null).Count(); }
public static void Initialize() { SQL_entity context = new SQL_entity(); SECTOR sector; List <SECTOR_MASK> masks = new List <SECTOR_MASK>(); Random rand = new Random(); context.SECTOR_NAMES.RemoveRange(from s in context.SECTOR_NAMES select s); context.SECTOR_MASKS.RemoveRange(from s in context.SECTOR_MASKS select s); context.REFMERCHANTS.RemoveRange(from s in context.REFMERCHANTS select s); List <SECTOR> names = new List <SECTOR>(); sector = new SECTOR { SECTOR_NAME = @"Retail&Telecom" }; masks.Add(new SECTOR_MASK { MASK = @"((retail(.*)telecom)|(telecom(.*)retail))", SECTOR = sector }); sector = new SECTOR { SECTOR_NAME = @"Travel$Restaurants" }; masks.Add(new SECTOR_MASK { MASK = @"((travel(.*)restaurants)|(restaurants(.*)travel))", SECTOR = sector }); sector = new SECTOR { SECTOR_NAME = @"ECOMM" }; masks.Add(new SECTOR_MASK { MASK = @"((.*)ECOMM(.*))", SECTOR = sector }); sector = new SECTOR { SECTOR_NAME = @"Hotels" }; masks.Add(new SECTOR_MASK { MASK = @"((.*)hotels(.*))", SECTOR = sector }); foreach (SECTOR_MASK ms in masks) { context.SECTOR_MASKS.Add(ms); } context.SaveChanges(); List <REFMERCHANTS> rf = new List <REFMERCHANTS>(); int upper = rand.Next(1000, 3000); int merch_gen = rand.Next(29000000, 59999999); long merch_solid = 9000000000; string merch = merch_solid.ToString(); for (int i = 0; i < upper; i++) { merch_solid = 9000000000; int type1 = rand.Next(290000000, 299999999); int type2 = rand.Next(590000000, 599999999); if (type1 % 2 == 0) { merch_solid += type1; } else { merch_solid += type2; } merch = merch_solid.ToString(); context.REFMERCHANTS.Add(new REFMERCHANTS { ITEM_ID = merch_solid.ToString(), USER_ID = 0 }); } context.SaveChanges(); }