private List <StoreVisaMachine> GetVisaMachine(int BankIserial, string company)
{
using (var context = new ccnewEntities(service.GetSqlConnectionString(company)))
{
var defaultQuery = context.TblStoreVisaMachines.Include(
nameof(TblStoreVisaMachine.TblVisaMachine1)).Where(v => v.TblVisaMachine1.TblBank == BankIserial);
List <StoreVisaMachine> result = new List <StoreVisaMachine>();
if (defaultQuery != null)
{
foreach (var item in defaultQuery)
{
var entity = context.Entities.FirstOrDefault(e =>
e.Iserial == item.TblVisaMachine1.EntityAccount && e.TblJournalAccountType == 15);
var model = new StoreVisaMachine()
{
VisaMachineIserial = item.TblVisaMachine1.Iserial,
Code = item.TblVisaMachine1.Code,
MachineId = item.TblVisaMachine1.MachineId,
BankIserial = item.TblVisaMachine1.TblBank,
DiscountPercent = item.TblVisaMachine1.DiscountPercent,
EntityAccount = item.TblVisaMachine1.EntityAccount,
EntityCode = entity == null ? "0" : entity.Code,
StoreVisaMachineIserial = item.Iserial,
StoreIserial = item.TblStore,
IsDefault = item.IsDefault,
Store = item.TblStore1,
};
result.Add(model);
}
}
return(result);
}
}
private int DeleteVisaMachine(StoreVisaMachine row, string company)
{
using (var context = new ccnewEntities(service.GetSqlConnectionString(company)))
{
var oldStoreRow = (from e in context.TblStoreVisaMachines
where e.Iserial == row.StoreVisaMachineIserial
select e).SingleOrDefault();
if (oldStoreRow != null)
{
context.DeleteObject(oldStoreRow);
}
var oldRow = context.TblVisaMachines.SingleOrDefault(r => r.Iserial == row.VisaMachineIserial);
if (oldRow != null)
{
context.DeleteObject(oldRow);
}
context.SaveChanges();
}
return(row.StoreVisaMachineIserial);
}
