public IHttpActionResult PutEventsTable(int id, EventsTable eventsTable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != eventsTable.EventId)
{
return(BadRequest());
}
db.Entry(eventsTable).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EventsTableExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public JsonResult SaveEvent(EventsTable e)
{
var status = false;
using (Database1Entities dc = new Database1Entities())
{
if (e.EventID > 0)
{
//update the event
var v = dc.EventsTables.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
v.Subject = e.Subject;
v.Start = e.Start;
v.End = e.End;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColor = e.ThemeColor;
}
}
else
{
dc.EventsTables.Add(e);
}
dc.SaveChanges();
status = true;
}
return(new JsonResult()
{
Data = new { status = status }
});
}
private static GeneratedType buildAppendEventOperation(EventGraph graph, GeneratedAssembly assembly)
{
var operationType = assembly.AddType("AppendEventOperation", typeof(AppendEventOperationBase));
var configure = operationType.MethodFor(nameof(AppendEventOperationBase.ConfigureCommand));
configure.DerivedVariables.Add(new Variable(typeof(IEvent), nameof(AppendEventOperationBase.Event)));
configure.DerivedVariables.Add(new Variable(typeof(StreamAction), nameof(AppendEventOperationBase.Stream)));
var columns = new EventsTable(graph).SelectColumns()
// Hokey, use an explicit model for writeable vs readable columns some day
.Where(x => !(x is IsArchivedColumn)).ToList();
var sql =
$"insert into {graph.DatabaseSchemaName}.mt_events ({columns.Select(x => x.Name).Join(", ")}) values ({columns.Select(_ => "?").Join(", ")})";
configure.Frames.Code($"var parameters = {{0}}.{nameof(CommandBuilder.AppendWithParameters)}(\"{sql}\");",
Use.Type <CommandBuilder>());
for (var i = 0; i < columns.Count; i++)
{
columns[i].GenerateAppendCode(configure, graph, i);
}
return(operationType);
}
public IHttpActionResult DeleteEventsTable(int id)
{
EventsTable eventsTable = db.EventsTables.Find(id);
var sub = from n in db.SubscriptionTables where n.Event_Id == id select n;
var book = from n in db.BookingTables where n.EventId == id select n;
SubscriptionTable st = (SubscriptionTable)sub.FirstOrDefault();
BookingTable bt = (BookingTable)book.FirstOrDefault();
if (st != null)
{
db.SubscriptionTables.Remove(st);
db.SaveChanges();
}
if (bt != null)
{
db.BookingTables.Remove(bt);
db.SaveChanges();
}
//EventsTable eventsTable = db.EventsTables.Find(id);
if (eventsTable == null)
{
return(NotFound());
}
db.EventsTables.Remove(eventsTable);
db.SaveChanges();
return(Ok(eventsTable));
}
private void Button1_Click(object sender, EventArgs e)
{
switch (comboBox2.SelectedIndex)
{
case 0:
EventsTable eventsTable = new EventsTable();
eventsTable.Show();
break;
case 1:
WorkersTable workersTable = new WorkersTable();
workersTable.Show();
break;
case 2:
DocsTable docsTable = new DocsTable();
docsTable.Show();
break;
case 3:
AppointmentsTable appointmentsTable = new AppointmentsTable();
appointmentsTable.Show();
break;
case 4:
CompaniesTable companiesTable = new CompaniesTable();
companiesTable.Show();
break;
}
}
public ActionResult DeleteConfirmed(int id)
{
EventsTable eventsTable = db.EventsTables.Find(id);
db.EventsTables.Remove(eventsTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void Initialize()
{
OpenConnections();
Users = new UsersTable(this);
Notes = new NotesTable(this);
UserEvents = new UserEventsTable(this);
Insurances = new InsurancesTable(this);
Events = new EventsTable(this);
}
public EventModel CreateEvent([FromBody] EventModel em)
{
if (em == null)
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
return(EventsTable.Create(em));
}
public ActionResult Edit([Bind(Include = "eventID,eventName,eventDescription,creditsToEarn,qrCodeString")] EventsTable eventsTable)
{
if (ModelState.IsValid)
{
db.Entry(eventsTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(eventsTable));
}
public async Task <List <BusinessEvent> > GetEvents(DateTimeOffset?lastEventRaised = null)
{
var(events, _) = await EventsTable.FoldEventsAsync(
this.GetPrimaryKey(),
(result, curr) => { result.Add(curr); return(result); },
() => new List <BusinessEvent>(),
lastEventRaised);
return(events);
}
public ActionResult Create([Bind(Include = "eventID,eventName,eventDescription,creditsToEarn,qrCodeString")] EventsTable eventsTable)
{
if (ModelState.IsValid)
{
db.EventsTables.Add(eventsTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(eventsTable));
}
public virtual void Delete()
{
if (this.IsNewRecord)
{
return;
}
KeyValue pkValue = KeyValue.XmlToKey(this.RecordUniqueId);
EventsTable.DeleteRecord(pkValue);
}
public IHttpActionResult GetEventsTable(int id)
{
EventsTable eventsTable = db.EventsTables.Find(id);
if (eventsTable == null)
{
return(NotFound());
}
return(Ok(eventsTable));
}
public async Task <BusinessEvent> RecordEventPayload <T>(int businessEventEnum, T payload)
{
var e = new BusinessEvent <T>(businessEventEnum, payload)
{
PartitionKey = this.GetPrimaryKey().ToString("D"),
};
var tableOperation = TableOperation.Insert(e);
await EventsTable.ExecuteAsync(tableOperation);
return(e);
}
// GET: EventsTables/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventsTable eventsTable = db.EventsTables.Find(id);
if (eventsTable == null)
{
return(HttpNotFound());
}
return(View(eventsTable));
}
public frmNewEdit(EventsTable obj)
{
InitializeComponent();
db = new EventsEntities();
if (obj == null)
{
eventsTableBindingSource.DataSource = new EventsTable();
db.EventsTable.Add(eventsTableBindingSource.Current as EventsTable);
}
else
{
eventsTableBindingSource.DataSource = obj;
db.EventsTable.Attach(eventsTableBindingSource.Current as EventsTable);
}
}
private static void buildSelectorMethods(StoreOptions options, GeneratedType builderType)
{
var sync = builderType.MethodFor(nameof(EventDocumentStorage.ApplyReaderDataToEvent));
var async = builderType.MethodFor(nameof(EventDocumentStorage.ApplyReaderDataToEventAsync));
// The json data column has to go first
var table = new EventsTable(options.EventGraph);
var columns = table.SelectColumns();
for (var i = 3; i < columns.Count; i++)
{
columns[i].GenerateSelectorCodeSync(sync, options.EventGraph, i);
columns[i].GenerateSelectorCodeAsync(async, options.EventGraph, i);
}
}
public virtual EventsRecord GetRecord()
{
if (this.DataSource != null)
{
return(this.DataSource);
}
if (this.RecordUniqueId != null)
{
return(EventsTable.GetRecord(this.RecordUniqueId, true));
}
// Localization.
throw new Exception(Page.GetResourceValue("Err:RetrieveRec", "OLR"));
}
public virtual void LoadData()
{
// Load the data from the database into the DataSource DatabaseOLR_db%dbo.Events record.
// It is better to make changes to functions called by LoadData such as
// CreateWhereClause, rather than making changes here.
// The RecordUniqueId is set the first time a record is loaded, and is
// used during a PostBack to load the record.
if (this.RecordUniqueId != null && this.RecordUniqueId.Length > 0)
{
this.DataSource = EventsTable.GetRecord(this.RecordUniqueId, true);
return;
}
// This is the first time a record is being retrieved from the database.
// So create a Where Clause based on the staic Where clause specified
// on the Query wizard and the dynamic part specified by the end user
// on the search and filter controls (if any).
WhereClause wc = this.CreateWhereClause();
// If there is no Where clause, then simply create a new, blank record.
if (wc == null || !(wc.RunQuery))
{
this.DataSource = new EventsRecord();
return;
}
// Retrieve the record from the database. It is possible
EventsRecord[] recList = EventsTable.GetRecords(wc, null, 0, 2);
if (recList.Length == 0)
{
// There is no data for this Where clause.
wc.RunQuery = false;
return;
}
// Set DataSource based on record retrieved from the database.
this.DataSource = (EventsRecord)EventsRecord.Copy(recList[0], false);
}
public IHttpActionResult PostEventsTable(EventsTable eventsTable)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.EventsTables.Add(eventsTable);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = eventsTable.EventId }, eventsTable));
}
catch
{
return(NotFound());
}
}
public IActionResult UpdateBet(int id)
{
RecordOfBets bet = _context.RecordOfBets.Find(id);
EventsTable betEvent = _context.EventsTable.Find(bet.EventId);
//gets the points spread and use a random number gen to get winner and set score for the eventstable
betEvent.EventStatus = "STATUS_FINAL";
//gets base score for both teams, used for all lines
Random random = new Random();
var baseScore = random.Next(0, 35);
//sportid: 2 = NFL, 4 = NBA
betEvent.HomeScore = GenScore(betEvent.SportId);
betEvent.AwayScore = GenScore(betEvent.SportId);
_context.EventsTable.Update(betEvent);
_context.SaveChanges(); //activate BetPayoutCheck();
return(RedirectToAction("PayoutCheck", "Home", new { eventId = betEvent.EventId }));
}
public double GetBetType(EventsTable betType)
{
if (betType != null)
{
var currentGameBetSpreadAway = betType.PointSpreadAwayMoney;
var currentGameBetSpreadHome = betType.PointSpreadHomeMoney;
var currentGameBetTotalOver = betType.TotalOverMoney;
var currentGameBetTotalUnder = betType.TotalUnderMoney;
foreach (EventsTable entry in _context.EventsTable)
{
//narrow down record
if (entry.EventId == betType.EventId && entry.PointSpreadAwayMoney == betType.PointSpreadAwayMoney)
{
currentGameBetSpreadAway += entry.PointSpreadAwayMoney;
return(currentGameBetSpreadAway);
}
else if (entry.EventId == betType.EventId && entry.PointSpreadHomeMoney == betType.PointSpreadHomeMoney)
{
currentGameBetSpreadHome += entry.PointSpreadHomeMoney;
return(currentGameBetSpreadHome);
}
else if (entry.EventId == betType.EventId && entry.TotalOverMoney == betType.TotalOverMoney)
{
currentGameBetTotalOver += entry.TotalOverMoney;
return(currentGameBetTotalOver);
}
else if (entry.EventId == betType.EventId && entry.TotalUnderMoney == betType.TotalUnderMoney)
{
currentGameBetTotalUnder += entry.TotalUnderMoney;
return(currentGameBetTotalUnder);
}
}
}
return(0);
}
public IActionResult ViewEvent(string eventId)
{
EventsTable temp = _context.EventsTable.Find(eventId);
return(View(temp));
}
private DataTable GroupBy()
{
DataView dv = new DataView(EventsTable);
IEnumerable <string> GroupByCols = _outputColumns.Where(col => !(col is AggregatedOutputColumn) && !(col.Hidden)).Select(col => col.Name);
//getting distinct values for group columns
DataTable dtGroup = dv.ToTable(true, GroupByCols.ToArray());
//Extract AggregatedColumns
List <AggregatedOutputColumn> outCols = new List <AggregatedOutputColumn>(_outputColumns.Where(col => col is AggregatedOutputColumn).Select(col => new AggregatedOutputColumn(col)));
//adding columns for the aggregations
foreach (var col in outCols)
{
Type t = null;
// set the base type on the aggregation:
// - MIN /MAX means use the base column type
// - all other aggregations mean Int32
if (!(col.Aggregation == AggregatedOutputColumn.AggregationType.Max || col.Aggregation == AggregatedOutputColumn.AggregationType.Min))
{
t = typeof(Int32);
}
else if (EventsTable.Columns.Contains(col.BaseColumn))
{
t = EventsTable.Columns[col.BaseColumn].DataType;
}
else
{
throw new InvalidExpressionException(String.Format("The base column '{0}' for the aggregated column '{1}' was not found. Please correct your expression.", col.BaseColumn, col.Alias));
}
dtGroup.Columns.Add(col.Alias, t);
}
try
{
//looping thru distinct values for the group
foreach (DataRow dr in dtGroup.Rows)
{
foreach (var col in outCols)
{
string filterString = " 1 = 1 ";
foreach (var grp in GroupByCols)
{
filterString += String.Format(" AND {0} = '{1}' ", EscapeColumnName(grp), EscapeFilterValue(dr[grp].ToString()));
}
dr[col.Alias] = EventsTable.Compute(col.Expression, filterString);
}
}
}
catch (Exception e)
{
logger.Trace(e, "Something went wrong during the aggregation.");
throw e;
}
// Set all columns as visible
foreach (DataColumn dc in dtGroup.Columns)
{
if (dc.ExtendedProperties.Contains("hidden"))
{
dc.ExtendedProperties["hidden"] = false;
}
else
{
dc.ExtendedProperties.Add("hidden", false);
}
}
return(dtGroup);
}
public virtual void SetEventId()
{
string selectedValue = null;
// figure out the selectedValue
// Set the EventId QuickSelector on the webpage with value from the
// DatabaseOLR_db%dbo.RegistrationTypes database record.
// this.DataSource is the DatabaseOLR_db%dbo.RegistrationTypes record retrieved from the database.
// this.EventId is the ASP:QuickSelector on the webpage.
// You can modify this method directly, or replace it with a call to
// base.SetEventId();
// and add your own custom code before or after the call to the base function.
if (this.DataSource != null && this.DataSource.EventIdSpecified)
{
// If the EventId is non-NULL, then format the value.
// The Format method will return the Display Foreign Key As (DFKA) value
selectedValue = this.DataSource.EventId.ToString();
}
else
{
// EventId is NULL in the database, so use the Default Value.
// Default Value could also be NULL.
if (this.DataSource != null && this.DataSource.IsCreated)
{
selectedValue = null;
}
else
{
selectedValue = RegistrationTypesTable.EventId.DefaultValue;
}
}
// Add the Please Select item.
if (selectedValue == null || selectedValue == "")
{
MiscUtils.ResetSelectedItem(this.EventId, new ListItem(this.Page.GetResourceValue("Txt:PleaseSelect", "OLR"), "--PLEASE_SELECT--"));
}
// Populate the item(s) to the control
this.EventId.SetFieldMaxLength(50);
System.Collections.Generic.IDictionary <string, object> variables = new System.Collections.Generic.Dictionary <string, object>();
FormulaEvaluator evaluator = new FormulaEvaluator();
if (selectedValue != null &&
selectedValue.Trim() != "" &&
!MiscUtils.SetSelectedValue(this.EventId, selectedValue) &&
!MiscUtils.SetSelectedDisplayText(this.EventId, selectedValue))
{
// construct a whereclause to query a record with DatabaseOLR_db%dbo.Events.EventId = selectedValue
CompoundFilter filter2 = new CompoundFilter(CompoundFilter.CompoundingOperators.And_Operator, null);
WhereClause whereClause2 = new WhereClause();
filter2.AddFilter(new BaseClasses.Data.ColumnValueFilter(EventsTable.EventId, selectedValue, BaseClasses.Data.BaseFilter.ComparisonOperator.EqualsTo, false));
whereClause2.AddFilter(filter2, CompoundFilter.CompoundingOperators.And_Operator);
// Execute the query
try
{
EventsRecord[] rc = EventsTable.GetRecords(whereClause2, new OrderBy(false, false), 0, 1);
System.Collections.Generic.IDictionary <string, object> vars = new System.Collections.Generic.Dictionary <string, object> ();
// if find a record, add it to the dropdown and set it as selected item
if (rc != null && rc.Length == 1)
{
EventsRecord itemValue = rc[0];
string cvalue = null;
string fvalue = null;
if (itemValue.EventIdSpecified)
{
cvalue = itemValue.EventId.ToString();
}
Boolean _isExpandableNonCompositeForeignKey = RegistrationTypesTable.Instance.TableDefinition.IsExpandableNonCompositeForeignKey(RegistrationTypesTable.EventId);
if (_isExpandableNonCompositeForeignKey && RegistrationTypesTable.EventId.IsApplyDisplayAs)
{
fvalue = RegistrationTypesTable.GetDFKA(itemValue, RegistrationTypesTable.EventId);
}
if ((!_isExpandableNonCompositeForeignKey) || (String.IsNullOrEmpty(fvalue)))
{
fvalue = itemValue.Format(EventsTable.EventId);
}
if (fvalue == null || fvalue.Trim() == "")
{
fvalue = cvalue;
}
MiscUtils.ResetSelectedItem(this.EventId, new ListItem(fvalue, cvalue));
}
}
catch
{
}
}
string url = this.ModifyRedirectUrl("../Events/Events-QuickSelector.aspx", "", true);
url = this.Page.ModifyRedirectUrl(url, "", true);
url += "?Target=" + this.EventId.ClientID + "&Formula=" + (this.Page as BaseApplicationPage).Encrypt("=Events.EventName") + "&IndexField=" + (this.Page as BaseApplicationPage).Encrypt("EventId") + "&EmptyValue=" + (this.Page as BaseApplicationPage).Encrypt("--PLEASE_SELECT--") + "&EmptyDisplayText=" + (this.Page as BaseApplicationPage).Encrypt(this.Page.GetResourceValue("Txt:PleaseSelect")) + "&Mode=" + (this.Page as BaseApplicationPage).Encrypt("FieldValueSingleSelection") + "&RedirectStyle=" + (this.Page as BaseApplicationPage).Encrypt("Popup");
this.EventId.Attributes["onClick"] = "initializePopupPage(this, '" + url + "', " + Convert.ToString(EventId.AutoPostBack).ToLower() + ", event); return false;";
}
public double CalculateTheProbabilty(EventsTable betType)
{
return(GetBetType(betType) / (GetBetType(betType) + 100) * 100);
//return 100 / (GetBetType(betType) + 100) * 100;
}
public IActionResult CreateBet(string _eventId, string _BetType, string _eventTime, string _betTeam, string _odd, float _moneyline)
{
//Ivo: Do we need the id of the user anywhere here?
//ticker stuff
List <TickerGames> tempTickerGames = new List <TickerGames>();
//ticker games we have bets on
foreach (RecordOfBets bets in _context.RecordOfBets.Where(b => b.UserId == User.FindFirst(ClaimTypes.NameIdentifier).Value).ToList())
{
TickerGames newTickerGame = new TickerGames();
EventsTable item = _context.EventsTable.Find(bets.EventId);
if (bets.EventId == item.EventId)
{
newTickerGame.FavoritedEvent = true;
}
newTickerGame.HomeTeam = item.HomeTeam;
newTickerGame.AwayTeam = item.AwayTeam;
newTickerGame.TimeOfEvent = item.EventDate;
newTickerGame.EventId = item.EventId;
newTickerGame.HomeSpread = (float)item.SpreadHome;
newTickerGame.AwaySpread = (float)item.SpreadAway;
newTickerGame.HomeMoneyline = (float)item.MoneyLineHome;
newTickerGame.AwayMoneyline = (float)item.MoneyLineAway;
newTickerGame.HomeTotal = (float)item.TotalHome;
newTickerGame.AwayTotal = (float)item.TotalAway;
newTickerGame.HomeSpreadMoneyLine = (float)item.PointSpreadHomeMoney;
newTickerGame.AwaySpreadMoneyLine = (float)item.PointSpreadAwayMoney;
newTickerGame.HomeTotalMoneyLine = (float)item.TotalUnderMoney;
newTickerGame.AwayTotalMoneyLine = (float)item.TotalUnderMoney;
if (!tempTickerGames.Contains(newTickerGame))
{
tempTickerGames.Add(newTickerGame);
}
}
foreach (EventsTable item in _context.EventsTable.ToList())
{
TickerGames newTickerGame = new TickerGames();
newTickerGame.HomeTeam = item.HomeTeam;
newTickerGame.AwayTeam = item.AwayTeam;
newTickerGame.TimeOfEvent = item.EventDate;
newTickerGame.EventId = item.EventId;
newTickerGame.HomeSpread = (float)item.SpreadHome;
newTickerGame.AwaySpread = (float)item.SpreadAway;
newTickerGame.HomeMoneyline = (float)item.MoneyLineHome;
newTickerGame.AwayMoneyline = (float)item.MoneyLineAway;
newTickerGame.HomeTotal = (float)item.TotalHome;
newTickerGame.AwayTotal = (float)item.TotalAway;
newTickerGame.HomeSpreadMoneyLine = (float)item.PointSpreadHomeMoney;
newTickerGame.AwaySpreadMoneyLine = (float)item.PointSpreadAwayMoney;
newTickerGame.HomeTotalMoneyLine = (float)item.TotalUnderMoney;
newTickerGame.AwayTotalMoneyLine = (float)item.TotalUnderMoney;
if (!tempTickerGames.Contains(newTickerGame))
{
tempTickerGames.Add(newTickerGame);
}
}
betPlacingModel.TickerGames = tempTickerGames;
//event info
betPlacingModel.BetType = _BetType;
betPlacingModel.EventDate = DateTime.Parse(_eventTime);
betPlacingModel.Event = _context.EventsTable.Find(_eventId);
betPlacingModel.Odd = _odd;
betPlacingModel.BetTeam = _betTeam;
betPlacingModel.BetMoneyLine = _moneyline;
betPlacingModel.Event = _context.EventsTable.Find(_eventId);
return(View("BetPlacement", betPlacingModel));
}
