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