protected void Page_Load(object sender, EventArgs e)
{
ScotiaBankDataContext dbcontext = new ScotiaBankDataContext();
TransGV.DataSource = dbcontext.transaction_histories;
TransGV.DataBind();
}
public static void Make_payment(int cust_id, int acct_num, Decimal Pay_amt, Decimal Acct_balance, DateTime Payment_date, String trans_type)
{
using (ScotiaBankDataContext scotia = new ScotiaBankDataContext())
{
try
{
//Calling stored procedure
scotia.Make_Payment(cust_id, acct_num, Pay_amt, Acct_balance, Payment_date, trans_type);
}
catch (FormatException e)
{
Console.WriteLine(e.Message);
}
}
}
/*For customer*/
public static void Cust_genbill(int customer_id, String name, DateTime Statement_date, DateTime Due_date, Decimal Bill_amt)
{
using (ScotiaBankDataContext scotia = new ScotiaBankDataContext())// these were created long ago using linq to sql look for .dbml extensions
{
try
{
//Calling stored procedure
scotia.Generate_Bill(customer_id, name, Statement_date, Due_date, Bill_amt);
}
catch (FormatException e)
{
Console.WriteLine(e.Message);
}
}
}