protected void Page_Load(object sender, EventArgs e) { NCBJDataContext dbcontext = new NCBJDataContext(); TransGV.DataSource = dbcontext.nwc_Transaction_logs; TransGV.DataBind(); }
public static int get_lime_balance(int userid) { NCBJDataContext ncb = new NCBJDataContext(); int Acct_balance = (from cust in ncb.nwc_Accounts where cust.Cust_num == userid select cust.Balance).FirstOrDefault <int>(); return(Acct_balance); }
public static void Recieve_Payments(int cust_id, int acct_num, Decimal Pay_amt, Decimal Acct_balance, DateTime Payment_date, String trans_type) { using (NCBJDataContext ncb = new NCBJDataContext()) { try { //calling stored procedure ncb.Recieve_Payment(cust_id, acct_num, Pay_amt, Acct_balance, Payment_date, trans_type); }catch (FormatException e) { Console.WriteLine(e.Message); } } }
static ScotiaBankDataContext scotiaB = new ScotiaBankDataContext();// I have to keep this contaxt open in order to return table for bill view /*These are for nwc*/ public static void Generate_bill(int customer_id, String name, DateTime Statement_date, DateTime Due_date, Decimal Bill_amt)//the generate bill stored procedure needs { using (NCBJDataContext ncb = new NCBJDataContext()) { try { //Calling stored procedure ncb.Generate_Bill(customer_id, name, Statement_date, Due_date, Bill_amt); } catch (FormatException e) { Console.WriteLine(e.Message); } } }