public GetScReceivingMasterQM GetScReceivingMaster() { GetScReceivingMasterQM getScReceivingMasterQM = new GetScReceivingMasterQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GetScReceivingMasterSelectCommand { Connection = connection }; getScReceivingMasterQM = command.Execute(); } return(getScReceivingMasterQM); }
public GetScReceivingMasterQM Execute() { var response = new GetScReceivingMasterQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetSCReceivingMaster]"; sqlCommand.CommandType = CommandType.StoredProcedure; using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.GetScReceiveMasterModelList = reader.ToList <GetScReceivingMasterModel>(); } } return(response); }