public string ManageRFPDetails(int _RFPID, int _FROMLOCATION, int _TOLOCATION, int _VEHICLETYPEID, decimal _APPROVEDAMOUNT, string _SERVICETYPE,
decimal _RFPVOLUME, decimal _RFPDURATION,
string _ACTIVE, int _CREATEDBY, DateTime _CREATEDON, string _SEARCH1, string _SEARCH2, string _SEARCH3, string _MODE)
{
using (BLRFPDetail objbl = new BLRFPDetail())
{
objbl._RFPID = Convert.ToInt32(_RFPID);
objbl._FROMLOCATION = Convert.ToInt32(_FROMLOCATION);
objbl._TOLOCATION = Convert.ToInt32(_TOLOCATION);
objbl._VEHICLETYPEID = Convert.ToInt32(_VEHICLETYPEID);
objbl._APPROVEDAMOUNT = Convert.ToDecimal(_APPROVEDAMOUNT);
objbl._SERVICETYPE = Convert.ToString(_SERVICETYPE);
objbl._RFPVOLUME = Convert.ToDecimal(_RFPVOLUME);
objbl._RFPDURATION = Convert.ToDecimal(_RFPDURATION);
objbl._ACTIVE = _ACTIVE;
objbl._CREATEDBY = Convert.ToInt32(_CREATEDBY);
objbl._CREATEDONDATE = Convert.ToDateTime(_CREATEDON);
objbl._SEARCH1 = _SEARCH1;
objbl._SEARCH2 = _SEARCH2;
objbl._SEARCH3 = _SEARCH3;
objbl._MODE = _MODE;
//==================
return(objbl.ManageRFPDetails());
//==================
}
}
public DataSet GetRFPDetailByRFPID(BLRFPDetail obj)
{
string queryString = "CALL SP_MANAGERFPDETAIL(?_RFPID, ?_FROMLOCATION, ?_TOLOCATION, ?_VEHICLETYPEID, ?_APPROVEDAMOUNT, ?_SERVICETYPE, ?_RFPVOLUME, ?_RFPDURATION, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_SEARCH1, ?_SEARCH2, ?_SEARCH3, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[15];
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.Decimal, obj._APPROVEDAMOUNT, "?_APPROVEDAMOUNT", ParameterDirection.Input);
mySqlParam[5] = CreateParameters(DbType.String, obj._SERVICETYPE, "?_SERVICETYPE", ParameterDirection.Input);
mySqlParam[6] = CreateParameters(DbType.Decimal, obj._RFPVOLUME, "?_RFPVOLUME", ParameterDirection.Input);
mySqlParam[7] = CreateParameters(DbType.Decimal, obj._RFPDURATION, "?_RFPDURATION", ParameterDirection.Input);
mySqlParam[8] = CreateParameters(DbType.String, obj._ACTIVE, "?_ACTIVE", ParameterDirection.Input);
mySqlParam[9] = CreateParameters(DbType.Int32, obj._CREATEDBY, "?_CREATEDBY", ParameterDirection.Input);
mySqlParam[10] = CreateParameters(DbType.Date, obj._CREATEDONDATE, "?_CREATEDON", ParameterDirection.Input);
mySqlParam[11] = CreateParameters(DbType.String, obj._SEARCH1, "?_SEARCH1", ParameterDirection.Input);
mySqlParam[12] = CreateParameters(DbType.String, obj._SEARCH2, "?_SEARCH2", ParameterDirection.Input);
mySqlParam[13] = CreateParameters(DbType.String, obj._SEARCH3, "?_SEARCH3", ParameterDirection.Input);
mySqlParam[14] = CreateParameters(DbType.String, obj._MODE, "?_MODE", ParameterDirection.Input);
DataSet _ds = (DataSet)MySqlHelper.ExecuteDataset(connectionString, queryString, mySqlParam);
return(_ds);
}
public string ManageRFPDetails(BLRFPDetail obj)
{
string result = string.Empty;
if (obj._RFPID == null)
{
obj._RFPID = 0;
}
string queryString = "CALL SP_MANAGERFPDETAIL(?_RFPID, ?_FROMLOCATION, ?_TOLOCATION, ?_VEHICLETYPEID, ?_APPROVEDAMOUNT, ?_SERVICETYPE, ?_RFPVOLUME, ?_RFPDURATION, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_SEARCH1, ?_SEARCH2, ?_SEARCH3, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[15];
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.Decimal, obj._APPROVEDAMOUNT, "?_APPROVEDAMOUNT", ParameterDirection.Input);
mySqlParam[5] = CreateParameters(DbType.String, obj._SERVICETYPE, "?_SERVICETYPE", ParameterDirection.Input);
mySqlParam[6] = CreateParameters(DbType.Decimal, obj._RFPVOLUME, "?_RFPVOLUME", ParameterDirection.Input);
mySqlParam[7] = CreateParameters(DbType.Decimal, obj._RFPDURATION, "?_RFPDURATION", ParameterDirection.Input);
mySqlParam[8] = CreateParameters(DbType.String, obj._ACTIVE, "?_ACTIVE", ParameterDirection.Input);
mySqlParam[9] = CreateParameters(DbType.Int32, obj._CREATEDBY, "?_CREATEDBY", ParameterDirection.Input);
mySqlParam[10] = CreateParameters(DbType.Date, obj._CREATEDONDATE, "?_CREATEDON", ParameterDirection.Input);
mySqlParam[11] = CreateParameters(DbType.String, obj._SEARCH1, "?_SEARCH1", ParameterDirection.Input);
mySqlParam[12] = CreateParameters(DbType.String, obj._SEARCH2, "?_SEARCH2", ParameterDirection.Input);
mySqlParam[13] = CreateParameters(DbType.String, obj._SEARCH3, "?_SEARCH3", ParameterDirection.Input);
mySqlParam[14] = CreateParameters(DbType.String, obj._MODE, "?_MODE", ParameterDirection.Input);
return((string)MySqlHelper.ExecuteScalar(connectionString, queryString, mySqlParam));
}
public GetRFPDetail[] GetRFPDetails(int _RFPID, int _FROMLOCATION, int _TOLOCATION, int _VEHICLETYPEID, decimal _APPROVEDAMOUNT, string _SERVICETYPE,
decimal _RFPVOLUME, decimal _RFPDURATION,
string _ACTIVE, int _CREATEDBY, DateTime _CREATEDON, string _SEARCH1, string _SEARCH2, string _SEARCH3, string _MODE)
{
List <GetRFPDetail> returnObj = new List <GetRFPDetail>();
using (BLRFPDetail obj = new BLRFPDetail())
{
//============
obj._RFPID = _RFPID;
obj._FROMLOCATION = _FROMLOCATION;
obj._TOLOCATION = _TOLOCATION;
obj._VEHICLETYPEID = _VEHICLETYPEID;
obj._APPROVEDAMOUNT = _APPROVEDAMOUNT;
obj._SERVICETYPE = _SERVICETYPE;
obj._RFPVOLUME = _RFPVOLUME;
obj._RFPDURATION = _RFPDURATION;
obj._ACTIVE = _ACTIVE;
obj._CREATEDBY = _CREATEDBY;
obj._CREATEDONDATE = _CREATEDON;
obj._SEARCH1 = _SEARCH1;
obj._SEARCH2 = _SEARCH2;
obj._SEARCH3 = _SEARCH3;
obj._MODE = _MODE;
//============
DataSet ds = obj.GetRFPDetails();
//============
foreach (DataRow item in ds.Tables[0].Rows)
{
returnObj.Add(new GetRFPDetail()
{
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"]),
APPROVEDAMOUNT = Convert.ToDecimal(item["APPROVEDAMOUNT"]),
ACTIVE = Convert.ToString(item["ACTIVE"]),
//LOCATIONNAME = Convert.ToString(item["LOCATIONNAME"]),
FROMLOCATIONNAME = Convert.ToString(item["FROMLOCATIONNAME"]),
TOLOCATIONNAME = Convert.ToString(item["TOLOCATIONNAME"]),
RFPVOLUME = Convert.ToDecimal(item["RFPVOLUME"]),
RFPDURATION = Convert.ToDecimal(item["RFPDURATION"]),
VEHICLETYPENAME = Convert.ToString(item["VEHICLETYPENAME"]),
});
}
}
return(returnObj.ToArray());
}
public DataSet GetRFPDetails(BLRFPDetail obj)
{
return(GetRFPDetailByRFPID(obj));
}
