public string ManageTransaction(int _RFPID, int _FROMLOCATION, int _TOLOCATION, int _VEHICLETYPEID, string _SERVICETYPE, decimal _CLEANSHEETRATE, decimal _CONTRACTRATE, decimal _SHIPXRATE, decimal _PVSRFPRATE, decimal _MARKETRATE, decimal _BAQUOTE, string _BACKHAULAVL, decimal _BACKHAULPERCENT, decimal _APPROVEDAMOUNT,
string _ACTIVE, int _CREATEDBY, string _CREATEDON, string _MODE)
{
using (BLManageRFPTransaction objbl = new BLManageRFPTransaction())
{
objbl._RFPID = Convert.ToInt32(_RFPID);
objbl._FROMLOCATION = Convert.ToInt32(_FROMLOCATION);
objbl._TOLOCATION = Convert.ToInt32(_TOLOCATION);
objbl._VEHICLETYPEID = Convert.ToInt32(_VEHICLETYPEID);
objbl._SERVICETYPE = _SERVICETYPE;
objbl._CLEANSHEETRATE = Convert.ToDecimal(_CLEANSHEETRATE);
objbl._CONTRACTRATE = Convert.ToDecimal(_CONTRACTRATE);
objbl._SHIPXRATE = Convert.ToDecimal(_SHIPXRATE);
objbl._PVSRFPRATE = Convert.ToDecimal(_PVSRFPRATE);
objbl._MARKETRATE = Convert.ToDecimal(_MARKETRATE);
objbl._BAQUOTE = Convert.ToDecimal(_BAQUOTE);
objbl._BACKHAULAVL = _BACKHAULAVL;
objbl._BACKHAULPERCENT = Convert.ToDecimal(_BACKHAULPERCENT);
objbl._APPROVEDAMOUNT = Convert.ToDecimal(_APPROVEDAMOUNT);
objbl._ACTIVE = _ACTIVE;
objbl._CREATEDBY = Convert.ToInt32(_CREATEDBY);
objbl._CREATEDON = _CREATEDON;
objbl._MODE = _MODE;
//==================
return(objbl.ManageTransaction());
//==================
}
}
public DataSet GetAllActiveManageTransaction(BLManageRFPTransaction obj)
{
string queryString = "CALL SP_MANAGERFPTRANSACTION(?_RFPID, ?_FROMLOCATION, ?_TOLOCATION, ?_VEHICLETYPEID, ?_SERVICETYPE, ?_CLEANSHEETRATE, ?_CONTRACTRATE, ?_SHIPXRATE, ?_PVSRFPRATE, ?_MARKETRATE, ?_BAQUOTE, ?_BACKHAULAVL, ?_BACKHAULPERCENT, ?_APPROVEDAMOUNT, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[18];
mySqlParam[0] = CreateParameters(DbType.Int32, obj._RFPID, "?_RFPID", ParameterDirection.Input);
mySqlParam[1] = CreateParameters(DbType.Int32, "", "?_FROMLOCATION", ParameterDirection.Input);
mySqlParam[2] = CreateParameters(DbType.Int32, "", "?_TOLOCATION", ParameterDirection.Input);
mySqlParam[3] = CreateParameters(DbType.Int32, "", "?_VEHICLETYPEID", ParameterDirection.Input);
mySqlParam[4] = CreateParameters(DbType.String, "", "?_SERVICETYPE", ParameterDirection.Input);
mySqlParam[5] = CreateParameters(DbType.Decimal, "", "?_CLEANSHEETRATE", ParameterDirection.Input);
mySqlParam[6] = CreateParameters(DbType.Decimal, "", "?_CONTRACTRATE", ParameterDirection.Input);
mySqlParam[7] = CreateParameters(DbType.Decimal, "", "?_SHIPXRATE", ParameterDirection.Input);
mySqlParam[8] = CreateParameters(DbType.Decimal, "", "?_PVSRFPRATE", ParameterDirection.Input);
mySqlParam[9] = CreateParameters(DbType.Decimal, "", "?_MARKETRATE", ParameterDirection.Input);
mySqlParam[10] = CreateParameters(DbType.String, "", "?_BACKHAULAVL", ParameterDirection.Input);
mySqlParam[11] = CreateParameters(DbType.Decimal, "", "?_BACKHAULPERCENT", ParameterDirection.Input);
mySqlParam[12] = CreateParameters(DbType.Decimal, "", "?_APPROVEDAMOUNT", ParameterDirection.Input);
mySqlParam[13] = CreateParameters(DbType.String, "", "?_ACTIVE", ParameterDirection.Input);
mySqlParam[14] = CreateParameters(DbType.Int32, "1", "?_CREATEDBY", ParameterDirection.Input);
mySqlParam[15] = CreateParameters(DbType.String, "1800-01-01", "?_CREATEDON", ParameterDirection.Input);
mySqlParam[16] = CreateParameters(DbType.String, obj._MODE, "?_MODE", ParameterDirection.Input);
DataSet _ds = (DataSet)MySqlHelper.ExecuteDataset(connectionString, queryString, mySqlParam);
return(_ds);
}
public string ManageTransaction(BLManageRFPTransaction obj)
{
string result = string.Empty;
if (obj._RFPID == null)
{
obj._RFPID = 0;
}
string queryString = "CALL SP_MANAGERFPTRANSACTION(?_RFPID, ?_FROMLOCATION, ?_TOLOCATION, ?_VEHICLETYPEID, ?_SERVICETYPE, ?_CLEANSHEETRATE, ?_CONTRACTRATE, ?_SHIPXRATE, ?_PVSRFPRATE, ?_MARKETRATE, ?_BAQUOTE, ?_BACKHAULAVL, ?_BACKHAULPERCENT, ?_APPROVEDAMOUNT, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[18];
mySqlParam[0] = CreateParameters(DbType.Int32, obj._RFPID, "?_RFPID", ParameterDirection.Input);
mySqlParam[1] = CreateParameters(DbType.Int32, obj._FROMLOCATION, "?_FROMLOCATION", ParameterDirection.Input);
mySqlParam[2] = CreateParameters(DbType.Int32, obj._TOLOCATION, "?_TOLOCATION", ParameterDirection.Input);
mySqlParam[3] = CreateParameters(DbType.Int32, obj._VEHICLETYPEID, "?_VEHICLETYPEID", ParameterDirection.Input);
mySqlParam[4] = CreateParameters(DbType.String, obj._SERVICETYPE, "?_SERVICETYPE", ParameterDirection.Input);
mySqlParam[5] = CreateParameters(DbType.Decimal, obj._CLEANSHEETRATE, "?_CLEANSHEETRATE", ParameterDirection.Input);
mySqlParam[6] = CreateParameters(DbType.Decimal, obj._CONTRACTRATE, "?_CONTRACTRATE", ParameterDirection.Input);
mySqlParam[7] = CreateParameters(DbType.Decimal, obj._SHIPXRATE, "?_SHIPXRATE", ParameterDirection.Input);
mySqlParam[8] = CreateParameters(DbType.Decimal, obj._PVSRFPRATE, "?_PVSRFPRATE", ParameterDirection.Input);
mySqlParam[9] = CreateParameters(DbType.Decimal, obj._MARKETRATE, "?_MARKETRATE", ParameterDirection.Input);
mySqlParam[10] = CreateParameters(DbType.Decimal, obj._BAQUOTE, "?_BAQUOTE", ParameterDirection.Input);
mySqlParam[11] = CreateParameters(DbType.String, obj._BACKHAULAVL, "?_BACKHAULAVL", ParameterDirection.Input);
mySqlParam[12] = CreateParameters(DbType.Decimal, obj._BACKHAULPERCENT, "?_BACKHAULPERCENT", ParameterDirection.Input);
mySqlParam[13] = CreateParameters(DbType.Decimal, obj._APPROVEDAMOUNT, "?_APPROVEDAMOUNT", ParameterDirection.Input);
mySqlParam[14] = CreateParameters(DbType.String, obj._ACTIVE, "?_ACTIVE", ParameterDirection.Input);
mySqlParam[15] = CreateParameters(DbType.Int32, obj._CREATEDBY, "?_CREATEDBY", ParameterDirection.Input);
mySqlParam[16] = CreateParameters(DbType.String, obj._CREATEDON, "?_CREATEDON", ParameterDirection.Input);
mySqlParam[17] = CreateParameters(DbType.String, obj._MODE, "?_MODE", ParameterDirection.Input);
return((string)MySqlHelper.ExecuteScalar(connectionString, queryString, mySqlParam));
}
public GetManageTransaction[] GetManageTransaction(int _RFPID, int _FROMLOCATION, int _TOLOCATION, int _VEHICLETYPEID, string _SERVICETYPE, decimal _CLEANSHEETRATE, decimal _CONTRACTRATE, decimal _SHIPXRATE, decimal _PVSRFPRATE, decimal _MARKETRATE, decimal _BAQUOTE, string _BACKHAULAVL, decimal _BACKHAULPERCENT, decimal _APPROVEDAMOUNT,
string _ACTIVE, int _CREATEDBY, string _CREATEDON, string _MODE)
{
List <GetManageTransaction> returnObj = new List <GetManageTransaction>();
using (BLManageRFPTransaction obj = new BLManageRFPTransaction())
{
//============
obj._RFPID = _RFPID;
obj._FROMLOCATION = _FROMLOCATION;
obj._TOLOCATION = _TOLOCATION;
obj._VEHICLETYPEID = _VEHICLETYPEID;
obj._SERVICETYPE = _SERVICETYPE;
obj._CLEANSHEETRATE = _CLEANSHEETRATE;
obj._CONTRACTRATE = _CONTRACTRATE;
obj._SHIPXRATE = _SHIPXRATE;
obj._PVSRFPRATE = _PVSRFPRATE;
obj._MARKETRATE = _MARKETRATE;
obj._BAQUOTE = _BAQUOTE;
obj._BACKHAULAVL = _BACKHAULAVL;
obj._BACKHAULPERCENT = _BACKHAULPERCENT;
obj._APPROVEDAMOUNT = _APPROVEDAMOUNT;
obj._ACTIVE = _ACTIVE;
obj._MODE = _MODE;
//============
DataSet ds = obj.GetManageTransaction();
//============
foreach (DataRow item in ds.Tables[0].Rows)
{
returnObj.Add(new GetManageTransaction()
{
RFPID = Convert.ToInt32(item["RFPID"]),
FROMLOCATION = Convert.ToInt32(item["FROMLOCATION"]),
TOLOCATION = Convert.ToInt32(item["TOLOCATION"]),
VEHICLETYPEID = Convert.ToInt32(item["VEHICLETYPEID"]),
SERVICETYPE = Convert.ToString(item["SERVICETYPE"]),
CLEANSHEETRATE = Convert.ToDecimal(item["CLEANSHEETRATE"]),
CONTRACTRATE = Convert.ToDecimal(item["CONTRACTRATE"]),
SHIPXRATE = Convert.ToDecimal(item["SHIPXRATE"]),
PVSRFPRATE = Convert.ToDecimal(item["PVSRFPRATE"]),
MARKETRATE = Convert.ToDecimal(item["MARKETRATE"]),
BAQUOTE = Convert.ToDecimal(item["BAQUOTE"]),
BACKHAULAVL = Convert.ToString(item["BACKHAULAVL"]),
BACKHAULPERCENT = Convert.ToDecimal(item["BACKHAULPERCENT"]),
APPROVEDAMOUNT = Convert.ToDecimal(item["APPROVEDAMOUNT"]),
ACTIVE = Convert.ToString(item["ACTIVE"]),
});
}
}
return(returnObj.ToArray());
}
public DataSet GetManageTransaction(BLManageRFPTransaction obj)
{
if (obj._MODE == "BYRFPID")
{
return(GetManageTransactionBYRFPID(obj));
}
else if (obj._MODE == "GETALL")
{
return(GetAllActiveManageTransaction(obj));
}
else
{
return(SearchManageTransaction(obj));
}
}
