public ToDoListResponse All()
{
ToDoListResponse todoListResponse = new ToDoListResponse();
using (var context = new iTrellis_ToDoEntities())
{
foreach (ToDoList todoList in context.ToDoLists.Include(x => x.ToDoTaskItems).ToList())
{
Core.Model.ToDoList coreToDoList = new Core.Model.ToDoList();
coreToDoList.ID = todoList.ID;
coreToDoList.CreatedByUserID = todoList.CreatedByUserID;
coreToDoList.CreatedByUserName = todoList.UserProfile.UserName;
coreToDoList.DateCreated = todoList.DateCreated;
coreToDoList.ListName = todoList.ListName;
foreach (var dataItem in todoList.ToDoTaskItems)
{
Core.Model.ToDoTaskItem coreItem = new Core.Model.ToDoTaskItem();
coreItem.ID = dataItem.ID;
coreItem.ItemCompletedDate = dataItem.ItemCompletedDate;
coreItem.ItemCreatedDate = dataItem.ItemCreatedDate;
coreItem.ItemDetails = dataItem.ItemDetails;
coreItem.ItemIsDeleted = dataItem.ItemIsDeleted;
coreItem.ItemName = dataItem.ItemName;
coreItem.ItemUpdatedDate = dataItem.ItemUpdatedDate;
coreItem.ItemDueDate = dataItem.ItemDueDate;
coreToDoList.TaskItems.Add(coreItem);
}
todoListResponse.ToDoLists.Add(coreToDoList);
}
}
return(todoListResponse);
}
public ToDoListResponse Sync(SyncToDoRequest request)
{
ToDoListResponse response = new ToDoListResponse();
try
{
response.ToDos = new List <ToDoViewModel>();
if (request.LastUpdatedAt != null)
{
response.ToDos.AddRange(unitOfWork.GetToDoRepository()
.GetToDosNewerThen(request.CompanyId, (DateTime)request.LastUpdatedAt)
?.ConvertToToDoViewModelList() ?? new List <ToDoViewModel>());
}
else
{
response.ToDos.AddRange(unitOfWork.GetToDoRepository()
.GetToDos(request.CompanyId)
?.ConvertToToDoViewModelList() ?? new List <ToDoViewModel>());
}
response.Success = true;
}
catch (Exception ex)
{
response.ToDos = new List <ToDoViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public ToDoListResponse GetToDosNewerThen(int companyId, DateTime?lastUpdateTime)
{
ToDoListResponse response = new ToDoListResponse();
try
{
if (lastUpdateTime != null)
{
response.ToDos = unitOfWork.GetToDoRepository()
.GetToDosNewerThen(companyId, (DateTime)lastUpdateTime)
.ConvertToToDoViewModelList();
}
else
{
response.ToDos = unitOfWork.GetToDoRepository()
.GetToDos(companyId)
.ConvertToToDoViewModelList();
}
response.Success = true;
}
catch (Exception ex)
{
response.ToDos = new List <ToDoViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public async Task <ToDoListResponse> CreateToDoTask(ToDoDataContext context, ToDo AddToDoRequest)
{
ToDo toDo = new ToDo
{
//ToDoId = AddToDoRequest.ToDoId,
Title = AddToDoRequest.Title,
Notes = AddToDoRequest.Notes,
DateCreated = DateTime.Now,
ReminderDate = AddToDoRequest.ReminderDate,
DueDate = AddToDoRequest.DueDate,
IsDone = AddToDoRequest.IsDone,
ToDoType = (ToDoTypeId)AddToDoRequest.ToDoType
};
context.ToDo.Add(toDo);
var response = await context.SaveChangesAsync();
var getTodo = context.ToDo.SingleOrDefault(getToDo => getToDo.ToDoId == toDo.ToDoId);
if (getTodo == null)
{
throw new Exception("No Data found");
}
var toDoListResponse = new ToDoListResponse
{
ToDoId = getTodo.ToDoId,
Title = getTodo.Title,
DateCreated = getTodo.DateCreated,
ToDoType = getTodo.ToDoType,
Notes = getTodo.Notes
};
return(toDoListResponse);
}
public ActionResult Index(int id)
{
_todoListResponse = _todoListService.All();
if (_todoListResponse.Success)
{
todoListModel = new ToDoListModel(_todoListResponse.ToDoLists.Where(x => x.ID == id).SingleOrDefault());
}
return(View(todoListModel));
}
public ActionResult Add(ToDoListResponse usertodo)
{
usertodo.Status = "Not Start";
usertodo.ID = 2;
todo.Add(usertodo);
ViewBag.mylist = todo;
return(View("index"));
}
public ActionResult Delete(int id)
{
if (todo != null)
{
ToDoListResponse _todo = todo.First(t => t.ID == id);
todo.Remove(_todo);
}
ViewBag.mylist = todo;
return(View("index"));
}
public ToDoListResponse CreateToDoList(Core.Model.ToDoList coreToDoList)
{
ToDoListResponse todolistresponse = new ToDoListResponse();
try
{
todolistresponse = _iqueryToDoLists.CreateToDoList(coreToDoList);
}
catch (Exception ex)
{
todolistresponse.Success = false;
todolistresponse.ErrorMessage = ex.ToString();
}
return(todolistresponse);
}
public ToDoListResponse All()
{
ToDoListResponse todolistresponse = new ToDoListResponse();
try
{
todolistresponse = _iqueryToDoLists.All();
todolistresponse.Success = true;
}
catch (Exception ex)
{
todolistresponse.Success = false;
todolistresponse.ErrorMessage = ex.ToString();
}
return(todolistresponse);
}
public ToDoListResponse Sync(SyncToDoRequest request)
{
ToDoListResponse response = new ToDoListResponse();
try
{
response = WpfApiHandler.SendToApi <SyncToDoRequest, ToDoViewModel, ToDoListResponse>(request, "Sync");
}
catch (Exception ex)
{
response.ToDos = new List <ToDoViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public ActionResult callchangeFun(int todoid, int Status)
{
ToDoListResponse _todo = todo.First(t => t.ID == todoid);
if (Status == 1)
{
if (_todo.Status == "Not Start")
{
_todo.Status = "Start";
}
}
else if (Status == 5)
{
_todo.Status = "End";
}
ViewBag.mylist = todo;
return(View("index"));
}
public ToDoListResponse CreateToDoList(Core.Model.ToDoList coreToDoList)
{
ToDoListResponse todoListResponse = new ToDoListResponse();
using (var context = new iTrellis_ToDoEntities())
{
ToDoList dataToDoList = new ToDoList();
dataToDoList.CreatedByUserID = coreToDoList.CreatedByUserID;
dataToDoList.DateCreated = coreToDoList.DateCreated;
dataToDoList.ID = coreToDoList.ID;
dataToDoList.ListName = coreToDoList.ListName;
context.ToDoLists.Add(dataToDoList);
context.SaveChanges();
coreToDoList.ID = dataToDoList.ID;
}
todoListResponse.ToDoLists = new List <Core.Model.ToDoList>();
todoListResponse.ToDoLists.Add(coreToDoList);
return(todoListResponse);
}
public JsonResult GetToDos(int companyId)
{
ToDoListResponse response = new ToDoListResponse();
try
{
response = toDoService.GetToDos(companyId);
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
Console.WriteLine(ex.Message);
}
return(Json(response, new Newtonsoft.Json.JsonSerializerSettings()
{
Formatting = Newtonsoft.Json.Formatting.Indented
}));
}
public JsonResult Sync([FromBody] SyncToDoRequest request)
{
ToDoListResponse response = new ToDoListResponse();
try
{
response = this.toDoService.Sync(request);
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(Json(response, new Newtonsoft.Json.JsonSerializerSettings()
{
Formatting = Newtonsoft.Json.Formatting.Indented
}));
}
public ToDoListResponse GetPrivateToDos(int companyId, string filterString)
{
ToDoListResponse response = new ToDoListResponse();
List <ToDoViewModel> ToDos = new List <ToDoViewModel>();
using (SqliteConnection db = new SqliteConnection("Filename=SirmiumERPGFC.db"))
{
db.Open();
try
{
SqliteCommand selectCommand = new SqliteCommand(
SqlCommandSelectPart +
"FROM ToDos " +
"WHERE CompanyId = @CompanyId " +
"AND IsPrivate = 1 " +
"AND CreatedById = @CreatedById " +
"ORDER BY IsSynced, Id DESC;", db);
selectCommand.Parameters.AddWithValue("@CompanyId", companyId);
selectCommand.Parameters.AddWithValue("@CreatedById", MainWindow.CurrentUserId);
SqliteDataReader query = selectCommand.ExecuteReader();
while (query.Read())
{
ToDos.Add(Read(query));
}
}
catch (SqliteException error)
{
MainWindow.ErrorMessage = error.Message;
response.Success = false;
response.Message = error.Message;
response.ToDos = new List <ToDoViewModel>();
return(response);
}
db.Close();
}
response.Success = true;
response.ToDos = ToDos;
return(response);
}
public async Task <ToDoListResponse> GetToDoTask(ToDoDataContext context, int ToDoTaskId)
{
var getTodo = context.ToDo.SingleOrDefault(getToDo => getToDo.ToDoId == ToDoTaskId);
if (getTodo == null)
{
throw new Exception("No Data found");
}
var toDoListResponse = new ToDoListResponse
{
ToDoId = getTodo.ToDoId,
Title = getTodo.Title,
DateCreated = getTodo.DateCreated,
ToDoType = getTodo.ToDoType,
Notes = getTodo.Notes
};
return(toDoListResponse);
}
public ToDoListResponse GetToDos(int companyId)
{
ToDoListResponse response = new ToDoListResponse();
try
{
response = WpfApiHandler.GetFromApi <List <ToDoViewModel>, ToDoListResponse>("GetToDos", new Dictionary <string, string>()
{
{ "CompanyId", companyId.ToString() }
});
}
catch (Exception ex)
{
response.ToDos = new List <ToDoViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public ToDoListResponse GetToDos(int companyId)
{
ToDoListResponse response = new ToDoListResponse();
try
{
response.ToDos = unitOfWork.GetToDoRepository()
.GetToDos(companyId)
.ConvertToToDoViewModelList();
response.Success = true;
}
catch (Exception ex)
{
response.ToDos = new List <ToDoViewModel>();
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
public ToDoListsModel(ToDoListResponse todoListResponse)
{
success = todoListResponse.Success;
if (success)
{
todolistmodels = new List <ToDoListModel>();
foreach (var todoList in todoListResponse.ToDoLists)
{
ToDoListModel todolistmodel = new ToDoListModel(todoList);
todolistmodel.DateCreated = todoList.DateCreated;
todolistmodel.ListName = todoList.ListName;
todolistmodel.UserName = todoList.CreatedByUserName;
todolistmodel.ID = todoList.ID;
todolistmodels.Add(todolistmodel);
}
}
else
{
this.ErrorMessage = todoListResponse.ErrorMessage;
}
}
public override DataGridResult <ToDoListElement> execute(DataGridInput input)
{
ToDoListRequest request = new ToDoListRequest();
request.UserInfo = NavigationHandler.UserInfo;
request.PageSize = input.NumResForPage;
request.RequestedPage = input.NumPage;
request.IdGruppo = NavigationHandler.RuoloInfo.IdGruppo;
request.Registri = NavigationHandler.Registri;
if (!string.IsNullOrEmpty(input.IdParent))
{
request.ParentFolderId = input.IdParent;
}
ToDoListResponse resp = WSStub.getTodoList(request);
DataGridResult <ToDoListElement> res = new DataGridResult <ToDoListElement>();
res.NumTotResults = resp.TotalRecordCount;
res.Elements = new List <ToDoListElement>();
foreach (ToDoListElement temp in resp.Elements)
{
res.Elements.Add(temp);
}
return(res);
}
public void Sync(IToDoService toDoService, Action <int, int> callback = null)
{
try
{
SyncToDoRequest request = new SyncToDoRequest();
request.CompanyId = MainWindow.CurrentCompanyId;
request.LastUpdatedAt = GetLastUpdatedAt(MainWindow.CurrentCompanyId);
int toSync = 0;
int syncedItems = 0;
ToDoListResponse response = toDoService.Sync(request);
if (response.Success)
{
toSync = response?.ToDos?.Count ?? 0;
List <ToDoViewModel> toDosFromDB = response.ToDos;
using (SqliteConnection db = new SqliteConnection(SQLiteHelper.SqLiteTableName))
{
db.Open();
using (var transaction = db.BeginTransaction())
{
SqliteCommand deleteCommand = db.CreateCommand();
deleteCommand.CommandText = "DELETE FROM ToDos WHERE Identifier = @Identifier";
SqliteCommand insertCommand = db.CreateCommand();
insertCommand.CommandText = SqlCommandInsertPart;
foreach (var toDo in toDosFromDB)
{
deleteCommand.Parameters.AddWithValue("@Identifier", toDo.Identifier);
deleteCommand.ExecuteNonQuery();
deleteCommand.Parameters.Clear();
if (toDo.IsActive)
{
toDo.IsSynced = true;
insertCommand = AddCreateParameters(insertCommand, toDo);
insertCommand.ExecuteNonQuery();
insertCommand.Parameters.Clear();
syncedItems++;
callback?.Invoke(syncedItems, toSync);
}
}
transaction.Commit();
}
db.Close();
}
}
else
{
throw new Exception(response.Message);
}
}
catch (Exception ex)
{
MainWindow.ErrorMessage = ex.Message;
}
}
protected override void ExecuteParticular(MainModel model)
{
logger.Info("begin");
model.TabShow = Tab.TODO_LIST;
ToDoListRequest request = new ToDoListRequest();
request.UserInfo = NavigationHandler.CurrentUser;
if (NavigationHandler.DeleganteInfo != null) //Abbiamo una delega in esercizio
{
request.UserInfo.DelegatoInfo = NavigationHandler.LoggedInfo;
}
request.PageSize = ConfigurationHandler.NumResultsForPage;
request.RequestedPage = _currentPage;
request.IdGruppo = NavigationHandler.RuoloInfo.IdGruppo;
request.IdCorrGlobali = NavigationHandler.RuoloInfo.Id;
request.Registri = NavigationHandler.Registri;
request.ParentFolderId = IdParent;
request.FascId = IdFasc;
ToDoListResponse resp = WSStub.getTodoList(request);
logger.Info("responseCode: " + resp.Code);
if (resp.Code == ToDoListResponseCode.OK)
{
ToDoListModel tabModel = new ToDoListModel(resp.TotalRecordCount, ConfigurationHandler.NumResultsForPage);
tabModel.IdParent = IdParent;
tabModel.NomeParent = NomeParent;
tabModel.ToDoListElements = resp.Elements;
if (resp.TotalRecordCount == 0)
{
tabModel.CurrentPage = 0;
}
else
{
tabModel.CurrentPage = _currentPage;
}
if (_numElements < 0 || IdParent == null)
{
_numElements = resp.TotalRecordCount;
}
if (_idTrasm != null)
{
foreach (ToDoListElement el in tabModel.ToDoListElements)
{
el.IdTrasm = _idTrasm;
}
}
//Verifico se il pulsante visto è visibile
bool setDataVista = ConfigurationHandler.IsVisibleButtonVisto;
tabModel.SetDataVista = setDataVista;
tabModel.NumElements = _numElements;
model.TabModel = tabModel;
NavigationHandler.ToDoListMemento = Memento;
}
else
{
logger.Info("add system error");
addSystemError(model);
}
logger.Info("end");
}
