public JCS_DataInterface.Models.Administration.Unit dbGet(string collection_type_code) { List <DbParameter> parameters = new List <DbParameter>(); parameters.Add(_sqlConn.GetParameter("unit_code", this._unitCode)); JCS_DataInterface.Models.Administration.Unit result = new JCS_DataInterface.Models.Administration.Unit(); try { using (DbDataReader dataReader = _sqlConn.GetDataReader("SELECT unitCode, unitName, unitDescription FROM dbo.system_units WHERE unitCode = @unit_code", parameters, System.Data.CommandType.Text)) { while (dataReader.Read()) { result._unitCode = (string)dataReader["unitCode"]; result._unitName = (string)dataReader["unitName"]; result._unitDescription = (string)dataReader["unitDescription"]; return(result); } } } catch (Exception ex) { result._unitDescription = "Error on JCS_DataInterface.iUnit.dbGet :=> " + ex.Message.ToString(); return(result); } result._unitDescription = "No Records Found"; return(result); }
public List <JCS_DataInterface.Models.Administration.Unit> dbSearch(string searchKey) { List <DbParameter> parameters = new List <DbParameter>(); parameters.Add(_sqlConn.GetParameter("searchKey", searchKey)); List <JCS_DataInterface.Models.Administration.Unit> result = new List <JCS_DataInterface.Models.Administration.Unit>(); JCS_DataInterface.Models.Administration.Unit resultItem = new JCS_DataInterface.Models.Administration.Unit(); try { using (DbDataReader dataReader = _sqlConn.GetDataReader("SELECT unitCode, unitName, unitDescription FROM dbo.system_units WHERE unitName like '%'+@searchKey+'%' OR unitDescription LIKE '%'+@searchKey+'%' ", parameters, System.Data.CommandType.Text)) { while (dataReader.Read()) { resultItem = new JCS_DataInterface.Models.Administration.Unit(); resultItem._unitCode = dataReader["unitCode"].ToString(); resultItem._unitName = (string)dataReader["unitName"]; resultItem._unitDescription = (string)dataReader["unitDescription"]; result.Add(resultItem); } return(result); } } catch (Exception ex) { resultItem._unitDescription = "Error on JCS_DataInterface.iUnit.dbSearch :=> " + ex.Message.ToString(); result.Add(resultItem); return(result); } }