public SigmaResultType AddUploadedFileInfo(TypeUploadedFileInfo objUploadedFileInfo)
{
SigmaResultType result = new SigmaResultType();
try
{
UploadedFileInfoMgr uploadedFileInfoMgr = new UploadedFileInfoMgr();
result = uploadedFileInfoMgr.AddUploadedFileInfo(objUploadedFileInfo);
return result;
}
catch (Exception ex)
{
// Log Exception
ExceptionHelper.logException(ex);
result.IsSuccessful = false;
result.ErrorMessage = ex.Message;
return result;
}
}
public SigmaResultType AddUploadedFileInfo(TypeUploadedFileInfo objUploadedFileInfo)
{
TransactionScope scope = null;
SigmaResultType result = new SigmaResultType();
TypeUserInfo userinfo = AuthMgr.GetUserInfo();
//objFileStore.CompanyId = userinfo.CompanyId.ToString();
objUploadedFileInfo.CreatedBy = userinfo.SigmaUserId;
objUploadedFileInfo.UpdatedBy = userinfo.SigmaUserId;
objUploadedFileInfo.UploadedBy = userinfo.SigmaUserId;
// Get connection string
string connStr = ConnStrHelper.getDbConnString();
using (scope = new TransactionScope(TransactionScopeOption.Required))
{
List<SqlParameter> paramList = new List<SqlParameter>();
paramList.Add(new SqlParameter("@FileStoreId", objUploadedFileInfo.FileStoreId));
paramList.Add(new SqlParameter("@Name", objUploadedFileInfo.Name));
paramList.Add(new SqlParameter("@Size", objUploadedFileInfo.Size));
paramList.Add(new SqlParameter("@Path", objUploadedFileInfo.Path));
paramList.Add(new SqlParameter("@UploadedBy", objUploadedFileInfo.UploadedBy));
//paramList.Add(new SqlParameter("@UploadedDate", objUploadedFileInfo.UploadedDate));
paramList.Add(new SqlParameter("@FileExtension", objUploadedFileInfo.FileExtension));
paramList.Add(new SqlParameter("@Revision", GetUploadedFileRevisionInfo(objUploadedFileInfo.FileStoreId)));
paramList.Add(new SqlParameter("@CreatedBy", objUploadedFileInfo.CreatedBy));
paramList.Add(new SqlParameter("@UpdatedBy", objUploadedFileInfo.UpdatedBy));
SqlParameter outParam = new SqlParameter("@NewId", SqlDbType.Int);
outParam.Direction = ParameterDirection.Output;
paramList.Add(outParam);
result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, CommandType.StoredProcedure, "usp_AddUploadedFileInfo", paramList.ToArray());
result.IsSuccessful = true;
result.ScalarValue = (int)outParam.Value;
scope.Complete();
}
return result;
}
public SigmaResultType UpdateUploadedFileInfo(TypeUploadedFileInfo objUploadedFileInfo)
{
SigmaResultType result = new SigmaResultType();
try
{
result.IsSuccessful = true;
return result;
}
catch (Exception ex)
{
// Log Exception
ExceptionHelper.logException(ex);
result.IsSuccessful = false;
result.ErrorMessage = ex.Message;
return result;
}
}
public SigmaResultType UpdateUploadedFileInfo(TypeUploadedFileInfo objUploadedFileInfo)
{
TransactionScope scope = null;
SigmaResultType result = new SigmaResultType();
TypeUserInfo userinfo = AuthMgr.GetUserInfo();
//objFileStore.CompanyId = userinfo.CompanyId.ToString();
objUploadedFileInfo.CreatedBy = userinfo.SigmaUserId;
objUploadedFileInfo.UpdatedBy = userinfo.SigmaUserId;
objUploadedFileInfo.UploadedBy = userinfo.SigmaUserId;
// Get connection string
string connStr = ConnStrHelper.getDbConnString();
// Compose parameters
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@UploadedFileInfoId", objUploadedFileInfo.UploadedFileInfoId),
new SqlParameter("@FileStoreId", objUploadedFileInfo.FileStoreId),
new SqlParameter("@Name", objUploadedFileInfo.Name),
new SqlParameter("@Size", objUploadedFileInfo.Size),
new SqlParameter("@Path", objUploadedFileInfo.Path),
new SqlParameter("@UploadedBy", objUploadedFileInfo.UploadedBy),
new SqlParameter("@UploadedDate", objUploadedFileInfo.UploadedDate),
new SqlParameter("@FileExtension", objUploadedFileInfo.FileExtension),
new SqlParameter("@Revision", objUploadedFileInfo.Revision),
new SqlParameter("@CreatedBy", objUploadedFileInfo.CreatedBy),
new SqlParameter("@UpdatedBy", objUploadedFileInfo.UpdatedBy),
};
using (scope = new TransactionScope(TransactionScopeOption.Required))
{
result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_UpdateUploadedFileInfo", parameters);
result.IsSuccessful = true;
scope.Complete();
}
return result;
}
public SigmaResultType RemoveUploadedFileInfo(TypeUploadedFileInfo objUploadedFileInfo)
{
SigmaResultType result = new SigmaResultType();
TransactionScope scope = null;
// Get connection string
string connStr = ConnStrHelper.getDbConnString();
// Compose parameters
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@UploadedFileInfoId", objUploadedFileInfo.UploadedFileInfoId)
};
using (scope = new TransactionScope(TransactionScopeOption.Required))
{
result.AffectedRow = SqlHelper.ExecuteNonQuery(connStr, "usp_RemoveUploadedFileInfo", parameters);
result.IsSuccessful = true;
scope.Complete();
}
return result;
}
