public GetLocation[] GetLocations(int _LOCATIONID, string _LOCATIONCODE, string _LOCATIONNAME,
string _ACTIVE, int _CREATEDBY, string _CREATEDON, string _MODE)
{
List <GetLocation> returnObj = new List <GetLocation>();
using (BLLocation obj = new BLLocation())
{
//============
obj._LOCATIONID = _LOCATIONID;
obj._LOCATIONCODE = _LOCATIONCODE;
obj._LOCATIONNAME = _LOCATIONNAME;
obj._ACTIVE = _ACTIVE;
obj._CREATEDBY = _CREATEDBY;
obj._CREATEDON = _CREATEDON;
obj._MODE = _MODE;
//============
DataSet ds = obj.GetLocations();
//============
foreach (DataRow item in ds.Tables[0].Rows)
{
returnObj.Add(new GetLocation()
{
LOCATIONID = Convert.ToInt32(item["LOCATIONID"]),
LOCATIONCODE = Convert.ToString(item["LOCATIONCODE"]),
LOCATIONNAME = Convert.ToString(item["LOCATIONNAME"]),
ACTIVE = Convert.ToString(item["ACTIVE"]),
});
}
}
return(returnObj.ToArray());
}
public DataSet GetLocations(BLLocation obj)
{
if (obj._MODE == "BYLOCATIONID")
{
return(GetLocationByLocationID(obj));
}
else if (obj._MODE == "GETALL")
{
return(GetAllActiveLocations(obj));
}
else
{
return(SearchLocation(obj));
}
}
public string ManageLocations(int _LOCATIONID, string _LOCATIONCODE, string _LOCATIONNAME,
string _ACTIVE, int _CREATEDBY, string _CREATEDON, string _MODE)
{
using (BLLocation objbl = new BLLocation())
{
objbl._LOCATIONID = Convert.ToInt32(_LOCATIONID);
objbl._LOCATIONCODE = _LOCATIONCODE;
objbl._LOCATIONNAME = _LOCATIONNAME;
objbl._ACTIVE = _ACTIVE;
objbl._CREATEDBY = Convert.ToInt32(_CREATEDBY);
objbl._CREATEDON = _CREATEDON;
objbl._MODE = _MODE;
//==================
return(objbl.ManageLocations());
//==================
}
}
public DataSet SearchLocation(BLLocation obj)
{
string queryString = "CALL SP_MANAGELOCATION(?_LOCATIONID, ?_LOCATIONCODE, ?_LOCATIONNAME, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[7];
mySqlParam[0] = CreateParameters(DbType.Int32, obj._LOCATIONID, "?_LOCATIONID", ParameterDirection.Input);
mySqlParam[1] = CreateParameters(DbType.String, obj._LOCATIONCODE, "?_LOCATIONCODE", ParameterDirection.Input);
mySqlParam[2] = CreateParameters(DbType.String, obj._LOCATIONNAME, "?_LOCATIONNAME", 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._CREATEDON, "?_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 ManageLocations(BLLocation obj)
{
string result = string.Empty;
if (obj._LOCATIONID == null)
{
obj._LOCATIONID = 0;
}
string queryString = "CALL SP_MANAGELOCATION(?_LOCATIONID, ?_LOCATIONCODE, ?_LOCATIONNAME, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[7];
mySqlParam[0] = CreateParameters(DbType.Int32, obj._LOCATIONID, "?_LOCATIONID", ParameterDirection.Input);
mySqlParam[1] = CreateParameters(DbType.String, obj._LOCATIONCODE, "?_LOCATIONCODE", ParameterDirection.Input);
mySqlParam[2] = CreateParameters(DbType.String, obj._LOCATIONNAME, "?_LOCATIONNAME", 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.String, obj._CREATEDON, "?_CREATEDON", ParameterDirection.Input);
mySqlParam[6] = CreateParameters(DbType.String, obj._MODE, "?_MODE", ParameterDirection.Input);
return((string)MySqlHelper.ExecuteScalar(connectionString, queryString, mySqlParam));
}
