public void AddToDoMessages(string userName, IEnumerable<TodoMessageDto> list)
{
//if (!ValidateEnumerableParam(list)) return;
using (var context = new TodoDBEntities())
{
var user = context.Users.FirstOrDefault(x => x.UserName == userName);
foreach (var item in list)
{
var msg = context.TodoMessages.CreateObject();
msg.IsCompleted = item.IsCompleted;
msg.PriorityID = (int)item.Priority;
msg.Person = item.Person;
msg.Message = item.Message;
msg.Users = user;
context.TodoMessages.AddObject(msg);
context.SaveChanges();
}
}
this.RunPriorityWorkflow(userName, list);
//using (var callback = new TodoServiceCallbackClient())
// callback.OnAddToDoMessagesComplete(userName, true);
}
public int CreateUser(string userName)
{
if (string.IsNullOrWhiteSpace(userName))
throw new ArgumentException("argument userName is null or empty");
int result = -1;
using (var context = new TodoDBEntities())
{
var newUser = context.Users.CreateObject();
newUser.UserName = userName;
context.Users.AddObject(newUser);
context.SaveChanges();
result = newUser.ID;
}
return result;
}
public static void TodoPriorityExecute(string userName, IEnumerable<TodoMessageDto> list)
{
//simple logic
using (var context = new TodoDBEntities())
{
var user = context.Users.FirstOrDefault(x => x.UserName == userName);
foreach(var item in context.TodoMessages)
{
if(item.PriorityID == (int)PriorityType.High)
{
item.Message = item.Message.ToUpper();
}
else
{
item.Message = item.Message.ToLower();
}
}
context.SaveChanges();
}
}
public void UpdateToDoMessages(string userName, IEnumerable<TodoMessageDto> list)
{
//if (!ValidateEnumerableParam(list)) return;
using (var context = new TodoDBEntities())
{
var user = context.Users.FirstOrDefault(x => x.UserName == userName);
foreach (var item in list)
{
var msg = context.TodoMessages.CreateObject();
msg.ID = item.Id;
msg.IsCompleted = item.IsCompleted;
msg.PriorityID = (int)item.Priority;
msg.Person = item.Person;
msg.Message = item.Message;
msg.Users = user;
//context.TodoMessages.Attach(msg);
context.ObjectStateManager.ChangeObjectState(msg, System.Data.EntityState.Modified);
}
context.SaveChanges();
}
this.RunPriorityWorkflow(userName, list);
}
public void RemoveToDoMessages(string userName, IEnumerable<int> ids)
{
//if (!ValidateEnumerableParam(ids)) return;
using (var context = new TodoDBEntities())
{
context.ExecuteStoreCommand(@"delete from TodoMessages where ID in (" + string.Join(",", ids).PadRight(1) + ")");
context.SaveChanges();
}
using (var callback = new TodoServiceCallbackClient())
callback.OnRemoveToDoMessagesComplete(userName, true);
}
