public StockEnquiryOptionQM Execute(Int16 Option)
{
StockEnquiryOptionQM response = new StockEnquiryOptionQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetStockOptionEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@Option", SsDbType.SmallInt, ParameterDirection.Input, Option));
if (Option == 0)
{
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.getStockOptionEnquiryForSerialModel = reader.ToList <GetStockOptionEnquiryForSerialModel>();
}
}
else
{
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.getStockOptionEnquiryForItemModel = reader.ToList <GetStockOptionEnquiryForItemModel>();
}
}
}
return(response);
}
public StockEnquiryOptionQM GetStockEnquiryForGrid(Int16 Option)
{
StockEnquiryOptionQM ds = new StockEnquiryOptionQM();
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new GetStockEnquirySelectCommandForGrid {
Connection = connection
};
ds = command.Execute(Option);
}
return(ds);
}
