private void pBoxTaskComplete_Click(object sender, EventArgs e)
        {
            if (Icon == null)
            {
                Bitmap img = new Bitmap("C:\\Users\\sajib\\source\\repos\\Task Manager\\image\\checkmark.png");
                Icon = img;

                pBoxTaskComplete.Refresh();
                Thread.Sleep(1000);

                TaskSer taskS = new TaskSer();
                taskS.Update(Task_ID, 1);

                //HomePage2.home2.Close();
                //HomePage2.home2 = new HomePage2();
                //HomePage2.home2.Show();

                UserControlForOnlyTestPurpose.uC.LoadTaskList();
            }
        }
        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();
        }