public ActionResult PublishEvent(int id)
{
Event.Event ev;
ev = new Event.Event(id);
SQLQueries.PublishEvent(id);
return(View(ev));
}
public static IEnumerable <object[]> JsonConvert_DeserializesUnexpectedNull_IntegerValues_DataProvider()
{
var nullCapacityEvent = new Event.Event
{
Id = "eventId",
Capacity = int.MaxValue
};
var nullCapacityEventAsString = JsonConvert.SerializeObject(
new ResultOrError <Event.Event> {
Result = nullCapacityEvent
},
Formatting.None,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Include,
Converters = new List <JsonConverter>()
{
new IsoDateTimeConverter()
{
DateTimeFormat = Utils.DateTimeFormat
}
}
}
);
yield return(new object[]
{
// dates can come from API as actually null string, however our conversion inserted
// the default date/time string so replace that for test purposes
nullCapacityEventAsString.Replace(int.MaxValue.ToString(), "null"),
nullCapacityEvent
});
}
public void setLock(Event.Event evt,int cctvid,string desc1,string desc2,int preset)
{
try
{
unlock();
this.cctvid=cctvid;
this.desc1=desc1;
this.desc2=desc2;
this.preset=preset;
this.evt = evt;
byte[] codebig5 =/* RemoteInterface.Util.StringToUTF8Bytes(desc2);*/ RemoteInterface.Util.StringToBig5Bytes(desc2);
desc2 = System.Web.HttpUtility.UrlEncode(codebig5);
codebig5 = /* RemoteInterface.Util.StringToUTF8Bytes(desc1); */ RemoteInterface.Util.StringToBig5Bytes(desc1);
desc1 = System.Web.HttpUtility.UrlEncode(codebig5);
string uristr=string.Format(LockWindows.lockurlbase,this.wid,this.cctvid,desc1,desc2,preset);
// string uristr = string.Format(LockWindows.lockurlbase, 3, this.cctvid, desc1, desc2, preset);
//只鎖定 第3號視窗
System.Net.WebRequest web = System.Net.HttpWebRequest.Create(new Uri(uristr
,UriKind.Absolute)
);
System.IO.Stream stream = web.GetResponse().GetResponseStream();
System.IO.StreamReader rd = new System.IO.StreamReader(stream);
string res = rd.ReadToEnd();
isLock = true;
}
catch (Exception ex)
{
isLock = false;
}
}
public static IEnumerable <object[]> JsonConvert_DeserializesUnexpectedNull_DateTimeValues_DataProvider()
{
var nullDatesEvent = new Event.Event
{
Id = "eventId",
};
var nullDatesEventAsString = JsonConvert.SerializeObject(
new ResultOrError <Event.Event> {
Result = nullDatesEvent
},
Formatting.None,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Include,
Converters = new List <JsonConverter>()
{
new IsoDateTimeConverter()
{
DateTimeFormat = Utils.DateTimeFormat
}
}
}
);
yield return(new object[]
{
nullDatesEventAsString,
nullDatesEvent
});
var nonNullDatesEvent = new Event.Event
{
Id = "47",
StartDateTime = DateTime.Now,
EndDateTime = DateTime.MaxValue
};
var nonNullDatesEventAsString = JsonConvert.SerializeObject(
new ResultOrError <Event.Event> {
Result = nonNullDatesEvent
},
Formatting.None,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Include,
Converters = new List <JsonConverter>()
{
new IsoDateTimeConverter()
{
DateTimeFormat = Utils.DateTimeFormat
}
}
}
);
yield return(new object[]
{
nonNullDatesEventAsString,
nonNullDatesEvent
});
}
public ScheduleEvent(Event.Event @event, Schedule.Schedule schedule)
{
EventId = @event.Id;
ScheduleId = schedule.Id;
Event = @event;
Schedule = schedule;
}
public static List <Event.Event> getAllEventsList(int iPublishStatus = 0, bool bActiveOnly = false)
{
DataTable dtEvents = new DataTable();
string sQuery = string.Empty;
switch (iPublishStatus)
{
case (0): //All Events
sQuery = "SELECT iEventId FROM calendarevent WHERE (bActive = 1 OR bActive = " + Convert.ToInt32(bActiveOnly) + ")";
break;
case (1): //Submitted Events Only
sQuery = "SELECT iEventId FROM calendarevent WHERE (bActive = 1 OR bActive = " + Convert.ToInt32(bActiveOnly) + ") AND bPublished = 0";
break;
case (2): //Published Events Only
sQuery = "SELECT iEventId FROM calendarevent WHERE (bActive = 1 OR bActive = " + Convert.ToInt32(bActiveOnly) + ") AND bPublished = 1";
break;
}
dtEvents = SQLDataAdapter.Query4DataTable(sQuery);
List <Event.Event> list = new List <Event.Event>();
foreach (DataRow row in dtEvents.Rows)
{
int iEventId = (int)row[0];
Event.Event e = new Event.Event(iEventId);
list.Add(e);
}
return(list);
}
public async Task <IEnumerable <Event.Event> > LoadEventsAsync()
{
var result = new List <Event.Event>();
try
{
var loadedEvents = await GetDataAsync(EventsURL);
foreach (var loadedEvent in loadedEvents)
{
var modelEvent = new Event.Event
{
Title = loadedEvent["name"].ToString(),
Description = HtmlFormatter.RemoveHtmlTags(loadedEvent["description"].ToString()),
RSVPCount = int.Parse(loadedEvent["yes_rsvp_count"].ToString())
};
result.Add(modelEvent);
}
}
catch (Exception ex)
{
LogException(ex);
}
return(result);
}
public static void AddEvent(Event.Event e)
{
gettingEventsFromQueue.WaitOne();
lock (eventListLock) {
InstantEventList.Add(e);
}
}
/// <summary>
/// 设备编辑事件
/// </summary>
internal void DeviceEditEvent(string DeviceID, string edittype)
{
try
{
Event.Event evt = new Event.Event();
evt.EventType = Event.Event.Types.EventType.MediaConfigurationChanged;
evt.Detail = "DeviceEditEvent: " + edittype + " " + DeviceID;
evt.OccurredTime = (UInt64)(DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0)).TotalSeconds;
string GBServerChannelAddress = EnvironmentVariables.DeviceManagementServiceAddress ?? "devicemanagementservice:8080";
// Channel channel = new Channel(GBServerChannelAddress, ChannelCredentials.Insecure);
//devicemanagementservice 是预留的服务标识(暂命名为设备管理服务).目前没有这个服务.
//需要你的微服务架构中实现一个设备资产以及一个配置管理服务(或者二合一的资源管服务)
//以达到两个目的：1、用来为当前GB服务提供启动配置，2、为GB收到注册的设备/平台信息，提供全平台的统一的存储服务.
var channel = GrpcChannel.ForAddress(EnvironmentVariables.DeviceManagementServiceAddress ?? "devicemanagementservice:8080"); //, ChannelCredentials.Insecure);
var client = new DevicesManager.DevicesManagerClient(channel);
QueryGBDeviceByGBIDsResponse rep = new QueryGBDeviceByGBIDsResponse();
QueryGBDeviceByGBIDsRequest req = new QueryGBDeviceByGBIDsRequest();
req.GbIds.Add(DeviceID);
rep = client.QueryGBDeviceByGBIDs(req);
if (rep.Devices.Count > 0)
{
evt.DeviceID = rep.Devices[0].Guid;
evt.DeviceName = rep.Devices[0].Name;
logger.Debug("DeviceEditEvent: " + edittype + " " + rep.Devices[0].ToString());
}
else
{
logger.Warn("DeviceEditEvent: Devices[" + DeviceID + "] can't be found in database");
return;
}
Message message = new Message();
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("Content-Type", "application/octet-stream");
message.Header = dic;
message.Body = evt.ToByteArray();
byte[] payload = Encoding.UTF8.GetBytes(JsonConvert.SerializeObject(message));
string subject = Event.EventTopic.OriginalEventTopic.ToString();//"OriginalEventTopic"
#region
Options opts = ConnectionFactory.GetDefaultOptions();
opts.Url = EnvironmentVariables.GBNatsChannelAddress ?? Defaults.Url;
using (IConnection c = new ConnectionFactory().CreateConnection(opts))
{
c.Publish(subject, payload);
c.Flush();
logger.Debug("Device add/update event published.");
}
#endregion
}
catch (Exception ex)
{
logger.Error("DeviceEditEvent Exception: " + ex.Message);
}
}
/// <summary>
/// Returns an event object representing the last submitted event.
/// </summary>
/// <returns>Returns a populated event object</returns>
public static Event.Event GetLastEvent()
{
int iEventId;
string sQuery = "SELECT iEventId FROM calendarevent ORDER BY iEventId DESC LIMIT 1";
iEventId = SQLDataAdapter.Query4Int(sQuery);
Event.Event ev = new Event.Event(iEventId);
return(ev);
}
public ActionResult DeleteEvent(int id)
{
Event.Event ev;
ev = new Event.Event(id);
SQLQueries.DeactivateEvent(id);
if (ev.IsPublished)
{
EventManager.PublishedEvents.Remove(id);
}
else
{
EventManager.SubmittedEvents.Remove(id);
}
return(View(ev));
}
public void Check_GetEventPlace_returns_event()
{
//Arrange
var checker = new Event.Event();
checker = checker.getEvent("51", false);
string expectedArray = "here";
//Act
string result = checker.getPlace();
//String Assert
Assert.AreEqual(expectedArray, result);
}
private static void AddTimedEvent(Event.Event e, State currentWriteState)
{
gettingEventsFromQueue.WaitOne();
if (e.executionTime == DateTime.MinValue)
{
e.executionTime = DateTime.Now.AddMilliseconds(-rnd.Next(0, 10000));
}
lock (eventListLock) {
while (currentWriteState.futureEvents.ContainsKey(e.executionTime))
{
Logger.log(44, Category.EventEngine, Severity.Warn, string.Format("Event for {0} already exists, increasing exec time by 1ms", e.executionTime.ToLongTimeString()));
e.executionTime = e.executionTime.AddMilliseconds(1);
}
currentWriteState.futureEvents.Add(e.executionTime, e);
}
}
private Event.Event GetMouseEventPayload(MouseState mouseState)
{
Event.Event eventdata = new Event.Event
{
Mouse = new MouseEvent
{
X = mouseState.X,
Y = mouseState.Y,
LeftButton = mouseState.LeftButton,
RightButton = mouseState.RightButton,
MiddleButton = mouseState.MiddleButton
}
};
return(eventdata);
}
public ActionResult EditEvent(Event.Event ev)
{
SQLQueries.UpdateEvent(ev);
var file = Request.Files["file"];
if (file != null)
{
//MySqlComm
byte[] fileBytes = new byte[file.ContentLength];
file.InputStream.Read(fileBytes, 0, file.ContentLength);
ev.Image = fileBytes;
SQLData.SQLQueries.UpdateEventImage(ev);
}
return(RedirectToAction("EventDetails", new { id = ev.EventId }));
}
/// <summary>
/// Creates a new submitted event in DB
/// </summary>
/// <param name="sEventTitle">Event Title</param>
/// <param name="dEventDate">Date of Event</param>
/// <param name="sStartTime">Event Start Time(optional)</param>
/// <param name="sEndTime">Event End Time(optional)</param>
/// <param name="bAllDay">All Day Event(optional)</param>
/// <param name="sVenueName">Venue Name</param>
/// <param name="sAddress">Address</param>
/// <param name="sDescription">Description</param>
/// <param name="sOrganizerName">Organizer's Name</param>
/// <param name="sOrganizerEmail">Organizer's Email</param>
/// <param name="sOrganizerPhoneNumber">Organizer's Phone Number</param>
/// <param name="sOrganizerURL">Organizer's URL(optional)</param>
/// <param name="sCost">Cost(optional)</param>
/// <param name="sRegistrationURL">Registration URL(optional)</param>
/// <param name="sSubmitterName">Submitter's Name(optional)</param>
/// <param name="sSubmitterEmail">Submitter's Email(optional)</param>
/// <returns></returns>
public static int InsertSubmittedEvent(string sEventTitle, string dEventDate, string dEndDate, string sStartTime, string sEndTime, bool bAllDay, string sVenueName, string sAddress, string sDescription, string sOrganizerName,
string sOrganizerEmail, string sOrganizerPhoneNumber, string sOrganizerURL, string sCost, string sRegistrationURL, string sSubmitterName, string sSubmitterEmail)
{
int iRowsAffected = 0;
string sQuery = "INSERT INTO calendarevent(vEventTitle, dEventDate, dEndDate, vStartTime, vEndTime, bAllDay, vVenueName, vAddress, vDescription, vOrganizerName, vOrganizerEmail, vOrganizerPhoneNumber," +
"vOrganizerURL, vCost, vRegistrationURL, vSubmitterName, vSubmitterEmail)" +
"VALUES('" + sEventTitle + "','" + dEventDate + "','" + dEndDate + "','" + sStartTime + "','" + sEndTime + "'," + Convert.ToInt32(bAllDay) + ",'" + sVenueName + "','" + sAddress + "','" +
sDescription + "','" + sOrganizerName + "','" + sOrganizerEmail + "','" + sOrganizerPhoneNumber + "','" + sOrganizerURL + "','" + sCost + "','" + sRegistrationURL + "','" + sSubmitterName + "','" + sSubmitterEmail + "')";
iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
int eventId = SQLDataAdapter.LastInsertedId;
var submittedEvent = new Event.Event(sEventTitle, sOrganizerName, sOrganizerEmail, sOrganizerPhoneNumber, sVenueName, sAddress, sDescription, sRegistrationURL, sSubmitterName, sSubmitterEmail, dEventDate, dEndDate, sStartTime, sEndTime, bAllDay);
submittedEvent.EventId = eventId;
EventManager.SubmittedEvents.Add(eventId, submittedEvent);
return(eventId);
}
public void Check_GetEventDate_returns_event()
{
//Arrange
var checker = new Event.Event();
checker = checker.getEvent("51", false);
string expectedArray = "12/10/2018";
//Act
string resultDay = checker.getTheDate().Day.ToString();
string resultMonth = checker.getTheDate().Month.ToString();
string resultYear = checker.getTheDate().Year.ToString();
string result = resultMonth + "/" + resultDay + "/" + resultYear;
//String Assert
Assert.AreEqual(expectedArray, result);
}
public static Event.Event call(Event.Event e)
{
foreach (IEcoEventListener classRegistred in FireEventTool.registredListener)
{
foreach (var processorMethod in classRegistred.GetType().GetMethods().Where(method => method.HasAttribute <RegisterEventAttribute>()))
{
if (processorMethod.IsStatic)
{
throw new InvalidOperationException(QQLib.prefix + "Command porcessor method must be not static.");
}
if (processorMethod.ReturnType != typeof(void))
{
throw new InvalidOperationException(QQLib.prefix + "Command porcessor method must return a void value and actualy return: " + processorMethod.ReturnType);
}
var parameters = processorMethod.GetParameters();
if (parameters.Length != 1)
{
throw new InvalidOperationException(QQLib.prefix + "Command porcessor method must take one arg Event object only");
}
if (!typeof(Event.Event).IsAssignableFrom(parameters[0].ParameterType))
{
throw new InvalidOperationException(QQLib.prefix + "Command porcessor method must take an Event type on arg and the arg is actualy: " + parameters[0].ParameterType);
}
if (parameters[0].ParameterType == e.GetType())
{
List <object> processArgs = new List <object> {
e
};
processorMethod.Invoke(classRegistred, processArgs.ToArray());
}
}
}
return(e);
}
public Discount CreateDiscount(DiscountType discountType, Event.Event @event, decimal discountAmount)
{
switch (discountType)
{
case DiscountType.HostSpecial:
var hostSpecialReward = new RewardService().GetHostSpecialReward(@event.ActualDate);
hostSpecialReward.DiscountAmount = @event.HostSpecialReward.DiscountAmount;
hostSpecialReward.ItemCode = @event.HostSpecialReward.ItemCode;
hostSpecialReward.SalesThreshold = @event.HostSpecialReward.SalesThreshold;
hostSpecialReward.HasBeenRedeemed = @event.HostSpecialReward.HasBeenRedeemed;
return(hostSpecialReward);
default:
throw new NotImplementedException(string.Format("No implementation for {0}.", discountType));
}
}
public void SerializeDateTimeValues_MatchesExpected(
Event.Event data,
Dictionary <string, string> expectedResult)
{
// Note that the usage of the Event class here is because it has dateTime fields
var result = serializer.Serialize(data);
var serialized = JsonConvert.SerializeObject(
expectedResult,
Formatting.None,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore,
}
);
// Strip the { } from start and end of serialized substring
Assert.Contains(serialized.TrimStart('{').TrimEnd('}'), result);
}
public static void UpdateEventImage(Event.Event ev)
{
SQLDataAdapter.QueryUpdateImage(ev.EventId, ev.Image);
}
private void EmitKeyPressEvent(Event.Event eventObj)
{
_eventManager.Emit("keypress", eventObj);
}
private void EmitKeyUpEvent(Event.Event eventObj)
{
_eventManager.Emit("keyup", eventObj);
}
private void EmitKeyDownEvent(Event.Event eventObj)
{
_eventManager.Emit("keydown", eventObj);
}
public static void UpdateEvent(Event.Event ev)
{
string sQuery = "UPDATE calendarevent SET vEventTitle = '" + ev.Title + "', vOrganizerName = '" + ev.HostName + "', vOrganizerEmail = '" + ev.HostEmail + "', vOrganizerPhoneNumber = '" + ev.HostPhoneNumber + "', vVenueName = '" + ev.VenueName + "', vAddress = '" + ev.Address + "', vDescription = '" + ev.Description + "', vRegistrationURL = '" + ev.RegistrationURL + "', vSubmitterName = '" + ev.SubmitterName + "', vSubmitterEmail = '" + ev.SubmitterEmail + "', dEventDate = '" + ev.Date + "', dEndDate = '" + ev.EndDate + "', vStartTime = '" + ev.StartTime + "', vEndTime = '" + ev.EndTime + "', bAllDay = " + ev.AllDay + " WHERE iEventId = " + ev.EventId + " ";
int iRowsAffected = SQLDataAdapter.QueryExecute(sQuery);
}
public void JsonConvert_DeserializesUnexpectedNull_IntegerValues(string data, Event.Event expectedResult)
{
// Note that the usage of the Event class here is because it has datetime fields
var result = deserializer.Deserialize <Event.Event>(data);
Assert.Equal(expectedResult.Id, result.Result.Id);
Assert.Equal(0, result.Result.Capacity);
}
public void JsonConvert_DeserializesUnexpectedNull_DateTimeValues(string data, Event.Event expectedResult)
{
// Note that the usage of the Event class here is because it has datetime fields
var result = deserializer.Deserialize <Event.Event>(data);
Assert.Equal(expectedResult.Id, result.Result.Id);
Assert.Equal(AdjustToNearestSecond(expectedResult.StartDateTime), result.Result.StartDateTime);
Assert.Equal(AdjustToNearestSecond(expectedResult.EndDateTime), result.Result.EndDateTime);
}
public void AddEvent(Event.Event @event)
{
ScheduleEvent e = new ScheduleEvent(@event, this);
_scheduleEvents.Add(e);
}
public ActionResult SubmitEvent(FormCollection form)
{
var EventTitle = Convert.ToString(form["submitEventTitle"]);
var FirstName = Convert.ToString(form["submitFirstName"]);
var LastName = Convert.ToString(form["submitLastName"]);
var HostEmail = Convert.ToString(form["submitEmail"]);
var HostPhoneNumber = Convert.ToString(form["submitPhoneNumber"]);
var Date = Convert.ToString(form["submitDate"]);
var EndDate = Convert.ToString(form["submitEndDate"]);
var StartTime = Convert.ToString(form["submitTime"]);
var EventInformation = Convert.ToString(form["submitEventInformation"]);
var file = Request.Files["image"];
var StreetAddress = Convert.ToString(form["submitStreetAddress"]);
var Address2 = Convert.ToString(form["submitAddressLine2"]);
var City = Convert.ToString(form["submitCity"]);
var State = Convert.ToString(form["submitState"]);
var Zip = Convert.ToString(form["submitZip"]);
var Country = Convert.ToString(form["submitCountry"]);
bool AllDay = true;
if (form["AllDay"] == null)
{
AllDay = false;
}
var VenueName = Convert.ToString(form["submitVenueName"]);
var EndTime = Convert.ToString(form["submitEndTime"]);
var HostURL = Convert.ToString(form["submitURL"]);
var Cost = "Free";
bool Fre = true;
if (form["Free"] == null)
{
Fre = false;
}
if (!Fre)
{
Cost = Convert.ToString(form["submitCost"]);
}
var RegURL = Convert.ToString(form["submitRegisterURL"]);
var SubFName = Convert.ToString(form["submitFirstSName"]);
var SubLName = Convert.ToString(form["submitLastSName"]);
var SubEmail = Convert.ToString(form["submitSEmail"]);
string address = StreetAddress + " " + Address2 + " " + City + " " + State + " " + Zip + " " + Country;
int iNewEventId = SQLData.SQLQueries.InsertSubmittedEvent(EventTitle, Date, EndDate, StartTime, EndTime, AllDay, VenueName, address, EventInformation, FirstName + " " + LastName, HostEmail, HostPhoneNumber, HostURL, Cost, RegURL, SubFName + " " + SubLName, SubEmail);
if (file != null)
{
//MySqlComm
byte[] fileBytes = new byte[file.ContentLength];
file.InputStream.Read(fileBytes, 0, file.ContentLength);
Event.Event ev = new Event.Event();
ev.EventId = iNewEventId;
ev.Image = fileBytes;
SQLData.SQLQueries.UpdateEventImage(ev);
}
List <PropertyType> liPropertyType = new List <PropertyType>();
liPropertyType = SQLQueries.getAllPropertyTypes(true);
List <MultiSelectList> liMultiSelect = new List <MultiSelectList>();
foreach (PropertyType pt in liPropertyType)
{
string sName = pt.Name;
var props = Convert.ToString(form[sName]);
if (props != null)
{
string[] sProps = props.Split(',');
foreach (string s in sProps)
{
int iProp = int.Parse(s);
SQLData.SQLQueries.AddPropertyToEvent(iNewEventId, iProp);
}
}
}
return(Redirect("Index"));
}
public ActionResult EventDetails(int id)
{
Event.Event ev;
ev = new Event.Event(id);
return(View(ev));
}
public void unlock()
{
System.Net.WebRequest web = System.Net.HttpWebRequest.Create(string.Format(LockWindows.unlockurl,this.wid));
System.IO.Stream stream = web.GetResponse().GetResponseStream();
System.IO.StreamReader rd = new System.IO.StreamReader(stream);
string res = rd.ReadToEnd();
this.cctvid = 0;
this.desc1 = "";
this.desc2 = "";
this.preset = 0;
isLock = false ;
this.evt = null;
}
public ActionResult ConfirmDelete(int id)
{
Event.Event ev;
ev = new Event.Event(id);
return(View(ev));
}
