public Bitmap CropWindowExtraInformation(Bitmap image, ExtraInformation extraInformation)
{
Point point;
Size size;
switch (extraInformation)
{
case ExtraInformation.Urshi_1:
case ExtraInformation.Urshi_2:
case ExtraInformation.Urshi_3:
case ExtraInformation.Urshi_4:
case ExtraInformation.Urshi_5:
point = TransformFrom1440p(CommonImageCoordinate.WindowUrshiGemUp);
size = TransformFrom1440p(CommonImageSize.WindowUrhsiGemUp);
break;
case ExtraInformation.ObeliskIsEmpowered:
point = TransformFrom1440p(CommonImageCoordinate.WindowObeliskEmpowered);
size = TransformFrom1440p(CommonImageSize.WindowObeliskEmpowered);
break;
case ExtraInformation.AcceptGriftIsEmpowered:
point = TransformFrom1440p(CommonImageCoordinate.WindowAcceptGriftEmpowered);
size = TransformFrom1440p(CommonImageSize.WindowAcceptGriftEmpowered);
break;
default:
throw new NotImplementedException();
}
return(ImageHelper.CropImage(image, new Rectangle(point, size)));
}
public void SaveExtraInformation(Bitmap bitmap, ExtraInformation extraInformation)
{
Directory.CreateDirectory($"{OutputDirectoryDated}/ExtraInformation");
var image = cropWindowService.CropWindowExtraInformation(bitmap, extraInformation);
image.Save($"{OutputDirectoryDated}/ExtraInformation/{extraInformation}.png");
}
public override string ToString()
{
if (!String.IsNullOrEmpty(ExtraInformation))
{
ExtraInformation = ExtraInformation.Replace(',', '.');
// replace comma's to prevent mixing with records.
}
return
(string.Format(String.Join(",", Nvl(SubTest), StepNr, Nvl(ShortDescription), Status, Nvl(CauseOfFailure),
Nvl(ExtraInformation))));
}
public async Task <ActionResult> SaveExtraInformation(ExtraInformation extraInformation)
{
bool result;
if (extraInformation.ExtraInformationId > 0)
{
result = await _extraInformationLogic.UpdateExtraInformation(extraInformation);
}
else
{
result = await _extraInformationLogic.InsertExtraInformation(extraInformation) > 0;
}
return(new HttpStatusCodeResult(result ? 200 : 500));
}
public async Task <ActionResult> Card(int id)
{
ExtraInformation extraInformation;
if (id > 0)
{
extraInformation = await _extraInformationLogic.GetExtraInformation(id);
}
else
{
extraInformation = new ExtraInformation();
}
return(View(extraInformation));
}
public async Task UpdateExtraInformation(ExtraInformation extraInformation)
{
var sqlExtraInformation = await Context.ExtraInformation.SingleOrDefaultAsync(i => i.ExtraInformationId == extraInformation.ExtraInformationId);
if (sqlExtraInformation == null)
{
return;
}
sqlExtraInformation.Title = extraInformation.Title;
sqlExtraInformation.Text = extraInformation.Text;
Context.ExtraInformation.Update(sqlExtraInformation);
await Context.SaveChangesAsync();
}
public async Task <int> InsertExtraInformation(ExtraInformation extraInformation)
{
StringBuilder query = new StringBuilder();
query.Append("INSERT INTO ");
query.Append(TableName);
query.Append(" (");
query.Append("[Title]");
query.Append(",[Type]");
query.Append(",[ShowInCv]");
query.Append(") ");
query.Append(" OUTPUT INSERTED.ExtraInformationId ");
query.Append(" VALUES ");
query.Append("(");
query.Append("@Title");
query.Append(", @Type");
query.Append(", @ShowInCv");
query.Append(")");
try
{
using (IDbConnection connection = _manager.GetSqlConnection())
{
var extraInformationId = await connection.QueryFirstAsync <int>(query.ToString(),
new
{
extraInformation.Title,
extraInformation.Type,
extraInformation.ShowInCv
});
string updateQuery = $"UPDATE {TableName} SET [PositionInCv] = {extraInformationId} WHERE [ExtraInformationId] = {extraInformationId}";
await connection.ExecuteAsync(updateQuery);
return(extraInformationId);
}
}
catch (Exception e)
{
Logger.Log(e);
}
return(-1);
}
public async Task <bool> UpdateExtraInformation(ExtraInformation extraInformation)
{
StringBuilder query = new StringBuilder();
query.Append("UPDATE ");
query.Append($"{TableName} ");
query.Append("SET ");
query.Append("[Title] = @Title ");
query.Append(",[Type] = @Type ");
query.Append(",[ShowInCv] = @ShowInCv ");
query.Append("WHERE ");
query.Append("ExtraInformationId = @ExtraInformationId ");
try
{
using (IDbConnection connection = _manager.GetSqlConnection())
{
var result = await connection.ExecuteAsync(query.ToString(),
new
{
extraInformation.ExtraInformationId,
extraInformation.Title,
extraInformation.Type,
extraInformation.ShowInCv
});
return(result > 0);
}
}
catch (Exception e)
{
Logger.Log(e);
}
return(false);
}
public Task <bool> UpdateExtraInformation(ExtraInformation extraInformation)
{
return(_repository.UpdateExtraInformation(extraInformation));
}
public Task <int> InsertExtraInformation(ExtraInformation extraInformation)
{
return(_repository.InsertExtraInformation(extraInformation));
}
