public List <JCS_DataInterface.Models.Administration.CollectionType> dbSearch(string searchKey) { List <DbParameter> parameters = new List <DbParameter>(); parameters.Add(_sqlConn.GetParameter("ct_display_name", searchKey)); parameters.Add(_sqlConn.GetParameter("ct_description", searchKey)); List <JCS_DataInterface.Models.Administration.CollectionType> result = new List <JCS_DataInterface.Models.Administration.CollectionType>(); JCS_DataInterface.Models.Administration.CollectionType resultItem = new JCS_DataInterface.Models.Administration.CollectionType(); try { using (DbDataReader dataReader = _sqlConn.GetDataReader("SELECT collection_type_code ,ct_display_name ,ct_description ,ct_billed_to,collectable_flag ,collect_on_delivery_flag ,added_by FROM dbo.collection_type WHERE ct_display_name like '%'+@ct_display_name+'%' OR ct_description LIKE '%'+@ct_description+'%' ", parameters, System.Data.CommandType.Text)) { while (dataReader.Read()) { resultItem = new JCS_DataInterface.Models.Administration.CollectionType(); resultItem._collectionTypeCode = dataReader["collection_type_code"].ToString(); resultItem._ctDisplayName = dataReader["ct_display_name"].ToString(); resultItem._ctDescription = dataReader["ct_description"].ToString(); resultItem._ctBilledTo = dataReader["ct_billed_to"].ToString(); resultItem._collectableFlag = dataReader["collectable_flag"].ToString(); resultItem._collectOnDeliveryFlag = dataReader["collect_on_delivery_flag"].ToString(); resultItem._addedBy = dataReader["added_by"].ToString(); result.Add(resultItem); } return(result); } } catch (Exception ex) { resultItem._ctDisplayName = "Error on JCS_DataInterface.iCollectionType.dbSearch :=> " + ex.Message.ToString(); result.Add(resultItem); return(result); } }
public JCS_DataInterface.Models.Administration.CollectionType dbGet(string collection_type_code) { List <DbParameter> parameters = new List <DbParameter>(); parameters.Add(_sqlConn.GetParameter("collection_type_code", this._collectionTypeCode)); JCS_DataInterface.Models.Administration.CollectionType result = new JCS_DataInterface.Models.Administration.CollectionType(); try { using (DbDataReader dataReader = _sqlConn.GetDataReader("SELECT collection_type_code ,ct_display_name ,ct_description ,ct_billed_to,collectable_flag ,collect_on_delivery_flag ,added_by FROM dbo.collection_type WHERE Collection_Type_Code = @collection_type_code", parameters, System.Data.CommandType.Text)) { while (dataReader.Read()) { result._collectionTypeCode = (string)dataReader["collection_type_code"]; result._ctDisplayName = (string)dataReader["ct_display_name"]; result._ctDescription = (string)dataReader["ct_description"]; result._ctBilledTo = (string)dataReader["ct_billed_to"]; result._collectableFlag = (string)dataReader["collectable_flag"]; result._collectOnDeliveryFlag = (string)dataReader["collect_on_delivery_flag"]; result._addedBy = (string)dataReader["added_by"]; return(result); } } } catch (Exception ex) { result._ctDisplayName = "Error on JCS_DataInterface.iCollectionType.dbGet :=> " + ex.Message.ToString(); return(result); } result._ctDisplayName = "No Records Found"; return(result); }