protected void Page_Load(object sender, EventArgs e) { try { string username = (string)(Session["username"]); ProjectDatasetTableAdapters.user_banksTableAdapter ds = new ProjectDatasetTableAdapters.user_banksTableAdapter(); ProjectDataset.user_banksDataTable dt = new ProjectDataset.user_banksDataTable(); dt = ds.GetDataid(username); if (dt.Rows.Count > 0) { banksview.Visible = true; lblmsg.Visible = false; banksview.DataSource = dt; banksview.DataBind(); } else { banksview.Visible = false; lblmsg.Visible = true; lblmsg.Text = "Sorry, You have not added any bank account yet!"; } } catch (Exception ex) { lblmsg.Visible = true; lblmsg.Text = ex.ToString(); } }
protected void btnsend_Click(object sender, EventArgs e) { try { string username = (string)(Session["username"]); String bankname = txtbankname.Text.ToString(); String accountno = txtbankaccount.Text.ToString(); if (bankname == "") { lblmsg.Visible = true; lblmsg.Text = "Bank Name Must not be empty."; mtop.Style["margin-top"] = "40px"; } else if (accountno == "") { lblmsg.Visible = true; lblmsg.Text = "Account Number Must not be empty"; mtop.Style["margin-top"] = "40px"; } else { ProjectDatasetTableAdapters.usersTableAdapter ta = new ProjectDatasetTableAdapters.usersTableAdapter(); ProjectDataset.usersDataTable td = new ProjectDataset.usersDataTable(); td = ta.GetDataByusername(username); String uid = td.Rows[0]["user_id"].ToString(); lblmsg.Visible = true; lblmsg.Text = "Bank Added Successfully!"; lblmsg.Style["background"] = "#4CAF50!important"; mtop.Style["margin-top"] = "40px"; ProjectDatasetTableAdapters.user_banksTableAdapter bds = new ProjectDatasetTableAdapters.user_banksTableAdapter(); bds.Insert(Convert.ToInt32(uid), bankname, accountno); } } catch (Exception ex) { lblmsg.Visible = true; lblmsg.Text = ex.ToString(); mtop.Style["margin-top"] = "40px"; } }