public GetCompanyMasterQM GetCompanyMaster(int companyCode) { var model = new GetCompanyMasterQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new CompanyMasterSelectCommand { Connection = connection }; model = command.Execute(companyCode); } return(model); }
public GetCompanyMasterQM Execute(int companyCode) { var response = new GetCompanyMasterQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetCompanyMaster]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@CompanyCode", SsDbType.Int, ParameterDirection.Input, companyCode)); using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.GetCompanyMasterModelList = reader.ToList <GetCompanyMasterModel>(); } //response.RecordCount = Convert.ToInt32(sqlCommand.Parameters["@RecordCount"].Value); } return(response); }