public tblBank GetBankingInfo(string bankName) { using (var db = new FrameworkDBEntities()) { return(db.tblBanks.FirstOrDefault(b => b.BankName == bankName)); } }
public tblTransactionType GetTransTypeInfo(int transTypeNameId) { using (var db = new FrameworkDBEntities()) { return(db.tblTransactionTypes.FirstOrDefault(b => b.TransactionTypeId == transTypeNameId)); } }
public tblAccountName GetAcNameInfo(int acNameId) { using (var db = new FrameworkDBEntities()) { return(db.tblAccountNames.FirstOrDefault(b => b.ACnameID == acNameId)); } }
public Transaction GetSingleTransaction(int id) { using (var db = new FrameworkDBEntities()) { var tblTransaction = db.tblTransactions.FirstOrDefault(p => p.TransID == id); return(_dataMapper.Map <tblTransaction, Transaction>(tblTransaction)); } }
public IEnumerable <EachEntityTran> GetAllTransaction() { var transactionList = new List <EachEntityTran>(); using (var db = new FrameworkDBEntities()) { var tblTransactions = (from v in db.tblEachEntityTrans select v).ToList(); return(_dataMapper.Map <List <tblEachEntityTran>, List <EachEntityTran> >(tblTransactions)); } }
public IEnumerable <EachEntityTran> GetTransactionforEachEntity(string bankName) { GetAllTransaction(); var transactionList = new List <EachEntityTran>(); using (var db = new FrameworkDBEntities()) { var tblTransactions = (from v in db.tblEachEntityTrans where v.BankName.Trim() == bankName select v).ToList(); return(_dataMapper.Map <List <tblEachEntityTran>, List <EachEntityTran> >(tblTransactions)); } }
private void AccountNameCombo_OnLoaded(object sender, RoutedEventArgs e) { List <string> data = new List <string>(); using (var db = new FrameworkDBEntities()) { var comboBox = sender as ComboBox; data = (from g in db.tblAccountNames select g.ACname).ToList(); comboBox.ItemsSource = data; comboBox.SelectedIndex = 0; db.Dispose(); } }
private void TransTypeComboBox_Loaded(object sender, RoutedEventArgs e) { List <string> data = new List <string>(); using (var db = new FrameworkDBEntities()) { var comboBox = sender as ComboBox; data = (from g in db.tblTransactionTypes select g.TransactionTypeName).ToList(); comboBox.ItemsSource = data; comboBox.SelectedIndex = 0; db.Dispose(); } }
public void FinanceListComboBox_Loaded(object sender, RoutedEventArgs e) { List <string> data = new List <string>(); using (var db = new FrameworkDBEntities()) { var comboBox = sender as ComboBox; data = (from g in db.tblBanks select g.BankName).ToList(); comboBox.ItemsSource = data; comboBox.SelectedIndex = 0; db.Dispose(); } }
public bool UpdateTblEntity(tblEachEntityTran entityTran) { try { using (var db = new FrameworkDBEntities()) { db.tblEachEntityTrans.Add(entityTran); db.Entry(entityTran).State = EntityState.Added; db.SaveChanges(); db.Dispose(); return(true); } } catch (Exception e) { Console.WriteLine(e); return(false); } }
public bool UpdateTblTransaction(tblTransaction transaction) { try { using (var db = new FrameworkDBEntities()) { db.tblTransactions.Add(transaction); db.Entry(transaction).State = EntityState.Added; db.SaveChanges(); db.Dispose(); // var id = (from w in db.tblTransactions orderby w select w.TransID).FirstOrDefault(); return(true); } } catch (Exception e) { Console.WriteLine(e); return(false); } }