public ActionResult AddRequest(RequestDA oRequest) { try { var memId = RDN.Library.Classes.Account.User.GetMemberId(); var league = MemberCache.GetLeagueOfMember(memId); oRequest.RequestCreator = memId; var executeId = RequestFactory.Add_New_Request(oRequest); ManagementCache.AddOfficiatingRequestsCount(1); var token = FacebookData.GetLatestAccessToken(); //FacebookFactory.Initialize(token).GetPageAuthorization(ConfigurationManager.AppSettings["FacebookPageName"].ToString(), ConfigurationManager.AppSettings["FacebookPageId"].ToString()) // .PostToFanPage("Officials Request:" + oRequest.TeamsPlaying + " @ " + oRequest.Date.GetValueOrDefault().ToShortDateString() + "\n\n" + RDN.Portable.Config.ServerConfig.WEBSITE_DEFAULT_LOCATION + "/officiating-requests/view/" + executeId, "", "", "", "", ""); FacebookFactory.Initialize(token).GetPageAuthorization(ConfigurationManager.AppSettings["FacebookPageName2"].ToString(), ConfigurationManager.AppSettings["FacebookPageId2"].ToString()) .PostToFanPage("Officials Request: " + oRequest.TeamsPlaying + " @ " + oRequest.Date.GetValueOrDefault().ToShortDateString() + "\n\n" + RDN.Portable.Config.ServerConfig.WEBSITE_DEFAULT_LOCATION + "/officiating-requests/view/" + executeId, "", "", "", "", ""); ///Twitter TwitterFactory.Initialize(ConfigurationManager.AppSettings["TwitterConsumerKey"].ToString(), ConfigurationManager.AppSettings["TwitterConsumerSecret"].ToString(), ConfigurationManager.AppSettings["TwitterToken"].ToString(), ConfigurationManager.AppSettings["TwitterTokenSecret"].ToString()) .SendMessage("Officials Request: " + oRequest.TeamsPlaying + " @ " + oRequest.Date.GetValueOrDefault().ToShortDateString() + " #rollerderby " + RDN.Portable.Config.ServerConfig.WEBSITE_DEFAULT_LOCATION + "/officiating-requests/view/" + executeId); } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } return Redirect(Url.Content("~/officiating/requests?u=" + SiteMessagesEnum.sac)); }
public static long Add_New_Request(RequestDA NewRequest) { try { var dc = new ManagementContext(); DataModels.Officials.RefereeRequest con = new DataModels.Officials.RefereeRequest(); con.Date = NewRequest.Date; con.Description = NewRequest.Description; con.EvaluationsProvided = NewRequest.EvaluationsProvided; con.FirstWhistle = NewRequest.FirstWhistle; con.IsRegulation = NewRequest.IsRegulation; con.IsReimbursement = NewRequest.IsReimbursement; con.IsSnacksProvided = NewRequest.IsSnacksProvided; con.NonsoNeded = NewRequest.NonsoNeded; con.NoRefNeded = NewRequest.NoRefNeded; con.RuleSetId = NewRequest.RuleSetId; con.TeamsPlaying = NewRequest.TeamsPlaying; con.TravelStipendForNSO = NewRequest.TravelStipendForNSO; con.TravelStipendForRefs = NewRequest.TravelStipendForRefs; con.Location = new DataModels.Location.Location(); con.Location.LocationName = NewRequest.LocationName; con.Location.Contact = new DataModels.ContactCard.ContactCard(); ContactCard.ContactCardFactory.AddAddressToContact(NewRequest.Address, NewRequest.Address1, NewRequest.City, NewRequest.State, NewRequest.Zip, AddressTypeEnum.Bout, con.Location.Contact, dc.Countries.Where(x => x.Code == NewRequest.Country || x.Name == NewRequest.Country).FirstOrDefault()); con.RequestCreator = dc.Members.Where(x => x.MemberId == NewRequest.RequestCreator).FirstOrDefault(); dc.Requests.Add(con); int c = dc.SaveChanges(); //return c > 0; return con.RequestId; } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } return 0; }
public ActionResult EditRequest(RequestDA oRequest) { try { bool execute = RequestFactory.UpdateRequest(oRequest); return Redirect(Url.Content("~/officiating/requests?u=" + SiteMessagesEnum.s)); } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } return Redirect(Url.Content("~/?u=" + SiteMessagesEnum.sww)); }
public static bool UpdateRequest(RequestDA RequestToUpdate) { try { var dc = new ManagementContext(); var dbRequest = dc.Requests.Where(x => x.RequestId == RequestToUpdate.RequestId).FirstOrDefault(); if (dbRequest == null) return false; var country = dc.Countries.Where(x => x.Code == RequestToUpdate.Country).FirstOrDefault(); var card = dbRequest.Location.Contact; dbRequest.Location.LocationName = RequestToUpdate.LocationName; ContactCard.ContactCardFactory.UpdateAddressToContact(RequestToUpdate.Address, RequestToUpdate.Address1, RequestToUpdate.City, RequestToUpdate.State, RequestToUpdate.Zip, AddressTypeEnum.Bout, card, country); dbRequest.Date = RequestToUpdate.Date; dbRequest.Description = RequestToUpdate.Description; dbRequest.EvaluationsProvided = RequestToUpdate.EvaluationsProvided; dbRequest.FirstWhistle = RequestToUpdate.FirstWhistle; dbRequest.IsRegulation = RequestToUpdate.IsRegulation; dbRequest.IsReimbursement = RequestToUpdate.IsReimbursement; dbRequest.IsSnacksProvided = RequestToUpdate.IsSnacksProvided; dbRequest.NonsoNeded = RequestToUpdate.NonsoNeded; dbRequest.NoRefNeded = RequestToUpdate.NoRefNeded; dbRequest.RequestCreator.MemberId = RequestToUpdate.RequestCreator; dbRequest.RuleSetId = RequestToUpdate.RuleSetId; dbRequest.TeamsPlaying = RequestToUpdate.TeamsPlaying; dbRequest.TravelStipendForNSO = RequestToUpdate.TravelStipendForNSO; dbRequest.TravelStipendForRefs = RequestToUpdate.TravelStipendForRefs; int c = dc.SaveChanges(); return c > 0; } catch (Exception exception) { ErrorDatabaseManager.AddException(exception, exception.GetType()); } return false; }
private static RequestDA DisplayRequestList(DataModels.Officials.RefereeRequest oRequest) { RequestDA bl = new RequestDA(); if (oRequest.Location != null) { var loc = Location.LocationFactory.DisplayLocation(oRequest.Location); bl.LocationName = loc.LocationName; var add = loc.Contact.Addresses.FirstOrDefault(); if (add != null) { bl.Address = add.Address1; bl.Address1 = add.Address2; bl.City = add.CityRaw; bl.State = add.StateRaw; bl.Zip = add.Zip; } } bl.Date = oRequest.Date; bl.Description = oRequest.Description; bl.EvaluationsProvided = oRequest.EvaluationsProvided; bl.FirstWhistle = oRequest.FirstWhistle; bl.IsRegulation = oRequest.IsRegulation; bl.IsReimbursement = oRequest.IsReimbursement; bl.IsSnacksProvided = oRequest.IsSnacksProvided; bl.NonsoNeded = oRequest.NonsoNeded; bl.NoRefNeded = oRequest.NoRefNeded; bl.RuleSetId = oRequest.RuleSetId; bl.TeamsPlaying = oRequest.TeamsPlaying; bl.TravelStipendForNSO = oRequest.TravelStipendForNSO; bl.TravelStipendForRefs = oRequest.TravelStipendForRefs; bl.RequestId = oRequest.RequestId; bl.RequestCreator = oRequest.RequestCreator.MemberId; return bl; }