public bool ChanegeUserPasswod_DBH(string un, string oldpass, string newpass)
{
bool ret = false;
ret = this.Execute_Insert(MyQueryBuilder.ChangePassword(un, oldpass, newpass));
return(ret);
}
} // Add_SalesMan_Force(string un, string pas)
public bool Add_Rates_ToDB(String frm, String to, float rate, uint collectid)
{
String st = MyQueryBuilder.Insert_Rate(++Rate_ID, frm, to,
collectid, rate);
//MessageBox.Show("Insert :" + st); //--
return(Execute_Insert(st));
}
} // Add_SalesMan(string un, string pas)
private bool Add_SalesMan_Force(string un, string pas)
{
bool ret = false;
if (Execute_Insert(MyQueryBuilder.Insert_Salesman(un, pas)))
{
ret = true;
}
return(ret);
} // Add_SalesMan_Force(string un, string pas)
private bool Add_Customer_Force(string name, string cnic, string cell)
{
bool ret = false;
int id = int.Parse((++Customer_ID) + "");
if (Execute_Insert(MyQueryBuilder.Insert_Customer(id, name, cnic, cell)))
{
ret = true;
}
return(ret);
} // Add_Customer_Force(string name, string cnic, string cell)
} // Valid_SalesMan(string un, string pas)
public bool SalesMan_Exist(string un)
{
bool ret = false;
OracleDataReader odr;
odr = Execute_Query(MyQueryBuilder.Select_Salesman_Only(un));
if (odr.Read() && odr.GetOracleValue(0).ToString().Equals(un))
{
ret = true;
}
return(ret);
} // SalesMan_Exist(string un)
} // Execute_Insert(string st)
public bool Valid_SalesMan(string un, string pas)
{
bool ret = false;
OracleDataReader odr;
odr = Execute_Query(MyQueryBuilder.Select_Salesman_Pass(un, pas));
if (odr.Read() && odr.GetOracleValue(0).ToString().Equals(un))
{
ret = true;
}
return(ret);
} // Valid_SalesMan(string un, string pas)
public DataSet GetCurrSaleReports(String cur, DateTime fm, DateTime to)
{
OracleCommand ocmd;
OracleDataAdapter adp;
DataSet ds = new DataSet();
String temp = "";
try
{
ocmd = oracleconnection.CreateCommand();
temp = MyQueryBuilder.CurrSaleReport(cur,
MyDateTimeFormatter.Convert_To_OracleDate(fm), MyDateTimeFormatter.Convert_To_OracleDate(to));
/* //----//
* TextBoxForm tbf = new TextBoxForm();
* tbf.textBox1.Text = temp;
* tbf.Show();
* MessageBox.Show("Temp:\n" + temp);
* // */
ocmd.CommandText = temp;
adp = new OracleDataAdapter(ocmd);
adp.Fill(ds);
}
catch (InvalidOperationException ex)
{
MessageBox.Show("InvalidOperationException in " +
"\nMoney_Exchanger_Owner_Side-DBHandling-GetCurrSaleReports(" + cur + ")\n" +
ex.Message);
ds.Clear();
}
catch (OracleException ex)
{
MessageBox.Show("OracleException in " +
"\nMoney_Exchanger_Owner_Side-DBHandling-GetCurrSaleReports(" + cur + ")\n" +
ex.Message);
ds.Clear();
}
catch (SystemException ex)
{
MessageBox.Show("Exception in "
+ "\nMoney_Exchanger_Owner_Side-DBHandling-GetCurrSaleReports(" + cur + ")\n" +
ex.Message);
ds.Clear();
}
return(ds);
}
} // Add_Customer_Force(string name, string cnic, string cell)
public int Customer_Exist(string cnic)
{
int ret = -1;
OracleDataReader odr;
try
{
odr = Execute_Query(MyQueryBuilder.Select_CustomerID_Only(cnic));
if (odr.Read())
{
ret = int.Parse(odr.GetOracleValue(0).ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("DBHandling.Customer_Exist():" + ex.Message);
ret = -1;
}
return(ret);
} // SalesMan_Exist(string un)
} // eof public DataSet GetCurrRates
public int RateID(string cur, bool by, float rate)
{
int id = -1;
OracleDataReader odr;
try
{
odr = this.Execute_Query(MyQueryBuilder.Query_RateID(cur, by, rate));
if (odr.Read())
{
id = int.Parse(odr.GetOracleValue(0).ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("DBHandling.RateID():" + ex.Message);
id = -1;
}
return(id);
}
} // SalesMan_Exist(string un)
public int Exchange(string operat, int cust_id, int rates_id, float exchanges_amount)
{
int id = -1;
string query = "";
try
{
id = int.Parse((++Exchange_ID) + "");
query = MyQueryBuilder.Insert_Exchange(id, cust_id, rates_id, operat,
exchanges_amount, MyDateTimeFormatter.Convert_To_OracleDate(DateTime.Now));
if (!this.Execute_Insert(query))
{
id = -1;
}
}
catch (Exception ex)
{
MessageBox.Show("DBHandling.Exchange():" + ex.Message);
id = -1;
}
return(id);
}
public DataSet GetSalesManReportDBH(String salesman, DateTime fm, DateTime to)
{
OracleCommand ocmd;
OracleDataAdapter adp;
DataSet ds = new DataSet();
String temp = "";
try
{
ocmd = oracleconnection.CreateCommand();
temp = MyQueryBuilder.SalesManReport(salesman,
MyDateTimeFormatter.Convert_To_OracleDate(fm), MyDateTimeFormatter.Convert_To_OracleDate(to));
ocmd.CommandText = temp;
adp = new OracleDataAdapter(ocmd);
adp.Fill(ds);
}
catch (InvalidOperationException ex)
{
MessageBox.Show("InvalidOperationException in " +
"\nMoney_Exchanger_Owner_Side-DBHandling-GetSalesManReportDBH\n" +
ex.Message);
ds.Clear();
}
catch (OracleException ex)
{
MessageBox.Show("OracleException in " +
"\nMoney_Exchanger_Owner_Side-DBHandling-GetSalesManReportDBH\n" +
ex.Message);
ds.Clear();
}
catch (SystemException ex)
{
MessageBox.Show("Exception in "
+ "\nMoney_Exchanger_Owner_Side-DBHandling-GetSalesManReportDBH\n" +
ex.Message);
ds.Clear();
}
return(ds);
}
} // SalesMan_Exist(string un)
public bool Add_SalesMan(string un, string pas)
{
OracleDataReader odr;
bool ret = false;
try
{
if (!SalesMan_Exist(un))
{
Add_SalesMan_Force(un, pas);
}
odr = Execute_Query("" + MyQueryBuilder.Select_Salesman_Pass(un, pas));
if (odr.Read() && odr.GetOracleValue(0).ToString().Equals(un))
{
ret = true;
}
}
catch (OracleException ex)
{
return(ret);
}
return(ret);
} // Add_SalesMan(string un, string pas)
public DataSet GetCurrRates(String cur)
{
OracleCommand ocmd;
OracleDataAdapter adp;
DataSet ds = new DataSet();
try
{
ocmd = oracleconnection.CreateCommand();
ocmd.CommandText = "" + MyQueryBuilder.Query_Currency_Buy_Sell(cur, Collections_ID);
adp = new OracleDataAdapter(ocmd);
adp.Fill(ds);
}
catch (InvalidOperationException ex)
{
MessageBox.Show("InvalidOperationException in " +
"\nMoney_Exchanger_Server_Side-DBHandling-GetCurrRates(" + cur + ")\n" +
ex.Message);
ds.Clear();
}
catch (OracleException ex)
{
MessageBox.Show("OracleException in " +
"\nMoney_Exchanger_Server_Side-DBHandling-GetCurrRates(" + cur + ")\n" +
ex.Message);
ds.Clear();
}
catch (SystemException ex)
{
MessageBox.Show("Exception in "
+ "\nMoney_Exchanger_Server_Side-DBHandling-GetCurrRates(" + cur + ")\n" +
ex.Message);
ds.Clear();
}
return(ds);
} // eof public DataSet GetCurrRates