public static PictureData ToPictureData(PictureDb p)
{
FillAlgorithm fillType = DbTypeConvertor.FillAlgFromDb(p.FillType);
return(new PictureData(PictureType.Local, p.PackId, p.PicId, fillType)
{
HasSave = (p.HasSave == 1),
Solved = (p.Solved == 1),
PicClass = DbTypeConvertor.PicClassFromDb(p.PicClass)
});
}
public static void UpdatePicture(PictureData pd)
{
try
{
PictureDb obj = DbTypeConvertor.FromPictureData(pd);
DatabaseManager.db.UpdateTable(obj);
}
catch (Exception ex)
{
FMLogger.Log("upd pic error. " + ex.Message);
AnalyticsManager.DbTransactionError("picDb", "UpdatePicture: " + ex.Message);
}
}
public static void AddPicture(PictureData pd)
{
try
{
PictureDb obj = DbTypeConvertor.FromPictureData(pd);
DatabaseManager.db.Insert(obj);
}
catch (Exception ex)
{
FMLogger.Log("error adding picture. " + ex.Message);
AnalyticsManager.DbTransactionError("picDb", "AddPicture: " + ex.Message);
}
}
public static PictureData GetPicture(int id)
{
PictureData result;
try
{
PictureDb p = DatabaseManager.db.Get <PictureDb>(id);
PictureData pictureData = DbTypeConvertor.ToPictureData(p);
result = pictureData;
}
catch
{
result = null;
}
return(result);
}
public static void DeletePicture(PictureData pd)
{
if (pd.HasSave)
{
DatabaseManager.DeleteSave(pd.Id, false);
}
try
{
PictureDb obj = DbTypeConvertor.FromPictureData(pd);
DatabaseManager.db.Delete <PictureDb>(obj);
}
catch (Exception ex)
{
FMLogger.Log("error del pic. " + ex.Message);
AnalyticsManager.DbTransactionError("picDb", "DeletePicture: " + ex.Message);
}
}
public static void DeleteSave(int id, bool updPicData = true)
{
try
{
string query = "DELETE FROM SaveDb WHERE PicId = ?";
DatabaseManager.db.Execute(query, new object[]
{
id
});
GeneralSettings.SavesCount--;
}
catch (Exception ex)
{
FMLogger.Log("error save del. " + ex.Message);
AnalyticsManager.DbTransactionError("saveDb", "DeleteSave: " + ex.Message);
}
if (updPicData)
{
try
{
string query2 = "SELECT * FROM PictureDb WHERE PicId=?";
bool flag;
PictureDb pictureDb = DatabaseManager.db.QueryFirstRecord <PictureDb>(out flag, query2, new object[]
{
id
});
if (flag)
{
pictureDb.HasSave = 0;
DatabaseManager.db.UpdateTable(pictureDb);
}
}
catch (Exception ex2)
{
FMLogger.Log("error upd pd when save deleted. " + ex2.Message);
}
}
}
public static void AddSave(PictureSaveData pictureSaveData)
{
try
{
SaveDb obj = DbTypeConvertor.FromPictureSaveData(pictureSaveData);
DatabaseManager.db.Insert(obj);
string query = "SELECT * FROM PictureDb WHERE PicId=?";
bool flag;
PictureDb pictureDb = DatabaseManager.db.QueryFirstRecord <PictureDb>(out flag, query, new object[]
{
pictureSaveData.Id
});
if (flag && pictureDb.HasSave == 0)
{
pictureDb.HasSave = 1;
DatabaseManager.db.UpdateTable(pictureDb);
}
}
catch (Exception ex)
{
FMLogger.Log("failed to add save. " + ex.Message);
AnalyticsManager.DbTransactionError("saveDb", "AddSave: " + ex.Message);
}
}
