private void button5_Click(object sender, EventArgs e) { if (!button5.Text.Equals("Show Uncompleted Task")) { button5.Text = "Show Uncompleted Task"; flowLayoutPanel1Today.Controls.Clear(); List <Tasks> tk; TaskSer cs = new TaskSer(); CategorySer cg = new CategorySer(); int cat_Id = cg.GetCategoryID(ProjectName, LogIn.user_ID); //tk = cs.GetAll(cat_Id); cg = new CategorySer(); tk = cs.GetAllCompleteOrNotTask(1, cat_Id); for (int i = 0; i < tk.Count; i++) { AddTaskInfo ad = new AddTaskInfo(); ad.Tittle = tk[i].Tittle; //DateTime dt = DateTime.Parse(tk[i].Date, "dddd, dd MMMM yyyy"); ad.Date = Convert.ToDateTime(tk[i].Date).ToLongDateString(); ad.Task_ID = tk[i].Task_ID; Bitmap img = new Bitmap("C:\\Users\\sajib\\source\\repos\\Task Manager\\image\\checkmark.png"); ad.Icon = img; flowLayoutPanel1Today.Controls.Add(ad); } } else { button5.Text = "Show Completed Task"; flowLayoutPanel1Today.Controls.Clear(); List <Tasks> tk; TaskSer cs = new TaskSer(); CategorySer cg = new CategorySer(); int cat_Id = cg.GetCategoryID(ProjectName, LogIn.user_ID); cg = new CategorySer(); tk = cs.GetAll(cat_Id); for (int i = 0; i < tk.Count; i++) { AddTaskInfo ad = new AddTaskInfo(); ad.Tittle = tk[i].Tittle; ad.Date = Convert.ToDateTime(tk[i].Date).ToLongTimeString(); ad.Task_ID = tk[i].Task_ID; flowLayoutPanel1Today.Controls.Add(ad); } } }
private void HomePage2_Load(object sender, EventArgs e) { //Before //CategoryListShow(); //ContentUserControl cuc = new ContentUserControl(); //CategorySer s = new CategorySer(); //if(category_ID != 0) // cuc.ProjectName = s.GetCategoryName(category_ID, LogIn.user_ID); //else if(CategoryName != "") //{ // category_ID = s.GetCategoryID(CategoryName, LogIn.user_ID); // cuc.ProjectName = CategoryName; //} ////int cat_ID = s.GetCategoryID("Inbox"); //TaskListShow(cuc.Flow, category_ID); //panel4.Controls.Add(cuc); //After try { if (checkFormLoadFirstTime == false) { CategoryListShow(); CategorySer s = new CategorySer(); int catID = s.GetCategoryID("Inbox", LogIn.user_ID); TaskSer taskS = new TaskSer(); List <Tasks> taskList = taskS.GetAll(catID); UserControlForOnlyTestPurpose.uC.Project_Name = "Inbox"; UserControlForOnlyTestPurpose.uC.LoadTaskList(taskList); checkFormLoadFirstTime = true; } } catch (Exception ep) { MessageBox.Show(ep.Message); } }
//After public void ForProjectUserControl(string projectName) { try { CategorySer s = new CategorySer(); int catID = s.GetCategoryID(projectName, LogIn.user_ID); TaskSer taskS = new TaskSer(); List <Tasks> taskList = taskS.GetAll(catID); userControlForOnlyTestPurpose2.Project_Name = projectName; userControlForOnlyTestPurpose2.LoadTaskList(taskList); } catch (Exception ep) { MessageBox.Show(ep.Message); } }
private void button4_Click(object sender, EventArgs e) { if (comboBox3.SelectedIndex < 0) { MessageBox.Show("Select Reminder"); } else { UserSer userS = new UserSer(); int viewerID = userS.GetUserIdByEmail(comboBox2.SelectedItem.ToString()); CategorySer cg = new CategorySer(); int catID = cg.GetCategoryID(comboBox3.SelectedItem.ToString(), LogIn.user_ID); userS = new UserSer(); userS.Delete(viewerID, LogIn.user_ID, catID); comboBox3.Items.Remove(comboBox3.SelectedItem); comboBox3.Text = ""; } }
private void btnInbox_Click(object sender, EventArgs e) { //After try { //CategoryListShow(); CategorySer s = new CategorySer(); int catID = s.GetCategoryID("Inbox", LogIn.user_ID); TaskSer taskS = new TaskSer(); List <Tasks> taskList = taskS.GetAll(catID); UserControlForOnlyTestPurpose.uC.Project_Name = "Inbox"; UserControlForOnlyTestPurpose.uC.LoadTaskList(taskList); } catch (Exception ep) { MessageBox.Show(ep.Message); } }
public void RefreshContent() { flowLayoutPanel1Today.Controls.Clear(); List <Tasks> tk; TaskSer cs = new TaskSer(); CategorySer cg = new CategorySer(); int cat_Id = cg.GetCategoryID(ProjectName, LogIn.user_ID); //MessageBox.Show(ProjectName); //MessageBox.Show(cat_Id.ToString()); cg = new CategorySer(); tk = cs.GetAllSortByDate(cat_Id); for (int i = 0; i < tk.Count; i++) { AddTaskInfo ad = new AddTaskInfo(); ad.Tittle = tk[i].Tittle; ad.Date = Convert.ToDateTime(tk[i].Date).ToLongDateString(); ad.Task_ID = tk[i].Task_ID; flowLayoutPanel1Today.Controls.Add(ad); } }
private void comboBox3_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox3.SelectedIndex < 0) { MessageBox.Show("Select Category!!!!"); } else { string catName = comboBox3.SelectedItem.ToString(); CategorySer catS = new CategorySer(); int catID = catS.GetCategoryID(catName, LogIn.user_ID); ShareTaskSer tS = new ShareTaskSer(); List <int> tkIDList = tS.GetAllTasksFromShareTasks(catID); TaskSer taskService; string tittle; for (int i = 0; i < tkIDList.Count; i++) { taskService = new TaskSer(); tittle = taskService.GetTaskTittle(catID, tkIDList[i]); cBCategory.Items.Add(tittle); } } }
private int GetCategoryID() { CategorySer cg = new CategorySer(); return(cg.GetCategoryID(Project_Name, LogIn.user_ID)); }
private int GetCatID(string catName) { CategorySer cs = new CategorySer(); return(cs.GetCategoryID(catName, LogIn.user_ID)); }
private void button1_Click(object sender, EventArgs e) { bool checkRepeatIsChange = false; TaskSer taskService = new TaskSer(); Tasks ts = new Tasks(); ts.Task_ID = obj.Task_ID; ts.Tittle = textBox1.Text; ts.Description = textBox2.Text; ts.Date = dateTimePicker2.Value.ToShortDateString(); ts.Time = dateTimePicker1.Value.ToShortTimeString(); CategorySer cS = new CategorySer(); int cat_ID; if (cBCategory.SelectedIndex < 0) { cat_ID = cS.GetCategoryID("Inbox", LogIn.user_ID); } else { cat_ID = cS.GetCategoryID(cBCategory.SelectedItem.ToString(), LogIn.user_ID); } ts.Category_ID = cat_ID; int prio; if (cBPriority.SelectedIndex < 0) { prio = 1; } else { if (cBPriority.SelectedItem.ToString().Equals("High")) { prio = 3; } else if (cBPriority.SelectedItem.ToString().Equals("Medium")) { prio = 2; } else { prio = 1; } } ts.Priority = prio; List <BeforeNotificationTime> notificationTimeList = new List <BeforeNotificationTime>(); if (cBSelectedReminders.Items.Count == 0) { //MessageBox.Show(cBSelectedReminders.Items.Count.ToString()); BeforeNotificationTime notifyTime = new BeforeNotificationTime(); notifyTime.Date = dateTimePicker2.Value.ToShortDateString(); notifyTime.Time = dateTimePicker1.Value.ToShortTimeString(); notificationTimeList.Add(notifyTime); } else { //MessageBox.Show("Inside The Else Part"); //5 minutes before //10 minutes before //15 minutes before //30 minutes before //1 hour before for (int i = 0; i < cBSelectedReminders.Items.Count; i++) { BeforeNotificationTime notifyTime = new BeforeNotificationTime(); string time; time = cBSelectedReminders.Items[i].ToString(); string an = ""; for (int k = 0; k < time.Length; k++) { if (time[k] == ' ') { break; } an += (time[k].ToString()); } int timeValue = Convert.ToInt32(an); //MessageBox.Show(timeValue.ToString()); if (cBSelectedReminders.Items[i].ToString().Contains("minutes before - NO")) { //MessageBox.Show("Inside Minutes Part"); notifyTime.NotifyTimeBeforeString = cBSelectedReminders.Items[i].ToString(); notifyTime.Date = dateTimePicker2.Value.ToShortDateString(); DateTime tm = dateTimePicker1.Value; DateTime tm2 = tm.AddMinutes(timeValue); TimeSpan t = tm2 - tm; tm = tm - t; notifyTime.Time = tm.ToShortTimeString(); //MessageBox.Show(tm.ToShortTimeString()); if (cBSelectedReminders.Items.ToString().Contains("EM")) { notifyTime.Notify_Via = 2; } if (cBSelectedReminders.Items.ToString().Contains("SM")) { notifyTime.Notify_Via = 3; } else { notifyTime.Notify_Via = 1; } notificationTimeList.Add(notifyTime); } else if (cBSelectedReminders.Items[i].ToString().Contains("hours before - NO")) { //MessageBox.Show("Inside Hours Part"); notifyTime.NotifyTimeBeforeString = cBSelectedReminders.Items[i].ToString(); notifyTime.Date = dateTimePicker2.Value.ToShortDateString(); DateTime tm = dateTimePicker1.Value; DateTime tm2 = tm.AddHours(timeValue); TimeSpan t = tm2 - tm; tm = tm - t; notifyTime.Time = tm.ToShortTimeString(); if (cBSelectedReminders.Items.ToString().Contains("EM")) { notifyTime.Notify_Via = 2; } if (cBSelectedReminders.Items.ToString().Contains("SM")) { notifyTime.Notify_Via = 3; } else { notifyTime.Notify_Via = 1; } notificationTimeList.Add(notifyTime); } else if (cBSelectedReminders.Items[i].ToString().Contains("days before - NO")) { //MessageBox.Show("Inside Days Part"); notifyTime.NotifyTimeBeforeString = cBSelectedReminders.Items[i].ToString(); DateTime tm = dateTimePicker1.Value; DateTime tm2 = tm.AddDays(timeValue); TimeSpan t = tm2 - tm; tm = tm - t; notifyTime.Date = tm.ToShortDateString(); notifyTime.Time = dateTimePicker1.Value.ToShortTimeString(); if (cBSelectedReminders.Items.ToString().Contains("EM")) { notifyTime.Notify_Via = 2; } if (cBSelectedReminders.Items.ToString().Contains("SM")) { notifyTime.Notify_Via = 3; } else { notifyTime.Notify_Via = 1; } notificationTimeList.Add(notifyTime); } else { //MessageBox.Show("Inside Weeks Part"); notifyTime.NotifyTimeBeforeString = cBSelectedReminders.Items[i].ToString(); DateTime tm = dateTimePicker1.Value; DateTime tm2 = tm.AddDays(timeValue * 7); TimeSpan t = tm2 - tm; tm = tm - t; notifyTime.Date = tm.ToShortDateString(); notifyTime.Time = dateTimePicker1.Value.ToShortTimeString(); if (cBSelectedReminders.Items.ToString().Contains("EM")) { notifyTime.Notify_Via = 2; } if (cBSelectedReminders.Items.ToString().Contains("SM")) { notifyTime.Notify_Via = 3; } else { notifyTime.Notify_Via = 1; } notificationTimeList.Add(notifyTime); } } } ts.Notify_Time_List = notificationTimeList; List <string> repeateDateList = new List <string>(100); if (cBRepeat.Text.Equals(obj.RepeatName) || cBRepeat.SelectedIndex < 0) { ts.Repeat_Date_List = obj.Repeat_Date_List; } else { if (MessageBox.Show("Are you update All Task Which is follwing this task????", "Hello!!", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { checkRepeatIsChange = true; TaskSer taskS = new TaskSer(); taskS.DeleteByRepeatID(obj.RepeatDateTask_ID); ts.RepeatDateTask_ID = System.Guid.NewGuid().ToString(); if (cBRepeat.SelectedItem.ToString().Equals("Every day")) { DateTime dt = DateTime.Now; for (int i = 0; i < repeateDateList.Capacity; i++) { repeateDateList.Add(dt.ToShortDateString()); dt = dt.AddDays(1); } } else if (cBRepeat.SelectedItem.ToString().Equals("Every week")) { DateTime dt = DateTime.Now; for (int i = 0; i < repeateDateList.Capacity; i++) { repeateDateList.Add(dt.ToShortDateString()); dt = dt.AddDays(7); } } else if (cBRepeat.SelectedItem.ToString().Equals("Every month")) { DateTime dt = DateTime.Now; for (int i = 0; i < repeateDateList.Capacity; i++) { repeateDateList.Add(dt.ToShortDateString()); dt = dt.AddMonths(1); } } else { DateTime dt = DateTime.Now; for (int i = 0; i < repeateDateList.Capacity; i++) { repeateDateList.Add(dt.ToShortDateString()); dt = dt.AddYears(1); } } } else { cBRepeat.Text = obj.RepeatName; } } if (checkRepeatIsChange) { ts.Repeat_Date_List = repeateDateList; TaskSer tSer = new TaskSer(); tSer.Insert(ts); } else { TaskSer tSer = new TaskSer(); tSer.Update(ts); } this.Close(); }
private void AddTaskInDatabase() { List <string> repeateDateList = new List <string>(100); List <BeforeNotificationTime> notificationTimeList = new List <BeforeNotificationTime>(); CategorySer cSer = new CategorySer(); if (textBox1.Text != null) { Tasks ts = new Tasks(); ts.Tittle = textBox1.Text; if (textBox2.Text != null) { ts.Description = textBox2.Text; } ts.Date = dateTimePicker2.Value.ToShortDateString(); ts.Time = dateTimePicker1.Value.ToString("hh:mm tt"); if (cBCategory.SelectedIndex < 0) { ts.Category_ID = cSer.GetCategoryID("Inbox", LogIn.user_ID); } else { ts.Category_ID = cSer.GetCategoryID(cBCategory.SelectedItem.ToString(), LogIn.user_ID); } if (cBPriority.SelectedIndex < 0) { ts.Priority = 1; } else { if (cBPriority.SelectedItem.ToString().Equals("High")) { ts.Priority = 3; } else if (cBPriority.SelectedItem.ToString().Equals("Medium")) { ts.Priority = 2; } else { ts.Priority = 1; } } if (cBRepeat.SelectedIndex < 0) { ts.RepeatDateTask_ID = System.Guid.NewGuid().ToString(); } else { ts.RepeatDateTask_ID = System.Guid.NewGuid().ToString(); if (cBRepeat.SelectedItem.ToString().Equals("Every day")) { DateTime dt = DateTime.Now; for (int i = 0; i < repeateDateList.Capacity; i++) { repeateDateList.Add(dt.ToShortDateString()); dt = dt.AddDays(1); } } else if (cBRepeat.SelectedItem.ToString().Equals("Every week")) { DateTime dt = DateTime.Now; for (int i = 0; i < repeateDateList.Capacity; i++) { repeateDateList.Add(dt.ToShortDateString()); dt = dt.AddDays(7); } } else if (cBRepeat.SelectedItem.ToString().Equals("Every month")) { DateTime dt = DateTime.Now; for (int i = 0; i < repeateDateList.Capacity; i++) { repeateDateList.Add(dt.ToShortDateString()); dt = dt.AddMonths(1); } } else { DateTime dt = DateTime.Now; for (int i = 0; i < repeateDateList.Capacity; i++) { repeateDateList.Add(dt.ToShortDateString()); dt = dt.AddYears(1); } } } if (cBSelectedReminders.Items.Count == 0) { //MessageBox.Show(cBSelectedReminders.Items.Count.ToString()); BeforeNotificationTime notifyTime = new BeforeNotificationTime(); notifyTime.Date = dateTimePicker2.Value.ToShortDateString(); notifyTime.Time = dateTimePicker1.Value.ToShortTimeString(); notificationTimeList.Add(notifyTime); } else { //MessageBox.Show("Inside The Else Part"); //5 minutes before //10 minutes before //15 minutes before //30 minutes before //1 hour before for (int i = 0; i < cBSelectedReminders.Items.Count; i++) { BeforeNotificationTime notifyTime = new BeforeNotificationTime(); string time; time = cBSelectedReminders.Items[i].ToString(); string an = ""; for (int k = 0; k < time.Length; k++) { if (time[k] == ' ') { break; } an += (time[k].ToString()); } int timeValue = Convert.ToInt32(an); //MessageBox.Show(timeValue.ToString()); if (cBSelectedReminders.Items[i].ToString().Contains("minutes before - NO")) { //MessageBox.Show("Inside Minutes Part"); notifyTime.NotifyTimeBeforeString = cBSelectedReminders.Items[i].ToString(); notifyTime.Date = dateTimePicker2.Value.ToShortDateString(); DateTime tm = dateTimePicker1.Value; DateTime tm2 = tm.AddMinutes(timeValue); TimeSpan t = tm2 - tm; tm = tm - t; notifyTime.Time = tm.ToShortTimeString(); //MessageBox.Show(tm.ToShortTimeString()); if (cBSelectedReminders.Items.ToString().Contains("EM")) { notifyTime.Notify_Via = 2; } if (cBSelectedReminders.Items.ToString().Contains("SM")) { notifyTime.Notify_Via = 3; } else { notifyTime.Notify_Via = 1; } notificationTimeList.Add(notifyTime); } else if (cBSelectedReminders.Items[i].ToString().Contains("hours before - NO")) { //MessageBox.Show("Inside Hours Part"); notifyTime.NotifyTimeBeforeString = cBSelectedReminders.Items[i].ToString(); notifyTime.Date = dateTimePicker2.Value.ToShortDateString(); DateTime tm = dateTimePicker1.Value; DateTime tm2 = tm.AddHours(timeValue); TimeSpan t = tm2 - tm; tm = tm - t; notifyTime.Time = tm.ToShortTimeString(); if (cBSelectedReminders.Items.ToString().Contains("EM")) { notifyTime.Notify_Via = 2; } if (cBSelectedReminders.Items.ToString().Contains("SM")) { notifyTime.Notify_Via = 3; } else { notifyTime.Notify_Via = 1; } notificationTimeList.Add(notifyTime); } else if (cBSelectedReminders.Items[i].ToString().Contains("days before - NO")) { //MessageBox.Show("Inside Days Part"); notifyTime.NotifyTimeBeforeString = cBSelectedReminders.Items[i].ToString(); DateTime tm = dateTimePicker1.Value; DateTime tm2 = tm.AddDays(timeValue); TimeSpan t = tm2 - tm; tm = tm - t; notifyTime.Date = tm.ToShortDateString(); notifyTime.Time = dateTimePicker1.Value.ToShortTimeString(); if (cBSelectedReminders.Items.ToString().Contains("EM")) { notifyTime.Notify_Via = 2; } if (cBSelectedReminders.Items.ToString().Contains("SM")) { notifyTime.Notify_Via = 3; } else { notifyTime.Notify_Via = 1; } notificationTimeList.Add(notifyTime); } else { //MessageBox.Show("Inside Weeks Part"); notifyTime.NotifyTimeBeforeString = cBSelectedReminders.Items[i].ToString(); DateTime tm = dateTimePicker1.Value; DateTime tm2 = tm.AddDays(timeValue * 7); TimeSpan t = tm2 - tm; tm = tm - t; notifyTime.Date = tm.ToShortDateString(); notifyTime.Time = dateTimePicker1.Value.ToShortTimeString(); if (cBSelectedReminders.Items.ToString().Contains("EM")) { notifyTime.Notify_Via = 2; } if (cBSelectedReminders.Items.ToString().Contains("SM")) { notifyTime.Notify_Via = 3; } else { notifyTime.Notify_Via = 1; } notificationTimeList.Add(notifyTime); } } } ts.Repeat_Date_List = repeateDateList; ts.Notify_Time_List = notificationTimeList; TaskSer taskService = new TaskSer(); List <int> taskID = taskService.Insert(ts); taskService = new TaskSer(); taskService.InsertInNotificationTime(taskID, ts); MessageBox.Show("Task Is Added!!!"); this.Close(); UserControlForOnlyTestPurpose.uC.LoadTaskList(); } else { MessageBox.Show("You Should be Put the task tittle!!!"); } }
private void button7_Click(object sender, EventArgs e) { CategorySer cg = new CategorySer(); int cat_Id = cg.GetCategoryID(ProjectName, LogIn.user_ID); OpenFileDialog fb = new OpenFileDialog(); fb.Filter = "Excel Office | *.xls; *.xlsx"; if (fb.ShowDialog() == DialogResult.OK) { FileStream strem = new FileStream(fb.FileName, FileMode.Open, FileAccess.Read); IExcelDataReader exReader = ExcelReaderFactory.CreateReader(strem); DataSet ds = exReader.AsDataSet(new ExcelDataSetConfiguration() { ConfigureDataTable = (_) => new ExcelDataTableConfiguration() { UseHeaderRow = true } }); TaskSer tkSer = new TaskSer(); List <Tasks> tk = new List <Tasks>(); Tasks t; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { t = new Tasks(); for (int j = 0; j < ds.Tables[0].Columns.Count; j++) { if (j == 0) { t.Task_ID = Convert.ToInt32(ds.Tables[0].Rows[i][j].ToString()); } else if (j == 1) { t.Tittle = ds.Tables[0].Rows[i][j].ToString(); } else if (j == 2) { t.Date = ds.Tables[0].Rows[i][j].ToString(); } else if (j == 3) { t.Time = ds.Tables[0].Rows[i][j].ToString(); } else if (j == 4) { t.RepeatDateTask_ID = ds.Tables[0].Rows[i][j].ToString(); } else if (j == 5) { t.Description = ds.Tables[0].Rows[i][j].ToString(); } else if (j == 6) { t.Priority = Convert.ToInt32(ds.Tables[0].Rows[i][j].ToString()); } else if (j == 7) { t.Category_ID = cat_Id; } else { t.Task_Complete = Convert.ToInt32(ds.Tables[0].Rows[i][j].ToString()); } } tk.Add(t); } exReader.Close(); strem.Close(); for (int i = 0; i < tk.Count; i++) { tkSer.Insert(tk[i]); } MessageBox.Show("File Is Imported"); } }