public GetSubContractReceivingResponseQM GetSubContractReceivingDetails(Int64 VendorCode) { var model = new GetSubContractReceivingResponseQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GetSubContractReceivingSelectCommand { Connection = connection }; model = command.Execute(VendorCode); } return(model); }
public GetSubContractReceivingResponseQM Execute(Int64 VendorCode) { var response = new GetSubContractReceivingResponseQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetScReceivingDetails]"; sqlCommand.Parameters.Add(AddParameter("@VendorCode", SsDbType.BigInt, ParameterDirection.Input, VendorCode)); sqlCommand.CommandType = CommandType.StoredProcedure; using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.getSubContractReceivingResponseModel = reader.ToList <GetSubContractReceivingResponseModel>(); } } return(response); }