protected void gridLeftBtnAcceptAll_Click(object sender, EventArgs e)
        {
            foreach (GridViewRow row in gridViewLeftPanel1.Rows)
            {
                CheckBox cb = (CheckBox)row.FindControl("gridLeftChkBoxSelect");
                if (cb.Checked)
                {
                    int userid = Convert.ToInt32(Session["UserId"]);
                    JobTracker jobtracker = new JobTracker();
                    JobTrackerHistory jtHist = new JobTrackerHistory();
                    //var data = jobtracker.GetRequestNeededApproval(userid);
                    Label jobtrackId = (Label)row.FindControl("gridLeftlblJobTrackId");
                    jobtracker = jobtracker.GetJobTracker(Convert.ToInt32(jobtrackId.Text), false);

                    if (jobtracker.ActionRequest == "Delete")
                    {
                        jobtracker.Status = "Approved";
                        jtHist = jtHist.ConvertToHistory(jobtracker);
                        jobtracker.Delete(jobtracker.Id);
                    }
                    else
                    {
                        jobtracker.Status = "Approved";
                        jobtracker.Update(jobtracker);
                        jtHist = jtHist.ConvertToHistory(jobtracker);
                    }
                    jtHist.Insert(jtHist);
                }
            }
            gridLeftChkBoxSelectAll.Checked = false;
            InitializeGridViewLeftPanel1(new List<string>());
            InitializeGridViewLeftPanel2();
            InitializeGridViewLeftPanel3();
        }
        protected void ConnectToCAP()
        {
            JobTracker jobtracker = new JobTracker();

            PanelLogin.Visible = jobtracker.CanConnectToCAP();
            Panel_Error.Visible = !jobtracker.CanConnectToCAP();
        }
        public JobTrackerHistory ConvertToHistory(JobTracker jobtracker)
        {
            JobTrackerHistory jthist = new JobTrackerHistory();
            jthist.JobTrackerId = jobtracker.Id;
            jthist.JobIdNumber = jobtracker.JobIdNumber;
            jthist.JobTypeId = jobtracker.JobTypeId;
            jthist.Remarks = jobtracker.Remarks;
            jthist.Description = jobtracker.Description;
            jthist.StartTime = jobtracker.StartTime;
            jthist.EndTime = jobtracker.EndTime;
            jthist.ApprovedBy = jobtracker.ApprovedBy;
            jthist.CreatedBy = jobtracker.CreatedBy;
            jthist.LastUpdateDate = jobtracker.LastUpdateDate;
            jthist.LastUpdatedBy = jobtracker.LastUpdatedBy;
            jthist.CreateDate = jobtracker.CreateDate;
            jthist.Status = jobtracker.Status;
            jthist.SupervisorRemarks = jobtracker.SupervisorRemarks;
            jthist.UserId = jobtracker.UserId;
            jthist.ScheduleDate = jobtracker.ScheduleDate;
            jthist.Action = jobtracker.ActionRequest;
            jthist.JobStatus = jobtracker.JobStatus;
            jthist.HWNo = jobtracker.HWNo;
            jthist.SWNo = jobtracker.SWNo;
            jthist.Customer = jobtracker.Customer;
            jthist.EvalNo = jobtracker.EvalNo;

            return jthist;
        }
        protected void InitializeRepError()
        {
            JobTracker jobtracker = new JobTracker();
            var data = jobtracker.GetUnclosedJobs(Convert.ToInt32(Session["UserId"]));
            List<string> openjobs = new List<string>();
            foreach (JobTracker j in data)
            {
                openjobs.Add("Unclosed job: "+j.jobtype+", opened last "+Convert.ToDateTime(j.StartTime).ToString("dd-MMM-yyyy hh:mm"));
            }

            RepError.DataSource = openjobs;
            RepError.DataBind();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            JobTracker jobtracker = new JobTracker();
            if (!isValidUser() || (!jobtracker.CanConnectToCAP()))
                Response.Redirect("Login.aspx");
            if (!HasAccess())
                Response.Redirect("Dashboard.aspx");
            HttpContext.Current.Session["siteSubHeader"] = "Report";
            HttpContext.Current.Session["selectedTab"] = "Report";

            if (!IsPostBack)
            {
                InitializeRepeater();
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            JobTracker jobtracker = new JobTracker();
            if (!isValidUser() || (!jobtracker.CanConnectToCAP()))
                Response.Redirect("Login.aspx");
            GetMyAccessRights();
            if (myAccessRights == null)
                Response.Redirect("Dashboard.aspx");
            HttpContext.Current.Session["siteSubHeader"] = "Setup";
            HttpContext.Current.Session["selectedTab"] = "Setup";

            if (!IsPostBack)
            {
                modalTxtBoxMessage.Attributes.Add("onchange", "DefaultValue();");
            }
        }
        protected void BtnBreak_Click(object sender, EventArgs e)
        {
            int userid = Convert.ToInt32(Session["UserId"]);
            JobType jobtype = new JobType();
            jobtype = jobtype.GetDefaultBreak();
            DateTime selectedDate = DateTime.Parse(txtBoxDate.Text);
            JobTracker jobtracker = new JobTracker();
            bool noError = true;
            User user = new User();
            user = user.GetUser(userid, selectedDate);

            if (jobtracker.HasPreviousUnclosedJobs(userid,DateTime.Today)) //check if user has unclosed jobs
            {
                noError = false;
                panelAlertHeader2.CssClass = "modalAlertHeader";
                alertModalBtnOK2.CssClass = "buttonalert";
                labelAlertHeader2.Text = "Error";
                labelAlertMessage2.Text = "Please close all jobs before adding a new one.";
                programmaticAlertModalPopup2.Show();
            }
            else
            {
                string errMsg = "";
                errMsg = jobtracker.GetError(userid, selectedDate, 30); //check if there is an error
                if (errMsg.Trim() != "")
                {
                    noError = false;
                    panelAlertHeader2.CssClass = "modalAlertHeader";
                    alertModalBtnOK2.CssClass = "buttonalert";
                    labelAlertHeader2.Text = "Error";
                    labelAlertMessage2.Text = errMsg.Trim() + " Please settle error first.";
                    programmaticAlertModalPopup2.Show();
                }
            }
            if (noError)
            {
                if (TimeSpan.Parse(user.startTime) > TimeSpan.Parse(user.endTime)) //check if user has shifting hours
                {
                    RunBreakButtonActionForShifting();
                }
                else
                {
                    RunBreakButtonAction();
                }

            }
        }
 protected void modalBtnSync_Command(object sender, CommandEventArgs e)
 {
     modalTxtBoxMessage.Text = "Initializing....";
     modalTxtBoxMessage.Text = modalTxtBoxMessage.Text + Environment.NewLine + "Gathering Data....";
     JobTracker jobtracker = new JobTracker();
     var data = jobtracker.GetJobTrackerListWithJobId(false);
     for (int i = 0; i < data.Count; i++)
     {
         modalTxtBoxMessage.Text = modalTxtBoxMessage.Text + Environment.NewLine + "Synchronizing "+(i + 1)+" of "+ data.Count;
         jobtracker = jobtracker.GenerateHWAndSW(data[i].JobIdNumber.ToString().Trim());
         data[i].Customer = jobtracker.Customer;
         data[i].Description = jobtracker.Description;
         data[i].HWNo = jobtracker.HWNo;
         data[i].SWNo = jobtracker.SWNo;
         data[i].EvalNo = jobtracker.EvalNo;
         jobtracker.Update(data[i]);
     }
     modalTxtBoxMessage.Text = modalTxtBoxMessage.Text + Environment.NewLine + "Synchronization Complete.";
 }
        public List<Analysis> GetAnalysis(int departmentid, DateTime startdate, DateTime enddate, string stringjobid,string customer,int roleid)
        {
            List<Analysis> data = new List<Analysis>();
            JobTracker jobtracker = new JobTracker();
            List<JobTracker> joblist = new List<JobTracker>();
            JobTypeDepartment jobtypeDepartment = new JobTypeDepartment();
            List<JobType> jobtypelist = new List<JobType>();
            if (departmentid == 0)
            {
                //joblist = jobtracker.GetJobTrackerForAnalysis(startdate, enddate);
                JobType jobtype = new JobType();
                jobtypelist = jobtype.GetJobTypeListByRoleId(roleid);
            }
            else
            {
                //joblist = jobtracker.GetJobTrackerForAnalysis(departmentid, startdate, enddate);
                jobtypelist = jobtypeDepartment.GetJobTypeList(departmentid);
            }
            for (int i = 0; i < jobtypelist.Count; i++)
            {
                Analysis newAnalysis = new Analysis();
                newAnalysis.jobtype = jobtypelist[i].Description;
                newAnalysis.jobtypeid = jobtypelist[i].Id.ToString();
                newAnalysis.totalworktime = jobtracker.GetTotalHours(jobtypelist[i].Id, startdate, enddate, "Approved", departmentid, stringjobid,customer);
                newAnalysis.totalforapproval = jobtracker.GetTotalHours(jobtypelist[i].Id, startdate, enddate, "For Approval", departmentid, stringjobid,customer);
                newAnalysis.totaljobTime = "";
                if (stringjobid.Trim() != "" || customer.Trim() != "")
                {
                    newAnalysis.totaljobTime = jobtracker.GetTotalHours(jobtypelist[i].Id, Convert.ToDateTime("1900-01-01"), DateTime.Now, "Approved", departmentid, stringjobid, customer);
                }
                //newAnalysis.totalrejectedtime = jobtracker.GetTotalHours(jobtypelist[i].Id, startdate, enddate, "Rejected", departmentid, stringjobid,customer);
                //newAnalysis.totalunclosedjobs = jobtracker.GetTotalUnclosedJobs(jobtypelist[i].Id, startdate, enddate, "Pending", departmentid, stringjobid).ToString();
                data.Add(newAnalysis);
            }

            return data;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            JobTracker jobtracker = new JobTracker();
            if (!isValidUser() || (!jobtracker.CanConnectToCAP()))
                Response.Redirect("Login.aspx");
            GetMyAccessRights();
            if (myAccessRights == null)
                Response.Redirect("Dashboard.aspx");
            HttpContext.Current.Session["siteSubHeader"] = "Setup";
            HttpContext.Current.Session["selectedTab"] = "Setup";

            if (!IsPostBack)
            {
                modalTxtBoxStartDate.Attributes.Add("readonly", "readonly"); //prevents user from typing on calendar textbox
                InitializeDropDownDepartment();
                InitializeGridUser();
                calendarExtenderStartDate.EndDate = DateTime.Today;
                calendarExtenderPatternStartDate.EndDate = DateTime.Today;
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            JobTracker jobtracker = new JobTracker();
            if (!isValidUser() || (!jobtracker.CanConnectToCAP()))
                Response.Redirect("Login.aspx");
            GetMyAccessRights();
            if (myAccessRights == null)
                Response.Redirect("Dashboard.aspx");
            HttpContext.Current.Session["siteSubHeader"] = "Setup";
            HttpContext.Current.Session["selectedTab"] = "Setup";

            if (!IsPostBack)
            {
                InitializeDropDownDepartment();
                InitializeGridUser();
            }
        }
        protected void InitializeGridViewBottom2()
        {
            JobTracker jobTracker = new JobTracker();
            List<JobTracker> data = new List<JobTracker>();
            gridViewBottom2.EmptyDataText = "No data found";

            if (ddlBottomPersonel.Items.Count > 0)
            {
                //if (ddlBottomPersonel.SelectedItem.Text.Trim() != "All")
                //{
                //    gridViewBottom2.EmptyDataText = "No Data Found";
                //    int personelid = Convert.ToInt32(ddlBottomPersonel.SelectedItem.Value);
                //    DateTime startdate = Convert.ToDateTime(txtBoxBottomFromDate.Text.Trim() + " 00:00:00");
                //    DateTime enddate = Convert.ToDateTime(txtBoxBottomToDate.Text.Trim() + " 23:59:59");
                //    data = jobTracker.GetJobTrackerListExcludeRejected(personelid, startdate, enddate, false);
                //}
                //else
                //{
                DateTime startdate = Convert.ToDateTime(txtBoxBottomFromDate.Text.Trim() + " 00:00:00");
                DateTime enddate = Convert.ToDateTime(txtBoxBottomToDate.Text.Trim() + " 23:59:59");
                int deptid = Convert.ToInt32(ddlBottomDepartment.SelectedValue);
                string jobid = txtBoxBottomJobId.Text.Trim();
                string customer = txtBoxBottomCustomer.Text.Trim();
                int userid = Convert.ToInt32(ddlBottomPersonel.SelectedItem.Value);
                data = jobTracker.GetJobTrackerListExcludeRejected(startdate, enddate, userid, deptid, jobid, customer,true);
                //}
            }

            gridViewBottom2.DataSource = data;
            gridViewBottom2.DataBind();
        }
        private void GenerateSummaryRows(ref DataTable table)
        {
            Department dept = new Department();
            JobTypeDepartment jobtypeDepartment = new JobTypeDepartment();
            JobTracker jobtracker = new JobTracker();
            //joboverviewDepartment = dept.GetJobOverviewDepartment();
            distincProjectList = jobtracker.GetDistinctProjectList(Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), txtBoxJobId.Text.Trim());
            joboverviewRow = new List<List<List<JobTracker>>>();
            for (int y = 0; y < distincProjectList.Count;y++ )
            {
                joboverviewRow.Add(new List<List<JobTracker>>());
                DataRow row = table.NewRow();
                row["HW No"] = distincProjectList[y].HWNo == null ? "" : distincProjectList[y].HWNo.Trim();
                row["SW No"] = distincProjectList[y].SWNo == null ? "" : distincProjectList[y].SWNo.Trim();
                row["Customer"] = distincProjectList[y].Customer == null ? "" : distincProjectList[y].Customer.Trim();
                row["Description"] = distincProjectList[y].Description == null ? "" : distincProjectList[y].Description.Trim();
                for (int x = 0; x < joboverviewDepartment.Count; x++)
                {
                    List<JobTracker> jtlist = new List<JobTracker>();
                    for (int i = 0; i < joboverviewJobType[x].Count; i++)
                    {
                        JobTracker l = jobtracker.GetJobTrackerJobOverview(joboverviewJobType[x][i].Id, distincProjectList[y].SWNo, distincProjectList[y].HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), joboverviewDepartment[x].Id);
                        jtlist.Add(l);
                    }
                    joboverviewRow[y].Add(jtlist);
                    JobTracker j = new JobTracker();
                    string curstatus = "";
                    int curindex = -1;
                    for (int i = 0; i < jtlist.Count; i++)
                    {
                        if (jtlist[i] == null)
                            continue;
                        else if (jtlist[i].JobStatus.IndexOf("On Hold") > -1)
                        {
                            curstatus = "On Hold";
                            curindex = i;

                            break;
                        }
                        else if (jtlist[i].JobStatus.IndexOf("In Progress") > -1)
                        {
                            if (curstatus != "In Progress")
                            {
                                curstatus = "In Progress";
                                curindex = i;
                            }
                        }
                        else if (jtlist[i].JobStatus.IndexOf("Completed") > -1 && curindex < 0)
                        {
                            if (curstatus == "")
                            {
                                curstatus = "Completed";
                                curindex = i;
                            }
                        }
                    }
                    if (curindex != -1)
                    {
                        j = jtlist[curindex];
                    }
                    //JobTracker j = jobtracker.GetJobTrackerJobOverview(p.SWNo, p.HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), d.Id);
                    if (j == null)
                    {
                        row[joboverviewDepartment[x].Acronym + "" + joboverviewDepartment[x].Id] = "";
                    }
                    else
                    {
                        row[joboverviewDepartment[x].Acronym + "" + joboverviewDepartment[x].Id] = joboverviewDepartment[x].Id + "|" + j.JobStatus + " " + Convert.ToDateTime(j.EndTime).ToString("dd-MMM-yyyy") + "|" + distincProjectList[y].HWNo + "|" + distincProjectList[y].SWNo;
                    }
                }
                table.Rows.Add(row);
            }
        }
 private void ParseJobTracker(T_JobTracker data,JobTracker jobtracker)
 {
     data.Id = jobtracker.Id;
     data.JobIdNumber = jobtracker.JobIdNumber;
     data.JobTypeId = jobtracker.JobTypeId;
     data.Remarks = jobtracker.Remarks;
     data.Description = jobtracker.Description;
     data.StartTime = jobtracker.StartTime;
     data.EndTime = jobtracker.EndTime;
     data.ApprovedBy = jobtracker.ApprovedBy;
     data.CreatedBy = jobtracker.CreatedBy;
     data.LastUpdateDate = jobtracker.LastUpdateDate;
     data.LastUpdatedBy = jobtracker.LastUpdatedBy;
     data.CreateDate = jobtracker.CreateDate;
     data.Status = jobtracker.Status;
     data.SupervisorRemarks = jobtracker.SupervisorRemarks;
     data.UserId = jobtracker.UserId;
     data.ScheduleDate = jobtracker.ScheduleDate;
     data.ActionRequest = jobtracker.ActionRequest;
     data.HWNo = jobtracker.HWNo;
     data.SWNo = jobtracker.SWNo;
     data.JobStatus = jobtracker.JobStatus;
     data.Customer = jobtracker.Customer;
     data.EvalNo = jobtracker.EvalNo;
 }
        //Get Jobtracker data for Overview Tab
        public JobTracker GetJobTrackerJobOverview(string SW, string HW, DateTime sdate, DateTime edate, int departmentid)
        {
            TimeTrackerEntities db = new TimeTrackerEntities();

            var data = (from j in db.T_JobTracker
                        where j.M_User.DepartmentId == departmentid
                        &&
                        //((j.StartTime >= sdate
                        //&& j.StartTime <= edate)
                        //||
                        //(j.EndTime >= sdate && j.EndTime <= edate))
                        j.EndTime <= edate
                        && j.Status == "Approved"
                        && j.SWNo == SW
                        && j.HWNo == HW

                        orderby j.EndTime descending
                        select new JobTracker()
                        {
                            Id = j.Id,
                            UserId = j.UserId,
                            StartTime = j.StartTime,
                            EndTime = j.EndTime,
                            Description = j.Description,
                            JobTypeId = j.JobTypeId,
                            JobIdNumber = j.JobIdNumber,
                            jobtype = j.M_JobType.Description,
                            Remarks = j.Remarks,
                            ApprovedBy = j.ApprovedBy,
                            CreateDate = j.CreateDate,
                            LastUpdateDate = j.LastUpdateDate,
                            CreatedBy = j.CreatedBy,
                            LastUpdatedBy = j.LastUpdatedBy,
                            Status = j.Status,
                            SupervisorRemarks = j.SupervisorRemarks,
                            ActionRequest = j.ActionRequest,
                            ScheduleDate = j.ScheduleDate,
                            SWNo = j.SWNo,
                            HWNo = j.HWNo,
                            JobStatus = j.JobStatus,
                            fullname = j.M_User.Firstname + " " + j.M_User.Lastname,
                            Customer = j.Customer,
                            EvalNo = j.EvalNo
                        }).ToList();

            db.Dispose();
            JobTracker result = new JobTracker();
            string curstatus = "";
            int curindex = -1;
            for (int i = 0; i < data.Count; i++)
            {
                if (data[i].JobStatus.IndexOf("On Hold") > -1)
                {
                    curstatus = "On Hold";
                    curindex = i;

                    break;
                }
                else if (data[i].JobStatus.IndexOf("In Progress") > -1)
                {
                    if (curstatus != "In Progress")
                    {
                        curstatus = "In Progress";
                        curindex = i;
                    }
                }
                else if (data[i].JobStatus.IndexOf("Completed") > -1 && curindex < 0)
                {
                    if (curstatus == "")
                    {
                        curstatus = "Completed";
                        curindex = i;
                    }
                }
            }
            if (curindex != -1)
            {
                result = data[curindex];
            }
            return result;
        }
 public JobTracker GenerateHWAndSWOld(string jobidnumber)
 {
     JobTracker jobtracker = new JobTracker();
     using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString()))
     {
         SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num,CO_Name,SO.SO_PCBdesc,SO_TotalSolSO,SO.SO_EvalNo from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobidnumber.Trim() + "'", con);
         con.Open();
         SqlDataReader reader = cmd.ExecuteReader();
         while (reader.Read())
         {
             jobtracker.Customer = reader["CO_Name"].ToString();
             jobtracker.Description = reader["SO_PCBdesc"].ToString();
             jobtracker.HWNo = reader["SO_Num"].ToString();
             jobtracker.SWNo = reader["SO_TotalSolSO"].ToString();
             jobtracker.EvalNo = reader["SO_EvalNo"].ToString();
         }
     }
     if (jobtracker.HWNo == null || jobtracker.HWNo.Trim() == "")
     {
         using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString()))
         {
             SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num,CO_Name,SO.SO_PCBdesc,SO_TotalSolSO,SO.SO_EvalNo from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobidnumber.Trim() + "'", con);
             con.Open();
             SqlDataReader reader = cmd.ExecuteReader();
             while (reader.Read())
             {
                 jobtracker.Customer = reader["CO_Name"].ToString();
                 jobtracker.Description = reader["SO_PCBdesc"].ToString();
                 jobtracker.SWNo = reader["SO_Num"].ToString();
                 jobtracker.HWNo = reader["SO_TotalSolSO"].ToString();
                 jobtracker.EvalNo = reader["SO_EvalNo"].ToString();
             }
         }
     }
     return jobtracker;
 }
 public void Update(JobTracker jobtracker)
 {
     using (TimeTrackerEntities db = new TimeTrackerEntities())
     {
         try
         {
             T_JobTracker t_jobtracker = db.T_JobTracker.FirstOrDefault(j => j.Id == jobtracker.Id);
             UpdateParse(t_jobtracker, jobtracker);
             db.SaveChanges();
         }
         catch (Exception ex)
         {
             string msg = ex.Message;
         }
     }
 }
        protected void Page_Load(object sender, EventArgs e)
        {
            JobTracker jobtracker = new JobTracker();
            if (!isValidUser() || (!jobtracker.CanConnectToCAP()))
                Response.Redirect("Login.aspx");
            HttpContext.Current.Session["siteSubHeader"] = "Dashboard";
            HttpContext.Current.Session["selectedTab"] = "Dashboard";

            if (!IsPostBack)
            {
                txtBoxBottomFromDate.Attributes.Add("readonly", "readonly");
                txtBoxBottomToDate.Attributes.Add("readonly", "readonly");
                calExtBottomFromDate.SelectedDate = DateTime.Now;
                calExtBottomFromDate.EndDate = DateTime.Now;
                txtBoxBottomFromDate.Text = DateTime.Now.ToString("dd MMM yyyy");
                calExtBottomToDate.SelectedDate = DateTime.Now;
                calExtBottomToDate.StartDate = DateTime.Now;
                calExtBottomToDate.EndDate = DateTime.Now;
                txtBoxBottomToDate.Text = DateTime.Now.ToString("dd MMM yyyy");

                if (!isSupervisor())
                {
                    gridLeftChkBoxSelectAll.Checked = false;
                    tabPanelLeft1.Visible = false;
                }
                InitializeGridViewLeftPanel1(new List<string>());
                InitializeGridViewLeftPanel2();
                InitializeGridViewLeftPanel3();
                InitializeBottomDropDownDepartment();
                InitializeBottomDropDownPersonel();
                InitializeGridViewBottom();
                InitializeGridViewBottom2();
            }
        }
        protected void modalBtnConfirm_Command(object sender, CommandEventArgs e)
        {
            string[] remarks = modalTxtBoxRemarks.Text.Replace("\n"," ").Trim().Split(' ');
            int counter = 0;
            Regex rgx = new Regex("[^a-zA-Z0-9]");
            for (int i = 0; i < remarks.Length; i++)
            {
                if (rgx.Replace(remarks[i],"").Trim() != "")
                {
                    counter++;
                }
            }
            if (counter > 2)
            {
                int userid = Convert.ToInt32(Session["UserId"]);
                if (e.CommandName == "RejectAll")
                {
                    foreach (GridViewRow row in gridViewLeftPanel1.Rows)
                    {
                        CheckBox cb = (CheckBox)row.FindControl("gridLeftChkBoxSelect");
                        if (cb.Checked)
                        {
                            JobTracker jobtracker = new JobTracker();
                            JobTrackerHistory jtHist = new JobTrackerHistory();
                            Label jobtrackId = (Label)row.FindControl("gridLeftlblJobTrackId");
                            jobtracker = jobtracker.GetJobTracker(Convert.ToInt32(jobtrackId.Text), false);
                            jobtracker.ApprovedBy = userid;
                            jobtracker.LastUpdatedBy = userid;
                            jobtracker.LastUpdateDate = DateTime.Now;
                            jobtracker.SupervisorRemarks = modalTxtBoxRemarks.Text;
                            jobtracker.Status = "Rejected";
                            jobtracker.Update(jobtracker);
                            jtHist = jtHist.ConvertToHistory(jobtracker);
                            jtHist.Insert(jtHist);
                        }
                    }
                    gridLeftChkBoxSelectAll.Checked = false;
                    InitializeGridViewLeftPanel1(new List<string>());
                }
                else
                {
                    JobTracker jobtracker = new JobTracker();
                    JobTrackerHistory jtHist = new JobTrackerHistory();
                    int id = Convert.ToInt32(e.CommandArgument);
                    jobtracker = jobtracker.GetJobTracker(id, false);
                    jobtracker.ApprovedBy = userid;
                    jobtracker.LastUpdatedBy = userid;
                    jobtracker.LastUpdateDate = DateTime.Now;
                    jobtracker.SupervisorRemarks = modalTxtBoxRemarks.Text;
                    jobtracker.Status = "Rejected";
                    jobtracker.Update(jobtracker);

                    jtHist = jtHist.ConvertToHistory(jobtracker);
                    jtHist.Insert(jtHist);
                    List<string> selectedJobtrackerId = GetGridViewLeftPanel1SelectedJobIds();
                    InitializeGridViewLeftPanel1(selectedJobtrackerId);
                }
                InitializeGridViewLeftPanel2();
                InitializeGridViewLeftPanel3();
            }
            else
            {
                modalBottomLabelError.Text = "Minimum Three(3) Words";
                modalBottomLabelError.Visible = true;
                programmaticModalPopup.Show();
            }
        }
        protected void linkButtonBottom_Command(object sender, CommandEventArgs e)
        {
            if (ddlBottomPersonel.Items.Count > 0)
            {
                JobTracker jobTracker = new JobTracker();
                string jobtypeid = e.CommandArgument.ToString();
                List<JobTracker> data = new List<JobTracker>();
                string[] argument = jobtypeid.Split('|');
                DateTime startdate = Convert.ToDateTime(txtBoxBottomFromDate.Text.Trim() + " 00:00:00");
                DateTime enddate = Convert.ToDateTime(txtBoxBottomToDate.Text.Trim() + " 23:59:59");
                if (argument.Count() > 3)
                {
                    startdate = Convert.ToDateTime("1900-01-01");
                    enddate = DateTime.Now;
                }
                LinkButton lb = (LinkButton)sender;

                int deptid = Convert.ToInt32(ddlBottomDepartment.SelectedValue);
                string jobid = txtBoxBottomJobId.Text.Trim();
                string customer = txtBoxBottomCustomer.Text.Trim();
                int userid = Convert.ToInt32(ddlBottomPersonel.SelectedItem.Value);
                data = jobTracker.GetJobTrackerList(startdate, enddate,Convert.ToInt32(argument[0]),argument[2].Trim(), userid, deptid, jobid, customer,true);
                labelmodalBottom.Text = argument[1] + " - " + lb.Text+" - "+argument[2];
                gridViewModalBottom.DataSource = data;
                gridViewModalBottom.DataBind();
                programmaticModalPopupBottom.Show();
            }
        }
        protected void InitializeGridViewLeftPanel3()
        {
            int userid = Convert.ToInt32(Session["UserId"]);
            JobTracker jobTracker = new JobTracker();
            List<JobTracker> data = new List<JobTracker>();
            data = jobTracker.GetRejectedRequest(userid,false);
            Converter model = new Converter();

            DataTable table = model.ConvertToDataTable(data);

            gridViewLeftPanel3.DataSource = table;
            gridViewLeftPanel3.DataBind();
        }
        protected void InitializeGridViewLeftPanel1(List<string> selectedjobtrack)
        {
            int userid = Convert.ToInt32(Session["UserId"]);
            JobTracker jobTracker = new JobTracker();
            List<JobTracker> data = new List<JobTracker>();
            data = jobTracker.GetRequestNeededApproval(userid,false);
            Converter model = new Converter();

            DataTable table = model.ConvertToDataTable(data);
            gridViewLeftPanel1.DataSource = table;
            gridViewLeftPanel1.DataBind();

            if (selectedjobtrack.Count > 0)
            {
                for (int i = 0; i < selectedjobtrack.Count; i++)
                {
                    foreach (GridViewRow row in gridViewLeftPanel1.Rows)
                    {
                        string jobtrackId = ((Label)row.FindControl("gridLeftlblJobTrackId")).Text.Trim();
                        if (selectedjobtrack[i] == jobtrackId)
                        {
                            CheckBox cb = (CheckBox)row.FindControl("gridLeftChkBoxSelect");
                            cb.Checked = true;
                            selectedjobtrack.RemoveAt(i);
                            --i;
                            break;
                        }
                    }
                }
            }
        }
 //private JobTracker GetCustomer(string jobid)
 //{
 //    JobTracker jobTracker = new JobTracker();
 //    using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString()))
 //    {
 //        SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobid.Trim() + "'", con);
 //        con.Open();
 //        SqlDataReader reader = cmd.ExecuteReader();
 //        while (reader.Read())
 //        {
 //            jobTracker.Customer = reader["CO_Name"].ToString();
 //            jobTracker.Description = reader["SO_PCBdesc"].ToString();
 //        }
 //    }
 //    if (jobTracker.Customer == null || jobTracker.Customer == "")
 //    {
 //        using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString()))
 //        {
 //            SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobid.Trim() + "'", con);
 //            con.Open();
 //            SqlDataReader reader = cmd.ExecuteReader();
 //            while (reader.Read())
 //            {
 //                jobTracker.Customer = reader["CO_Name"].ToString();
 //                jobTracker.Description = reader["SO_PCBdesc"].ToString();
 //            }
 //        }
 //    }
 //    return jobTracker;
 //}
 //private void GetCustomer(JobTracker jobtracker)
 //{
 //    if (jobtracker.HWNo != null && jobtracker.HWNo.Trim() != "")
 //    {
 //        using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString()))
 //        {
 //            SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobtracker.HWNo.Trim() + "'", con);
 //            con.Open();
 //            SqlDataReader reader = cmd.ExecuteReader();
 //            while (reader.Read())
 //            {
 //                jobtracker.Customer = reader["CO_Name"].ToString();
 //                jobtracker.Description = reader["SO_PCBdesc"].ToString();
 //            }
 //        }
 //    }
 //    else if ((jobtracker.SWNo != null && jobtracker.SWNo.Trim() != "") && (jobtracker.Customer == null || jobtracker.Customer.Trim() == ""))
 //    {
 //        using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString()))
 //        {
 //            SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobtracker.SWNo.Trim() + "'", con);
 //            con.Open();
 //            SqlDataReader reader = cmd.ExecuteReader();
 //            while (reader.Read())
 //            {
 //                jobtracker.Customer = reader["CO_Name"].ToString();
 //                jobtracker.Description = reader["SO_PCBdesc"].ToString();
 //            }
 //        }
 //    }
 //}
 public void Insert(JobTracker jobtracker)
 {
     T_JobTracker j = new T_JobTracker();
     ParseJobTracker(j, jobtracker);
     using (TimeTrackerEntities db = new TimeTrackerEntities())
     {
         try
         {
             db.T_JobTracker.Add(j);
             db.SaveChanges();
         }
         catch (Exception ex)
         {
             string msg = ex.Message;
         }
     }
 }
 protected void lnkBtn_Command(object sender, CommandEventArgs e)
 {
     if (e.CommandName == "JobOverviewDetails")
     {
         JobTracker j = new JobTracker();
         j = j.GetJobTracker(Convert.ToInt32(e.CommandArgument),false);
         modalDetailLabelName.Text = j.fullname;
         modalDetailLabelJobType.Text = j.jobtype;
         modalDetailLabelJobStatus.Text = j.JobStatus;
         modalDetailLabelDate.Text = Convert.ToDateTime(j.ScheduleDate).ToString("dd-MMM-yyyy");
         modalDetailLabelStartTime.Text = Convert.ToDateTime(j.StartTime).ToString("hh:mm tt");
         modalDetailLabelEndTime.Text = Convert.ToDateTime(j.EndTime).ToString("hh:mm tt");
         modalDetailTxtBoxRemarks.Text = j.Remarks;
         this.programmaticModalPopupDetail.Show();
     }
     else if (e.CommandName == "JobOverviewSummary")
     {
         JobTypeDepartment jobtypeDepartment = new JobTypeDepartment();
         JobTracker jobtracker = new JobTracker();
         string argument = e.CommandArgument.ToString();
         string[] s = argument.Split('|');
         var jobtypes = jobtypeDepartment.GetJobOverviewJobType(Convert.ToInt32(s[0]));
         Dictionary<string, string> repeaterdata = new Dictionary<string, string>();
         for (int i = 0; i < jobtypes.Count; i++)
         {
             JobTracker j = jobtracker.GetJobTrackerJobOverview(jobtypes[i].Id, s[2], s[1], Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), Convert.ToInt32(s[0]));
             if (j == null)
             {
                 repeaterdata.Add(jobtypes[i].Description, "");
             }
             else
             {
                 repeaterdata.Add(jobtypes[i].Description, j.JobStatus + " " + Convert.ToDateTime(j.EndTime).ToString("dd-MMM-yyyy"));
             }
         }
         modalSummaryRepeater.DataSource = repeaterdata;
         modalSummaryRepeater.DataBind();
         programmaticModalPopupSummary.Show();
     }
 }
        public JobTracker GenerateHWAndSWOld2(string jobidnumber)
        {
            JobTracker jobtracker = new JobTracker();
            using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString()))
            {
                SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num,CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobidnumber.Trim() + "'", con);
                con.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    jobtracker.Customer = reader["CO_Name"].ToString();
                    jobtracker.Description = reader["SO_PCBdesc"].ToString();
                    jobtracker.HWNo = reader["SO_Num"].ToString();
                }
            }
            if (jobtracker.HWNo == null || jobtracker.HWNo.Trim() == "")
            {
                using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString()))
                {
                    SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num,CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobidnumber.Trim() + "'", con);
                    con.Open();
                    SqlDataReader reader = cmd.ExecuteReader();
                    while (reader.Read())
                    {
                        jobtracker.Customer = reader["CO_Name"].ToString();
                        jobtracker.Description = reader["SO_PCBdesc"].ToString();
                        jobtracker.SWNo = reader["SO_Num"].ToString();
                    }
                }
                if (jobtracker.SWNo != null && jobtracker.SWNo.Trim() != "")
                {
                    using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString()))
                    {
                        SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num from Sales_Order SO where '" + jobtracker.Description.Trim() + "' Like '%'+CAST(SO_Num as varchar(20))+'%' ORDER BY SO_NUM Desc", con);
                        con.Open();
                        SqlDataReader reader = cmd.ExecuteReader();
                        while (reader.Read())
                        {
                            jobtracker.HWNo = reader["SO_Num"].ToString();
                        }
                    }

                    if (jobtracker.HWNo == null || jobtracker.HWNo.Trim() == "")
                    {
                        using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString()))
                        {
                            SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num from Sales_Order SO where SO_PCBdesc Like '%" + jobtracker.SWNo.Trim() + "%' ORDER BY SO_NUM Desc", con);
                            con.Open();
                            SqlDataReader reader = cmd.ExecuteReader();
                            while (reader.Read())
                            {
                                jobtracker.HWNo = reader["SO_Num"].ToString();
                            }
                        }
                    }
                }
            }
            else
            {
                using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString()))
                {
                    SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num from Sales_Order SO where '" + jobtracker.Description.Trim() + "' Like '%'+CAST(SO_Num as varchar(20))+'%' ORDER BY SO_NUM Desc", con);
                    con.Open();
                    SqlDataReader reader = cmd.ExecuteReader();
                    while (reader.Read())
                    {
                        jobtracker.SWNo = reader["SO_Num"].ToString();
                    }
                }

                if (jobtracker.SWNo == null || jobtracker.SWNo.Trim() == "")
                {
                    using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString()))
                    {
                        SqlCommand cmd = new SqlCommand("Select TOP 1 SO_Num from Sales_Order SO where SO_PCBdesc Like '%" + jobtracker.HWNo.Trim() + "%' ORDER BY SO_NUM Desc", con);
                        con.Open();
                        SqlDataReader reader = cmd.ExecuteReader();
                        while (reader.Read())
                        {
                            jobtracker.SWNo = reader["SO_Num"].ToString();
                        }
                    }
                }
            }
            return jobtracker;
        }
        private void GenerateDetailsRows(ref DataTable table)
        {
            Department dept = new Department();
            JobTypeDepartment jobtypeDepartment = new JobTypeDepartment();
            JobTracker jobtracker = new JobTracker();
            //var departments = dept.GetJobOverviewDepartment();
            //var distinctProjectList = jobtracker.GetDistinctProjectList(Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), txtBoxJobId.Text.Trim());

            for (int y = 0; y < distincProjectList.Count;y++ )
            {
                DataRow row = table.NewRow();
                row["HW No"] = distincProjectList[y].HWNo == null ? "" : distincProjectList[y].HWNo.Trim();
                row["SW No"] = distincProjectList[y].SWNo == null ? "" : distincProjectList[y].SWNo.Trim();
                row["Customer"] = distincProjectList[y].Customer == null ? "" : distincProjectList[y].Customer.Trim();
                row["Description"] = distincProjectList[y].Description == null ? "" : distincProjectList[y].Description.Trim();
                for (int x = 0; x < joboverviewDepartment.Count; x++)
                {
                    //var jobtypes = jobtypeDepartment.GetJobOverviewJobType(d.Id);
                    for (int i = 0; i < joboverviewJobType[x].Count; i++)
                    {
                        //JobTracker j = jobtracker.GetJobTrackerJobOverview(joboverviewJobType[x][i].Id, p.SWNo, p.HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), joboverviewDepartment[x].Id);
                        if (joboverviewRow[y][x][i] == null)
                        {
                            row[joboverviewJobType[x][i].Acronym + "" + joboverviewDepartment[x].Id] = "";
                        }
                        else
                        {
                            row[joboverviewJobType[x][i].Acronym + "" + joboverviewDepartment[x].Id] = joboverviewRow[y][x][i].Id + "|" + joboverviewRow[y][x][i].JobStatus + " " + Convert.ToDateTime(joboverviewRow[y][x][i].EndTime).ToString("dd-MMM-yyyy");
                        }
                    }
                }
                table.Rows.Add(row);
            }
        }
 private void UpdateParse(T_JobTracker t_jobtracker, JobTracker jobtracker)
 {
     t_jobtracker.JobIdNumber = jobtracker.JobIdNumber;
     t_jobtracker.JobTypeId = jobtracker.JobTypeId;
     t_jobtracker.Remarks = jobtracker.Remarks;
     t_jobtracker.Description = jobtracker.Description;
     t_jobtracker.StartTime = jobtracker.StartTime;
     t_jobtracker.EndTime = jobtracker.EndTime;
     t_jobtracker.ApprovedBy = jobtracker.ApprovedBy;
     t_jobtracker.LastUpdateDate = jobtracker.LastUpdateDate;
     t_jobtracker.LastUpdatedBy = jobtracker.LastUpdatedBy;
     t_jobtracker.Status = jobtracker.Status;
     t_jobtracker.SupervisorRemarks = jobtracker.SupervisorRemarks;
     t_jobtracker.UserId = jobtracker.UserId;
     t_jobtracker.ScheduleDate = jobtracker.ScheduleDate;
     t_jobtracker.ActionRequest = jobtracker.ActionRequest;
     t_jobtracker.HWNo = jobtracker.HWNo;
     t_jobtracker.SWNo = jobtracker.SWNo;
     t_jobtracker.JobStatus = jobtracker.JobStatus;
     t_jobtracker.Customer = jobtracker.Customer;
     t_jobtracker.EvalNo = jobtracker.EvalNo;
 }
        private void GenerateFlowRows(ref DataTable table)
        {
            JobFlow jobflow = new JobFlow();
            JobTypeFlow jobtypeFlow = new JobTypeFlow();
            JobTracker jobtracker = new JobTracker();
            //var jobflows = jobflow.GetJobOverviewJobFlow();
            //var distinctProjectList = jobtracker.GetDistinctProjectList(Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), txtBoxJobId.Text.Trim());

            foreach (JobTracker p in distincProjectList)
            {
                DataRow row = table.NewRow();
                row["HW No"] = p.HWNo == null ? "" : p.HWNo.Trim();
                row["SW No"] = p.SWNo == null ? "" : p.SWNo.Trim();
                row["Customer"] = p.Customer == null ? "" : p.Customer.Trim();
                row["Description"] = p.Description == null ? "" : p.Description.Trim();
                for (int x = 0; x < jobflowList.Count; x++)
                {
                    //var jobtypes = jobtypeFlow.GetJobTypeFlowListByJobFlow(jobflowList[x].Id);
                    for (int i = 0; i < jobtypeflowlist[x].Count; i++)
                    {
                        JobTracker j = new JobTracker();
                        string deptacro = "";
                        if (jobtypeflowlist[x][i].DepartmentId != null)
                            deptacro = jobtypeflowlist[x][i].departmentAcronym;

                        if (jobtypeflowlist[x][i].DepartmentId != null)
                        {
                            j = jobtracker.GetJobTrackerJobOverview(jobtypeflowlist[x][i].JobTypeId, p.SWNo, p.HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"), Convert.ToInt32(jobtypeflowlist[x][i].DepartmentId));
                        }
                        else
                        {
                            j = jobtracker.GetJobTrackerJobOverview(jobtypeflowlist[x][i].JobTypeId, p.SWNo, p.HWNo, Convert.ToDateTime(txtBoxStartDate.Text + " 00:00:00"), Convert.ToDateTime(txtBoxEndDate.Text + " 23:59:59"));
                        }
                        if (j == null)
                        {
                            row[jobtypeflowlist[x][i].jobtypeAcronym + deptacro + "" + jobflowList[x].Id] = "";
                        }
                        else
                        {
                            row[jobtypeflowlist[x][i].jobtypeAcronym + deptacro + "" + jobflowList[x].Id] = j.Id + "|" + j.JobStatus + " " + Convert.ToDateTime(j.EndTime).ToString("dd-MMM-yyyy");
                        }
                    }
                }
                table.Rows.Add(row);
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            JobTracker jobtracker = new JobTracker();
            if (!isValidUser() || (!jobtracker.CanConnectToCAP()))
                Response.Redirect("Login.aspx");
            HttpContext.Current.Session["siteSubHeader"] = "JobOverview";
            HttpContext.Current.Session["selectedTab"] = "JobOverview";

            if (!IsPostBack)
            {
                txtBoxStartDate.Attributes.Add("readonly", "readonly");
                txtBoxEndDate.Attributes.Add("readonly", "readonly");
                InitializeStartDate();
                InitializeEndDate();
                //GenerateDynamicGrid();
            }
            GenerateDynamicGrid();
        }
 protected void gridViewLeftPanel1_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     int userid = Convert.ToInt32(Session["UserId"]);
     int index = Convert.ToInt32(e.CommandArgument);
     JobTracker jobtracker = new JobTracker();
     JobTrackerHistory jtHist = new JobTrackerHistory();
     //var data = jobtracker.GetRequestNeededApproval(userid);
     Label jobtrackId = (Label)gridViewLeftPanel1.Rows[index].FindControl("gridLeftlblJobTrackId");
     jobtracker = jobtracker.GetJobTracker(Convert.ToInt32(jobtrackId.Text),false);
     //data[index].LastUpdateDate = DateTime.Now;
     //data[index].LastUpdatedBy = userid;
     jobtracker.ApprovedBy = userid;
     jobtracker.LastUpdateDate = DateTime.Now;
     jobtracker.LastUpdatedBy = userid;
     if(e.CommandName == "AcceptRequest")
     {
         if (jobtracker.ActionRequest == "Delete")
         {
             jobtracker.Status = "Approved";
             jtHist = jtHist.ConvertToHistory(jobtracker);
             jobtracker.Delete(jobtracker.Id);
         }
         else
         {
             jobtracker.Status = "Approved";
             jobtracker.Update(jobtracker);
             jtHist = jtHist.ConvertToHistory(jobtracker);
         }
         jtHist.Insert(jtHist);
         List<string> selectedJobtrackerId = GetGridViewLeftPanel1SelectedJobIds();
         InitializeGridViewLeftPanel1(selectedJobtrackerId);
         InitializeGridViewLeftPanel2();
         InitializeGridViewLeftPanel3();
     }
     else if (e.CommandName == "RejectRequest")
     {
         //data[index].Status = "Rejected";
         modalBottomLabelError.Visible = false;
         modalBottomLabelError.Text = "";
         modalBtnConfirm.CommandArgument = jobtracker.Id.ToString();
         modalBtnConfirm.CommandName = "Reject";
         modalTxtBoxRemarks.Text = "";
         programmaticModalPopup.Show();
         //jobtracker.Update(data[index]);
         //InitializeGridViewLeft();
     }
 }