/// <summary>
/// Fixed:
/// </summary>
public Error.Types UpdateSiteImage(byte[] data)
{
BinaryType = "SiteImage";
var imageData = new Libraries.Images.ImageData(
data,
ReferenceId,
Libraries.Images.ImageData.Types.SiteImage);
switch (Parameters.BinaryStorage.Provider)
{
case "Local": imageData.WriteToLocal(); break;
default:
Bin = imageData.ReSizeBytes(Libraries.Images.ImageData.SizeTypes.Regular);
Thumbnail = imageData.ReSizeBytes(
Libraries.Images.ImageData.SizeTypes.Thumbnail);
Icon = imageData.ReSizeBytes(Libraries.Images.ImageData.SizeTypes.Icon);
Rds.ExecuteNonQuery(transactional: true, statements:
Rds.UpdateOrInsertBinaries(
selectIdentity: true,
where : Rds.BinariesWhere()
.ReferenceId(ReferenceId)
.BinaryType("SiteImage"),
param: Rds.BinariesParamDefault(this, setDefault: true)));
break;
}
return(Error.Types.None);
}
private List <SqlStatement> UpdateStatements(
List <SqlStatement> statements,
DateTime timestamp,
SqlParamCollection param,
bool otherInitValue = false,
List <SqlStatement> additionalStatements = null)
{
var where = Rds.BinariesWhereDefault(this)
.UpdatedTime(timestamp, _using: timestamp.InRange());
if (VerUp)
{
statements.Add(CopyToStatement(where, Sqls.TableTypes.History));
Ver++;
}
statements.AddRange(new List <SqlStatement>
{
Rds.UpdateBinaries(
where : where,
param: param ?? Rds.BinariesParamDefault(this, otherInitValue: otherInitValue),
countRecord: true)
});
if (additionalStatements?.Any() == true)
{
statements.AddRange(additionalStatements);
}
return(statements);
}
public ErrorData UpdateOrCreate(
Context context,
SiteSettings ss,
SqlWhereCollection where = null,
SqlParamCollection param = null)
{
SetBySession(context: context);
var statements = new List <SqlStatement>
{
Rds.UpdateOrInsertBinaries(
where : where ?? Rds.BinariesWhereDefault(
context: context,
binaryModel: this),
param: param ?? Rds.BinariesParamDefault(
context: context,
ss: ss,
binaryModel: this,
setDefault: true))
};
var response = Repository.ExecuteScalar_response(
context: context,
transactional: true,
selectIdentity: true,
statements: statements.ToArray());
BinaryId = (response.Id ?? BinaryId).ToLong();
Get(context: context);
return(new ErrorData(type: Error.Types.None));
}
/// <summary>
/// Fixed:
/// </summary>
public Error.Types UpdateTenantImage(Context context, byte[] bin)
{
BinaryType = "TenantImage";
var imageData = new Libraries.Images.ImageData(
bin,
ReferenceId,
Libraries.Images.ImageData.Types.TenantImage);
switch (Parameters.BinaryStorage.Provider)
{
case "Local": imageData.WriteToLocal(); break;
default:
Bin = imageData.ReSizeBytes(Libraries.Images.ImageData.SizeTypes.Logo);
Rds.ExecuteNonQuery(
context: context,
transactional: true,
statements: Rds.UpdateOrInsertBinaries(
where : Rds.BinariesWhere()
.ReferenceId(ReferenceId)
.BinaryType("TenantImage"),
param: Rds.BinariesParamDefault(
context: context,
binaryModel: this,
setDefault: true)));
break;
}
return(Error.Types.None);
}
private List <SqlStatement> UpdateStatements(
Context context,
SiteSettings ss,
string dataTableName = null,
SqlWhereCollection where = null,
SqlParamCollection param = null,
bool otherInitValue = false)
{
return(new List <SqlStatement>
{
Rds.UpdateBinaries(
dataTableName: dataTableName,
where : where,
param: param ?? Rds.BinariesParamDefault(
context: context,
ss: ss,
binaryModel: this,
otherInitValue: otherInitValue)),
new SqlStatement(Def.Sql.IfConflicted.Params(BinaryId))
{
IfConflicted = true,
Id = BinaryId
}
});
}
public List <SqlStatement> CreateStatements(
Context context,
SiteSettings ss,
string dataTableName = null,
Sqls.TableTypes tableType = Sqls.TableTypes.Normal,
SqlParamCollection param = null,
bool otherInitValue = false)
{
var statements = new List <SqlStatement>();
statements.AddRange(new List <SqlStatement>
{
Rds.InsertBinaries(
dataTableName: dataTableName,
tableType: tableType,
selectIdentity: true,
param: param ?? Rds.BinariesParamDefault(
context: context,
ss: ss,
binaryModel: this,
setDefault: true,
otherInitValue: otherInitValue))
});
return(statements);
}
public List <SqlStatement> CreateStatements(
Sqls.TableTypes tableType = Sqls.TableTypes.Normal,
SqlParamCollection param = null,
bool paramAll = false)
{
return(new List <SqlStatement>
{
Rds.InsertBinaries(
tableType: tableType,
selectIdentity: true,
param: param ?? Rds.BinariesParamDefault(
this, setDefault: true, paramAll: paramAll))
});
}
public List <SqlStatement> UpdateStatements(
SqlParamCollection param, bool paramAll = false)
{
var timestamp = Timestamp.ToDateTime();
return(new List <SqlStatement>
{
Rds.UpdateBinaries(
verUp: VerUp,
where : Rds.BinariesWhereDefault(this)
.UpdatedTime(timestamp, _using: timestamp.InRange()),
param: param ?? Rds.BinariesParamDefault(this, paramAll: paramAll),
countRecord: true)
});
}
public List <SqlStatement> CreateStatements(
List <SqlStatement> statements,
Sqls.TableTypes tableType = Sqls.TableTypes.Normal,
SqlParamCollection param = null,
bool otherInitValue = false)
{
statements.AddRange(new List <SqlStatement>
{
Rds.InsertBinaries(
tableType: tableType,
selectIdentity: true,
param: param ?? Rds.BinariesParamDefault(
this, setDefault: true, otherInitValue: otherInitValue))
});
return(statements);
}
public Error.Types UpdateOrCreate(
RdsUser rdsUser = null,
SqlWhereCollection where = null,
SqlParamCollection param = null)
{
SetBySession();
var statements = new List <SqlStatement>
{
Rds.UpdateOrInsertBinaries(
selectIdentity: true,
where : where ?? Rds.BinariesWhereDefault(this),
param: param ?? Rds.BinariesParamDefault(this, setDefault: true))
};
var newId = Rds.ExecuteScalar_long(
rdsUser: rdsUser,
transactional: true,
statements: statements.ToArray());
BinaryId = newId != 0 ? newId : BinaryId;
Get();
return(Error.Types.None);
}
private List <SqlStatement> UpdateStatements(
List <SqlStatement> statements,
DateTime timestamp,
SqlParamCollection param,
bool paramAll = false,
List <SqlStatement> additionalStatements = null)
{
statements.AddRange(new List <SqlStatement>
{
Rds.UpdateBinaries(
verUp: VerUp,
where : Rds.BinariesWhereDefault(this)
.UpdatedTime(timestamp, _using: timestamp.InRange()),
param: param ?? Rds.BinariesParamDefault(this, paramAll: paramAll),
countRecord: true)
});
if (additionalStatements?.Any() == true)
{
statements.AddRange(additionalStatements);
}
return(statements);
}
/// <summary>
/// Fixed:
/// </summary>
public Error.Types UpdateSiteImage(
Context context,
SiteSettings ss,
byte[] bin)
{
BinaryType = "SiteImage";
var imageData = new Libraries.Images.ImageData(
bin,
ReferenceId,
Libraries.Images.ImageData.Types.SiteImage);
switch (Parameters.BinaryStorage.GetSiteImageProvider())
{
case "Local": imageData.WriteToLocal(); break;
default:
Bin = imageData.ReSizeBytes(Libraries.Images.ImageData.SizeTypes.Regular);
Thumbnail = imageData.ReSizeBytes(
Libraries.Images.ImageData.SizeTypes.Thumbnail);
Icon = imageData.ReSizeBytes(Libraries.Images.ImageData.SizeTypes.Icon);
ContentType = "image/png";
Repository.ExecuteNonQuery(
context: context,
transactional: true,
statements: Rds.UpdateOrInsertBinaries(
where : Rds.BinariesWhere()
.ReferenceId(ReferenceId)
.BinaryType("SiteImage"),
param: Rds.BinariesParamDefault(
context: context,
ss: ss,
binaryModel: this,
setDefault: true)));
break;
}
return(Error.Types.None);
}
