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