public ReturnResult <ComputerRoom> Edit(ComputerRoomEditViewModel computer)
{
DbProvider dbProvider = new DbProvider();
string outCode = String.Empty;
string outMessage = String.Empty;
StoredProcedureConfigs <ComputerRoom> storedProcedureConfigs = new StoredProcedureConfigs <ComputerRoom>();
dbProvider.SetQuery(storedProcedureConfigs._UPDATE_SINGLE_STORED_PROCEDURE, CommandType.StoredProcedure)
.SetParameter("Id", SqlDbType.NVarChar, computer.Pk_id, 100, ParameterDirection.Input)
.SetParameter("Name", SqlDbType.NVarChar, computer.Name, 100, ParameterDirection.Input)
.SetParameter("Status", SqlDbType.Int, computer.Status, ParameterDirection.Input)
.SetParameter("EditBy", SqlDbType.NVarChar, computer.EditBy, ParameterDirection.Input)
.SetParameter("ERROR_CODE", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output)
.SetParameter("ERROR_MESSAGE", SqlDbType.NVarChar, DBNull.Value, 400, ParameterDirection.Output)
.ExcuteNonQuery()
.Complete();
dbProvider.GetOutValue("ERROR_CODE", out outCode)
.GetOutValue("ERROR_MESSAGE", out outMessage);
return(new ReturnResult <ComputerRoom>()
{
ErrorCode = outCode,
ErrorMessage = outMessage,
});
}
public ReturnResult <ComputerRoom> GetAll()
{
List <ComputerRoom> computerList = new List <ComputerRoom>();
DbProvider dbProvider = new DbProvider();
string outCode = String.Empty;
string outMessage = String.Empty;
int totalRows = 0;
StoredProcedureConfigs <ComputerRoom> storedProcedureConfigs = new StoredProcedureConfigs <ComputerRoom>();
dbProvider.SetQuery(storedProcedureConfigs._GET_ALL_STORED_PROCEDURE, CommandType.StoredProcedure)
.SetParameter("ERROR_CODE", System.Data.SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output)
.SetParameter("ERROR_MESSAGE", System.Data.SqlDbType.NVarChar, DBNull.Value, 400, ParameterDirection.Output)
.GetList <ComputerRoom>(out computerList)
.Complete();
dbProvider.GetOutValue("ERROR_CODE", out outCode)
.GetOutValue("ERROR_MESSAGE", out outMessage);
return(new ReturnResult <ComputerRoom>()
{
ItemList = computerList,
ErrorCode = outCode,
ErrorMessage = outMessage,
TotalRows = totalRows
});
}
