public void AddUserMessage()
{
using (var uow = new CapriconContext())
{
//retreive an existing user
var userRepository = new UserRepository(uow);
var existingUser = userRepository.GetAll().FirstOrDefault();
Assert.IsNotNull(existingUser);
//retreive an existing message
var messageRepository = new MessageRepository(uow);
var existingMessage = messageRepository.GetAll().FirstOrDefault();
Assert.IsNotNull(existingMessage);
//create new user messsage
var newUserMessage = new UserMessage()
{
User = existingUser,
Message = existingMessage
};
//add the new user message to the repository
var userMessageRepository = new UserMessageRepository(uow);
userMessageRepository.Add(newUserMessage);
try
{
uow.SaveChanges();
}
catch (DbEntityValidationException ex)
{
//Retrieve validation errors
ex.EntityValidationErrors.ToList().ForEach
(
v =>
{
v.ValidationErrors.ToList().ForEach
(
e =>
{
System.Diagnostics.Debug.WriteLine(e.ErrorMessage);
}
);
}
);
Assert.Fail("Test failed");
}
//retrieve saved object
var uow1 = new CapriconContext();
var repository = new UserMessageRepository(uow1);
var savedUserMessages = repository.GetAll().ToList();
Assert.AreEqual(savedUserMessages[0].User.FirstName, existingUser.FirstName = "james");
Assert.AreEqual(savedUserMessages[0].Message.MessageId, existingMessage.MessageId = 1);
};
}
public void AddUserMessage()
{
using (var uow = new CapriconContext())
{
//retreive an existing user
var userRepository = new UserRepository(uow);
var existingUser = userRepository.GetAll().FirstOrDefault();
Assert.IsNotNull(existingUser);
//retreive an existing message
var messageRepository = new MessageRepository(uow);
var existingMessage = messageRepository.GetAll().FirstOrDefault();
Assert.IsNotNull(existingMessage);
//create new user messsage
var newUserMessage = new UserMessage()
{
User = existingUser,
Message = existingMessage
};
//add the new user message to the repository
var userMessageRepository = new UserMessageRepository(uow);
userMessageRepository.Add(newUserMessage);
try
{
uow.SaveChanges();
}
catch (DbEntityValidationException ex)
{
//Retrieve validation errors
ex.EntityValidationErrors.ToList().ForEach
(
v =>
{
v.ValidationErrors.ToList().ForEach
(
e =>
{
System.Diagnostics.Debug.WriteLine(e.ErrorMessage);
}
);
}
);
Assert.Fail("Test failed");
}
//retrieve saved object
var uow1 = new CapriconContext();
var repository = new UserMessageRepository(uow1);
var savedUserMessages = repository.GetAll().ToList();
Assert.AreEqual(savedUserMessages[0].User.FirstName, existingUser.FirstName = "james");
Assert.AreEqual(savedUserMessages[0].Message.MessageId, existingMessage.MessageId = 1);
};
}
protected void OnMessageGridNeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
if (SessionManager.CurrentUser != null)
{
UserMessageRepository messageRepo = new UserMessageRepository();
MessageGrid.DataSource = messageRepo.GetUnreadJobRemindMessagesToday(SessionManager.CurrentUser.UserID);
}
}
/// <summary>
///
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public List <UserMessageModel> GetUserMessages()
{
var items = UserMessageRepository.GetAll();
if (items != null)
{
return(items.Select(p => p.ToModel()).ToList());
}
return(new List <UserMessageModel>());
}
/// <summary>
///
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public DatatablesView <UserMessageModel> GetUserMessagesByPaging(DataTablesPaging request)
{
int total = 0;
var pagingItems = UserMessageRepository.GetItemsByPaging(request, out total);
var items = new List <UserMessageModel>();
foreach (var pagingItem in pagingItems)
{
var item = pagingItem.ToModel();
items.Add(item);
}
return(new DatatablesView <UserMessageModel>(request.Draw, total, pagingItems.Count, items));
}
public ActionResult Details(long messageID, int?pageIndex)
{
pageIndex = pageIndex ?? 1;
UserMessageRepository.LoadWith(x => x.CreatorUser, x => x.MessageSection);
var message = UserMessageRepository.GetByPK(messageID);
if (message == null || message.ReceiverUserID.HasValue)
{
return(null);
}
var studentIds = _.List(message.CreatorUser.Student_ID.GetValueOrDefault());
var userMessages = UserMessageRepository.GetAll(x => x.ParentMessageID == messageID)
.OrderBy(x => x.UserMessageID)
.ToPagedList(pageIndex.Value - 1);
studentIds.AddRange(userMessages.Select(x => x.CreatorUser.Student_ID.GetValueOrDefault()));
studentIds = studentIds.Where(x => x > 0).ToList();
/* var bestStudents = ProfileService.FilterBestGraduate(studentIds);
* var excelMasterStudents = ProfileService.FilterExcelMaster(studentIds);*/
var realStudents = ProfileService.FilterRealGraduate(studentIds);
var model = new MessageVM {
Message = message,
Answers = userMessages
};
model.AllMessages.ForEach(x => {
var studentId = x.CreatorUser.Student_ID.GetValueOrDefault();
if (studentId > 0)
{
var types = new List <string>();
/* if(bestStudents.Contains(studentId)) {
* types.Add(UserMessage.BestGraduate);
* }
* if(excelMasterStudents.Contains(studentId)) {
* types.Add(UserMessage.ExcelMaster);
* }*/
var real = realStudents.GetValueOrDefault(studentId);
if (real != null)
{
types.Add(UserMessage.RealSpecialist + real);
}
x.BestTypes = types;
}
});
return(View(model));
}
public void DeleteUserMessage()
{
using (var uow = new CapriconContext())
{
var userMessageRepository = new UserMessageRepository(uow);
var existingUserMessage = userMessageRepository.Find(um => um.Id == 2).FirstOrDefault();
Assert.IsNotNull(existingUserMessage);
int id;
if (existingUserMessage != null)
{
id = existingUserMessage.Id;
//Delete selected user message
userMessageRepository.Delete(existingUserMessage);
try
{
uow.SaveChanges();
}
catch (DbEntityValidationException ex)
{
//Retrieve validation errors
ex.EntityValidationErrors.ToList().ForEach
(
v =>
{
v.ValidationErrors.ToList().ForEach
(
e =>
{
System.Diagnostics.Debug.WriteLine(e.ErrorMessage);
}
);
}
);
Assert.Fail("Test failed");
}
Assert.IsNull(userMessageRepository.Find(um => um.Id == id).FirstOrDefault());
}
else //no user messages were selected
{
Assert.Fail("No user message was selected");
}
}
}
public void CanSetStatusToHasBeenReceived()
{
var sendTime = DateTime.Now;
var userMessage = new UserMessage(_toaccount, _fromaccount, sendTime, "message" + _uniqueTestString);
UserMessageRepository userMessageRepository = new UserMessageRepository();
userMessageRepository.Add(userMessage);
Assert.That(userMessage.Id > 0);
userMessage.HasBeenReceived = true;
userMessageRepository.Add(userMessage);
Assert.AreEqual(true, userMessage.HasBeenReceived);
}
public void CanGetTheLastUserMessage()
{
var randomRccount = new Account(0, "RandomAccount" + _uniqueTestString, "ToEmail" + _uniqueTestString,
AccountType.Full);
var accountRepository = new AccountRepository();
accountRepository.Add(_fromaccount);
accountRepository.Add(_toaccount);
accountRepository.Add(randomRccount);
var sendTime = DateTime.Now;
var userMessage1 = new UserMessage(_toaccount, _fromaccount, sendTime, "message" + _uniqueTestString + 1)
{
HasBeenReceived = true
};
var userMessage2 = new UserMessage(_toaccount, _fromaccount, sendTime, "message" + _uniqueTestString + 2)
{
HasBeenReceived = true
};
var userMessage3 = new UserMessage(randomRccount, _fromaccount, sendTime, "message" + _uniqueTestString + 3);
var userMessage4 = new UserMessage(_toaccount, _fromaccount, sendTime, "message" + _uniqueTestString + 3);
UserMessageRepository userMessageRepository = new UserMessageRepository();
userMessageRepository.Add(userMessage1);
userMessageRepository.Add(userMessage2);
userMessageRepository.Add(userMessage3);
userMessageRepository.Add(userMessage4);
var result = userMessageRepository.GetAllPendingMessagesForAccount(_toaccount.Id);
var singleMessage = result.Single();
Assert.AreEqual(userMessage4.Id, singleMessage.Id);
Assert.AreEqual(userMessage4.TextMessage, singleMessage.TextMessage);
Assert.AreEqual(userMessage4.FromAccount.Id, singleMessage.FromAccount.Id);
Assert.AreEqual(userMessage4.FromAccount.Name, singleMessage.FromAccount.Name);
Assert.AreEqual(userMessage4.ToAccount.Id, singleMessage.ToAccount.Id);
}
private void InitControls()
{
int count = 0;
if (SessionManager.CurrentUser != null)
{
count = new UserMessageRepository().CountUnreadJobRemindMessagesToday(SessionManager.CurrentUser.UserID);
lnkUnreadMessage.Text = string.Format(ResourceManager.GetString("lblUnreadMessage"), count);
if (count > 0)
{
lnkUnreadMessage.Font.Bold = true;
}
else
{
lnkUnreadMessage.Font.Bold = false;
lnkUnreadMessage.Text = string.Format(ResourceManager.GetString("lblUnreadMessage"), 0);
}
}
}
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 void UpdateUserMessage()
{
using (var uow = new CapriconContext())
{
var userMessageRepository = new UserMessageRepository(uow);
var existingUserMessage = userMessageRepository.Find(um => um.Id == 1).FirstOrDefault();
Assert.IsNotNull(existingUserMessage);
//retreive an existing user
var userRepository = new UserRepository(uow);
var existingUser = userRepository.Find(u => u.UserId == 1).FirstOrDefault();
Assert.IsNotNull(existingUser);
//retreive an existing message
var messageRepository = new MessageRepository(uow);
var existingMessage = messageRepository.Find(m => m.MessageId == 1).FirstOrDefault();
Assert.IsNotNull(existingMessage);
//edit an existing user message
existingUserMessage.User = existingUser;
existingUserMessage.Message = existingMessage;
userMessageRepository.Attach(existingUserMessage);
uow.Entry(existingUserMessage).State = EntityState.Modified;
try
{
uow.SaveChanges();
}
catch (DbEntityValidationException ex)
{
//Retrieve validation errors
ex.EntityValidationErrors.ToList().ForEach
(
v =>
{
v.ValidationErrors.ToList().ForEach
(
e =>
{
System.Diagnostics.Debug.WriteLine(e.ErrorMessage);
}
);
}
);
Assert.Fail("Test failed");
}
//retrieve saved object
var uow1 = new CapriconContext();
var repository = new UserMessageRepository(uow1);
var savedUserMessages = repository.GetAll().ToList();
Assert.AreEqual(savedUserMessages[0].User, existingUser);
Assert.AreEqual(savedUserMessages[0].Message, existingMessage);
};
}
private void DeleteMessages()
{
UserMessageRepository messageRepo = new UserMessageRepository();
foreach (GridDataItem selectedItem in MessageGrid.SelectedItems)
{
TableCell messageIDCell = selectedItem["MessageID"];
if (messageIDCell != null)
{
int messageID = Convert.ToInt32(messageIDCell.Text);
UserMessage message = messageRepo.FindOne(new UserMessage(messageID));
if (message != null)
{
messageRepo.Delete(message);
}
}
}
MessageGrid.Rebind();
}
protected void OnMyAjaxManagerAjaxRequest(object sender, AjaxRequestEventArgs e)
{
if (e.Argument.IndexOf("MarkAsUnread") != -1 || e.Argument.IndexOf("MarkAsRead") != -1)
{
//MyAjaxManager.AjaxSettings.AddAjaxSetting(MyAjaxManager, ddlActions);
//MyAjaxManager.AjaxSettings.AddAjaxSetting(MyAjaxManager, lblScript);
MyAjaxManager.AjaxSettings.AddAjaxSetting(MyAjaxManager, MessageGrid);
UpdateMessagesStatus(e.Argument);
}
else if (e.Argument.IndexOf("DeleteMessage") != -1)
{
MyAjaxManager.AjaxSettings.AddAjaxSetting(MyAjaxManager, MessageGrid);
DeleteMessages();
}
UserMessageRepository messageRepo = new UserMessageRepository();
int count = messageRepo.CountUnreadJobRemindMessagesToday(SessionManager.CurrentUser.UserID);
bool isBold = (count > 0);
string script = string.Format("resetUnreadMessagesText('{0}',\"{1}\",'{2}');", "lnkUnreadMessage", string.Format(ResourceManager.GetString("lblUnreadMessage"), count), isBold);
MyAjaxManager.ResponseScripts.Add(script);
}
private void UpdateMessagesStatus(string status)
{
UserMessageRepository messageRepo = new UserMessageRepository();
foreach (GridDataItem selectedItem in MessageGrid.SelectedItems)
{
TableCell messageIDCell = selectedItem["MessageID"];
if (messageIDCell != null)
{
int messageID = Convert.ToInt32(messageIDCell.Text);
UserMessage message = messageRepo.FindOne(new UserMessage(messageID));
if (message != null)
{
if (status == "MarkAsRead")
{
message.IsUnread = false;
}
else if (status == "MarkAsUnread")
{
message.IsUnread = true;
}
messageRepo.Update(message);
}
}
}
MessageGrid.Rebind();
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public UserMessageModel GetUserMessage(int id)
{
var item = UserMessageRepository.GetItem(id);
return(item.ToModel());
}
public void UpdateUserMessage()
{
using (var uow = new CapriconContext())
{
var userMessageRepository = new UserMessageRepository(uow);
var existingUserMessage = userMessageRepository.Find(um => um.Id == 1).FirstOrDefault();
Assert.IsNotNull(existingUserMessage);
//retreive an existing user
var userRepository = new UserRepository(uow);
var existingUser = userRepository.Find(u => u.UserId == 1).FirstOrDefault();
Assert.IsNotNull(existingUser);
//retreive an existing message
var messageRepository = new MessageRepository(uow);
var existingMessage = messageRepository.Find(m => m.MessageId == 1).FirstOrDefault();
Assert.IsNotNull(existingMessage);
//edit an existing user message
existingUserMessage.User = existingUser;
existingUserMessage.Message = existingMessage;
userMessageRepository.Attach(existingUserMessage);
uow.Entry(existingUserMessage).State = EntityState.Modified;
try
{
uow.SaveChanges();
}
catch (DbEntityValidationException ex)
{
//Retrieve validation errors
ex.EntityValidationErrors.ToList().ForEach
(
v =>
{
v.ValidationErrors.ToList().ForEach
(
e =>
{
System.Diagnostics.Debug.WriteLine(e.ErrorMessage);
}
);
}
);
Assert.Fail("Test failed");
}
//retrieve saved object
var uow1 = new CapriconContext();
var repository = new UserMessageRepository(uow1);
var savedUserMessages = repository.GetAll().ToList();
Assert.AreEqual(savedUserMessages[0].User, existingUser);
Assert.AreEqual(savedUserMessages[0].Message, existingMessage);
};
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Save(UserMessageModel model)
{
return(UserMessageRepository.Save(model.ToPO()));
}
public void DeleteUserMessage()
{
using (var uow = new CapriconContext())
{
var userMessageRepository = new UserMessageRepository(uow);
var existingUserMessage = userMessageRepository.Find(um => um.Id == 2).FirstOrDefault();
Assert.IsNotNull(existingUserMessage);
int id;
if (existingUserMessage != null)
{
id = existingUserMessage.Id;
//Delete selected user message
userMessageRepository.Delete(existingUserMessage);
try
{
uow.SaveChanges();
}
catch (DbEntityValidationException ex)
{
//Retrieve validation errors
ex.EntityValidationErrors.ToList().ForEach
(
v =>
{
v.ValidationErrors.ToList().ForEach
(
e =>
{
System.Diagnostics.Debug.WriteLine(e.ErrorMessage);
}
);
}
);
Assert.Fail("Test failed");
}
Assert.IsNull(userMessageRepository.Find(um => um.Id == id).FirstOrDefault());
}
else //no user messages were selected
Assert.Fail("No user message was selected");
}
}
private void BindData()
{
UserMessageRepository messageRepo = new UserMessageRepository();
MessageGrid.DataSource = messageRepo.GetUnreadJobRemindMessagesToday(SessionManager.CurrentUser.UserID);
MessageGrid.DataBind();
}
