public Boolean IfExists(params String[] args)
{
Boolean result = false;
using (MySqlConnection myCon = new MySqlConnection(connString))
{
myCommand = new MySqlCommand();
myCommand.Connection = myCon;
myCommand.Connection.Open();
using (SelectingCommand SelCmd = new SelectingCommand(myCommand))
{
result = SelCmd.GetFIOCheck(args[0], args[1], args[2]);
}
myCommand.Connection.Close();
return result;
}
}
/* */
public DataTable SelectInformation(params Object[] args)
{
DataTable result = null;
using (MySqlConnection myCon = new MySqlConnection(connString))
{
myCommand = new MySqlCommand();
myCommand.Connection = myCon;
myCommand.Connection.Open();
using (SelectingCommand SelCmd = new SelectingCommand(myCommand))
{
switch (args.Length)
{
case 0:
result = SelCmd.GetReqInfo();
break;
case 1:
result = SelCmd.GetReqInfo((int)args[0]);
break;
case 2:
case 3:
result = SelCmd.GetReqInfo((String)args[0], (String)args[1], (String)args[2]);
break;
}
}
myCommand.Connection.Close();
}
return result;
}
public DataTable SelectLastAgreement()
{
DataTable result = null;
using (MySqlConnection myCon = new MySqlConnection(connString))
{
myCommand = new MySqlCommand();
myCommand.Connection = myCon;
myCommand.Connection.Open();
using (SelectingCommand SelCmd = new SelectingCommand(myCommand))
{
result = SelCmd.GetLastAgreement();
}
myCommand.Connection.Close();
}
return result;
}
public DataTable SelectDepoInfo(params Int32[] info)
{
DataTable result = null;
using (MySqlConnection myCon = new MySqlConnection(connString))
{
myCommand = new MySqlCommand();
myCommand.Connection = myCon;
myCommand.Connection.Open();
using (SelectingCommand SelCmd = new SelectingCommand(myCommand))
{
result = SelCmd.GetDepoInfo(info);
}
myCommand.Connection.Close();
}
return result;
}