public JCS_DataInterface.Models.Administration.ShipmentType dbGet(string collection_type_code)
{
List <DbParameter> parameters = new List <DbParameter>();
parameters.Add(_sqlConn.GetParameter("shipment_type", this._shipmentType));
JCS_DataInterface.Models.Administration.ShipmentType result = new JCS_DataInterface.Models.Administration.ShipmentType();
try
{
using (DbDataReader dataReader = _sqlConn.GetDataReader("SELECT ShipmentType,Description,isTransaction FROM Shipment_Type where ShipmentType =@shipment_type;", parameters, System.Data.CommandType.Text))
{
while (dataReader.Read())
{
result._shipmentType = (string)dataReader["ShipmentType"];
result._description = (string)dataReader["Description"];
result._isTransaction = (string)dataReader["isTransaction"];
return(result);
}
}
}
catch (Exception ex)
{
result._description = "Error on JCS_DataInterface.iPaymentType.dbGet :=> " + ex.Message.ToString();
return(result);
}
result._description = "No Records Found";
return(result);
}
public List <JCS_DataInterface.Models.Administration.ShipmentType> dbSearch(string searchKey)
{
List <DbParameter> parameters = new List <DbParameter>();
parameters.Add(_sqlConn.GetParameter("description", searchKey));
List <JCS_DataInterface.Models.Administration.ShipmentType> result = new List <JCS_DataInterface.Models.Administration.ShipmentType>();
JCS_DataInterface.Models.Administration.ShipmentType resultItem = new JCS_DataInterface.Models.Administration.ShipmentType();
try
{
using (DbDataReader dataReader = _sqlConn.GetDataReader("SELECT ShipmentType,Description,isTransaction FROM Shipment_Type where Description like '%'+@description+'%' ", parameters, System.Data.CommandType.Text))
{
while (dataReader.Read())
{
resultItem = new Models.Administration.ShipmentType();
resultItem._shipmentType = dataReader["ShipmentType"].ToString();
resultItem._description = dataReader["Description"].ToString();
resultItem._isTransaction = dataReader["isTransaction"].ToString();
result.Add(resultItem);
}
return(result);
}
}
catch (Exception ex)
{
resultItem._description = "Error on JCS_DataInterface.iPaymentType.dbSearch :=> " + ex.Message.ToString();
result.Add(resultItem);
return(result);
}
}
