public void Key_Clients_DeleteByMerchant(int ID_) { KEY_CLIENTS = context.Set <KEY_CLIENTS>(); var a = from s in this.KEY_CLIENTS where s.SE_NUMBER == ID_ select s; foreach (var b in a) { KEY_CLIENTS.Remove(b); } }
public void Key_Clients_Insert(KEY_CLIENTS kk) { var a = KEY_CLIENTS.Where(s => s.SE_NUMBER == kk.SE_NUMBER); //distinct check if (!KEY_CLIENTS.Where(s => s.SE_NUMBER == kk.SE_NUMBER).Any()) { KEY_CLIENTS.Add(kk); } }
//>>!!! 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(); }