public ProfilS GetProfil(string name, string tokenid = "")
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
var profil = db.Profil.SingleOrDefault(p => p.Name == name);
if (profil == null)
{
return CreateProfil(name, tokenid);
}
else if (tokenid == profil.TokenId)
{
if (tokenid == "")
{
Random random = new Random();
tokenid = random.Next().ToString();
profil.TokenId = tokenid;
db.Profil.InsertOnSubmit(profil);
db.SubmitChanges();
}
return new ProfilS()
{
id = profil.idProfil,
name = profil.Name,
avatar = profil.Avatar,
rank = profil.Rank,
tokenid = profil.TokenId
};
}
else
{
return new ProfilS()
{
id = -1,
name = "",
avatar = "",
rank = 0,
tokenid = ""
};
}
}
}
public int CreateOrUpdateEvent(int id, string name, DateTime startDate, DateTime endDate, byte[] image, string description)
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
Event eventGame = null;
if (id == 0)
{
eventGame = new Event()
{
Name = name,
StartDate = startDate,
EndDate = endDate,
Image = "",
Description = description
};
db.Event.InsertOnSubmit(eventGame);
}
else
{
eventGame = db.Event.SingleOrDefault(e => e.idEvent == id);
if (name != "")
{
eventGame.Name = name;
}
eventGame.StartDate = startDate;
eventGame.EndDate = endDate;
if (description != "")
{
eventGame.Description = description;
}
}
try
{
if (image != null)
{
if (id == 0)
db.SubmitChanges();
string path = IMAGE_PATH + "events\\" + eventGame.idEvent + "-" + eventGame.Name;
if (!Directory.Exists(path))
Directory.CreateDirectory(IMAGE_PATH + "events\\" + eventGame.idEvent + "-" + eventGame.Name);
using (FileStream fs = new FileStream(path + "\\" + "cover", FileMode.OpenOrCreate, FileAccess.Write))
{
fs.Write(image, 0, image.Length);
eventGame.Image = path + "\\" + "cover";
}
}
db.SubmitChanges();
return eventGame.idEvent;
}
catch (Exception ex)
{
Console.WriteLine("ERROR CreateEvent " + ex.Message);
return -1;
}
}
}
public bool DeletePricepool(int id)
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
var pricepool = db.PricePool.SingleOrDefault(e => e.idPricePool == id);
if (pricepool != null)
{
db.PricePool.DeleteOnSubmit(pricepool);
try
{
db.SubmitChanges();
return true;
}
catch (Exception ex)
{
Console.WriteLine("delete price " + ex.Message);
}
}
return false;
}
}
public bool DeleteEvent(int id)
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
Event eventGame = null;
eventGame = db.Event.SingleOrDefault(e => e.idEvent == id);
if (eventGame != null)
{
if (Directory.Exists(IMAGE_PATH + "event\\" + eventGame.idEvent + "-" + eventGame.Name))
Directory.Delete(IMAGE_PATH + "event\\" + eventGame.idEvent + "-" + eventGame.Name);
db.Event.DeleteOnSubmit(eventGame);
try
{
db.SubmitChanges();
return true;
}
catch (Exception ex)
{
Console.WriteLine("ERROR Delete Event " + ex.Message);
}
}
return false;
}
}
public bool DeletePrice(int id)
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
Price price = null;
price = db.Price.SingleOrDefault(p => p.idPrice == id);
if (price != null)
{
if (Directory.Exists(IMAGE_PATH + "prices\\" + price.idPrice + "-" + price.Name))
Directory.Delete(IMAGE_PATH + "prices\\" + price.idPrice + "-" + price.Name);
db.Price.DeleteOnSubmit(price);
try
{
db.SubmitChanges();
return true;
}
catch (Exception ex)
{
Console.WriteLine("ERROR Delete Price " + ex.Message);
}
}
return false;
}
}
public ProfilS CreateProfil(string name, string tokenId = "")
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
Profil profil = null;
profil = db.Profil.SingleOrDefault(p => p.Name == name);
if (profil == null)
{
if (tokenId == "")
{
Random random = new Random();
tokenId = random.Next().ToString();
}
profil = new Profil();
profil.Name = name;
profil.TokenId = tokenId;
profil.Avatar = "";
profil.Rank = 0;
db.Profil.InsertOnSubmit(profil);
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
Console.WriteLine("ERROR CreateProfil " + ex.Message);
return null;
}
}
else
{
profil = new Profil()
{
idProfil = -1,
Name = "",
Avatar = "",
Rank = 0,
TokenId = ""
};
}
return new ProfilS() {
id = profil.idProfil,
name = profil.Name,
avatar = profil.Avatar,
rank = profil.Rank,
tokenid = profil.TokenId
};
}
}
public bool CreatePricePool(int priceId, int eventId, int placeRangeMin, int placeRangeMax, float placePercent)
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
Event group = db.Event.SingleOrDefault(g => g.idEvent == eventId);
if (group != null)
{
PricePool pricePool = new PricePool()
{
idPrice = priceId,
idEvent = eventId,
placeRangeMin = placeRangeMin,
placeRangeMax = placeRangeMax,
placePurcent = placePercent
};
db.PricePool.InsertOnSubmit(pricePool);
try
{
db.SubmitChanges();
return true;
}
catch (Exception ex)
{
Console.WriteLine("CREATE PRICEPOOL " + ex.Message);
}
}
return false;
}
}
public bool CreatePrice(string name, string image, string description, string path)
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
Price price = new Price() {
Name = name,
Image = image,
Description = description,
Path = path
};
db.Price.InsertOnSubmit(price);
try
{
db.SubmitChanges();
return true;
}
catch (Exception ex)
{
Console.WriteLine("ERROR CreatePrice " + ex.Message);
}
return false;
}
}
public int CreateOrUpdatePrice(int id, string name, byte[] image, byte[] asset, string description)
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
Price price = null;
if (id == 0)
{
price = new Price()
{
Name = name,
Image = "",
Path = "",
Description = description
};
db.Price.InsertOnSubmit(price);
}
else
{
price = db.Price.SingleOrDefault(e => e.idPrice == id);
if (name != "")
price.Name = name;
if (description != "")
price.Description = description;
}
try
{
if (image != null || asset != null)
{
if (id == 0)
db.SubmitChanges();
string path = IMAGE_PATH + "prices\\" + price.idPrice + "-" + price.Name;
if (!Directory.Exists(path))
Directory.CreateDirectory(IMAGE_PATH + "prices\\" + price.idPrice + "-" + price.Name);
if (image != null)
{
using (FileStream fs = new FileStream(path + "\\" + "cover", FileMode.OpenOrCreate, FileAccess.Write))
{
fs.Write(image, 0, image.Length);
price.Image = path + "\\" + "cover";
}
}
if (asset != null)
{
using (FileStream fs = new FileStream(path + "\\" + "asset", FileMode.OpenOrCreate, FileAccess.Write))
{
fs.Write(asset, 0, asset.Length);
price.Path = path + "\\" + "asset";
}
}
}
db.SubmitChanges();
return price.idPrice;
}
catch (Exception ex)
{
Console.WriteLine("ERROR CreateEvent " + ex.Message);
return -1;
}
}
}
public bool CreateOrUpdateGroupSign(int eventId, int profilId, int score)
{
using (MasterDBDataContext db = new MasterDBDataContext())
{
Event eventGame = db.Event.SingleOrDefault(e => e.idEvent == eventId);
Profil profil = db.Profil.SingleOrDefault(p => p.idProfil == profilId);
if (eventGame != null && profil != null)
{
GroupSign groupSign = null;
groupSign = db.GroupSign.SingleOrDefault(gs => gs.idEvent == eventId && gs.idProfil == profilId);
if (groupSign == null)
{
groupSign = new GroupSign()
{
idEvent = eventId,
idProfil = profil.idProfil,
Score = score
};
db.GroupSign.InsertOnSubmit(groupSign);
}
else
{
if (groupSign.Score < score)
{
groupSign.Score = score;
}
}
try
{
db.SubmitChanges();
}
catch (Exception ex)
{
Console.WriteLine("Create Group Sign " + ex.Message);
return false;
}
}
}
return true;
}