protected void Page_Load(object sender, EventArgs e) { try { string username = (string)(Session["username"]); ProjectDatasetTableAdapters.usersTableAdapter ta = new ProjectDatasetTableAdapters.usersTableAdapter(); string balance = ta.GetBalancebyusername(username).ToString(); ProjectDataset.usersDataTable dt = new ProjectDataset.usersDataTable(); dt = ta.GetDataByusername(username); String ubalance = dt.Rows[0]["balance"].ToString(); String userid = dt.Rows[0]["user_id"].ToString(); lblbalance.InnerText = ubalance + " PKR"; ProjectDatasetTableAdapters.transfersTableAdapter tds = new ProjectDatasetTableAdapters.transfersTableAdapter(); String counter = tds.transactioncount(username).ToString(); if (Convert.ToInt32(counter) > 0) { String intransfers = ta.transfercount(Convert.ToInt32(userid)).ToString(); lbltransfers.InnerText = intransfers + " PKR"; } ProjectDatasetTableAdapters.withdrawalsTableAdapter wds = new ProjectDatasetTableAdapters.withdrawalsTableAdapter(); String wcounter = wds.withdrawalcount(username).ToString(); if (Convert.ToInt32(wcounter) > 0) { String twithdrawals = wds.totalwithdrawals(username).ToString(); lblwithdrawals.InnerText = twithdrawals + " PKR"; } } catch (Exception Ex) { Response.Write(Ex.ToString()); } }
protected void btnwithdraw_Click(object sender, EventArgs e) { try { String username = (string)Session["username"]; String bankid = dropdownbank.SelectedItem.Value.ToString(); String wamount = txtamount.Text.ToString(); int amount = Convert.ToInt32(wamount); ProjectDatasetTableAdapters.withdrawalsTableAdapter wds = new ProjectDatasetTableAdapters.withdrawalsTableAdapter(); ProjectDatasetTableAdapters.usersTableAdapter uds = new ProjectDatasetTableAdapters.usersTableAdapter(); ProjectDataset.usersDataTable udt = new ProjectDataset.usersDataTable(); udt = uds.GetDataByusername(username); String userid = udt.Rows[0]["user_id"].ToString(); int balance = Convert.ToInt32(udt.Rows[0]["balance"].ToString()); String bankcount = uds.verifybankforwithdrawal(username, Convert.ToInt32(bankid)).ToString(); if (Convert.ToInt32(bankcount) > 0) { if (amount < 500) { lblmsg.Visible = true; lblmsg.Text = "Minimum amount to withdraw is 500 PKR"; mtop.Style["margin-top"] = "40px"; } else if (balance < amount) { lblmsg.Visible = true; lblmsg.Text = "You Don't have Enought Balance"; mtop.Style["margin-top"] = "40px"; } else { lblmsg.Visible = true; lblmsg.Text = "Withdrawal Successfully Initiated."; lblmsg.Style["background"] = "#4CAF50!important"; mtop.Style["margin-top"] = "40px"; wds.insertwithdrawal(Convert.ToInt32(userid), Convert.ToInt32(bankid), Convert.ToInt32(wamount)); uds.updatesenderbalance(Convert.ToInt32(wamount), username); } } else { lblmsg.Visible = true; lblmsg.Text = "This bank account is not yours."; mtop.Style["margin-top"] = "40px"; } } catch (Exception ex) { lblmsg.Visible = true; lblmsg.Text = ex.ToString(); mtop.Style["margin-top"] = "40px"; } }