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); }