private static int get_id(string acct_num, string table_name)
{
int var_id = 0;
OleDbConnection con = new OleDbConnection(); //Initialize OleDBConnection
Conf.conf dbcon;
con = new OleDbConnection();
dbcon = new Conf.conf();
con.ConnectionString = dbcon.getConnectionString();
try
{
//OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\PC-23\Desktop\TVVS.accdb; Persist Security Info=False;");
con.Open();
string cmd = "SELECT * FROM " + table_name + " where acct_num = '" + acct_num + "'";
{
OleDbCommand command = new OleDbCommand(cmd, con);
OleDbDataReader rdr = command.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
var_id = Convert.ToInt32(rdr.GetValue(0).ToString());
}
}
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(var_id);
}
private static string items_counter(string table_name)
{
string items = "";
OleDbConnection con = new OleDbConnection(); //Initialize OleDBConnection
Conf.conf dbcon;
con = new OleDbConnection();
dbcon = new Conf.conf();
con.ConnectionString = dbcon.getConnectionString();
try
{
//OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\PC-23\Desktop\TVVS.accdb; Persist Security Info=False;");
//Matched.conString();
con.Open();
string cmd = "SELECT COUNT(acct_name) FROM " + table_name + " where match_code <> 'U'";
{
OleDbCommand command = new OleDbCommand(cmd, con);
OleDbDataReader rdr = command.ExecuteReader();
rdr.Read();
items = rdr.GetValue(0).ToString();
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(items);
}
private static string amount_sum(string table_name)
{
string amount = "";
OleDbConnection con = new OleDbConnection(); //Initialize OleDBConnection
Conf.conf dbcon;
con = new OleDbConnection();
dbcon = new Conf.conf();
con.ConnectionString = dbcon.getConnectionString();
try
{
//OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\PC-23\Desktop\TVVS.accdb; Persist Security Info=False;");
//conString();
con.Open();
string cmd = "SELECT sum(amount) FROM " + table_name + " where match_code = 'U'";
{
OleDbCommand command = new OleDbCommand(cmd, con);
OleDbDataReader rdr = command.ExecuteReader();
rdr.Read();
{
amount = String.Format("{0:n}", Double.Parse(rdr.GetValue(0).ToString()));
}
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(amount);
}
private void conString()
{
con = new OleDbConnection();
dbcon = new Conf.conf();
con.ConnectionString = dbcon.getConnectionString();
}