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