public void SqlStatement(Context context, List <SqlStatement> statements, long referenceId)
{
if (Added == true)
{
var bin = GetBin();
if (bin != null)
{
statements.Add(Rds.InsertBinaries(
param: Rds.BinariesParam()
.TenantId(context.TenantId)
.ReferenceId(referenceId, _using: referenceId != 0)
.ReferenceId(raw: Def.Sql.Identity, _using: referenceId == 0)
.Guid(Guid)
.Title(Name)
.BinaryType("Attachments")
.Bin(bin, _using: !Parameters.BinaryStorage.IsLocal())
.FileName(Name)
.Extension(Extention)
.Size(Size)
.ContentType(ContentType)));
}
DataSources.File.DeleteTemp(Guid);
}
else if (Deleted == true)
{
statements.Add(Rds.DeleteBinaries(
factory: context,
where : Rds.BinariesWhere().Guid(Guid)));
}
}
public void SqlStatement(List <SqlStatement> statements, long referenceId)
{
if (Added == true)
{
var bin = GetBin();
if (bin != null)
{
statements.Add(Rds.InsertBinaries(
selectIdentity: true,
param: Rds.BinariesParam()
.TenantId(Sessions.TenantId())
.ReferenceId(referenceId, _using: referenceId != 0)
.ReferenceId(raw: Def.Sql.Identity, _using: referenceId == 0)
.Guid(Guid)
.Title(Name)
.BinaryType("Attachments")
.Bin(bin, _using: !Parameters.BinaryStorage.IsLocal())
.FileName(Name)
.Extension(Extention)
.Size(Size)
.ContentType(ContentType)));
}
Directory.Delete(Path.Combine(Directories.Temp(), Guid), recursive: true);
}
else if (Deleted == true)
{
statements.Add(Rds.DeleteBinaries(
where : Rds.BinariesWhere().Guid(Guid)));
}
}
public Error.Types Delete()
{
Rds.ExecuteNonQuery(
transactional: true,
statements: new SqlStatement[]
{
Rds.DeleteBinaries(
where : Rds.BinariesWhere().BinaryId(BinaryId))
});
return(Error.Types.None);
}
public Error.Types Delete()
{
var statements = new List <SqlStatement>();
statements.AddRange(new List <SqlStatement>
{
Rds.DeleteBinaries(
where : Rds.BinariesWhere().BinaryId(BinaryId))
});
Rds.ExecuteNonQuery(
transactional: true,
statements: statements.ToArray());
return(Error.Types.None);
}
public Error.Types Delete()
{
var statements = new List <SqlStatement>();
var where = Rds.BinariesWhere().BinaryId(BinaryId);
statements.AddRange(new List <SqlStatement>
{
Rds.DeleteBinaries(where : where)
});
var response = Rds.ExecuteScalar_response(
transactional: true,
statements: statements.ToArray());
return(Error.Types.None);
}
public ErrorData Delete(Context context)
{
var statements = new List <SqlStatement>();
var where = Rds.BinariesWhere().BinaryId(BinaryId);
statements.AddRange(new List <SqlStatement>
{
Rds.DeleteBinaries(factory: context, where : where)
});
Repository.ExecuteNonQuery(
context: context,
transactional: true,
statements: statements.ToArray());
return(new ErrorData(type: Error.Types.None));
}
public void SqlStatement(Context context, List<SqlStatement> statements, long referenceId, Column column)
{
if (Added == true)
{
var bin = IsStoreLocalFolder(column) ? default : GetBin();
statements.Add(Rds.UpdateOrInsertBinaries(
param: Rds.BinariesParam()
.TenantId(context.TenantId)
.ReferenceId(referenceId, _using: referenceId != 0)
.ReferenceId(raw: Def.Sql.Identity, _using: referenceId == 0)
.Guid(Guid)
.Title(Name ?? FileName)
.BinaryType("Attachments")
.Bin(bin, _using: !IsStoreLocalFolder(column))
.Bin(raw: "NULL", _using: IsStoreLocalFolder(column))
.FileName(Name ?? FileName)
.Extension(Extention)
.Size(Size)
.ContentType(ContentType),
where: Rds.BinariesWhere().Guid(Guid)));
}
else if (Deleted == true && !Overwritten.HasValue)
{
statements.Add(Rds.DeleteBinaries(
factory: context,
where: Rds.BinariesWhere().Guid(Guid)));
}
else
{
switch (Action)
{
case "Linked":
statements.Add(Rds.UpdateBinaries(
param: Rds.BinariesParam()
.ReferenceId(referenceId),
where: Rds.BinariesWhere().Guid(Guid)));
break;
default:
break;
}
}
}
