public IList<UserMessage> GetMessagesByUserID(int userid)
{
IList<UserMessage> userlist = new List<UserMessage>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@User_ID", SqlDbType.Int, userid);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetMessagesByUserId);
if (reader != null)
{
while (reader.Read())
{
UserMessage usermessage = new UserMessage();
if (!reader.IsDBNull(0)) usermessage.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) usermessage.UserID = reader.GetInt32(1);
if (!reader.IsDBNull(2)) usermessage.MessageID = reader.GetInt32(2);
if (!reader.IsDBNull(3)) usermessage.UserMessageState = reader.GetInt32(3);
usermessage.MarkOld();
userlist.Add(usermessage);
}
reader.Close();
}
return userlist;
}
protected void AddNewMessageToChatButtonClick(object sender, EventArgs e)
{
AccessorToApplication CurrentAccessorToApplication = new AccessorToApplication();
UserMessage CurrentUserMessage = new UserMessage(TextBoxForTypingNewMessage.Text, Membership.GetUser().UserName);
CurrentAccessorToApplication.AddNewMessageToChat(CurrentUserMessage);
RefreshDataSourceInRepeaterForChat();
}
public UserMessage GetUserMessageByUserIdandMsgId(int userid, int messageid)
{
UserMessage usermessage = new UserMessage();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@User_ID", SqlDbType.Int, userid);
sql.AddParameter("@Message_ID", SqlDbType.Int, messageid);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetUserMessageByUserIdAndMsgId);
if (reader != null)
{
while (reader.Read())
{
if (!reader.IsDBNull(0)) usermessage.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) usermessage.UserID = reader.GetInt32(1);
if (!reader.IsDBNull(2)) usermessage.MessageID = reader.GetInt32(2);
if (!reader.IsDBNull(3)) usermessage.UserMessageState = reader.GetInt32(3);
usermessage.MarkOld();
}
reader.Close();
}
return usermessage;
}
public void AddNewMessage(string TextOfMessage, string UserName)
{
List<UserMessage> CurrentListOfUserMessages = (CurrentUserSession[KeyForMessagesCreatedByCurrentUser] as List<UserMessage>);
UserMessage NewUserMessage = new UserMessage(TextOfMessage, UserName);
CurrentListOfUserMessages.Add(NewUserMessage);
if (CurrentListOfUserMessages.Count > MaxAmountOfMessages)
{
CurrentListOfUserMessages.RemoveAt(0);
}
}
public static void SubmitUserMessage(string endpoint, string userName, string message, int userID, int roomID)
{
var _chatClient = new ChatClient(endpoint);
var userMessage = new UserMessage();
userMessage.Message = message;
userMessage.UserID = userID;
userMessage.RoomID = roomID;
userMessage.Submitter = userName;
userMessage.TimeStamp = DateTime.Now;
_chatClient.SubmitUserMessage(userMessage);
}
public void AddNewMessageToChat(UserMessage NewUserMessage)
{
lock (GatesToApplication)
{
List<UserMessage> BufferForAllMessages = (HttpContext.Current.Application[KeyForChatMessages] as List<UserMessage>);
BufferForAllMessages.Add(NewUserMessage);
if (BufferForAllMessages.Count > MaxAmountOfMessagesInMemory)
{
BufferForAllMessages.RemoveAt(0);
}
}
}
public void AddNewMessageToChat(string TextOfMessage, string UserName)
{
List<UserMessage> CurrentListOfMessages = (HttpContext.Current.Application[KeyToChatMessages] as List<UserMessage>);
lock(GatesToMessages)
{
UserMessage NewUserMessage = new UserMessage(TextOfMessage, UserName);
CurrentListOfMessages.Add(NewUserMessage);
if (CurrentListOfMessages.Count > MaxAmountOfMessages)
{
CurrentListOfMessages.RemoveAt(0);
}
}
}
public IHttpActionResult SendPersonalMessage(UserMessageBindingModel model)
{
if (model == null)
{
return BadRequest("Missing message data.");
}
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
var recipientUser = this.db.Users.FirstOrDefault(u => u.UserName == model.Recipient);
if (recipientUser == null)
{
return BadRequest("Recipient user " + model.Recipient + " does not exists.");
}
var currentUserId = User.Identity.GetUserId();
var currentUser = db.Users.Find(currentUserId);
var message = new UserMessage()
{
Text = model.Text,
DateSent = DateTime.Now,
Sender = currentUser,
RecipientUser = recipientUser
};
db.UserMessages.Add(message);
db.SaveChanges();
if (message.Sender == null)
{
return this.Ok(
new
{
message.Id,
Message = "Anonymous message sent successfully to user " + recipientUser.UserName + "."
}
);
}
return this.Ok(
new
{
message.Id,
Sender = message.Sender.UserName,
Message = "Message sent successfully to user " + recipientUser.UserName + "."
}
);
}
public IHttpActionResult SendPersonalMessage(PersonalMessageInputModel msgInput)
{
if (msgInput == null)
{
return this.BadRequest("invalid message data");
}
if (!this.ModelState.IsValid)
{
return this.BadRequest();
}
var recipientUser = this.Data.Users.FirstOrDefault(u => u.UserName == msgInput.Recipient);
if (recipientUser == null)
{
return this.BadRequest();
}
var currentUserId = this.User.Identity.GetUserId();
var msg = new UserMessage()
{
UserRecipient = recipientUser,
Text = msgInput.Text,
DateSent = DateTime.Now,
UserSenderId = currentUserId
};
this.Data.UserMessages.Add(msg);
this.Data.SaveChanges();
if (currentUserId == null)
{
return this.Ok(new
{
Id = msg.Id,
Message = "Anonymous message sent successfully to user " + recipientUser.UserName
});
}
var currentUserName = this.User.Identity.GetUserName();
return this.Ok(new
{
Id = msg.Id,
Sender = currentUserName,
Message = "Message sent to user " + recipientUser.UserName
});
}
public IHttpActionResult SendAnonymousPersonalMessage([FromUri]UserMessagesBindingModel model)
{
if (model == null)
{
return this.BadRequest("Model cannot be null");
}
if (!this.ModelState.IsValid)
{
return this.BadRequest(this.ModelState);
}
var reciever = this.Data.Users.All().FirstOrDefault(u => u.UserName == model.Recipient);
if (reciever==null)
{
return this.NotFound();
}
var currentUserId = User.Identity.GetUserId();
var currentUser = this.Data.Users.Find(currentUserId);
var message = new UserMessage()
{
Text = model.Text,
DateSent = DateTime.Now,
Reciever = reciever,
Sender = currentUser
};
this.Data.UserMessages.Add(message);
this.Data.SaveChanges();
if (currentUser == null)
{
return this.Ok(
new
{
message.Id,
Message = "Anonymous message successfully sent to user " + model.Recipient + "."
});
}
else
{
return this.Ok(
new
{
message.Id,
Sender = message.Sender.UserName,
Message = "Message successfully sent to user " + model.Recipient + "."
});
}
}
//キーボードとゲームパッドの操作を管理
/// <summary>
/// ユーザからの入力を返す
/// UserMessage.Hidari:カーソルキー左，ゲームパッド十字キー左
/// UserMessage.Migi:カーソルキー右，ゲームパッド十字キー右
/// UserMessage.Shita:カーソルキー下，ゲームパッド十字キー下
/// UserMessage.Ue:カーソルキー上，ゲームパッド十字キー上
/// UserMessage.Shot:スペースキー，エンターキー，ゲームパッドボタンA
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public static bool checkUserMessage(UserMessage s)
{
GamePadState gp = GamePad.GetState(PlayerIndex.One);//ゲームパッドの状態を保持
KeyboardState ks = Keyboard.GetState(); //キーボードの状態を保持
bool b = false;
switch (s)
{
case UserMessage.Hidari:
if (ks.IsKeyDown(Keys.Left) || gp.IsButtonDown(Buttons.DPadLeft))
{
b = true;
}
break;
case UserMessage.Migi:
if (ks.IsKeyDown(Keys.Right) || gp.IsButtonDown(Buttons.DPadRight))
{
b = true;
}
break;
case UserMessage.Shita:
if (ks.IsKeyDown(Keys.Down) || gp.IsButtonDown(Buttons.DPadDown))
{
b = true;
}
break;
case UserMessage.Ue:
if (ks.IsKeyDown(Keys.Up) || gp.IsButtonDown(Buttons.DPadUp))
{
b = true;
}
break;
case UserMessage.Shot:
if (ks.IsKeyDown(Keys.Space) || ks.IsKeyDown(Keys.Enter) || gp.IsButtonDown(Buttons.A))
{
b = true;
}
break;
default:
b= false;
break;
}
return b;
}
string UserMessageRichText (UserMessage message)
{
return "<color=#" + SendBirdTheme.ToHex (uiTheme.senderColor) + ">" + message.Sender.Nickname + ": </color>" + message.Message;
}
/// <summary>
/// There are no comments for UserMessages in the schema.
/// </summary>
public void AddToUserMessages(UserMessage userMessage)
{
base.AddObject("UserMessages", userMessage);
}
public static bool IsExistMessage(UserMessage message)
{
using (WeChatDbContext entity = new WeChatDbContext())
{
var oldmsg = (from item in entity.UserMessages where (item.Content == message.Content) && (item.MsgId == message.MsgId) select item).SingleOrDefault();
if (oldmsg != null)
{ return true; }
else
{ return false; }
}
}
public void Send(UserMessage userMessage)
{
var log = string.Format("[{0}] : {1}", userMessage.Source, userMessage.Message);
Console.WriteLine(log);
Clients.Others.addMessage(userMessage);
}
private void MovePlayer()
{
UserMessage message;
int testRoomIndex;
Point previewMove = player.PreviewMove(player.CurrentDirection);
switch (CollisionDetection(previewMove))
{
case ObjectType.None:
player.Move(previewMove);
break;
case ObjectType.Door:
if (currentRoom.RoomWarp == null)
{
testRoomIndex = currentRoom.GetNextRoom(player.CurrentDirection);
if (testRoomIndex == -1)
{
this.GameResult = Castle.GameResult.Win;
EndGame();
if (StopGamePlay != null)
{
StopGamePlay(this, new EventArgs());
}
return;
}
if (mapReader.FindRoom(testRoomIndex).Dark)
{
if (ItemManager.FindItemInInventory("Lamp") != null)
{
currentRoomIndex = testRoomIndex;
MovePlayerRoom(previewMove);
DrawRoom();
}
else
{
message = new UserMessage();
message.AddLine("It's too dark");
message.AddLine("to go that way");
PrintUserMessage(message);
}
}
else
{
currentRoomIndex = testRoomIndex;
MovePlayerRoom(previewMove);
DrawRoom();
}
}
else
{
currentRoomIndex = currentRoom.RoomWarp.DestinationRoomId;
previewMove.X = currentRoom.RoomWarp.X;
previewMove.Y = currentRoom.RoomWarp.Y;
message = currentRoom.RoomWarp.UserMessage;
player.Move(previewMove);
DrawRoom();
PrintUserMessage(message);
}
break;
case ObjectType.UpStairs:
currentRoomIndex = currentRoom.GetNextRoom(CastleDirection.UpStairs);
DrawRoom();
break;
case ObjectType.DownStairs:
testRoomIndex = currentRoom.GetNextRoom(CastleDirection.DownStairs);
if (mapReader.FindRoom(testRoomIndex).Dark)
{
if (ItemManager.FindItemInInventory("Lamp") != null)
{
currentRoomIndex = currentRoom.GetNextRoom(CastleDirection.DownStairs);
DrawRoom();
}
else
{
message = new UserMessage();
message.AddLine("It's too dark");
message.AddLine("to go that way");
PrintUserMessage(message);
}
}
else
{
currentRoomIndex = currentRoom.GetNextRoom(CastleDirection.DownStairs);
DrawRoom();
}
break;
case ObjectType.LockedDoor:
message = new UserMessage();
message.AddLine("The Door is");
message.AddLine("locked");
PrintUserMessage(message);
break;
case ObjectType.Trap:
if (ProcessTrap() == false)
{
player.Move(previewMove);
}
break;
case ObjectType.Item:
PickupItem(previewMove);
break;
case ObjectType.Monster:
AttackMonster(previewMove);
break;
}
}
public static string InsertUserMessage(UserMessage message)
{
using (WeChatDbContext entity = new WeChatDbContext())
{
var oldmsg = (from item in entity.UserMessages where item.MsgId == message.MsgId select item).SingleOrDefault();
if (oldmsg == null)
{
message.CreateTime = DateTime.Now;
message.UpdateTime = DateTime.Now;
entity.UserMessages.Add(message);
entity.SaveChanges();
}
return "";
}
}
public async Task CreateUserMessageAsync(UserMessage userMessage)
{
await notificationRepository.CreateUserMessageAsync(userMessage);
}
/// <summary>
/// Testdata there are no keys available
/// </summary>
static FakeContext()
{
#region instructors
//----------------------------------------instructors---------------------------------------------------//
var intructors = new List<Instructor>
{
new Instructor {UserName = "******", Courses = new List<Course>() {}, MessagesSent = new List<UserMessage>(),Following = new List<User>{},Followers = new List<User>{}},
new Instructor {UserName = "******", Courses = new List<Course>() {},MessagesSent = new List<UserMessage>(),Following = new List<User>{},Followers = new List<User>{}}
};
//give instructors variables
var jim = intructors[0];
var brian = intructors[1];
#endregion
#region Courses
//---------------------------------------Courses------------------------------------------------------//
var courses = new List<Course>
{
new Course
{
Title = ".Net Database Technologies",
Status = true,
Resume = "Patterns relating to the EntityFramework and Friends",
CourseMessages = new List<CourseMessage>{},
Owner = jim,
Achievments = new List<Achievment>(),
Students = new List<Student>(),
Groups = new List<Group>()
},
new Course
{
Title = "Asp.Net MVC4",
Status = true,
Resume = "Learn about the Latest version of Microsoft's flagship web development platform",
CourseMessages = new List<CourseMessage>{},
Owner = jim,
Achievments = new List<Achievment>(),
Students = new List<Student>(),
Groups = new List<Group>()
},
new Course
{
Title = "Foudations of Windows store app development",
Status = false,
Resume = "Learn about Xaml and databinding",
CourseMessages = new List<CourseMessage>{},
Owner = brian,
Achievments = new List<Achievment>(),
Students = new List<Student>(),
Groups = new List<Group>()
},
new Course
{
Title = "Programming in C#",
Status = true,
Resume = "Learn how to program in C#",
CourseMessages = new List<CourseMessage>{},
Owner = brian,
Achievments = new List<Achievment>(),
Students = new List<Student>(),
Groups = new List<Group>()
},
new Course
{
Title = "Programming for beginners",
Status = true,
Resume = "For thoses who shouldn't give up the day job",
CourseMessages = new List<CourseMessage>{},
Owner = brian,
Achievments = new List<Achievment>(),
Students = new List<Student>(),
Groups = new List<Group>()
},
new Course
{
Title = "HTML5 and Javascript",
Status = true,
Resume = "Developing Apps in Javascript for all platforms",
CourseMessages = new List<CourseMessage>{},
Owner = jim,
Achievments = new List<Achievment>(),
Students = new List<Student>(),
Groups = new List<Group>()
}
};
//assign courses to local variables
var dotNetDbTechnologies = courses[0];
var aspNetMvc4 = courses[1];
var foundationsofWindowsStore = courses[2];
var programmingCsharp = courses[3];
var programmingForBeginners = courses[4];
var htmlAndJavascript = courses[5];
#endregion
#region Students
//----------------------------------------Students----------------------------------------------------//
var goodStudents = new List<Student>
{
new Student
{
UserName = "******",
CoursesTaken = new List<Course> (courses),
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
},
new Student
{
UserName = "******",
CoursesTaken = new List<Course> (courses),
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
},
new Student
{
UserName = "******",
CoursesTaken = new List<Course> (courses),
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
},
new Student
{
UserName = "******",
CoursesTaken = new List<Course> (courses),
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
},
new Student
{
UserName = "******",
CoursesTaken = new List<Course> (courses),
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
}
};
var stupidStudents = new List<Student>
{
new Student
{
UserName = "******",
CoursesTaken = new List<Course> {courses[3], courses[2],programmingForBeginners,htmlAndJavascript},
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
},
new Student
{
UserName = "******",
CoursesTaken = new List<Course> {courses[3], courses[2],programmingForBeginners,htmlAndJavascript},
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
},
new Student
{
UserName = "******",
CoursesTaken = new List<Course> {courses[3], courses[2],programmingForBeginners,htmlAndJavascript},
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
}
};
var drivers = new List<Student>
{
new Student
{
UserName = "******",
CoursesTaken = new List<Course> {courses[3], courses[4],htmlAndJavascript},
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
},
new Student
{
UserName = "******",
CoursesTaken = new List<Course> {courses[3], courses[4],htmlAndJavascript},
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
},
new Student
{
UserName = "******",
CoursesTaken = new List<Course> {courses[3], courses[4],htmlAndJavascript},
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
},
new Student
{
UserName = "******",
CoursesTaken = new List<Course> {courses[3], courses[4],htmlAndJavascript},
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
},
new Student
{
UserName = "******",
CoursesTaken = new List<Course> {courses[3], courses[4],htmlAndJavascript},
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
},
new Student
{
UserName = "******",
CoursesTaken = new List<Course> {courses[3], courses[4],htmlAndJavascript},
Groups = new List<Group> {},
Achievments = new List<Achievment> {},
MessagesSent = new List<UserMessage>{},
Following = new List<User>{},
Followers = new List<User>{}
}
};
//assign students to local variables
var andrew = goodStudents[0];
var tim = goodStudents[1];
var robert = goodStudents[2];
var narelle = goodStudents[3];
var bartoz = goodStudents[4];
var curly = stupidStudents[0];
var mo = stupidStudents[1];
var stu = stupidStudents[2];
var sebastien = drivers[0];
var fernando = drivers[1];
var nico = drivers[2];
var jenson = drivers[3];
var lewis = drivers[4];
var kimi = drivers[5];
//put all students together
var allstudents = new List<Student>();
allstudents.AddRange(goodStudents);
allstudents.AddRange(stupidStudents);
allstudents.AddRange(drivers);
#endregion
#region Groups
//------------------------------Groups-------------------------------------------------------//
var groups = new List<Group>
{
new Group
{
Title = "MOOCollab",
Status = true,
GroupSize = 5,
Owner = robert,
Course = dotNetDbTechnologies,
Members = new List<Student>(goodStudents),
GroupMessages = new List<GroupMessage>{}
},
new Group
{
Title = "The three stooges",
Status = false,
GroupSize = 5,
Owner = andrew,
Course = foundationsofWindowsStore,
Members = new List<Student>(stupidStudents){andrew},
GroupMessages = new List<GroupMessage> { }
},
new Group
{
Title = "Programmers in need",
Status = true,
GroupSize = 10,
Owner = narelle,
Course = programmingForBeginners,
Members = new List<Student>(drivers){narelle},
GroupMessages = new List<GroupMessage> { }
},
new Group
{
Title = "MVC4 Client side development",
Status = true,
GroupSize = 3,
Owner = bartoz,
Course = aspNetMvc4,
Members = new List<Student>{narelle,andrew,bartoz},
GroupMessages = new List<GroupMessage>{}
},
new Group
{
Title = "ClientSideDesign",
Status = true,
GroupSize = 8,
Owner = bartoz,
Course = htmlAndJavascript,
Members = new List<Student>(drivers){bartoz},
GroupMessages = new List<GroupMessage>{}
},
new Group
{
Title = "DbSkills",
Status = true,
GroupSize = 5,
Owner = tim,
Course = programmingForBeginners,
Members = new List<Student>(stupidStudents){tim},
GroupMessages = new List<GroupMessage>{}
},
new Group
{
Title = "We love linq",
Status = false,
GroupSize = 5,
Owner = narelle,
Course = programmingCsharp,
Members = new List<Student>(goodStudents){},
GroupMessages = new List<GroupMessage>{}
},
new Group
{
Title = "Reshaper skills",
Status = true,
GroupSize = 12,
Owner = tim,
Course = programmingCsharp,
Members = new List<Student>(goodStudents){nico,fernando,curly,stu},
GroupMessages = new List<GroupMessage>{}
},
new Group
{
Title = "We love Spa's",
Status = true,
GroupSize = 12,
Owner = andrew,
Course = htmlAndJavascript,
Members = new List<Student>(drivers){andrew,narelle,robert},
GroupMessages = new List<GroupMessage>{}
},
new Group
{
Title = "Understanding semantic markup",
Status = false,
GroupSize = 6,
Owner = bartoz,
Course = htmlAndJavascript,
Members = new List<Student>(stupidStudents){bartoz,tim,robert},
GroupMessages = new List<GroupMessage>{}
},
new Group
{
Title = "CSS3 for beginners",
Status = true,
GroupSize = 9,
Owner = robert,
Course = htmlAndJavascript,
Members = new List<Student>(drivers){robert,curly},
GroupMessages = new List<GroupMessage>{}
}
};
//give groups referencable names
var groupMooCollab = groups[0];
var groupStooges = groups[1];
var groupProgrammersInNeed = groups[2];
var groupMvc4ClientSide = groups[3];
var groupClientSideDesign = groups[4];
var dbSkills = groups[5];
var weLoveLinq = groups[6];
var reSharperSkills = groups[7];
var weLoveSpas = groups[8];
var understandingSemanticMarkup = groups[9];
var css3ForBeginners = groups[10];
//add groups to students
allstudents.ForEach(s => groups.ForEach(g =>
{
if (g.Members.Contains(s))
{
s.Groups.Add(g);
}
}));
//add groups to courses
groups.ForEach(g => courses.ForEach(c =>
{
if (g.Course == c)
{
c.Groups.Add(g);
}
}));
#endregion
#region Achievments
//--------------------------Achievments-----------------------------------------//
var achievments = new List<Achievment>
{
new Achievment
{
AwardType = AwardType.CourseCompleted,
Description = "Foundations course completed",
Student = goodStudents[0],
Course = courses[0],
Comments = ""
},
new Achievment
{
AwardType = AwardType.OutstandingContribution,
Description = "Very helpful contribution to course",
Student = goodStudents[1],
Course = courses[1],
Comments = ""
},
new Achievment
{
AwardType = AwardType.OutstandingContribution,
Description = "For outstanding support of fellow students",
Student = goodStudents[2],
Course = courses[2],
Comments = ""
}
};
//add achievments to courses
achievments.ForEach(a=> courses.ForEach(c =>
{
if (a.Course == c)
{
c.Achievments.Add(a);
}
}));
#endregion
#region Messages
//instructors message followers.
intructors.ForEach(i =>
{
var message = new UserMessage
{
Content = "Hi this is " + i.UserName + " calling",
Sender = i,
Title = i.UserName + "'s messages followers"
};
i.MessagesSent.Add(message);
});
//Students message followers
allstudents.ForEach(s =>
{
var message = new UserMessage
{
Content = s.UserName + " says thanks for following me",
Sender = s,
Title = "Thank you from " + s.UserName
};
s.MessagesSent.Add(message);
});
//Course owner message course
courses.ForEach(c =>
{
var message = new CourseMessage
{
Title = "Welcome to " + c.Title,
Sender = c.Owner,
Content = "Hi, \n Thanks for taking this course \n " + c.Owner.UserName,
Course = c
};
c.CourseMessages.Add(message);
});
groups.ForEach(g =>
{//send message from group owner
var message = new GroupMessage
{
Title = "Welcome to " + g.Title + " the best group on in the world",
Sender = g.Owner,
Content = "Hi All \n We are going to make this the best group on the system \n " + g.Owner.UserName,
Group = g
};
g.GroupMessages.Add(message);
//cast group members to List
var groupmembers = g.Members as List<Student>;
//Check for null
if (groupmembers != null)
groupmembers.ForEach(gm =>
{//If the current member is not also the owner...
if (gm != g.Owner)
{//add the following message
var memberMessage = new GroupMessage
{
Title = "Dear fellow " + g.Title + " members",
Sender = gm,
Content = "Hi guys \n Am looking forward to working with you. " + g.Title + " is going to be the best group ever \n" + gm.UserName,
Group = g
};
g.GroupMessages.Add(memberMessage);
}
});
});
//------------------------------Messages------------------------------------------//
#endregion
#region Stalking
//Have all students follow Jim
allstudents.ForEach(s => s.Following.Add(jim));
allstudents.ForEach(s => jim.Followers.Add(s));
#endregion
//add achievments to students
allstudents.ForEach(s=> achievments.ForEach(a =>
{
if (a.Student == s)
{
s.Achievments.Add(a);
}
}));
Instructors = intructors.AsQueryable();
Courses = courses.AsQueryable();
Groups = groups.AsQueryable();
Achievments = achievments.AsQueryable();
GoodStudents = goodStudents.AsQueryable();
StupidStudents = stupidStudents.AsQueryable();
Drivers = drivers.AsQueryable();
Students = allstudents.AsQueryable();
//Extract messages
GroupMessages = groups.SelectMany(g=>g.GroupMessages).ToList().AsQueryable();
CourseMessages = courses.SelectMany(c=>c.CourseMessages).ToList().AsQueryable();
//combine instructors and students
var studentsToUsers = allstudents as IEnumerable<User>;
var instructorsToUsers = intructors as IEnumerable<User>;
var allusers = new List<User>(studentsToUsers);
allusers.AddRange(instructorsToUsers);
Users = allusers.AsQueryable();
//Extract user messages
UserMessages = allusers.ToList().SelectMany(u => u.MessagesSent).ToList().AsQueryable();
}
public ActionResult LeaveMessage(string messageSender, string messageReceiver, string message)
{
UserMessage userMessage = new UserMessage();
userMessage.receiver = messageReceiver;
userMessage.sender = messageSender;
userMessage.messageBody = message;
if ((context.Clients.Find(messageSender)).profile != null)
{
userMessage.senderProfile = (context.Clients.Find(messageSender)).profile;
};
userMessage.@new = true;
userMessage.DateCreated = DateTime.Now;
context.UserMessages.Add(userMessage);
context.SaveChanges();
return RedirectToAction("UserProfile", new { UserName = messageReceiver });
}
public static void LogSummary(string summaryMessage, bool showIndividualMessages, bool showAsError)
{
var userMessage = new UserMessage();
userMessage.SummaryMessage = summaryMessage;
public static void WriteToDataStore(UserMessage userMessage)
{
UserMessagingSection objSection = (UserMessagingSection)ConfigurationManager.GetSection("UserMessagingSection");
SQLServerDB databaseSettings = null;
DataAccess objADO = null;
ArrayList colParameters = null;
string strMessage = userMessage.Body;
int intReturn = 0;
int intOutstandingMessageCharacters = 0;
if (objSection != null)
{
databaseSettings = objSection.DataStore;
}
if (databaseSettings == null)
{
throw new Exception("Unable to write User Message to SQL Server as Connection information was not specified");
}
try
{
// Create Data Access instance for communicating with SQL Server
objADO = new DataAccess(databaseSettings.ConnectionString);
// Write to the Log
intOutstandingMessageCharacters = userMessage.Body.Length;
while (intOutstandingMessageCharacters > 0)
{
// Send Message in multiple calls to accommodate limit on No. of Characters
if (userMessage.Body.Length > 7500)
{
strMessage = userMessage.Body.Substring(0, 7500);
intOutstandingMessageCharacters = (userMessage.Body.Length - 7500);
}
else
{
strMessage = userMessage.Body;
intOutstandingMessageCharacters = 0;
}
colParameters = new ArrayList();
colParameters.Add(new SqlParameter("@RecipientID", userMessage.Recipient));
colParameters.Add(new SqlParameter("@Body", userMessage.Body));
if (!string.IsNullOrEmpty(userMessage.Sender))
{
colParameters.Add(new SqlParameter("@ReplyAddress", userMessage.Sender));
}
if (!string.IsNullOrEmpty(userMessage.Subject))
{
colParameters.Add(new SqlParameter("@Subject", userMessage.Subject));
}
if (!string.IsNullOrEmpty(userMessage.TargetUrl))
{
colParameters.Add(new SqlParameter("@TargetUrl", userMessage.TargetUrl));
}
if (userMessage.ExpiryMinutesAfterCreation > -1)
{
colParameters.Add(new SqlParameter("@ExpiryMinutesAfterCreation", userMessage.ExpiryMinutesAfterCreation));
}
if (userMessage.ExpiryMinutesAfterSent > -1)
{
colParameters.Add(new SqlParameter("@ExpiryMinutesAfterCreation", userMessage.ExpiryMinutesAfterSent));
}
if (userMessage.PriorityLevel > 0)
{
colParameters.Add(new SqlParameter("@PriorityLevel", userMessage.PriorityLevel));
}
//workitem #36: Alert Escalation
if (userMessage.AlertID > 0)
{
colParameters.Add(new SqlParameter("@AlertID", userMessage.AlertID));
}
intReturn = objADO.ExecuteSQL(databaseSettings.StoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
if (intOutstandingMessageCharacters > 0)
{
string charactersNotWritten = userMessage.Body.Substring(7500, userMessage.Body.Length - 7500);
}
}
}
catch (Exception excE)
{
throw new Exception("Unable to write User Message to SQL Server as Connection information was not specified", excE);
}
finally
{
objADO = null;
colParameters = null;
}
}
private void ShowPoint()
{
UserMessage userMessage = new UserMessage(String.Format(" X: {0} Y: {1}", player.Position.X, player.Position.Y));
PrintUserMessage(userMessage);
}
private void ShowRoom()
{
UserMessage userMessage = new UserMessage("Room : " + this.currentRoomIndex);
PrintUserMessage(userMessage);
}
/// <summary>
/// Create a new UserMessage object.
/// </summary>
/// <param name="messageId">Initial value of MessageId.</param>
/// <param name="message">Initial value of Message.</param>
/// <param name="creationDate">Initial value of CreationDate.</param>
/// <param name="unread">Initial value of Unread.</param>
public static UserMessage CreateUserMessage(int messageId, string message, global::System.DateTime creationDate, bool unread)
{
UserMessage userMessage = new UserMessage();
userMessage.MessageId = messageId;
userMessage.Message = message;
userMessage.CreationDate = creationDate;
userMessage.Unread = unread;
return userMessage;
}
public IHttpActionResult PostPersonalMessage([FromBody] PersonalMessageBindingModel model)
{
if (model == null)
{
return(this.BadRequest());
}
if (!this.ModelState.IsValid)
{
return(this.BadRequest(this.ModelState));
}
var recipient = this.Data.Users.FirstOrDefault(u => u.UserName == model.Recipient);
if (recipient == null)
{
return(this.BadRequest());
}
if (this.User.Identity.IsAuthenticated)
{
var userId = this.User.Identity.GetUserId();
var sender = this.Data.Users.First(u => u.Id == userId);
var message = new UserMessage()
{
Sender = sender,
Recipient = recipient,
Text = model.Text,
DateSent = DateTime.Now
};
this.Data.UserMessages.Add(message);
this.Data.SaveChanges();
var viewModel = new ChannelMessageCreateWithUserViewModel()
{
Id = message.Id,
Sender = sender.UserName,
Message = "Message sent successfully to user " + recipient.UserName + "."
};
return(this.Ok(viewModel));
}
else
{
var message = new UserMessage()
{
Sender = null,
Recipient = recipient,
Text = model.Text,
DateSent = DateTime.Now
};
this.Data.UserMessages.Add(message);
this.Data.SaveChanges();
var viewModel = new ChannelMessageCreateViewModel()
{
Id = message.Id,
Message = "Anonymous message sent successfully to user " + recipient.UserName + "."
};
return(this.Ok(viewModel));
}
}
public IHttpActionResult PostPersonalMessages([FromBody] UserMessageBindingModel userMessageModel)
{
if (!ModelState.IsValid || userMessageModel == null || string.IsNullOrEmpty(userMessageModel.Text))
{
return BadRequest();
}
var recipient = db.Users.All().FirstOrDefault(u => u.UserName == userMessageModel.UserName);
if (recipient == null)
{
return NotFound();
}
var userId = User.Identity.GetUserId();
User user = null;
if (userId != null)
{
user = db.Users.All().FirstOrDefault(u => u.Id == userId);
}
if (userId != null && user == null)
{
return Unauthorized();
}
var userMessage = new UserMessage()
{
Text = userMessageModel.Text,
DateSent = DateTime.Now,
Reciever = recipient,
Sender = user
};
db.UserMessages.Add(userMessage);
db.SaveChanges();
if (user == null)
{
return this.Ok(new
{
Id = userMessage.Id,
Message = "Anonymous message sent successfully to user " + recipient.UserName + "."
});
}
return this.Ok(new
{
Id = userMessage.Id,
Sender = user.UserName,
Message = "Message sent to user " + recipient.UserName + "."
});
}
public void Weixin()
{
string weChat = ConfigurationManager.AppSettings["WeChatId"].ToString();
string templateId = ConfigurationManager.AppSettings["TemplateId"].ToString();
WeChatUser user = new WeChatUser();
UserSubscribeLog userlog = new UserSubscribeLog();
string accessToken = WeChatHelper.GetAccessToken();
StreamReader stream = new StreamReader(Request.InputStream);
XElement xml = XElement.Load(stream);
// 发送方帐号（open_id）
string fromUserName = GetXmlNodeValue(xml, "FromUserName");
// 公众帐号
string toUserName = GetXmlNodeValue(xml, "ToUserName");
// 消息类型
string msgType = GetXmlNodeValue(xml, "MsgType");
string eventKey = String.Empty;
string MsgId = String.Empty;
if (GetXmlNodeValue(xml, "EventKey") != "")
{
eventKey = GetXmlNodeValue(xml, "EventKey");
}
if (GetXmlNodeValue(xml, "MsgId") != "")
{
MsgId = GetXmlNodeValue(xml, "MsgId");
}
user.OpenId = fromUserName;
userlog.OpenId = fromUserName;
XDocument xdoc = new XDocument();
try
{
#region Event
if (msgType == "event")
{
string eventType = GetXmlNodeValue(xml, "Event");
if (eventType == "subscribe")
{
user.OpenId = fromUserName;
user.Subscribe = 1;
user.SubscribeTime = DateTime.Now;
user.LastUpdateStateTime = DateTime.Now;
user = WeChatHelper.GetSubscirbeUserInfo(accessToken, fromUserName);
userlog.LastUpdateTime = DateTime.Now;
userlog.Subcribe = 1;
try
{
if ((eventKey != null) && (eventKey != ""))
{
if (eventKey.StartsWith("qrscene_"))
{
user.LastSubscribeChannel = Int32.Parse(eventKey.Split('_')[1].ToString());
userlog.Channel = user.LastSubscribeChannel;
}
}
}
catch
{ }
DbServices.InsertUserSubcribeLog(userlog);
DbServices.InsertNewSubscribeUser(user);
List<Message> msglist = DbServices.GetMessage("subscribe");
YACHelper.SetYACUserOpenId(user.OpenId, user.LastSubscribeChannel);
string returnXml = WeChatHelper.ResponseMessage(msglist, user.OpenId);
Response.Write(returnXml);
}
if (eventType == "unsubscribe")
{
user.OpenId = fromUserName;
user.Subscribe = 0;
user.LastUpdateStateTime = DateTime.Now;
//WeChatHelper.GetSubscirbeUserInfo(accessToken, fromUserName);
userlog.Subcribe = 0;
userlog.Channel = 0;
userlog.LastUpdateTime = DateTime.Now;
DbServices.InsertUserSubcribeLog(userlog);
DbServices.UpdateUser(user);
YACHelper.SetYACCancelUserOpenId(user.OpenId, user.LastSubscribeChannel);
}
if (eventType == "LOCATION")
{
}
if (eventType == "CLICK")
{
if (eventKey != "")
{
List<Message> msglist = DbServices.GetMessage(eventKey);
if ((msglist != null) && (msglist.Count > 0))
{
string returnXml = WeChatHelper.ResponseMessage(msglist, user.OpenId);
Response.Write(returnXml);
}
}
}
if (eventType == "VIEW")
{ }
}
#endregion
#region Text
if (msgType == "text")
{
//Response.Write("");
string content = GetXmlNodeValue(xml, "Content");
UserMessage um = new UserMessage();
um.Content = content;
um.OpenId = user.OpenId;
um.MsgId = MsgId;
um.MessageType = "text";
//string withoutTrim = content.Trim();
#region 正常消息反馈机制
int start = Int32.Parse(ConfigurationManager.AppSettings["WorkStart"].ToString());
int end = Int32.Parse(ConfigurationManager.AppSettings["WorkEnd"].ToString());
if ((DateTime.Now.Hour > end) || (DateTime.Now.Hour < start))//晚上9点以后，早上8点以前，自动回复
{
um.ResponseType = "AutoMsg";
DbServices.InsertUserMessage(um);
StringBuilder message = new StringBuilder();
string words = ConfigurationManager.AppSettings["NightWords"].ToString();
message.Append(words);
string returnMsg = WeChatHelper.ResponseMessage(message.ToString(), user.OpenId, weChat);
Response.Write(returnMsg);
}
else
{
if (content == "养爱车求")//特殊关键字
{
um.ResponseType = "AutoMsg";
DbServices.InsertUserMessage(um);
StringBuilder message = new StringBuilder();
message.Append("后台地址：http://120.132.59.94/bk/");
message.Append("公司电话：400 0102 766");
message.Append("请牢记！");
string returnMsg = WeChatHelper.ResponseMessage(message.ToString(), user.OpenId, weChat);
Response.Write(returnMsg);
}
else
{
KeyWord kw = DbServices.FindMyKeyword(content);
if (kw != null)//关键字匹配
{
if (!String.IsNullOrEmpty(kw.MsgKeyValue))//检查消息的keyvalue是否为空，如果不为空，则返回匹配value的消息列表
{
um.ResponseType = "AutoKey";
um.ResponseKeValue = kw.MsgKeyValue;
DbServices.InsertUserMessage(um);
List<Message> msglist = DbServices.GetMessage(kw.MsgKeyValue);
if ((msglist != null) && (msglist.Count > 0))
{
string returnXml = WeChatHelper.ResponseMessage(msglist, user.OpenId);
Response.Write(returnXml);
}
}
else//读取关键字内容
{
um.ResponseType = "AutoMsg";
um.ResponseId = kw.KeyWordId;
DbServices.InsertUserMessage(um);
var staff = DbServices.GetStaff(user.OpenId);
string returnMsg = WeChatHelper.ResponseMessage(kw.Content, user.OpenId, weChat);
Response.Write(returnMsg);
}
}
else//非关键字匹配
{
if (!DbServices.IsExistMessage(um))
{
DbServices.InsertUserMessage(um);
string returnContent = "骚扰大家了，客户向后台发送了文字消息，消息如下：" + content;
bool isSendTemplateMsg = Convert.ToBoolean(ConfigurationManager.AppSettings["TemplateMsgOpen"].ToString());
if (isSendTemplateMsg)
{
List<Staff> staffList = DbServices.GetStaffList();
var wechatUser = DbServices.GetUserInfo(user.OpenId);
string nickname = "养爱车粉丝";
if (wechatUser != null)
{
nickname = wechatUser.NickName;
}
foreach (var staff in staffList)
{
if (staff.IsEnabled)
{
if (!String.IsNullOrEmpty(staff.OpenId))
{
string returnMsg = WeChatHelper.ResponseTemplateMessage(content, staff.OpenId, templateId, nickname);
if (!staff.IsSend)//标记是否已经给这个人发送过模板消息了
{
staff.IsSend = true;
WeChatHelper.PostTemplateMessage(returnMsg, accessToken);
}
}
}
}
}
string responseStr = WeChatHelper.ResponseDKFMessage(user.OpenId, weChat);
Response.Write(responseStr);
}
}
}
}
#endregion
}
#endregion
#region Image
if (msgType == "image")
{
UserMessage um = new UserMessage();
string MediaId = GetXmlNodeValue(xml, "MediaId");
string PicUrl = GetXmlNodeValue(xml, "PicUrl");
um.PicUrl = PicUrl;
um.OpenId = user.OpenId;
um.MessageType = "image";
um.MsgId = MsgId;
um.MediaId = MediaId;
DbServices.InsertUserMessage(um);
bool isNullKeyValue = Boolean.Parse(ConfigurationManager.AppSettings["NullKeyValue"].ToString());
if (isNullKeyValue)
{
Response.Write("");
}
else
{
UserSubscribeLog userSubscribeLog = DbServices.GetUserSubcribeLogInfo(user.OpenId);
if (userSubscribeLog != null)
{
string message = "欢迎关注养爱车:)，您可以从加油站工作人员那里领取养爱车提供的小礼品(每人限领1份)。";
string returnMsg = WeChatHelper.ResponseMessage(message, user.OpenId, weChat);
Response.Write(returnMsg);
}
}
if (DateTime.Now.Hour > 22)
{ }
}
#endregion
#region Vioce
if (msgType == "voice")
{
string MediaId = GetXmlNodeValue(xml, "MediaId");
string Format = GetXmlNodeValue(xml, "Format");
UserMessage um = new UserMessage();
um.OpenId = um.OpenId;
um.MediaId = MediaId;
um.MsgId = MsgId;
um.MessageType = "voice";
DbServices.InsertUserMessage(um);
}
#endregion
#region Link
if (msgType == "link")
{
string Title = GetXmlNodeValue(xml, "Title");
string Description = GetXmlNodeValue(xml, "Description");
string Url = GetXmlNodeValue(xml, "Url");
UserMessage um = new UserMessage();
um.OpenId = um.OpenId;
um.Url = Url;
um.Title = Title;
um.Description = Description;
um.MsgId = MsgId;
um.MessageType = "link";
DbServices.InsertUserMessage(um);
}
#endregion
}
catch
{
Response.Write("");
}
//return "";
}
private Neos.Data.Job SaveJobInfo()
{
UserMessageRepository messageRepo = new UserMessageRepository();
JobRepository jobRepo = new JobRepository();
Neos.Data.Job job = new Neos.Data.Job();
if (!string.IsNullOrEmpty(Request.QueryString["JobId"])) //edit
{
job = jobRepo.FindOne(new Job(Int32.Parse(Request.QueryString["JobId"])));
if (job != null)
{
string responsibleUser = job.CareerManager;
job = SetInfoForJob(job);
jobRepo.Update(job);
if (responsibleUser != ddlResponsible.SelectedValue) // in case select another responsible user
{
if (job.RemindDate.HasValue && job.ExpiredDate.HasValue)
{
UserMessage message = messageRepo.FindMessagesByRef(job.JobID.ToString());
if (message != null)
{
message.UserID = job.CareerManager;
messageRepo.Update(message);
}
}
}
}
}
else //edit
{
job = SetInfoForJob(job);
job.CreatedDate = DateTime.Now;
jobRepo.Insert(job);
//insert a notification message
if (job.RemindDate.HasValue && job.ExpiredDate.HasValue)
{
UserMessage message = new UserMessage();
message.UserID = ddlResponsible.SelectedValue;
message.Type = UserMessageType.JobResponsibility;
message.Subject = ResourceManager.GetString("message.JobReminderSubject");
message.MessageContent = string.Format(ResourceManager.GetString("message.JobReminderContent"), job.ExpiredDate.Value.ToString("dd/MM/yyyy hh:mm tt"), "JobProfile.aspx?JobId=" + job.JobID);
message.RemindDate = job.RemindDate;
message.CreatedDate = DateTime.Now;
message.IsUnread = true;
message.RefID = job.JobID.ToString();
messageRepo.Insert(message);
}
}
return job;
}
public CY.HotelBooking.Core.Business.UserMessage Select(int userMessageId)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@UserMessage_ID", SqlDbType.Int, userMessageId);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectMessageById);
if (reader != null && !reader.IsClosed && reader.Read())
{
UserMessage usermessage = new UserMessage();
if (!reader.IsDBNull(0)) usermessage.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) usermessage.UserID = reader.GetInt32(1);
if (!reader.IsDBNull(2)) usermessage.MessageID = reader.GetInt32(2);
if (!reader.IsDBNull(3)) usermessage.UserMessageState= reader.GetInt32(3);
return usermessage;
}
else
{
if (reader != null && !reader.IsClosed && reader.Read())
reader.Close();
return null;
}
}
public static UserMessageCollection Populate(DataTable userMessageData)
{
UserMessageCollection colMessages = null;
UserMessage objMessage = null;
if (userMessageData.Rows.Count > 0)
{
colMessages = new UserMessageCollection();
foreach (DataRow drMessage in userMessageData.Rows)
{
objMessage = new UserMessage();
objMessage.ID = (int)drMessage["ID"];
objMessage.Recipient = drMessage["RecipientID"].ToString();
objMessage.Body = drMessage["Body"].ToString();
objMessage.DateCreated = (DateTime)drMessage["DateCreated"];
if (!drMessage["Subject"].Equals(DBNull.Value))
{
objMessage.Subject = drMessage["Subject"].ToString();
}
if (!drMessage["DateReceived"].Equals(DBNull.Value))
{
objMessage.DateReceived = (DateTime)drMessage["DateReceived"];
}
if (!drMessage["TargetUrl"].Equals(DBNull.Value))
{
objMessage.TargetUrl = drMessage["TargetUrl"].ToString();
}
if (!drMessage["ReplyAddress"].Equals(DBNull.Value))
{
objMessage.Sender = drMessage["ReplyAddress"].ToString();
}
if (!drMessage["ExpiryMinutesAfterCreation"].Equals(DBNull.Value))
{
objMessage.ExpiryMinutesAfterCreation = (int)drMessage["ExpiryMinutesAfterCreation"];
}
if (!drMessage["ExpiryMinutesAfterSent"].Equals(DBNull.Value))
{
objMessage.ExpiryMinutesAfterSent = (int)drMessage["ExpiryMinutesAfterSent"];
}
if (!drMessage["PriorityLevel"].Equals(DBNull.Value))
{
objMessage.PriorityLevel = (int)drMessage["PriorityLevel"];
}
//Workitem #36: Alert Escalation
objMessage.AlertID = (int)drMessage["AlertID"];
colMessages.Add(objMessage);
}
}
return colMessages;
}
public async Task SendFileAsync(UserMessage requestMessage, string fileName, byte[] data)
{
CheckFileSize(data);
await SendFileAsync(requestMessage.BotId, requestMessage.From.ChatId, requestMessage.From.Huid, null, fileName, data);
}
