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();
}
