public GetToolsMasterQM GetToolsMaster(GetToolsMasterCM getToolsMasterCM)
{
var model = new GetToolsMasterQM();
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var command = new ToolsMasterSelectCommand {
Connection = connection
};
model = command.Execute();
}
return(model);
}
public GetToolsMasterQM Execute()
{
var response = new GetToolsMasterQM();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetToolsMaster]";
sqlCommand.CommandType = CommandType.StoredProcedure;
//sqlCommand.Parameters.Add(AddParameter("@ToolCode", SsDbType.Decimal, ParameterDirection.Input, Convert.ToInt32(model.ToolsCode)));
//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.GetToolsMasterList = reader.ToList <ToolsMasterModel>();
}
response.RecordCount = Convert.ToInt32(sqlCommand.Parameters["@RecordCount"].Value);
}
return(response);
}
