public GetVehicletype[] GetVehicletypes(int _VEHICLETYPEID, string _VEHICLETYPECODE, string _VEHICLETYPENAME, string _ACTIVE, int _CREATEDBY, DateTime _CREATEDON, string _MODE)
{
List <GetVehicletype> returnObj = new List <GetVehicletype>();
using (BLVehicletype obj = new BLVehicletype())
{
//============
obj._VEHICLETYPEID = _VEHICLETYPEID;
obj._VEHICLETYPECODE = _VEHICLETYPECODE;
obj._VEHICLETYPENAME = _VEHICLETYPENAME;
obj._ACTIVE = _ACTIVE;
obj._CREATEDBY = _CREATEDBY;
obj._CREATEDONDATE = _CREATEDON;
obj._MODE = _MODE;
//============
DataSet ds = obj.GetVehicletypes();
//============
if (ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
returnObj.Add(new GetVehicletype()
{
VEHICLETYPEID = Convert.ToInt32(item["VEHICLETYPEID"]),
VEHICLETYPECODE = Convert.ToString(item["VEHICLETYPECODE"]),
VEHICLETYPENAME = Convert.ToString(item["VEHICLETYPENAME"]),
ACTIVE = Convert.ToString(item["ACTIVE"]),
});
}
}
}
return(returnObj.ToArray());
}
public DataSet GetVehicletypes(BLVehicletype obj)
{
if (obj._MODE == "BYVEHICLETYPEID")
{
return(GetVehicletypeByVehicletypeID(obj));
}
else if (obj._MODE == "GETALL")
{
return(GetAllActiveVehicletypes(obj));
}
else
{
return(SearchVehicletypes(obj));
}
}
public string ManageVehicletypes(int _VEHICLETYPEID, string _VEHICLETYPECODE, string _VEHICLETYPENAME, string _ACTIVE, int _CREATEDBY, DateTime _CREATEDON, string _MODE)
{
using (BLVehicletype objbl = new BLVehicletype())
{
objbl._VEHICLETYPEID = Convert.ToInt32(_VEHICLETYPEID);
objbl._VEHICLETYPECODE = Convert.ToString(_VEHICLETYPECODE);
objbl._VEHICLETYPENAME = _VEHICLETYPENAME;
objbl._ACTIVE = _ACTIVE;
objbl._CREATEDBY = Convert.ToInt32(_CREATEDBY);
objbl._CREATEDONDATE = Convert.ToDateTime(_CREATEDON);
objbl._MODE = _MODE;
//==================
return(objbl.ManageVehicletypes());
//==================
}
}
public DataSet SearchVehicletypes(BLVehicletype obj)
{
string queryString = "CALL SP_MANAGEVEHICLETYPE(?_VEHICLETYPEID, ?_VEHICLETYPECODE, ?_VEHICLETYPENAME, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[7];
mySqlParam[0] = CreateParameters(DbType.Int32, obj._VEHICLETYPEID, "?_VEHICLETYPEID", ParameterDirection.Input);
mySqlParam[1] = CreateParameters(DbType.String, obj._VEHICLETYPECODE, "?_VEHICLETYPECODE", ParameterDirection.Input);
mySqlParam[2] = CreateParameters(DbType.String, obj._VEHICLETYPENAME, "?_VEHICLETYPENAME", ParameterDirection.Input);
mySqlParam[3] = CreateParameters(DbType.String, obj._ACTIVE, "?_ACTIVE", ParameterDirection.Input);
mySqlParam[4] = CreateParameters(DbType.Int32, obj._CREATEDBY, "?_CREATEDBY", ParameterDirection.Input);
mySqlParam[5] = CreateParameters(DbType.DateTime, obj._CREATEDONDATE, "?_CREATEDON", ParameterDirection.Input);
mySqlParam[6] = CreateParameters(DbType.String, obj._MODE, "?_MODE", ParameterDirection.Input);
DataSet _ds = (DataSet)MySqlHelper.ExecuteDataset(connectionString, queryString, mySqlParam);
return(_ds);
}
public string ManageVehicletypes(BLVehicletype obj)
{
string result = string.Empty;
string queryString = "CALL SP_MANAGEVEHICLETYPE(?_VEHICLETYPEID, ?_VEHICLETYPECODE, ?_VEHICLETYPENAME, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[7];
mySqlParam[0] = CreateParameters(DbType.Int32, obj._VEHICLETYPEID, "?_VEHICLETYPEID", ParameterDirection.Input);
mySqlParam[1] = CreateParameters(DbType.String, obj._VEHICLETYPECODE, "?_VEHICLETYPECODE", ParameterDirection.Input);
mySqlParam[2] = CreateParameters(DbType.String, obj._VEHICLETYPENAME, "?_VEHICLETYPENAME", ParameterDirection.Input);
mySqlParam[3] = CreateParameters(DbType.String, obj._ACTIVE, "?_ACTIVE", ParameterDirection.Input);
mySqlParam[4] = CreateParameters(DbType.Int32, obj._CREATEDBY, "?_CREATEDBY", ParameterDirection.Input);
mySqlParam[5] = CreateParameters(DbType.DateTime, obj._CREATEDONDATE, "?_CREATEDON", ParameterDirection.Input);
mySqlParam[6] = CreateParameters(DbType.String, obj._MODE, "?_MODE", ParameterDirection.Input);
return((string)MySqlHelper.ExecuteScalar(connectionString, queryString, mySqlParam));
}
