public GetIndustryType[] GetIndustryTypes(int _INDUSTRYTYPEID, string _INDUSTRYTYPECODE, string _INDUSTRYTYPENAME,
string _ACTIVE, int _CREATEDBY, string _CREATEDON, string _MODE)
{
List <GetIndustryType> returnObj = new List <GetIndustryType>();
using (BLIndustryType obj = new BLIndustryType())
{
//============
obj._INDUSTRYTYPEID = _INDUSTRYTYPEID;
obj._INDUSTRYTYPECODE = _INDUSTRYTYPECODE;
obj._INDUSTRYTYPENAME = _INDUSTRYTYPENAME;
obj._ACTIVE = _ACTIVE;
obj._CREATEDBY = _CREATEDBY;
obj._CREATEDON = _CREATEDON;
obj._MODE = _MODE;
//============
DataSet ds = obj.GetIndustryTypes();
//============
foreach (DataRow item in ds.Tables[0].Rows)
{
returnObj.Add(new GetIndustryType()
{
INDUSTRYTYPEID = Convert.ToInt32(item["INDUSTRYTYPEID"]),
INDUSTRYTYPECODE = Convert.ToString(item["INDUSTRYTYPECODE"]),
INDUSTRYTYPENAME = Convert.ToString(item["INDUSTRYTYPENAME"]),
ACTIVE = Convert.ToString(item["ACTIVE"]),
});
}
}
return(returnObj.ToArray());
}
public DataSet GetIndustryTypes(BLIndustryType obj)
{
if (obj._MODE == "BYINDUSTRYTYPEID")
{
return(GetIndustryTypeByIndustryTypeID(obj));
}
else if (obj._MODE == "GETALL")
{
return(GetAllActiveIndustryTypes(obj));
}
else
{
return(SearchIndustryTypes(obj));
}
}
public string ManageIndustrytype(int _INDUSTRYTYPEID, string _INDUSTRYTYPECODE, string _INDUSTRYTYPENAME,
string _ACTIVE, int _CREATEDBY, string _CREATEDON, string _MODE)
{
using (BLIndustryType objbl = new BLIndustryType())
{
objbl._INDUSTRYTYPEID = Convert.ToInt32(_INDUSTRYTYPEID);
objbl._INDUSTRYTYPECODE = _INDUSTRYTYPECODE;
objbl._INDUSTRYTYPENAME = _INDUSTRYTYPENAME;
objbl._ACTIVE = _ACTIVE;
objbl._CREATEDBY = Convert.ToInt32(_CREATEDBY);
objbl._CREATEDON = _CREATEDON;
objbl._MODE = _MODE;
//==================
return(objbl.ManageIndustryTypes());
//==================
}
}
public DataSet SearchIndustryTypes(BLIndustryType obj)
{
string queryString = "CALL SP_MANAGEINDUSTRYTYPE(?_INDUSTRYTYPEID, ?_INDUSTRYTYPECODE, ?_INDUSTRYTYPENAME, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[7];
mySqlParam[0] = CreateParameters(DbType.Int32, obj._INDUSTRYTYPEID, "?_INDUSTRYTYPEID", ParameterDirection.Input);
mySqlParam[1] = CreateParameters(DbType.String, obj._INDUSTRYTYPECODE, "?_INDUSTRYTYPECODE", ParameterDirection.Input);
mySqlParam[2] = CreateParameters(DbType.String, obj._INDUSTRYTYPENAME, "?_INDUSTRYTYPENAME", 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 ManageIndustryTypes(BLIndustryType obj)
{
string result = string.Empty;
if (obj._INDUSTRYTYPEID == null)
{
obj._INDUSTRYTYPEID = 0;
}
string queryString = "CALL SP_MANAGEINDUSTRYTYPE(?_INDUSTRYTYPEID, ?_INDUSTRYTYPECODE, ?_INDUSTRYTYPENAME, ?_ACTIVE, ?_CREATEDBY, ?_CREATEDON, ?_MODE)";
MySqlParameter[] mySqlParam = new MySqlParameter[7];
mySqlParam[0] = CreateParameters(DbType.Int32, obj._INDUSTRYTYPEID, "?_INDUSTRYTYPEID", ParameterDirection.Input);
mySqlParam[1] = CreateParameters(DbType.String, obj._INDUSTRYTYPECODE, "?_INDUSTRYTYPECODE", ParameterDirection.Input);
mySqlParam[2] = CreateParameters(DbType.String, obj._INDUSTRYTYPENAME, "?_INDUSTRYTYPENAME", 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);
result = ((String)MySqlHelper.ExecuteScalar(connectionString, queryString, mySqlParam)).ToString();
return(result);
}
