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