private void MainMenuProcessData(ThemeListsMenu currentMenu, UiRequest request) { var userId = request.UserId; if (request.IsBackward) { usersDailyTasks[userId] = null; } else if (!usersDailyTasks.ContainsKey(userId) || usersDailyTasks[userId] == null) { var datesCount = GetUsersDateTimesCount(userId); var dates = GetUsersDateTimes(userId, datesCount); var tasksOnDates = dates .Select(d => { var tasksCount = GetUsersTasksCountByDate(userId, d); return(Tuple.Create(d, GetAllTasksOnDate(userId, d, tasksCount))); }) .ToList(); usersDailyTasks[userId] = new DailyTasks(tasksOnDates); mainMenu.Options[0].Options = usersDailyTasks[userId] .GetAllDateTimes() .Select(d => new ThemeListsMenu() { MenuName = d.ToString(), MenuType = MenuType.Menu, Options = null, PreviousMenu = mainMenu.Options[0], ProcessData = ChooseTaskNumberProcessData, RequestFormat = ExpectingRequestFormat.Number }) .ToList(); } }
// GET: DailyTasks/Edit/5 public ActionResult Edit(int?id, string name, string prod) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DailyTasks dailyTasks = db.dailyTasks.Find(id); if (dailyTasks == null) { return(HttpNotFound()); } ApplicationDbContext cont = new ApplicationDbContext(); var task = new List <string>(); var Query = from q in cont.Users where q.businessname == "Employee" orderby q.fullname select q.fullname; task.AddRange(Query.Distinct()); ViewBag.name = new SelectList(task); var task2 = new List <string>(); var Query2 = from q in cont.Products orderby q.ProductId select q.ProductName; task2.AddRange(Query2); ViewBag.prod = new SelectList(task2); return(View(dailyTasks)); }
public ActionResult Create([Bind(Include = "TaskId,ProductId,Product,Quantity,Name,Date,Stime,Etime,Complete")] DailyTasks dailyTasks, string name, string prod) { if (ModelState.IsValid) { ApplicationDbContext cont = new ApplicationDbContext(); var task = new List <string>(); var Query = from q in cont.Users where q.businessname == "Employee" orderby q.fullname select q.fullname; task.AddRange(Query.Distinct()); ViewBag.name = new SelectList(task); var List2 = new List <string>(); var Query2 = from q in cont.Products orderby q.ProductId select q.ProductName; List2.AddRange(Query2); ViewBag.prod = new SelectList(List2); var ss = cont.Products.ToList().Find(x => x.ProductName == prod); dailyTasks.Name = name; dailyTasks.Product = prod; dailyTasks.ProductId = ss.ProductId; dailyTasks.Complete = false; dailyTasks.done = false; db.dailyTasks.Add(dailyTasks); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(dailyTasks)); }
public ActionResult DeleteConfirmed2(int id) { DailyTasks dailyTasks = db.dailyTasks.Find(id); db.dailyTasks.Remove(dailyTasks); db.SaveChanges(); return(RedirectToAction("Index")); }
private void RemoveTasks(DailyTasksResource dtResource, DailyTasks dtDb) { var removed = dtDb.Tasks.Where(x => !dtResource.Tasks.Any(y => y.Id == x.Id)); foreach (var task in removed.ToList()) { context.Tasks.Remove(task); } }
protected override bool Start(params object[] parameters) { ICommonCompomentsFactory factory = (ICommonCompomentsFactory)parameters[0]; //if (ran) throw new InvalidOperationException("Initializing only allowed at program start!"); if (ran) { return(false); } ran = true; Config.Initialize(); CommonComponent.Current.Config = Config.Current; StopTransfers.WalkingSpeed = () => PlanSettingsModel.WalkingSpeedInMps; factory.InitializeTools(); InitializeFields(); //StopPicker.LoadItemSource(); //Alkalmazás első indításakor hívódik meg if (AppFields.VersionId == null) { FirstRun = true; } //verzió kezelés, meghívódik verzió váltáskor if (AppFields.VersionId != CommonComponent.Current.Config.Version) { //Reset(); AppFields.VersionId = CommonComponent.Current.Config.Version; AppFields.ForceUpdate = true; AppFields.PlanningTrialExpired = false; factory.StopBackgroundAgent(); } try { //adatbázisok betöltése CommonComponent.Current.UB = factory.CreateUserBase(); //előzmények öregítése, itt csinálom gyorsan, hogy ne legyenek konkurens tranzakciók, amik a model teljes betöltésének a hatására fog indulni DailyTasks.Subscribe(CommonComponent.Current.UB.History.OldenHistory); DailyTasks.DoAll(); //majd a statikus adatbázist is betöltöm CommonComponent.Current.LoadTransitBase(); } catch (Exception ex) { Reset(); throw; } //csempe frissítő BackgroundAgent indítása factory.StartBackgroundAgent(); return(true); }
/// <summary> /// Gets or sets the daily task for the passed date /// </summary> /// <param name="dateTime">The date you want to get the daily task for</param> /// <returns>The daily task for that day</returns> private TimeTrackerTask GetDailyTask(DateTime dateTime) { var foundTask = DailyTasks.FirstOrDefault(x => x.TaskName == dateTime.Date.ToShortDateString()); if (foundTask == null) { foundTask = new TimeTrackerTask() { TaskName = dateTime.Date.ToShortDateString() }; DailyTasks.Add(foundTask); } return(foundTask); }
// GET: DailyTasks/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DailyTasks dailyTasks = db.dailyTasks.Find(id); if (dailyTasks == null) { return(HttpNotFound()); } return(View(dailyTasks)); }
public object Any(DailyTasks request) { return(new DailyTasksResponse { TechStackFavCountRowsUpdated = Db.ExecuteSql(@"UPDATE technology_stack SET fav_count=fav.count FROM (SELECT technology_stack_id, Count(*) AS Count FROM user_favorite_technology_stack GROUP BY technology_stack_id) as fav WHERE id = fav.technology_stack_id"), TechnologyFavCountRowsUpdated = Db.ExecuteSql(@"UPDATE technology SET fav_count=fav.count FROM (SELECT technology_id, Count(*) AS Count FROM user_favorite_technology GROUP BY technology_id) as fav WHERE id = fav.technology_id"), TechStackViewCountRowsUpdated = Db.ExecuteSql(@"UPDATE technology_stack SET view_count=v.view_count FROM (SELECT ref_slug, view_count FROM page_stats WHERE ref_type='stack') AS v WHERE v.ref_slug = slug"), TechnologyViewCountRowsUpdated = Db.ExecuteSql(@"UPDATE technology SET view_count=v.view_count FROM (SELECT ref_slug, view_count FROM page_stats WHERE ref_type='tech') AS v WHERE v.ref_slug = slug"), UserTechStackCountRowsUpdated = Db.ExecuteSql(@"UPDATE user_activity SET tech_stacks_count=t.total FROM (SELECT owner_id, COUNT(*) as total FROM technology_stack GROUP BY owner_id) AS t WHERE t.owner_id::int = id"), UserTechnologyCountRowsUpdated = Db.ExecuteSql(@"UPDATE user_activity SET technology_count=t.total FROM (SELECT owner_id, COUNT(*) as total FROM technology GROUP BY owner_id) AS t WHERE t.owner_id::int = id"), UserCommentCountRowsUpdated = Db.ExecuteSql(@"UPDATE user_activity SET comments_count=t.total FROM (SELECT user_id, COUNT(*) as total FROM post_comment GROUP BY user_id) AS t WHERE t.user_id = id"), UserUpVotesRowsUpdated = Db.ExecuteSql(@"UPDATE user_activity SET up_votes=t.total FROM (SELECT user_id, SUM(up_votes) as total FROM post GROUP BY user_id) AS t WHERE t.user_id = id"), UserDownVotesRowsUpdated = Db.ExecuteSql(@"UPDATE user_activity SET down_votes=t.total FROM (SELECT user_id, SUM(down_votes) as total FROM post GROUP BY user_id) AS t WHERE t.user_id = id"), UserReportCountRowsUpdated = Db.ExecuteSql(@"UPDATE user_activity SET report_count=t.report_count FROM (SELECT id as user_id, (select count(*) from post_report where user_id = c.id) + (select count(*) from post_comment where user_id = c.id and report_user_ids != null) as report_count FROM custom_user_auth c) t WHERE t.user_id = id") }); }
public async Task <AddTaskResponse> Handle(AddTaskCommand request, CancellationToken cancellationToken) { DailyTasks dailyTasks = new DailyTasks { AddedDate = DateTime.UtcNow, Priority = request.Priority, TaskEndTime = request.TaskEndTime, TaskStartTime = request.TaskStartTime, Title = request.Title, Owner = _httpContextAccessor.HttpContext.User.FindFirst(ClaimTypes.Email).Value }; await _taskService.AddTask(dailyTasks); return(new AddTaskResponse { Message = "New task has successfully added" }); }
public ActionResult EditEmp([Bind(Include = "TaskId,ProductId,Product,Quantity,Name,Date,Stime,Etime,Complete")] DailyTasks dailyTasks) { if (ModelState.IsValid) { Products pro = db.Products.ToList().Find(x => x.ProductId == dailyTasks.ProductId); var now = DateTime.Now; var time = new DateTime(now.Year, now.Month, now.Day, now.Hour, now.Minute, 0); var t = time.TimeOfDay; //Points obj = new Points(); //DateTime today = DateTime.Today; //DateTime time1 = DateTime.Now; //DateTime t2 = Convert.ToDateTime(t); //DateTime t1 = dailyTasks.Etime; //Points name1 = db.points.ToList().Find(x => x.Name == dailyTasks.Name); //int i = DateTime.Compare(t1, t2); //if (name1 != null) //{ // if (i < 0) // { // name1.EmPoints = name1.EmPoints + 1; // } // if (i == 0) // { // name1.EmPoints = name1.EmPoints + 0; // } // if (i > 0) // { // name1.EmPoints = name1.EmPoints - 1; // } //} //else //{ // obj.Name = dailyTasks.Name; // if (i < 0) // { // obj.EmPoints = obj.EmPoints + 1; // } // if (i == 0) // { // obj.EmPoints = obj.EmPoints + 0; // } // if (i > 0) // { // obj.EmPoints = obj.EmPoints - 1; // } //} if (dailyTasks.Complete == true) { pro.qtyh = pro.qtyh + dailyTasks.Quantity; } dailyTasks.CompTime = t.ToString(); db.Entry(dailyTasks).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index2")); } return(View(dailyTasks)); }
public ActionResult Edit([Bind(Include = "TaskId,ProductId,Product,Quantity,Name,Date,Stime,Etime,Complete")] DailyTasks dailyTasks, string name, string prod) { if (ModelState.IsValid) { ApplicationDbContext cont = new ApplicationDbContext(); var task = new List <string>(); var Query = from q in cont.Users where q.businessname == "Employee" orderby q.fullname select q.fullname; task.AddRange(Query.Distinct()); ViewBag.name = new SelectList(task); var List2 = new List <string>(); var Query2 = from q in cont.Products orderby q.ProductId select q.ProductName; List2.AddRange(Query2); ViewBag.prod = new SelectList(List2); var ss = cont.Products.ToList().Find(x => x.ProductName == prod); dailyTasks.Name = name; dailyTasks.Product = prod; dailyTasks.ProductId = ss.ProductId; Products pro = db.Products.ToList().Find(x => x.ProductId == dailyTasks.ProductId); ApplicationDbContext db2 = new ApplicationDbContext(); var daily = db2.dailyTasks.ToList().Find(x => x.TaskId == dailyTasks.TaskId && x.done == false); ApplicationDbContext db3 = new ApplicationDbContext(); var current = db3.dailyTasks.ToList().Find(x => x.TaskId == dailyTasks.TaskId); //Points obj = new Points(); //DateTime today = DateTime.Today; //DateTime time1 = DateTime.Now; //DateTime t2 = Convert.ToDateTime(t); //DateTime t1 = dailyTasks.Etime; //Points name1 = db.points.ToList().Find(x => x.Name == dailyTasks.Name); //int i = DateTime.Compare(t1, t2); //if (name1 != null) //{ // if (i < 0) // { // name1.EmPoints = name1.EmPoints + 1; // } // if (i == 0) // { // name1.EmPoints = name1.EmPoints + 0; // } // if (i > 0) // { // name1.EmPoints = name1.EmPoints - 1; // } //} //else //{ // obj.Name = dailyTasks.Name; // if (i < 0) // { // obj.EmPoints = obj.EmPoints + 1; // } // if (i == 0) // { // obj.EmPoints = obj.EmPoints + 0; // } // if (i > 0) // { // obj.EmPoints = obj.EmPoints - 1; // } //} if (daily != null) { if (dailyTasks.Complete == true) { pro.qtyh = pro.qtyh + dailyTasks.Quantity; dailyTasks.done = true; } } else if (dailyTasks.Complete == true) { int dif = 0; if (current.Quantity > dailyTasks.Quantity) { dif = dif + (current.Quantity - dailyTasks.Quantity); pro.qtyh = pro.qtyh - dif; } else if (current.Quantity < dailyTasks.Quantity) { dif = dif + (dailyTasks.Quantity - current.Quantity); pro.qtyh = pro.qtyh + dif; } else if (current.Quantity == dailyTasks.Quantity) { pro.qtyh = pro.qtyh; } } db.Entry(dailyTasks).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(dailyTasks)); }
public void RemoveDailyTask(int Id) { DailyTasks.Remove(Id); RemoveJob(Id); }
public async Task AddTask(DailyTasks dailyTasks) { await _taskRepository.Insert(dailyTasks); }