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 }); }