private void button1_Click(object sender, EventArgs e)
{
string query = "SELECT * from Accounts where AccountNo='" + txtacc.Text + "'";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
txtbal.Text = sdr[4].ToString();
}
}
public string DBConnection()
{
DatabaseConnectionClass databaseConnectionClass = new DatabaseConnectionClass();
string Con = databaseConnectionClass.var1;
string User = databaseConnectionClass.var2;
string Pass = databaseConnectionClass.var3;
string Connectionstring = System.IO.File.ReadAllText(Con);
string ConnectionUserName = System.IO.File.ReadAllText(User);
string ConnectionPasswrod = System.IO.File.ReadAllText(Pass);
string Con1 = Connectionstring.TrimEnd();
string User1 = EncryptionAndDecryption.Decrypt(ConnectionUserName);
string Pass1 = EncryptionAndDecryption.Decrypt(ConnectionPasswrod);
con = "Data Source=" + Con1.ToString() + ";Initial Catalog=DB_CORE;Network Library=DBMSSOCN;User ID=" + User1.ToString() + "; Password="******"";
con2 = "Data Source=" + Con1.ToString() + ";Initial Catalog=DB_CENTRAL;Network Library=DBMSSOCN;User ID=" + User1.ToString() + "; Password="******"";
con3 = "Data Source=" + Con1.ToString() + ";Initial Catalog=DB_INVENTORY;Network Library=DBMSSOCN;User ID=" + User1.ToString() + "; Password="******"";
return(con);
}
private void button1_Click(object sender, EventArgs e)
{
string fno;
string tono;
string date;
double amount;
fno = ftxt.Text;
tono = totxt.Text;
date = txtdate.Text;
amount = double.Parse(txtamount.Text);
string query = "update Accounts set Balance=Balance-'" + amount + "' where AccountNo='" + fno + "'";
string query1 = "update Accounts set Balance=Balance+'" + amount + "' where AccountNo='" + tono + "'";
string query2 = "INSERT into Transfers (F_Acc,To_Acc,Date,Amount) values ('" + fno + "','" + tono + "','" + date + "'," + amount + ")";
try
{
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int n = dcc.ExecuteSQL(query);
dcc.CloseConnection();
dcc.ConnectWithDB();
int n1 = dcc.ExecuteSQL(query1);
dcc.CloseConnection();
dcc.ConnectWithDB();
int n2 = dcc.ExecuteSQL(query2);
dcc.CloseConnection();
MessageBox.Show("Done");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void button8_Click(object sender, EventArgs e)
{
string query = "SELECT * from Accounts";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Account acc = new Account();
acc.AccountNo = sdr["AccountNo"].ToString();
acc.CustId = sdr["CustId"].ToString();
acc.AccountType = sdr["AccountType"].ToString();
acc.Description = sdr["Description"].ToString();
acc.Balance = Convert.ToInt32(sdr["Balance"]);
accList.Add(acc);
}
dcc.CloseConnection();
accTable.DataSource = accList;
}
private void AutoComplete()
{
studentSearchTB.AutoCompleteMode = AutoCompleteMode.Suggest;
studentSearchTB.AutoCompleteSource = AutoCompleteSource.CustomSource;
AutoCompleteStringCollection coll = new AutoCompleteStringCollection();
DatabaseConnectionClass dcc;
dcc = new DatabaseConnectionClass();
string query = "SELECT Id from Student";
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
firstName = sdr["Id"].ToString();
coll.Add(firstName);
}
dcc.CloseConnection();
studentSearchTB.AutoCompleteCustomSource = coll;
}
private void button8_Click(object sender, EventArgs e)
{
string query = "SELECT * from Transfers ";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Transfer tccc = new Transfer();
tccc.Tf_ID = Convert.ToInt32(sdr["Tf_Id"]);
tccc.F_Acc = sdr["F_Acc"].ToString();
tccc.To_Acc = sdr["To_Acc"].ToString();
tccc.Date = sdr["Date"].ToString();
tccc.Amount = Convert.ToDouble(sdr["Amount"]);
tcccList.Add(tccc);
}
dcc.CloseConnection();
tcccTable.DataSource = tcccList;
}
private void button8_Click(object sender, EventArgs e)
{
string query = "SELECT * from Transactions";
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
Transaction tcc = new Transaction();
tcc.Tx_ID = Convert.ToInt32(sdr["Tx_Id"]);
tcc.AccountNo = sdr["AccountNo"].ToString();
tcc.Date = sdr["Date"].ToString();
tcc.Balance = Convert.ToDouble(sdr["Balance"]);
tcc.Deposit = Convert.ToDouble(sdr["Deposit"]);
tccList.Add(tcc);
}
dcc.CloseConnection();
tccTable.DataSource = tccList;
}
public LoginForm()
{
InitializeComponent();
lr = new LoginRepo();
dcc = new DatabaseConnectionClass();
}
