public override List <object> SqlList(string sql, int limit = 0, int offset = 0) { List <object> categoryList = new List <object>(); dbEntities = new mpi_dbEntities(); var Events = dbEntities.events .SqlQuery(sql ). Select(@event => new { @event }); if (limit > 0) { Events = Events.Skip(offset * limit).Take(limit).ToList(); } else { Events = Events.ToList(); } foreach (var u in Events) { @event @event = u.@event; categoryList.Add(@event); } count = countSQL(sql, dbEntities.events); return(categoryList); }
public override BaseEntity Add(object Obj) { @event @event = (@event)Obj; dbEntities = new mpi_dbEntities(); @event.created_date = DateTime .Now; @event newEvent = dbEntities.events.Add(@event); try { dbEntities.SaveChanges(); return(newEvent); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; // return null; } }
public override BaseEntity GetById(object Id) { dbEntities = new mpi_dbEntities(); @event @event = (from o in dbEntities.events where o.id == (int)Id select o).SingleOrDefault(); return(@event); }
public ActionResult editar(long?editID) { if (Session["USER_ID"] != null) { if (editID != null) { long userId = (long)Session["USER_ID"]; user curUser = entities.users.Find(userId); editEventViewModel viewModel = new editEventViewModel(); @event editEvent = entities.events.Find(editID); viewModel.side_menu = "eventos"; viewModel.side_sub_menu = "eventos_editar"; viewModel.editEvent = editEvent; viewModel.curUser = curUser; viewModel.pubTaskList = ep.GetNotifiTaskList(userId); viewModel.pubMessageList = ep.GetChatMessages(userId); return(View(viewModel)); } else { return(Redirect(Url.Action("NotFound", "Error"))); } } else { return(Redirect(ep.GetLogoutUrl())); } }
private void addEvent_Clicked(object sender, EventArgs e) { List <@event> Events = settings.eventData; if (Events == null) { Events = new List <@event>(); } if (eventOnPage != null) { @event eventToUpdate = Events.Where(rec => rec.eventID == eventOnPage.eventID).First(); eventToUpdate.name = eventName.Text; eventToUpdate.recipes = selectedRecipes.Text; eventToUpdate.people = selectedPeople.Text; eventToUpdate.location = location.Text; eventToUpdate.time = time.Time.ToString(); eventToUpdate.date = date.Date.ToString("yyyy-MM-dd"); } else { eventOnPage = new @event(); eventOnPage.name = eventName.Text; eventOnPage.recipes = selectedRecipes.Text; eventOnPage.people = selectedPeople.Text; eventOnPage.location = location.Text; eventOnPage.time = time.Time.ToString(); eventOnPage.date = date.Date.ToString("yyyy-MM-dd"); eventOnPage.eventID = Guid.NewGuid().ToString(); Events.Add(eventOnPage); } settings.eventData = Events; Navigation.PopAsync(); }
public Event add(Event ev) { @event e = new @event(); e.api_key = ev.api_key; e.api_type = ev.api_type; e.event_end = ev.event_end; e.event_start = ev.event_start; e.interval = ev.interval; e.last_update = DateTime.Now; e.title = ev.title; e.url = ev.url; e.t_hashtag = ev.t_hashtag; e.t_username = ev.t_username; e.openstack_id = ev.openstack_id; e.offset = ev.offset; e.eod_category = ev.eod_category; e.eod_description = ev.eod_description; e.eod_time = ev.eod_time; e.eod_title = ev.eod_title; e.timewarp = ev.timewarp; e.timerun = ev.timerun; e.overridedisplay = ev.overridedisplay; e.overridetime = ev.overridetime; e.timezone = ev.timezone; e.full_session = ev.full_session; db.events.InsertOnSubmit(e); db.SubmitChanges(); ev.id = e.id; return(ev); }
public ActionResult registrado(long?id) { if (Session["USER_ID"] != null) { if (id != null) { long userId = (long)Session["USER_ID"]; user curUser = entities.users.Find(userId); @event event_item = entities.events.Find(id); registradoViewModel viewmodel = new registradoViewModel(); viewmodel.side_menu = "eventos"; viewmodel.side_sub_menu = "eventos"; viewmodel.event_name = event_item.name; viewmodel.event_date = Convert.ToDateTime(event_item.created_at).ToString("dd/MM/yyyy"); viewmodel.event_time = Convert.ToDateTime(event_item.created_at).ToString("hh:mm tt"); viewmodel.place = event_item.place; viewmodel.description = event_item.description; viewmodel.note = event_item.note; viewmodel.curUser = curUser; viewmodel.pubTaskList = ep.GetNotifiTaskList(userId); viewmodel.pubMessageList = ep.GetChatMessages(userId); return(View(viewmodel)); } else { return(Redirect(Url.Action("NotFound", "Error"))); } } else { return(Redirect(ep.GetLogoutUrl())); } }
public Event fullupdate(Event ev) { @event @event = this.db.events.Single <@event>((Expression <Func <@event, bool> >)(x => x.id == ev.id)); @event.api_key = ev.api_key; @event.api_type = ev.api_type; @event.event_end = ev.event_end; @event.event_start = ev.event_start; @event.interval = ev.interval; @event.title = ev.title; @event.url = ev.url; @event.openstack_id = ev.openstack_id; @event.offset = ev.offset; @event.eod_category = ev.eod_category; @event.eod_description = ev.eod_description; @event.eod_time = ev.eod_time; @event.eod_title = ev.eod_title; @event.t_username = ev.t_username; @event.t_hashtag = ev.t_hashtag; @event.timewarp = ev.timewarp; @event.timerun = ev.timerun; @event.overridedisplay = ev.overridedisplay; @event.overridetime = ev.overridetime; @event.timezone = ev.timezone; @event.last_timerun = ev.last_timerun; @event.full_session = ev.full_session; this.db.SubmitChanges(); return(ev); }
public ActionResult editevent(long editID, string name, string event_date, string event_time, string place, string description, string note, int share) { try { @event editevent = entities.events.Find(editID); editevent.name = name; editevent.place = place; editevent.event_date = DateTime.ParseExact(event_date + " " + event_time, "yyyy-MM-dd HH:mm", System.Globalization.CultureInfo.CurrentCulture); editevent.description = description; editevent.note = note; editevent.share = share; editevent.community_id = Convert.ToInt64(Session["CURRENT_COMU"]); entities.SaveChanges(); return(Redirect(Url.Action("registrados", "eventos", new { area = "webmaster" }))); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } return(Redirect(Url.Action("editar", "eventos", new { area = "webmaster", editID = editID }))); } }
public ActionResult newevent(string name, string event_date, string event_time, string place, string description, string note) { try { @event newEvent = new @event(); newEvent.name = name; newEvent.event_date = DateTime.ParseExact(event_date + " " + event_time, "yyyy-MM-dd HH:mm", System.Globalization.CultureInfo.CurrentCulture); newEvent.place = place; newEvent.description = description; newEvent.note = note; newEvent.share = 1; newEvent.community_id = Convert.ToInt64(Session["CURRENT_COMU"]); entities.events.Add(newEvent); entities.SaveChanges(); return(Redirect(Url.Action("registrados", "eventos", new { area = "webmaster" }))); } catch (Exception ex) { return(Redirect(Url.Action("agregar", "eventos", new { area = "webmaster", exception = ex.Message }))); } }
/// <summary> /// Test - Ajouter un Event /// </summary> private void button3_Click(object sender, EventArgs e) { DateTime eventStart = default(DateTime); DateTime eventtEnd = default(DateTime); string eventDesc = txtEventDescription.Text; if (dateTimePicker_eventStart.Checked) { eventStart = dateTimePicker_eventStart.Value; } if (dateTimePicker_eventEnd.Checked) { eventtEnd = dateTimePicker_eventEnd.Value; } @event newEvent = new @event(); newEvent.Description = eventDesc; newEvent.Event_Start = eventStart; newEvent.Event_End = eventtEnd; newEvent.Group_ID = activeGroupID; groupFacade.CreateNewEvent(newEvent); }
public ActionResult editar(long?editID, long?place) { if (Session["USER_ID"] != null) { if (Session["CURRENT_COMU"] != null) { if (editID != null) { long communityAct = Convert.ToInt64(Session["CURRENT_COMU"]); @event editEvent = entities.events.Where(x => x.id == editID && x.community_id == communityAct).FirstOrDefault(); if (editEvent != null) { try { long userId = (long)Session["USER_ID"]; user curUser = entities.users.Find(userId); List <ShowMessage> pubMessageList = ep.GetChatMessages(userId); editEventViewModel viewModel = new editEventViewModel(); communityList = ep.GetCommunityList(userId); viewModel.communityList = communityList; viewModel.side_menu = "event_calendar"; viewModel.side_sub_menu = "event_calendar_editar"; viewModel.editEvent = editEvent; viewModel.curUser = curUser; viewModel.document_category_list = entities.document_type.Where(x => x.community_id == communityAct).ToList(); viewModel.pubTaskList = ep.GetNotifiTaskList(userId); viewModel.pubMessageList = pubMessageList; viewModel.messageCount = ep.GetUnreadMessageCount(pubMessageList); ViewBag.Place = place; return(View(viewModel)); } catch (Exception ex) { return(Redirect(Url.Action("registrados", "eventos", new { area = "coadmin", Error = "Problema interno " + ex.Message }))); } } else { return(Redirect(Url.Action("registrados", "eventos", new { area = "coadmin", Error = "No existe ese elemento" }))); } } else { return(Redirect(Url.Action("registrados", "eventos", new { area = "coadmin" }))); } } else { return(Redirect(Url.Action("registrados", "eventos", new { area = "coadmin", Error = "No puede editar eventos. Usted no administra ninguna comunidad. Comuníquese con el Webmaster..." }))); } } else { return(Redirect(ep.GetLogoutUrl())); } }
/* gets all the evnts from the list of events*/ /* public static List<eventTbl> getAllEvents() * { * using (var db = new HeznekDB) * { * List<eventTbl> events = db.eventTbl.ToList(); * return events; * } * } * * /*update a specific event in the list of events*/ /* public static void updateEventInList(eventTbl updatedEvent) * { * using (var db = new HeznekDB()) * { * List<eventTbl> events = getAllEvents(); * * foreach (var eventIndex in events) * { * if (eventIndex.sn == updatedEvent.sn) * { * eventIndex.nameEvent = updatedEvent.nameEvent; * eventIndex.subjectEvent = updatedEvent.subjectEvent; * db.eventTbl.Remove(eventIndex); * db.eventTbl.Add(updatedEvent); * //NOTE: here the updated event gets a new serial number(KEY) * } * } * } * }*/ /* add an vent to list of events*/ public static void AddEvent(@event eventToAdd) { using (var db = new HeznekDB()) { [email protected](eventToAdd); db.SaveChanges(); } }
void EventPage_Loaded(object sender, RoutedEventArgs e) { this.Event = (App.Current as App).schedule.Events.Single(_event => _event.ID == this.ID); this.Dispatcher.BeginInvoke(() => { this.ContentPanel.DataContext = this.Event; this.lB_Links.ItemsSource = this.Event.Links; }); }
static public bool updateAmount(int id, int number) { using (DataClasses1DataContext context = new DataClasses1DataContext()) { @event myEvent = [email protected](@event => @event.event_id == id); myEvent.amount = number; context.SubmitChanges(); return(true); } }
static public bool updateCustomer(int id, int client) { using (DataClasses1DataContext context = new DataClasses1DataContext()) { @event myEvent = [email protected](@event => @event.event_id == id); myEvent.customer = client; context.SubmitChanges(); return(true); } }
static public bool updateType(int id, bool stocking) { using (DataClasses1DataContext context = new DataClasses1DataContext()) { @event myEvent = [email protected](@event => @event.event_id == id); myEvent.is_stocking_event = stocking; context.SubmitChanges(); return(true); } }
static public bool updateTime(int id, DateTime time) { using (DataClasses1DataContext context = new DataClasses1DataContext()) { @event myEvent = [email protected](@event => @event.event_id == id); myEvent.event_time = time; context.SubmitChanges(); return(true); } }
MemberDeclarationSyntax GenEvent(@event e) { if (e.name == null) { throw new InvalidOperationException("Name cannot be null"); } return(GenClass(typeMap.NewTypeToCs(typeMap.TypeToCs(e.name) + "Event"), e.Items, " : " + "EventArgs"). AddAttributeLists(BuildSingleAttributeList("Event", e.number))); }
static public bool deleteEvent(int id) { using (DataClasses1DataContext context = new DataClasses1DataContext()) { @event myEvent = [email protected](@event => @event.event_id == id); //tu patrzyłam na różne metody żeby zmienić ale tylko ta się nadaje [email protected](myEvent); context.SubmitChanges(); return(true); } }
public Event update(Event ev) { @event evv = db.events.Single(x => x.id == ev.id); evv.last_update = DateTime.Now; db.SubmitChanges(); return(ev); }
public ActionResult CreateEvent(@event ev) { using (EventsCoEntities db = new EventsCoEntities()) { ev.event_organizer = Convert.ToInt32(Session["user_id"]); db.events.Add(ev); db.SaveChanges(); return(RedirectToAction("Dashboard", "User", new { area = "" })); } }
public Boolean delete(Int32 id) { @event ev = db.events.Single(x => x.id == id); db.events.DeleteOnSubmit(ev); db.SubmitChanges(); return(true); }
static public bool updateDonut(int id, int don) { using (DataClasses1DataContext context = new DataClasses1DataContext()) { @event myEvent = [email protected](@event => @event.event_id == id); myEvent.donut = don; context.SubmitChanges(); return(true); } }
public EventOverviewPage(@event Events) { InitializeComponent(); nameOfEvent.Text = Events.name; listOfPeople.Text = Events.people; finalTime.Text = Events.time; finalLocation.Text = Events.location; allRecipes.Text = Events.recipes; finalDate.Text = Events.date; eventOnPage = Events; }
private void bunifuCustomDataGrid2_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { int id = Int32.Parse(bunifuCustomDataGrid2.Rows[e.RowIndex].Cells["Id"].Value.ToString()); @event evt = db.events.SingleOrDefault(x => x.Id == id); if (evt != null) { AddProjectForm af = new AddProjectForm(u, evt); af.ReftoAdd = this; af.Show(); } }
public ActionResult registrado(long?id) { if (Session["USER_ID"] != null) { if (id != null) { long communityAct = Convert.ToInt64(Session["CURRENT_COMU"]); @event event_item = entities.events.Where(x => x.id == id && x.community_id == communityAct).FirstOrDefault(); if (event_item != null) { try { long userId = (long)Session["USER_ID"]; user curUser = entities.users.Find(userId); List <ShowMessage> pubMessageList = ep.GetChatMessages(userId); registradoViewModel viewModel = new registradoViewModel(); titulosList = ep.GetTitulosByTitular(userId); listComunities = ep.GetCommunityListByTitular(titulosList); viewModel.communityList = listComunities; viewModel.side_menu = "eventos"; viewModel.event_name = event_item.name; viewModel.event_date = Convert.ToDateTime(event_item.created_at).ToString("dd/MM/yyyy"); viewModel.event_time = Convert.ToDateTime(event_item.created_at).ToString("hh:mm tt"); viewModel.place = event_item.place; viewModel.description = event_item.description; viewModel.note = event_item.note; viewModel.document_category_list = entities.document_type.Where(x => x.community_id == communityAct).ToList(); viewModel.curUser = curUser; viewModel.pubTaskList = ep.GetNotifiTaskList(userId); viewModel.pubMessageList = pubMessageList; viewModel.messageCount = ep.GetUnreadMessageCount(pubMessageList); return(View(viewModel)); } catch (Exception ex) { return(Redirect(Url.Action("error", "control", new { Error = "Ver evento: " + ex.Message }))); } } else { return(Redirect(Url.Action("calendario", "eventos", new { Error = "No existe ese elemento: " }))); } } else { return(Redirect(Url.Action("calendario", "eventos"))); } } else { return(Redirect(ep.GetLogoutUrl())); } }
/// <summary> /// Création d'un nouvel évènement dans un groupe /// </summary> public @event CreateNewEvent(@event newEvent) { try { return(mainControl.EventService.CreateNewEvent(newEvent)); } catch (ServiceException serviceException) { ExceptionLog.LogTheError(serviceException.Message); return(null); } }
public static @event Createevent(string @string, global::Namespace1.@event event1) { @event @event = new @event(); @event.@string = @string; if ((event1 == null)) { throw new global::System.ArgumentNullException("event1"); } @event.event1 = event1; return(@event); }
private void bunifuFlatButton5_Click(object sender, EventArgs e) { @event evt = new @event(); evt.title = evttitletextbox.Text; evt.startdate = startdatebox.Value; evt.enddate = enddatebox.Value; [email protected](evt); db.SubmitChanges(); db.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, db.events); eventscomboupdate(); MessageBox.Show("Event Added!"); }
public void ProcessRequest( HttpContext context ) { try { //Cache the sitemap for 8 hours... DataCache cache = CacheFactory.GetCache(); string CacheKey = "TimelineXml"; timeline root = cache[CacheKey] as timeline ; if (root == null) //we'll have to build it... { ILoggingDataService logService = LoggingDataServiceFactory.GetService(SiteConfig.GetLogPathFromCurrentContext()); IBlogDataService dataService = BlogDataServiceFactory.GetService(SiteConfig.GetContentPathFromCurrentContext(), logService); SiteConfig siteConfig = SiteConfig.GetSiteConfig(); root = new timeline(); root.events = new eventCollection(); int i = 0; //All Pages (stop after 750...it gets too big and the browser can't handle it...we'd need // to include dynamic paging EntryCollection entryCache = dataService.GetEntries(false); //Fortunately this comes in ordered by post date, descending foreach(Entry e in entryCache) { if (e.IsPublic && (++i < 750)) { //then add permalinks string url = SiteUtilities.GetPermaLinkUrl(siteConfig, (ITitledEntry)e); @event foo = new @event(e.CreatedLocalTime, false, TruncateDotDotDot(StripAllTags(e.Title), 50), url); foo.text += String.Format("<div align=\"right\"><a href=\"{0}\">More...</a></div>",url); root.events.Add(foo); } } cache.Insert(CacheKey,root,DateTime.Now.AddHours(8)); } XmlSerializer x = new XmlSerializer(typeof(timeline)); x.Serialize(HttpContext.Current.Response.OutputStream,root); HttpContext.Current.Response.ContentType = "text/xml"; } catch(Exception exc) { ErrorTrace.Trace(System.Diagnostics.TraceLevel.Error,exc); } }
public async Task RuntimeCodeGenTest() { var grain = GrainFactory.GetGrain<IRuntimeCodeGenGrain<@event>>(Guid.NewGuid()); var expected = new @event { Id = Guid.NewGuid(), @if = new List<@event> { new @event { Id = Guid.NewGuid() } }, PrivateId = Guid.NewGuid(), @public = new @event { Id = Guid.NewGuid() } }; var actual = await grain.SetState(expected); Assert.IsNotNull(actual, "Result of SetState should be a non-null value."); Assert.IsTrue(expected.Equals(actual)); var newActual = await grain.@static(); Assert.IsTrue(expected.Equals(newActual), "Result of @static() should be equal to expected value."); }
public CreateEventResult create(EventRequest eventRequest) { try { string eventCode = generateCode(); if (eventCode == null) return new CreateEventResult(); var userId = (from u in _entity.connections where u.connection_id == eventRequest.connectionId select u). FirstOrDefault(); @event newEvent = new @event() { name = eventRequest.name, user_id = userId.user_id, date = DateTime.Now, code = eventCode }; _entity.events.Add(newEvent); _entity.SaveChanges(); var eventId = (from e in _entity.events where e.code == eventCode select e.id).FirstOrDefault(); _entity.collaborators.Add(new collaborator() { user_id = userId.user_id, event_id = eventId, status = 1, user_role = 0 }); _entity.SaveChanges(); return new CreateEventResult() { code = eventCode, id = eventId }; } catch (Exception) { return new CreateEventResult(); } }
static void GenEvent (@event e, string name) { if (e.name == null) return; cwt.WriteLine ("[Event (" + e.number + ")]"); //GenClass (NewTypeToCs (ToCs (e.name) + "Event"), eItem, " : " + "Event"); GenClass (NewTypeToCs (ToCs (e.name) + "Event"), e.Items, " : " + "EventArgs"); cw.WriteLine ("public event " + "EventHandler<" + (ToCs (e.name) + "Event") + "> " + (ToCs (e.name) + "Event") + ";"); cw.WriteLine (); }
public static int ProcessEvent(@event a_event) { XmsCall l_call = new XmsCall(""); if(a_event.type == event_type.incoming) // new call { l_call.CallId = a_event.resource_id; l_call.CallState = XmsCall.e_CallState.STATE_OFFERED; l_call.CallDirection = XmsCall.e_CallDirection.Incoming; m_callTable.Add(a_event.resource_id, l_call); if (l_call.Answer() != 0) // failed for some reason, see logs, need to remove { l_call.Drop(); m_callTable.Remove(a_event.resource_id); } else { l_call.CallState = XmsCall.e_CallState.STATE_CONNECTED; l_call.Play("file://verification/verification_intro.wav"); } return 0; // done with the incoming call } switch(a_event.type) { case event_type.connected: break; case event_type.dtmf: break; case event_type.end_play: if (m_callTable.TryGetValue(a_event.resource_id, out l_call) == false) //should not be here Logger.Log("ERR - Invalid CRN", true); else { l_call.Drop(); m_callTable.Remove(l_call.CallId); } break; case event_type.end_playcollect: break; case event_type.end_playrecord: break; case event_type.hangup: try { l_call = m_callTable[a_event.resource_id]; l_call.Drop(); m_callTable.Remove(a_event.resource_id); } catch (KeyNotFoundException) { Logger.Log("ERR: Cannot find call reference to release", true); } break; case event_type.ringing: break; case event_type.tone: break; } return 0; }
public void addItemListener(@event.ItemListener e) { }