public DataSet GetStates(BLState obj)
{
if (obj._MODE == "BYSTATEID")
{
return(GetStateByStateID(obj));
}
else if (obj._MODE == "GETALL")
{
return(GetAllActiveStates(obj));
}
else
{
return(SearchStates(obj));
}
}
public DataSet SearchStates(BLState obj)
{
string queryString = "CALL SP_MANAGEState(?_STATEID, ?_STATECODE, ?_STATENAME, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[7];
mySqlParam[0] = CreateParameters(DbType.Int32, obj._STATEID, "?_STATEID", ParameterDirection.Input);
mySqlParam[1] = CreateParameters(DbType.String, obj._STATECODE, "?_STATECODE", ParameterDirection.Input);
mySqlParam[2] = CreateParameters(DbType.String, obj._STATENAME, "?_STATENAME", 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 ManageStates(BLState obj)
{
string result = string.Empty;
string queryString = "CALL SP_MANAGESTATE(?_STATEID, ?_STATECODE, ?_STATENAME, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[7];
mySqlParam[0] = CreateParameters(DbType.Int32, obj._STATEID, "?_STATEID", ParameterDirection.Input);
mySqlParam[1] = CreateParameters(DbType.String, obj._STATECODE, "?_STATECODE", ParameterDirection.Input);
mySqlParam[2] = CreateParameters(DbType.String, obj._STATENAME, "?_STATENAME", 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);
return((string)MySqlHelper.ExecuteScalar(connectionString, queryString, mySqlParam));
}
