/// <summary>
/// Adds a Node to the Site Map
/// </summary>
/// <param name="url">URL to add to SiteMap</param>
/// <param name="modified">true oo false if the item has just been modified.</param>
public static void AddNode(string url, bool modified)
{
var dc = new ManagementContext();
var site = dc.SiteMap.Where(x => x.Url.ToLower() == url.ToLower()).FirstOrDefault();
if (site == null)
{
Sitemap siteMap = new Sitemap();
siteMap.ChangeFrequency = Convert.ToInt32(SitemapHelperEnum.monthly);
siteMap.LastModified = DateTime.UtcNow;
siteMap.Url = url.ToLower();
dc.SiteMap.Add(siteMap);
dc.SaveChanges();
}
else
{
if (modified)
{
site.LastModified = DateTime.UtcNow;
TimeSpan span = DateTime.UtcNow.Subtract(site.LastModified.Value);
if (span.Days > 365)
site.ChangeFrequency = Convert.ToInt32(SitemapHelperEnum.yearly);
else if (span.Days > 31)
site.ChangeFrequency = Convert.ToInt32(SitemapHelperEnum.monthly);
else if (span.Days > 7)
site.ChangeFrequency = Convert.ToInt32(SitemapHelperEnum.weekly);
else if (span.Hours > 24)
site.ChangeFrequency = Convert.ToInt32(SitemapHelperEnum.daily);
else
site.ChangeFrequency = Convert.ToInt32(SitemapHelperEnum.hourly);
dc.SaveChanges();
}
}
}
public static bool TogglePrivacySettingsForMember(Guid memberId, MemberPrivacySettingsEnum privacySetting)
{
try
{
var dc = new ManagementContext();
var leagueMember = dc.Members.Include("Settings").Where(x => x.MemberId == memberId).FirstOrDefault();
if (leagueMember.Settings == null)
leagueMember.Settings = new DataModels.Member.MemberSettings();
MemberPrivacySettingsEnum owner = (MemberPrivacySettingsEnum)leagueMember.Settings.MemberPrivacySettingsEnum;
bool isType = owner.HasFlag(privacySetting);
if (isType)
owner &= ~privacySetting;
else
owner |= privacySetting;
leagueMember.Settings.MemberPrivacySettingsEnum = (long)owner;
int c = dc.SaveChanges();
return c > 0;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return false;
}
public static void MoveOwnersOfGameOverToNewOwnershipSystem()
{
var dc = new ManagementContext();
var gameDb = (from xx in dc.Games
select xx).ToList();
foreach (var game in gameDb)
{
if (game.OwnerOfGame != null)
{
GameMemberOwnership owner = new GameMemberOwnership();
owner.Game = game;
owner.Member = game.OwnerOfGame;
owner.OwnerType = Convert.ToInt32(GameOwnerEnum.Owner);
game.MemberOwners.Add(owner);
}
if (game.FederationOwner != null)
{
GameFederationOwnership owner = new GameFederationOwnership();
owner.Game = game;
owner.Federation = game.FederationOwner;
owner.OwnerType = Convert.ToInt32(GameOwnerEnum.Owner);
game.FederationOwners.Add(owner);
}
}
dc.SaveChanges();
}
public static bool AddNewDesignation(RDN.Library.Classes.League.Organization designation)
{
try
{
var dc = new ManagementContext();
DataModels.League.OrganizationChart.Designation con = new DataModels.League.OrganizationChart.Designation();
con.DesignationTitle = designation.DesigTitle;
con.DesignationLevel = designation.DesigLavel;
con.ShortNote = designation.ShortNote;
con.League = dc.Leagues.Where(x => x.LeagueId == designation.LeagueId).FirstOrDefault();
dc.Designations.Add(con);
int c = dc.SaveChanges();
return c > 0;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return false;
}
public bool UpdateMerchantSettings(OverviewMerchant store)
{
try
{
var dc = new ManagementContext();
var merc = dc.Merchants.Where(x => x.InternalReference == store.InternalReference && x.MerchantId == store.MerchantId && x.PrivateManagerId == store.PrivateManagerId).FirstOrDefault();
if (merc != null)
{
merc.OrderPayedNotificationEmail = store.OrderPayedNotificationEmail;
merc.PaypalEmail = store.PaypalEmail;
//need to make sure we have a paypal email.
if (String.IsNullOrEmpty(merc.PaypalEmail))
merc.AcceptPaymentsViaPaypal = false;
else
merc.AcceptPaymentsViaPaypal = store.AcceptPaymentsViaPaypal;
if (merc.AcceptPaymentsViaStripe || (store.AcceptPaymentsViaPaypal && !String.IsNullOrEmpty(store.PaypalEmail)))
merc.IsPublished = store.IsPublished;
else
merc.IsPublished = false;
dc.SaveChanges();
return true;
}
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return false;
}
public static bool Add_New_Item(RDN.Library.Classes.League.ItemInfoDA NewItem)
{
try
{
var dc = new ManagementContext();
DataModels.League.ItemInfo con = new DataModels.League.ItemInfo();
con.ItemSerialNo = NewItem.ItemSerialNo;
con.ItemName = NewItem.ItemName;
con.Location = NewItem.Location;
con.Notes = NewItem.Notes;
con.Quantity = NewItem.Quantity;
con.UnitePice = NewItem.UnitePice;
con.ItemsForLeague = dc.Leagues.Where(x => x.LeagueId == NewItem.ItemsForLeague).FirstOrDefault();
con.ItemAddByMember = dc.Members.Where(x => x.MemberId == NewItem.ItemAddByMember).FirstOrDefault();
dc.ItemInfos.Add(con);
int c = dc.SaveChanges();
return c > 0;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return false;
}
public static int DoUpdates()
{
try
{
int c = 0;
var dc = new ManagementContext();
var mems = dc.LeagueMembers.Where(x => x.LeagueOwnersEnum > 0);
foreach (var mem in mems)
{
mem.LeagueOwnersEnums = (int)mem.LeagueOwnersEnum;
if (mem.LeagueOwnersEnum > 0)
Console.WriteLine(mem.LeagueOwnersEnum);
//leagueMember.LeagueOwnersEnums = (int)owner;
mem.League = mem.League;
mem.Member = mem.Member;
}
c += dc.SaveChanges();
return c;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return 0;
}
/// <summary>
/// updates the penalty box DB with new information
/// </summary>
/// <param name="game"></param>
/// <param name="cachedGame"></param>
/// <param name="db"></param>
/// <param name="pen"></param>
public static void updatePenaltyBoxInDb(GameViewModel game, ManagementContext db, SkaterInPenaltyBoxViewModel pen, DataModels.Game.Game g)
{
try
{
var cachedPen = g.GameMemberPenaltyBox.Where(x => x.PenaltyIdFromGame == pen.PenaltyId).FirstOrDefault();
if (cachedPen == null)
insertNewPenaltyIntoDb(game, db, pen, g);
else
{
cachedPen.GameTimeMilliSecondsReturned = pen.GameTimeInMillisecondsReleased;
cachedPen.GameTimeMilliSecondsSent = pen.GameTimeInMillisecondsSent;
cachedPen.JamNumberReturned = pen.JamNumberReleased;
cachedPen.JamNumberSent = pen.JamNumberSent;
cachedPen.JamIdReturned = pen.JamIdReleased;
cachedPen.JamIdSent = pen.JamIdSent;
cachedPen.JamTimeMilliSecondsReturned = pen.JamTimeInMillisecondsReleased;
cachedPen.JamTimeMilliSecondsSent = pen.JamTimeInMillisecondsSent;
cachedPen.PenaltyType = pen.PenaltyType.ToString();
db.SaveChanges();
}
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
}
public static bool AddColor(string nameOfColor, string colorHex)
{
try
{
var dc = new ManagementContext();
Color color = ColorTranslator.FromHtml(colorHex);
int arb = color.ToArgb();
var colorDb = dc.Colors.Where(x => x.ColorIdCSharp == arb).FirstOrDefault();
if (colorDb == null)
{
DataModels.Color.Color co = new DataModels.Color.Color();
co.ColorName = nameOfColor;
co.ColorIdCSharp = arb;
dc.Colors.Add(co);
int c = dc.SaveChanges();
return c > 0;
}
return true;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType(), additionalInformation: nameOfColor + " " + colorHex);
}
return false;
}
public static void CommitFeedback(string feedback, string league, string email, FeedbackTypeEnum type)
{
try
{
ManagementContext db = new ManagementContext();
ScoreboardFeedback fb = new ScoreboardFeedback();
fb.Created = DateTime.UtcNow;
fb.Feedback = feedback;
fb.League = league;
fb.Email = email;
fb.FeedbackTypeEnum = (byte)FeedbackTypeEnum.None;
db.ScoreboardFeedback.Add(fb);
db.SaveChanges();
string body = "New Feedback Boss:<br/><br/>";
body += feedback + "<br/><br/>";
body += "from: " + email + "<br/>";
body += "url: http://raspberry.rdnation.com/Admin/Feedback<br/>";
body += "You Da Man!";
var emailData = new Dictionary<string, string> { { "body", body } };
EmailServer.EmailServer.SendEmail(ServerConfig.DEFAULT_EMAIL, ServerConfig.DEFAULT_EMAIL_FROM_NAME, ServerConfig.DEFAULT_INFO_EMAIL, EmailServer.EmailServer.DEFAULT_SUBJECT + " New Feedback", emailData, layout: EmailServerLayoutsEnum.Blank, priority: EmailPriority.Normal);
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
}
public static int insertAssistIntoDb(Guid teamId, GameViewModel game, AssistViewModel assisted, ManagementContext db, DataModels.Game.Game g)
{
int c = 0;
try
{
GameMemberAssist assist = new GameMemberAssist();
assist.DateTimeAssisted = assisted.CurrentDateTimeAssisted;
assist.GameAssistId = assisted.AssistId;
assist.JamNumber = assisted.JamNumber;
assist.JamId = assisted.JamId;
assist.PeriodNumber = assisted.Period;
assist.PeriodTimeRemainingMilliseconds = assisted.PeriodTimeRemaining;
assist.Game = g;
assist.MemberWhoAssisted = g.GameTeams.Where(x => x.TeamId == teamId).First().GameMembers.Where(x => x.GameMemberId == assisted.PlayerWhoAssisted.SkaterId).FirstOrDefault();
if (assist.MemberWhoAssisted != null)
{
db.GameMemberAssist.Add(assist);
c += db.SaveChanges();
}
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return c;
}
public static bool DeleteFolderFromLeague(Guid leagueId, long folderId)
{
try
{
var dc = new ManagementContext();
var fold = dc.LeagueDocumentFolders.Where(x => x.League.LeagueId == leagueId && x.CategoryId == folderId).FirstOrDefault();
if (fold != null)
{
fold.ParentFolder = null;
var docs = dc.LeagueDocuments.Where(x => x.Category.CategoryId == folderId);
foreach (var doc in docs)
{
doc.Category = null;
}
dc.LeagueDocumentFolders.Remove(fold);
int c = dc.SaveChanges();
return c > 0;
}
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return false;
}
public static bool EditLeagueContact(Guid leagueId, ContactDisplayBasic contact)
{
try
{
var dc = new ManagementContext();
var con = dc.LeagueContacts.Where(x => x.Contact.ContactId == contact.ContactId).FirstOrDefault();
con.Contact.CompanyName = contact.CompanyName;
con.Contact.Firstname = contact.FirstName;
con.Contact.Lastname = contact.LastName;
con.Contact.Link = contact.Link;
int countryId = Convert.ToInt32(contact.CountryId);
ContactCard.ContactCardFactory.UpdateAddressToContact(contact.Address1, contact.Address2, contact.CityRaw, contact.StateRaw, contact.Zip, AddressTypeEnum.None, con.Contact.ContactCard, dc.Countries.Where(x => x.CountryId == countryId).FirstOrDefault());
ContactCard.ContactCardFactory.UpdatePhoneNumberToCard(contact.PhoneNumber, con.Contact.ContactCard, String.Empty);
ContactCard.ContactCardFactory.UpdateEmailToContactCard(contact.Email, con.Contact.ContactCard);
con.Notes = contact.Notes;
con.ContactTypeEnum = (byte)((ContactTypeForOrganizationEnum)Enum.Parse(typeof(ContactTypeForOrganizationEnum), contact.ContactTypeSelected));
con.League = con.League;
con.Contact = con.Contact;
int c = dc.SaveChanges();
return c > 0;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return false;
}
public static bool Add_New_List(RDN.Library.Classes.League.TaskList.TaskListDA NewTaskList)
{
try
{
var dc = new ManagementContext();
DataModels.League.Task.TaskList con = new DataModels.League.Task.TaskList();
con.AssignedTo = NewTaskList.AssignedTo;
con.EndDate = NewTaskList.EndDate;
con.ListAddByMember = dc.Members.Where(x => x.MemberId == NewTaskList.ListAddByMember).FirstOrDefault();
con.ListName = NewTaskList.ListName;
con.TaskListForLeague = dc.Leagues.Where(x => x.LeagueId == NewTaskList.TaskListForLeague).FirstOrDefault();
dc.TaskLists.Add(con);
int c = dc.SaveChanges();
return c > 0;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return false;
}
public static void UpdateLocations()
{
var dc = new ManagementContext();
var adds = dc.Addresses;
foreach (var add in adds)
{
try
{
var coords = OpenStreetMap.FindLatLongOfAddress(add.Address1, add.Address2, add.Zip, add.CityRaw, add.StateRaw, add.Country != null ? add.Country.Name : String.Empty);
if (coords != null)
{
add.Coords = new System.Device.Location.GeoCoordinate();
add.Coords.Latitude = coords.Latitude;
add.Coords.Longitude = coords.Longitude;
add.Coords.Altitude = 0;
add.Coords.Course = 0;
add.Coords.HorizontalAccuracy = 1;
add.Coords.Speed = 0;
add.Coords.VerticalAccuracy = 1;
}
add.ContactCard = add.ContactCard;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
}
dc.SaveChanges();
}
public static void insertBlockIntoDb(Guid teamId, GameViewModel game, BlockViewModel block, ManagementContext db, DataModels.Game.Game g)
{
try
{
GameMemberBlock blocks = new GameMemberBlock();
blocks.DateTimeBlocked = block.CurrentDateTimeBlock;
blocks.GameBlockId = block.BlockId;
blocks.JamNumber = block.JamNumber;
blocks.JamId = block.JamId;
blocks.PeriodNumber = block.Period;
blocks.PeriodTimeRemainingMilliseconds = block.PeriodTimeRemaining;
blocks.Game = g;
blocks.MemberWhoBlocked = g.GameTeams.Where(x => x.TeamId == teamId).First().GameMembers.Where(x => x.GameMemberId == block.PlayerWhoBlocked.SkaterId).FirstOrDefault();
if (blocks.MemberWhoBlocked != null)
{
db.GameMemberBlock.Add(blocks);
db.SaveChanges();
}
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
}
public static bool Add_New_Sponsor(RDN.Library.Classes.League.Sponsor NewSponsor)
{
try
{
var dc = new ManagementContext();
DataModels.League.Sponsorship con = new DataModels.League.Sponsorship();
con.Description = NewSponsor.Description;
con.PromoCode = NewSponsor.PromoCode;
con.SponsorName = NewSponsor.SponsorName;
con.Website = NewSponsor.Website;
if (NewSponsor.BeginDate != new DateTime())
con.BeginDate = NewSponsor.BeginDate;
if (NewSponsor.EndDate != new DateTime())
con.EndDate = NewSponsor.EndDate;
con.Sponsored = NewSponsor.Sponsored;
con.SponsorForLeague = dc.Leagues.Where(x => x.LeagueId == NewSponsor.SponsorForLeague).FirstOrDefault();
con.SponsorAddByMember = dc.Members.Where(x => x.MemberId == NewSponsor.SponsorAddByMember).FirstOrDefault();
dc.Sponsorships.Add(con);
int c = dc.SaveChanges();
return c > 0;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType(), additionalInformation: NewSponsor.EndDate + ":" + NewSponsor.BeginDate);
}
return false;
}
public static bool RemoveDuesCollectionItem(long duesItemId, Guid duesManagementId, Guid memId, long duesCollectedId)
{
try
{
var dc = new ManagementContext();
var item = (from xx in dc.FeesCollected
where xx.MemberPaid.MemberId == memId
where xx.FeeItem.FeeCollectionId == duesItemId
where xx.FeeItem.FeeManagedBy.FeeManagementId == duesManagementId
select xx);
foreach (var fee in item)
{
fee.IsPaidInFull = false;
}
var feed = item.Where(x => x.FeeCollectionId == duesCollectedId).FirstOrDefault();
if (feed != null)
dc.FeesCollected.Remove(feed);
int c = dc.SaveChanges();
return true;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return false;
}
public static bool ChangeClassificationForMember(Guid duesManagementId, long classificationId, Guid memberId)
{
FeeClassificationFactory fClass = new FeeClassificationFactory();
try
{
var dc = new ManagementContext();
var classy = dc.FeeClassificationByMember.Where(x => x.FeeItem.FeeItem.FeeManagementId == duesManagementId && x.Member.MemberId == memberId).FirstOrDefault();
if (classificationId == 0)
{
dc.FeeClassificationByMember.Remove(classy);
}
else if (classy == null)
{
FeesClassificationByMember m = new FeesClassificationByMember();
var classification = dc.FeeClassification.Where(x => x.FeeItem.FeeManagementId == duesManagementId && x.FeeClassificationId == classificationId).FirstOrDefault();
m.FeeItem = classification;
m.Member = dc.Members.Where(x => x.MemberId == memberId).FirstOrDefault();
classification.MembersClassified.Add(m);
dc.FeeClassificationByMember.Add(m);
}
else
{
classy.FeeItem = dc.FeeClassification.Where(x => x.FeeItem.FeeManagementId == duesManagementId && x.FeeClassificationId == classificationId).FirstOrDefault();
}
int c = dc.SaveChanges();
return c > 0;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return false;
}
public static bool Add_New_Task(RDN.Library.Classes.League.TaskList.TaskDA NewTask)
{
try
{
var dc = new ManagementContext();
DataModels.League.Task.Task con = new DataModels.League.Task.Task();
con.Completed = NewTask.Completed;
con.Title = NewTask.Title;
con.DeadLine = NewTask.DeadLine;
con.EndDate = NewTask.EndDate;
con.Notes = NewTask.Notes;
con.StartDate = NewTask.StartDate;
con.StatusId = NewTask.StatusId;
con.TaskAddByMember = dc.Members.Where(x => x.MemberId == NewTask.TaskAddByMember).FirstOrDefault();
con.TaskBelongsTo = dc.TaskLists.Where(x => x.ListId == NewTask.TaskListId).FirstOrDefault();
dc.Tasks.Add(con);
int c = dc.SaveChanges();
return c > 0;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return false;
}
public static void insertScoreIntoDb(Guid teamId, GameViewModel game, ScoreViewModel score, ManagementContext db, DataModels.Game.Game g)
{
try
{
GameScore scores = new GameScore();
if (score.CurrentDateTimeScored != new DateTime())
scores.DateTimeScored = score.CurrentDateTimeScored;
else
scores.DateTimeScored = DateTime.UtcNow;
scores.GameScoreId = score.PointId;
scores.JamNumber = score.JamNumber;
scores.JamId = score.JamId;
scores.PeriodNumber = score.Period;
scores.PeriodTimeRemainingMilliseconds = score.PeriodTimeRemaining;
scores.Point = score.Points;
scores.GameTeam = g.GameTeams.Where(x => x.TeamId == teamId).First();
if (score.PlayerWhoScored != null && score.PlayerWhoScored.SkaterId != new Guid())
scores.MemberWhoScored = g.GameTeams.Where(x => x.TeamId == teamId).First().GameMembers.Where(x => x.GameMemberId == score.PlayerWhoScored.SkaterId).FirstOrDefault();
db.GameScore.Add(scores);
db.SaveChanges();
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType(), additionalInformation: "jamId:" + score.JamId + "/ pointId:" + score.PointId);
}
}
public static int DeepCompareOfficialReviewsToDb(GameViewModel game, ManagementContext db, DataModels.Game.Game gameNew)
{
try
{
if (game.OfficialReviews != null)
{
foreach (var member in game.OfficialReviews)
{
var review = gameNew.OfficialReviews.Where(x => x.OfficialReviewIdFromGame == member.OfficialReviewId).FirstOrDefault();
if (review == null)
AddOfficialReview(game, gameNew, member);
else
{
review.TeamNumber = (byte)member.TeamNumber;
review.Details = member.Details;
review.Result = member.Result;
}
}
}
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return db.SaveChanges();
}
/// <summary>
/// deletes a line item in the sitemap
/// </summary>
/// <param name="url"></param>
/// <returns></returns>
public static bool DeleteSiteMapItem(string url)
{
var dc = new ManagementContext();
var item = dc.SiteMap.Where(x => x.Url.ToLower() == url.ToLower()).FirstOrDefault();
if (item != null)
dc.SiteMap.Remove(item);
dc.SaveChanges();
return true;
}
public static void DeleteContactLeague(int itemToDelete)
{
var dc = new ManagementContext();
var item = dc.ContactLeagues.FirstOrDefault(x => x.LeagueId.Equals(itemToDelete));
if (item == null)
return;
dc.ContactLeagues.Remove(item);
dc.SaveChanges();
}
public static bool SaveNextAdminMessage(string message)
{
var dc = new ManagementContext();
AdminEmailMessages m = new AdminEmailMessages();
m.Message = message;
dc.AdminEmailMessages.Add(m);
int c = dc.SaveChanges();
return c > 0;
}
/// <summary>
/// signs the email up for public beta.
/// </summary>
/// <param name="email"></param>
public static void SignUpForBeta(string email)
{
var dc = new ManagementContext();
DataModels.Beta.BetaSignUp signUp = new DataModels.Beta.BetaSignUp();
signUp.Email = email;
signUp.Emailed = false;
dc.BetaEmails.Add(signUp);
dc.SaveChanges();
}
public static int DoUpdateOfGameTeamIds()
{
var dc = new ManagementContext();
var teams = dc.GameMembers;
foreach (var team in teams)
{
team.GameMemberDbId = team.GameMemberId;
team.Team = team.Team;
}
return dc.SaveChanges();
}
public static int UpgradeMessages()
{
var dc = new ManagementContext();
DateTime dt = DateTime.UtcNow.AddDays(-30);
var m = dc.GroupMessages.Where(x => x.Created > dt);
foreach (var mess in m)
{
mess.LastModified = DateTime.UtcNow;
}
int c = dc.SaveChanges();
return c;
}
/// <summary>
/// Stores the error object in the database
/// </summary>
/// <param name="errorObject">Error object to store</param>
public static void AddException(ErrorObject errorObject)
{
try
{
var dc = new ManagementContext();
var databaseError = new DataModels.Exception.Exception
{
AdditionalInformation = errorObject.AdditionalInformation,
AssemblyName = errorObject.AssemblyName,
AssemblyVersion = errorObject.AssemblyVersion,
Created = errorObject.Created,
ErrorNameSpace = errorObject.ErrorNameSpace,
MethodName = errorObject.MethodName,
NameSpace = errorObject.NameSpace,
Group = errorObject.ErrorGroup.HasValue ? (byte?)errorObject.ErrorGroup.Value : null,
Severity = errorObject.ErrorSeverity.HasValue ? (byte?)errorObject.ErrorSeverity.Value : null
};
if (errorObject.ErrorData != null && errorObject.ErrorData.Count > 0)
{
foreach (var errorDataDetail in errorObject.ErrorData)
{
var databaseErrorData = new DataModels.Exception.ExceptionData
{
DataType = (byte)errorDataDetail.DataType,
Name = errorDataDetail.Key,
Data = errorDataDetail.Value
};
databaseError.ExceptionData.Add(databaseErrorData);
}
}
if (errorObject.ErrorExceptions != null)
foreach (var exception in errorObject.ErrorExceptions)
{
var exceptionErrorDetail = new DataModels.Exception.ExceptionDetail();
exceptionErrorDetail.Depth = exception.Depth;
exceptionErrorDetail.Message = exception.Message;
exceptionErrorDetail.MethodName = exception.MethodName;
exceptionErrorDetail.StackTrace = exception.StackTrace;
databaseError.ExceptionDetails.Add(exceptionErrorDetail);
}
dc.ErrorExceptions.Add(databaseError);
dc.SaveChanges();
}
catch (Exception except)
{ AddException(except, except.GetType()); }
}
/// <summary>
/// inserts and updates the mac address of the scoreboard so that we can track active installs.
/// </summary>
/// <param name="id"></param>
public static ScoreboardInstance insertScoreboardActiveId(string scoreboardMacAddress, string version)
{
try
{
ManagementContext db = new ManagementContext();
var instance = (from xx in db.ScoreboardInstance
where xx.InstanceMacAddress == scoreboardMacAddress
select xx).FirstOrDefault();
if (instance != null)
{
instance.LastUpdated = DateTime.UtcNow;
instance.LoadsCount += 1;
if (!String.IsNullOrEmpty(version))
instance.Version = version;
db.SaveChanges();
return instance;
}
else
{
ScoreboardInstance ins = new ScoreboardInstance();
ins.Created = DateTime.UtcNow;
ins.InstanceMacAddress = scoreboardMacAddress;
ins.LastUpdated = DateTime.UtcNow;
ins.LoadsCount = 1;
if (!String.IsNullOrEmpty(version))
ins.Version = version;
db.ScoreboardInstance.Add(ins);
db.SaveChanges();
return ins;
}
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return null;
}