public GetSubcontractProcessMasterQM GetSubcontractProcessMaster() { var model = new GetSubcontractProcessMasterQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new SubcontractProcessMasterSelectCommand { Connection = connection }; model = command.Execute(); } return(model); }
public GetSubcontractProcessMasterQM Execute() { var response = new GetSubcontractProcessMasterQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetSubContractProcessMaster]"; sqlCommand.CommandType = CommandType.StoredProcedure; //sqlCommand.Parameters.Add(AddParameter("@ParameterCode", SsDbType.Decimal, ParameterDirection.Input, Convert.ToInt32(model.ParameterCode))); //sqlCommand.Parameters.Add(AddParameter("@PageSize", SsDbType.Int, ParameterDirection.Input, model.PageSize)); //sqlCommand.Parameters.Add(AddParameter("@PageIndex", SsDbType.Int, ParameterDirection.Input, model.PageIndex)); sqlCommand.Parameters.Add(AddParameter("@RecordCount", SsDbType.Int, ParameterDirection.Output, default(int))); using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.GetSubcontractProcessMasterList = reader.ToList <SubcontractProcessMasterModel>(); } response.RecordCount = Convert.ToInt32(sqlCommand.Parameters["@RecordCount"].Value); } return(response); }