protected void Button1_Click(object sender, EventArgs e) { if (pin.Equals(txtPin.Text)) { try { int amount = Convert.ToInt32(txtDC.Text); com = new SqlCommand("UPDATE DC_Bank SET Balance = Balance-" + amount + " WHERE DCID='" + DCID + "'", conn); com2 = new SqlCommand("UPDATE DC_CustomerMaster SET AMOUNT = AMOUNT+" + amount + " WHERE DCID=" + Convert.ToInt32(DCID.ToString()) + "", conn); transaction = conn.BeginTransaction(); com.Transaction = transaction; com2.Transaction = transaction; com.ExecuteNonQuery(); com2.ExecuteNonQuery(); transaction.Commit(); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Make Digital Cash Completed Successfully');", true); } catch (Exception ex) { transaction.Rollback(); ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Make Digital Cash Failed Please Try Again');", true); } finally { txtDC.Text = ""; txtPin.Text = ""; conn.Close(); } } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Your Bank Pin Is Invalid');", true); } }
protected void Page_Load(object sender, EventArgs e) { try { DCID = (String)Session["DCID"]; if (DCID.Equals("")) { Response.Redirect("Index.aspx"); } conn = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString); conn.Open(); com = new SqlCommand("SELECT [Amount] FROM [DC_CustomerMaster] where [DCID]=" + Convert.ToInt32(DCID.ToString()) + "", conn); reader = com.ExecuteReader(); while (reader.Read()) { amount = (int)reader[0]; } reader.Dispose(); com = new SqlCommand("SELECT [BankName],[AccountNo],[Balance],[Pin] FROM [DC_Bank] WHERE [DCID]='" + DCID + "'", conn); reader = com.ExecuteReader(); while (reader.Read()) { bankName = (String)reader[0]; bankAccNo = (String)reader[1]; bankBalance = (int)reader[2]; pin = (String)reader[3]; } reader.Dispose(); lblDCID.Text = DCID; lblAmount.Text = amount.ToString(); lblBankName.Text = bankName; lblBankAccNo.Text = bankAccNo; } catch (Exception ex) { Response.Write(ex); } }