public ReturnResult <ComputerFile> GetComputerFileById(int id) { var result = new ReturnResult <ComputerFile>(); ComputerFile profiles = new ComputerFile(); DbProvider dbProvider = new DbProvider(); string outCode = String.Empty; string outMessage = String.Empty; try { dbProvider.SetQuery("COMPUTER_GET_BY_ID", CommandType.StoredProcedure) .SetParameter("ComputerFileId", SqlDbType.Int, id, ParameterDirection.Input) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 255, ParameterDirection.Output) .GetSingle <ComputerFile>(out profiles) .Complete(); dbProvider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode.ToString() != "0") { result.Failed(outCode, outMessage); } else { result.Item = profiles; result.ErrorCode = "0"; result.ErrorMessage = ""; } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
public ReturnResult <ComputerFile> UploadFile(ComputerFile file) { DbProvider dbProvider = new DbProvider(); string outCode = String.Empty; string outMessage = String.Empty; dbProvider.SetQuery("COMPUTER_FILE_UPLOAD", CommandType.StoredProcedure) .SetParameter("FileName", SqlDbType.NVarChar, file.FileName, ParameterDirection.Input) .SetParameter("Url", SqlDbType.NVarChar, file.Url, ParameterDirection.Input) .SetParameter("CreatedBy", SqlDbType.NVarChar, file.CreatedBy, ParameterDirection.Input) .SetParameter("CreatedDate", SqlDbType.Date, file.CreatedDate, ParameterDirection.Input) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output) .ExcuteNonQuery() .Complete(); dbProvider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); return(new ReturnResult <ComputerFile>() { ErrorCode = outCode, ErrorMessage = outMessage, }); }
public ReturnResult <ComputerFile> UploadFile(ComputerFile fileList) { var result = ComputerDAL.UploadFile(fileList); return(result); }