public uint GetNewCollectionID()
{
uint temp = ++Collections_ID;
Execute_Insert("insert into collections(collect_id,collect_time) values (" +
temp + ",to_date('" +
MyDateTimeFormatter.Convert_To_OracleDate(DateTime.Now) + "','dd/mm/yyyy hh24:mi:ss') )");
return(temp);
}
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);
}
} // 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);
}
