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;
});
}
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)
{
}
