public static bool SaveUpdatedPaymentStatus(List <int> idsWhoHasPayed)
{
try
{
using (var db = new FotbollsTipsModel())
{
foreach (var item in idsWhoHasPayed)
{
var tipsData = (from hits in db.TipsDatas
where hits.Id == item
select hits).FirstOrDefault();
tipsData.HasPayed = true;
}
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
Log4NetLogic.Log(Log4NetLogic.LogLevel.ERROR, "An error in", "SaveUpdatedPaymentStatus", e);
return(false);
}
}
public static bool UpdateRandomValue(string name, string value)
{
try
{
using (var db = new FotbollsTipsModel())
{
var result = (from hits in db.TipsRandomValues
where hits.Name == name
select hits).FirstOrDefault();
result.Value = value;
result.Modified = DateTime.Now;
db.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Log4NetLogic.Log(Log4NetLogic.LogLevel.ERROR, "An error in", "UpdateRandomValue", e);
return(false);
}
}
public static bool SaveCorrectAnswers(TipsData model)
{
using (var db = new FotbollsTipsModel())
{
var result = (from hits in db.TipsDatas
where hits.Namn == DataLogic.RATT_SVAR
select hits).FirstOrDefault();
result.Finallag1 = model.Finallag1;
result.Finallag2 = model.Finallag2;
result.Vinnare = model.Vinnare;
// - - - - - DataLogic_SaveCorrectAnswers.txt - Code area starts - - - - - - -
result.Frankrike_Sydkorea = model.Frankrike_Sydkorea;
result.Tyskland_Kina = model.Tyskland_Kina;
result.Spanien_Sydafrika = model.Spanien_Sydafrika;
result.Norge_Nigeria = model.Norge_Nigeria;
result.Australien_Italien = model.Australien_Italien;
result.Brasilien_Jamaica = model.Brasilien_Jamaica;
result.England_Skottland = model.England_Skottland;
result.Argentina_Japan = model.Argentina_Japan;
result.Kanada_Kamerun = model.Kanada_Kamerun;
result.NyaZeeland_Nederländerna = model.NyaZeeland_Nederländerna;
result.Chile_Sverige = model.Chile_Sverige;
result.Usa_Thailand = model.Usa_Thailand;
result.Nigeria_Sydkorea = model.Nigeria_Sydkorea;
result.Tyskland_Spanien = model.Tyskland_Spanien;
result.Frankrike_Norge = model.Frankrike_Norge;
result.Australien_Brasilien = model.Australien_Brasilien;
result.Sydafrika_Kina = model.Sydafrika_Kina;
result.Japan_Skottland = model.Japan_Skottland;
result.Jamaica_Italien = model.Jamaica_Italien;
result.England_Argentina = model.England_Argentina;
result.Nederländerna_Kamerun = model.Nederländerna_Kamerun;
result.Kanada_NyaZeeland = model.Kanada_NyaZeeland;
result.Sverige_Thailand = model.Sverige_Thailand;
result.Usa_Chile = model.Usa_Chile;
result.Kina_Spanien = model.Kina_Spanien;
result.Sydafrika_Tyskland = model.Sydafrika_Tyskland;
result.Nigeria_Frankrike = model.Nigeria_Frankrike;
result.Sydkorea_Norge = model.Sydkorea_Norge;
result.Italien_Brasilien = model.Italien_Brasilien;
result.Jamaica_Australien = model.Jamaica_Australien;
result.Japan_England = model.Japan_England;
result.Skottland_Argentina = model.Skottland_Argentina;
result.Nederländerna_Kanada = model.Nederländerna_Kanada;
result.Kamerun_NyaZeeland = model.Kamerun_NyaZeeland;
result.Sverige_Usa = model.Sverige_Usa;
result.Thailand_Chile = model.Thailand_Chile;
// - - - - - DataLogic_SaveCorrectAnswers.txt - Code area ends - - - - - - -
db.SaveChanges();
}
return(true);
}
private static List <TipsData> GetTipsRawData()
{
using (var db = new FotbollsTipsModel())
{
var result = (from hits in db.TipsDatas
select hits).ToList();
return(result);
}
}
public static bool SaveNewTipsDataImagePath(TipsPathToPDF path)
{
using (var db = new FotbollsTipsModel())
{
db.TipsPathToPDFs.Add(path);
db.SaveChanges();
}
return(true);
}
public static List <TipsComment> GetComments()
{
using (var db = new FotbollsTipsModel())
{
var result = (from hits in db.TipsComments
select hits).ToList();
return(result);
}
}
public static bool SaveComment(TipsComment model)
{
using (var db = new FotbollsTipsModel())
{
var comment = new TipsComment()
{
Name = model.Name,
Comment = model.Comment,
EntryDate = DateTime.Now
};
db.TipsComments.Add(comment);
db.SaveChanges();
}
return(true);
}
public static string GetRandomValue(string name)
{
try
{
using (var db = new FotbollsTipsModel())
{
var result = (from hits in db.TipsRandomValues
where hits.Name == name
select hits).FirstOrDefault();
return(result.Value);
}
}
catch (Exception e)
{
Log4NetLogic.Log(Log4NetLogic.LogLevel.ERROR, "An error in", "GetRandomValue", e);
throw;
}
}
public static SavedTipsDataResult SaveNewTipsData(TipsData tipsData)
{
try
{
SaveTipsDataToLogFile(tipsData);
}
catch (Exception)
{
// Do nothing, since log to textfile does not work
}
try
{
using (var db = new FotbollsTipsModel())
{
db.TipsDatas.Add(tipsData);
db.SaveChanges();
return(new SavedTipsDataResult()
{
IdOfTipsdata = tipsData.Id,
SuccessedSave = true
});
}
}
catch (Exception e)
{
Log4NetLogic.Log(Log4NetLogic.LogLevel.ERROR, "An error in", "SaveNewTipsData", e);
return(new SavedTipsDataResult()
{
IdOfTipsdata = 0,
SuccessedSave = false
});
}
}
