public EventDate UpdateEventDate(EventDate eventDate)
{
var query = SQL
.UPDATE("TicketEventDates")
.SET("TicketEventID = @eventId, VenueID = @venueId, EventStartDateTime = @dateTime, Price = @price, MaxTickets = @maxTickets")
.WHERE("TicketEventDateID = @id");
var values = new
{
eventId = eventDate.TicketEventID,
venueId = eventDate.VenueID,
dateTime = eventDate.EventStartDateTime,
price = eventDate.Price,
maxTickets = eventDate.MaxTickets,
id = eventDate.TicketEventDateID
};
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
connection.Execute(query.ToString(), values);
var result = connection.Query <EventDate>("SELECT * FROM TicketEvents WHERE TicketEventId = @id", new { values.id }).First();
return(result);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="Time" /> class.
/// </summary>
/// <param name="date">The date.</param>
/// <param name="value">The value.</param>
public Time(EventDate date, string value = "")
{
Name = SetName(date);
Date = SetDate(date.ToString());
Day = SetDay(value);
Data = Day.ToString();
}
/// <summary>
/// Get the NFT data for the NFT
/// </summary>
/// <param name="address">Address of the sender</param>
/// <param name="key">Private key of the sender for encryption</param>
/// <param name="receiver">receiver of the NFT</param>
/// <returns></returns>
public override async Task <IDictionary <string, string> > GetMetadata(string address = "", string key = "", string receiver = "")
{
// create token metadata
var metadata = await GetCommonMetadata();
metadata.Add("EventId", EventId);
if (!string.IsNullOrEmpty(AuthorLink))
{
metadata.Add("AuthorLink", AuthorLink);
}
metadata.Add("EventDate", EventDate.ToString());
if (!string.IsNullOrEmpty(VideoLink))
{
metadata.Add("VideoLink", VideoLink);
}
if (MusicInLink)
{
metadata.Add("MusicInLink", "true");
}
metadata.Add("Location", Location);
metadata.Add("LocationC", LocationCoordinates);
metadata.Add("EventClass", Convert.ToInt32(EventClass).ToString());
if (Used)
{
metadata.Add("Used", "true");
}
if (PriceInDoge > 0)
{
metadata.Add("PriceInDoge", Price.ToString(CultureInfo.InvariantCulture));
}
return(metadata);
}
private void AddEventDatesOnCalendar(int id)
{
using (var scope = _scopeFactory.CreateScope())
{
var _context = scope.ServiceProvider.GetRequiredService <ApplicationDbContext>();
var calendar = _context.Events.Include(x => x.EventDateTemplates).Include(x => x.EventDates).ThenInclude(x => x.Teilnahmen).Include(x => x.Members).ThenInclude(x => x.ChatUserModel).Where(x => x.Id == id).FirstOrDefault();
if (calendar != null)
{
// Next 2 weeks
for (int week = 0; week < 2; week++)
{
foreach (EventDateTemplate template in calendar.EventDateTemplates)
{
EventDate eventdate = template.CreateEventDate(week);
eventdate.EventDateTemplateID = template.ID;
if (calendar.EventDates.Where(x => x.Date == eventdate.Date).Count() == 0)
{
eventdate.Teilnahmen = calendar.GenerateAppointmentRequests(eventdate);
_context.EventDates.Add(eventdate);
calendar.EventDates.Add(eventdate);
}
}
}
_context.SaveChanges();
}
}
}
// GET: EventDates/Delete/5
public ActionResult Delete(int?id, int?filter)
{
if (id == null || filter == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventDate eventDateList = db.EventDates.Where(o => o.ID == id).FirstOrDefault();
//EventDate eventDate = db.EventDates.Find(id);
EventDateDisplayObject edDO = new EventDateDisplayObject();
edDO.Agendas = db.Agendas.Where(o => o.EventDateID == id).ToList();
edDO.EventDate = eventDateList;
ViewBag.FilterID = filter;
return(View(edDO));
//if (id == null || filter == null)
//{
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//}
//int getID = id ?? default(int);
//EventDate eventDate = db.EventDates.Find(getID);
//if (eventDate == null)
//{
// return HttpNotFound();
//}
//ViewBag.FilterID = filter;
//return View(eventDate);
}
public IActionResult Index(EventDateDto eventDateDto)
{
EventDate eventDate = _mapper.Map <EventDate>(eventDateDto);
ViewBag.date = eventDate.Date.ToShortDateString();
return(View());
}
public string GetShareBodyText(Team team, EventWave eventWave, User user, EventDate eventDate,
bool includeJavascriptLineBreaks)
{
if (team == null || user == null || eventDate == null)
{
return(string.Empty);
}
var filePath = HostingEnvironment.MapPath(string.Format("~/{0}/{1}", DirtyGirlServiceConfig.Settings.EmailTemplatePath,
DirtyGirlServiceConfig.Settings.TeamInviteBody)) ?? "";
var bodyText =
System.IO.File.ReadAllText(filePath)
.Replace("{RegistrantName}",
string.Format("{0} {1}", user.FirstName, user.LastName))
.Replace("{EventID}", team.Event.EventId.ToString())
.Replace("{RaceLocation}", team.Event.GeneralLocality)
.Replace("{DayOfWeek}", eventDate.DateOfEvent.ToString("dddd"))
.Replace("{Month}", eventDate.DateOfEvent.ToString("MMMM"))
.Replace("{Day}", eventDate.DateOfEvent.ToString("dd"))
.Replace("{Year}", eventDate.DateOfEvent.ToString("yyyy"))
.Replace("{WaveNumber}", eventWave.EventWaveId.ToString())
.Replace("{BeginTime}", eventWave.StartTime.ToString("hh:mm tt"))
.Replace("{EndTime}", eventWave.EndTime.ToString("hh:mm tt"))
.Replace("{TeamCode}", team.Code)
.Replace("{LineBreak}", (includeJavascriptLineBreaks ? "\\" : ""));
return(bodyText);
}
public bool Update(EventDateForUpdateDto eventDateForUpdate)
{
try
{
var eventDateDto = GetById(eventDateForUpdate.id);
if (eventDateDto == null)
{
return(false);
}
EventDate DataEntity = _mapper.Map <EventDate>(eventDateDto);
_mapper.Map(eventDateForUpdate, DataEntity);
_repository.Update(DataEntity);
_repository.Save();
_logger.LogError($"Updated EventDate with id: {DataEntity.id}");
return(true);
}
catch (Exception ex)
{
_logger.LogError($"Something went wrong inside UpdateEventDate action: {ex.Message}");
throw new Exception();
}
}
protected override bool Execute(CodeActivityContext context)
{
List <int> id_List = ListSectionID.Get(context);
DateTimeOffset _EventDate = EventDate.Get(context);
bool roundData = RoundData.Get(context);
if (id_List == null || id_List.Count == 0)
{
Error.Set(context, "Список секций не может быть пустым");
return(false);
}
try
{
Stream Res = ARM_Service.XMLExportGetSection80020ForSectionArray(_EventDate, id_List, DataSourceType, BusRelation, roundData, false, TimeZoneId, true, false, false, 1, true).XMLStream;
MemoryStream ms = new MemoryStream();
Res.CopyTo(ms);
ms.Position = 0;
Document.Set(context, ms);
}
catch (Exception ex)
{
Error.Set(context, ex.Message);
if (!HideException.Get(context))
{
throw ex;
}
}
return(string.IsNullOrEmpty(Error.Get(context)));
}
protected override bool Execute(CodeActivityContext context)
{
List <int> ps_id_List = ListPsId.Get(context);
DateTime _EventDate = EventDate.Get(context);
bool roundData = RoundData.Get(context);
if (ps_id_List == null || ps_id_List.Count == 0)
{
Error.Set(context, "Список ПС не может быть пустым");
return(false);
}
try
{
Stream Res = ARM_Service.XMLExportGetPS80020ForPSArray(_EventDate, ps_id_List, DataSourceType, requiredATSCode, isReadCalculatedValues, roundData, false, UTCTimeShiftFromMoscow, false, false, 1, true).XMLStream;
MemoryStream ms = new MemoryStream();
Res.CopyTo(ms);
ms.Position = 0;
Document.Set(context, ms);
}
catch (Exception ex)
{
Error.Set(context, ex.Message);
if (!HideException.Get(context))
{
throw ex;
}
}
return(string.IsNullOrEmpty(Error.Get(context)));
}
/// <summary>
/// Initializes a new instance of the <see cref="Time" /> class.
/// </summary>
/// <param name="datarow">The data.</param>
/// <param name="date">The date.</param>
public Time(DataRow datarow, EventDate date)
{
Date = SetDate(datarow, date);
Name = SetName(datarow, date);
Day = SetDay(datarow, date);
Data = Day.ToString();
}
protected override bool Execute(CodeActivityContext context)
{
string _AisId = AisId.Get(context);
DateTimeOffset _EventDate = EventDate.Get(context);
bool roundData = RoundData.Get(context);
if (string.IsNullOrEmpty(_AisId))
{
Error.Set(context, "Идентификатор АИС не может быть пустым");
return(false);
}
try
{
XMLATSExportSingleObjectResultCompressed Res = ARM_Service.XMLExportGetAIS80020(_EventDate, _AisId, DataSourceType, isReadCalculatedValues, roundData, false, false, false, false, 1, true);
if (!string.IsNullOrEmpty(Res.Errors))
{
Error.Set(context, Res.Errors);
}
Document.Set(context, Res.XMLStreamCompressed);
}
catch (Exception ex)
{
Error.Set(context, ex.Message);
if (!HideException.Get(context))
{
throw ex;
}
}
return(string.IsNullOrEmpty(Error.Get(context)));
}
public ServiceResult RemoveEventDate(int eventDateId)
{
var result = new ServiceResult();
try
{
EventDate dateToDelete = _repository.EventDates.Find(x => x.EventDateId == eventDateId);
List <int> waveIds = dateToDelete.EventWaves.Select(x => x.EventWaveId).ToList();
foreach (int waveId in waveIds)
{
EventWave wave = dateToDelete.EventWaves.Single(x => x.EventWaveId == waveId);
if (CanRemoveEventWave(wave, result))
{
_repository.EventWaves.Delete(wave);
}
}
if (result.Success && CanRemoveEventDate(dateToDelete, result))
{
_repository.EventDates.Delete(dateToDelete);
_repository.SaveChanges();
}
}
catch (Exception ex)
{
result.AddServiceError(Utilities.GetInnerMostException(ex));
}
return(result);
}
public ServiceResult UpdateEventDate(EventDate ed)
{
var result = new ServiceResult();
try
{
if (ValidateEventDate(ed, result))
{
EventDate updateDate = _repository.EventDates.Find(x => x.EventDateId == ed.EventDateId);
updateDate.DateOfEvent = ed.DateOfEvent;
foreach (EventWave w in updateDate.EventWaves)
{
w.StartTime = new DateTime(ed.DateOfEvent.Year, ed.DateOfEvent.Month, ed.DateOfEvent.Day,
w.StartTime.Hour, w.StartTime.Minute, w.StartTime.Second);
w.EndTime = new DateTime(ed.DateOfEvent.Year, ed.DateOfEvent.Month, ed.DateOfEvent.Day,
w.EndTime.Hour, w.EndTime.Minute, w.EndTime.Second);
}
_repository.SaveChanges();
}
}
catch (Exception ex)
{
result.AddServiceError(Utilities.GetInnerMostException(ex));
}
return(result);
}
//
//Кнопка, переносит данные в основную таблицу.
//
private void Transfer_Button_Click(object sender, EventArgs e)
{
var archiveEvent = SearchingObject();
var addEventForm = new AddEventForm();
LoadDate_ComboBox(addEventForm);
addEventForm.comboBox1.Text = archiveEvent.vCalendar.ToString();
addEventForm.comboBox2.Text = archiveEvent.vListofCases.ToString();
addEventForm.comboBox1.Enabled = false;
addEventForm.dateTimePicker1.Value = Convert.ToDateTime(archiveEvent.StartTime);
addEventForm.dateTimePicker2.Value = Convert.ToDateTime(archiveEvent.EndTime);
DialogResult result = addEventForm.ShowDialog(this);
if (result == DialogResult.OK)
{
try
{
var eventDate = new EventDate();
eventDate.vListofCases = (ListofCases)addEventForm.comboBox1.SelectedItem;
eventDate.vCalendar = (Calendar)addEventForm.comboBox2.SelectedItem;
eventDate.StartTime = addEventForm.dateTimePicker1.Value.ToShortTimeString();
eventDate.EndTime = addEventForm.dateTimePicker2.Value.ToShortTimeString();
eventDate.MarkEventSet();
db.DBEventDate.Add(eventDate);
db.DBArchiveEvents.Remove(archiveEvent);
db.SaveChanges();
MessageBox.Show("Объект восстановлен!", "Оповещение", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source, MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
dataGridView1.Refresh();
}
public ActionResult DeleteConfirmed(int id)
{
EventDate eventDate = db.EventDates.Find(id);
db.EventDates.Remove(eventDate);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteEventDate(int eventDateId, int eventId)
{
EventDate eventDate = eFactory.edRepository.Get(eventDateId);
eFactory.edRepository.Remove(eventDate);
eFactory.edRepository.Complete();
return(RedirectToAction("Create3", new { eventId = eventId }));
}
public void Update(EventDate event_date)
{
EventDate eventDate = _eventDates.FirstOrDefault(ed => ed.id == event_date.id);
if (eventDate != null)
{
eventDate = event_date;
}
}
/// <summary>
/// Gets an XOR based hash code based on the contents of this object.
/// </summary>
public override int GetHashCode()
{
return(base.GetHashCode() ^
SourceId.GetHashCode() ^
(SourceAssemblyName != null ? SourceAssemblyName.GetHashCode() : 0) ^
EventDate.GetHashCode() ^
(Message != null ? Message.GetHashCode() : 0) ^
(ErrorTypeFullName != null ? ErrorTypeFullName.GetHashCode() : 0) ^
(StackTrace != null ? StackTrace.GetHashCode() : 0));
}
public virtual IActionResult UpdateEventDate([FromBody] EventDate eventDate)
{
var result = _eventDateRepository.UpdateEventDate(eventDate);
if (result == null)
{
return(NotFound());
}
return(new ObjectResult(result));
}
public virtual IActionResult AddEventDate([FromBody] EventDate body)
{
var result = _eventDateRepository.AddEventDate(body);
if (result == null)
{
return(BadRequest());
}
return(new ObjectResult(result));
}
public static EventDateDto ToDTO(this EventDate entity)
{
return(new EventDateDto
{
Id = entity.Id,
Beginning = entity.Beginning,
Ending = entity.Ending,
AllDay = entity.AllDay
});
}
public ActionResult Edit([Bind(Include = "Id,Date")] EventDate eventDate)
{
if (ModelState.IsValid)
{
db.Entry(eventDate).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(eventDate));
}
public override string ToString()
{
return(EventDate.ToString("HH:mm", CultureInfo.InvariantCulture) + "-"
// + EventToDate != null ? EventToDate.Value.ToString("HH:mm", CultureInfo.InvariantCulture) : string.Empty
+ " " + BuildingName
+ "-" + Event
+ "-" + PM
+ "-" + Venue
+ Room != string.Empty ? "-" + Room : "");
}
public ActionResult Create([Bind(Include = "Id,Date")] EventDate eventDate)
{
if (ModelState.IsValid)
{
db.EventDates.Add(eventDate);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(eventDate));
}
public ushort GetYear()
{
if (EventDate != null && EventDate.Length == 10)
{
return(Convert.ToUInt16(EventDate.Substring(6)));
}
else
{
return(0);
}
}
public void WriteXml(XmlWriter writer, string elementName, string type)
{
writer.WriteStartElement(elementName);
writer.WriteAttributeString(type, this.GetType().Name);
writer.WriteAttributeString(nameof(this.EventDate),
EventDate?.ToString(Constants.DateTimeFormat) ?? "NULL");
writer.WriteAttributeString(nameof(this.Title), this.Title);
writer.WriteAttributeString(nameof(this.IsWarrantyEvent), this.IsWarrantyEvent.ToString());
writer.WriteEndElement();
}
public ActionResult EventSelection(Guid itemId, int?eventId, int?eventDateId, int?eventWaveId, bool?returnToRegDetails, bool?redemption)
{
int eId = (eventId.HasValue)? eventId.Value : 0;
var vm = new vmRegistration_EventSelection
{
ItemId = itemId,
CartFocus = SessionManager.CurrentCart.CheckOutFocus,
EventOverview = (eventId.HasValue && eventId > 0 ? _service.GetEventOverviewById(eId) : new EventOverview()),
EventDateCount = (eventId.HasValue && eventId > 0 ? GetEventDateCount(eId) : 0),
LockEvent = true,
ReturnToRegistrationDetails = false
};
if (eventWaveId.HasValue)
{
EventWave selectedWave = _service.GetEventWaveById(eventWaveId.Value);
vm.EventId = selectedWave.EventDate.EventId;
vm.EventDateId = selectedWave.EventDateId;
vm.EventWaveId = selectedWave.EventWaveId;
}
else if (eventDateId.HasValue)
{
EventDate selectedDate = _service.GetEventDateById(eventDateId.Value);
vm.EventId = selectedDate.EventId;
vm.EventDateId = selectedDate.EventDateId;
}
else if (eventId.HasValue)
{
Event selectedEvent = _service.GetEventById(eventId.Value);
vm.EventId = eventId.Value;
vm.EventDateId = selectedEvent.EventDates.First().EventDateId;
vm.EventName = selectedEvent.GeneralLocality;
}
// did the cart timeout?
if (!SessionManager.CurrentCart.ActionItems.ContainsKey(itemId))
{
return(RedirectToAction("Index", "home"));
}
if (SessionManager.CurrentCart.ActionItems[itemId].ActionType == CartActionType.EventChange ||
SessionManager.CurrentCart.CheckOutFocus == CartFocusType.Redemption)
{
vm.LockEvent = false;
}
if (returnToRegDetails.HasValue && returnToRegDetails.Value == true)
{
vm.ReturnToRegistrationDetails = true;
}
return(View(vm));
}
/// <summary>
/// Updates a specific EventDate based on it's ID
/// </summary>
/// <returns>EventDate</returns>
public EventDate Put([FromBody] EventDate eventdate)
{
if (String.IsNullOrEmpty(eventdate.EventDateId))
{
eventdate.EventDateId = Guid.NewGuid().ToString();
}
this.OnBeforePut(eventdate);
this.SDM.Upsert(eventdate);
this.OnAfterPut(eventdate);
return(eventdate);
}
public EventDate UpdateEventDate(EventDate eventDate)
{
var outVar = eventDate.ToJson();
var client = new RestClient(_baseUrl);
var request = new RestRequest("api/event", Method.PUT);
request.AddParameter("application/json", outVar, ParameterType.RequestBody);
var response = client.Execute <EventDate>(request);
return(response.Data);
}
