public GetSubContractStockEnquiryQM GetSubContractStockEnquiryForGrid()
{
GetSubContractStockEnquiryQM getSubContractStockEnquiryQM = new GetSubContractStockEnquiryQM();
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new GetSubContractStockEnquiryForGridSelectCommand {
Connection = connection
};
getSubContractStockEnquiryQM = command.Execute();
}
return(getSubContractStockEnquiryQM);
}
public GetSubContractStockEnquiryQM Execute()
{
GetSubContractStockEnquiryQM response = new GetSubContractStockEnquiryQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetSubContractStockEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand))
{
response.GetSubContractStockEnquiryModelList = reader.ToList <GetSubContractStockEnquiryModel>();
}
}
return(response);
}
