protected void GetStudentDetails(int StudentID)
        {
            BEAuditor objBEAuditor = new BEAuditor();
            BAuditor  objBAuditor  = new BAuditor();

            //objBEUser.IntStudentID = StudentID;
            objBEAuditor.IntStudentID = StudentID;
            objBAuditor.BGetStudentDetails(objBEAuditor);
            if (objBEAuditor.DtResult != null)
            {
                if (objBEAuditor.DtResult.Rows.Count > 0)
                {
                    lblstudentfirstname.Text = objBEAuditor.DtResult.Rows[0]["studentName"].ToString();
                    lblEmail.Text            = objBEAuditor.DtResult.Rows[0]["EmailAddress"].ToString();
                    lblPhoneNumber.Text      = objBEAuditor.DtResult.Rows[0]["PhoneNumber"].ToString();
                    lblTimeZone.Text         = objBEAuditor.DtResult.Rows[0]["TimeZone"].ToString();
                    string imgpath = objBEAuditor.DtResult.Rows[0]["PhotoIdentity"].ToString();
                    //imgstudent.ImageUrl = "~/Student/Student_Identity/" + imgpath.Substring(3).ToString();
                    imgstudent.ImageUrl  = new AppSecurity().ImageToBase64(imgpath.Substring(3).ToString());
                    lblSpecialNeeds.Text = objBEAuditor.DtResult.Rows[0]["SpecialNeeds"].ToString();
                    if (objBEAuditor.DtResult.Rows[0]["Comments"].ToString() != null && objBEAuditor.DtResult.Rows[0]["Comments"].ToString() != string.Empty)
                    {
                        lblComments.Text = objBEAuditor.DtResult.Rows[0]["Comments"].ToString();
                    }
                    else
                    {
                        lblComments.Text = "N/A";
                    }
                }
            }
        }
        protected void LoadData(int studentID)
        {
            try
            {
                BEAuditor objBEAuditor = new BEAuditor();

                BAuditor objBAuditor = new BAuditor();

                objBEAuditor.IntStudentID = studentID;
                objBEAuditor.IntUserID    = Convert.ToInt32(Session[BaseClass.EnumPageSessions.USERID]);

                objBAuditor.BGetAuditorCourseDetails(objBEAuditor);

                if (objBEAuditor.DtResult.Rows.Count > 0)
                {
                    gvExamStatus.DataSource = objBEAuditor.DtResult;
                }
                else
                {
                    gvExamStatus.DataSource = new object[] { };
                }
            }
            catch (Exception Ex)
            {
                throw Ex;
            }
        }
 protected void LoadData()
 {
     try
     {
         BEAuditor objBEAuditor = new BEAuditor();
         BAuditor  objBAuditor  = new BAuditor();
         objBAuditor.BSearchStudentDetails(objBEAuditor);
         if (objBEAuditor.DtResult.Rows.Count > 0)
         {
             Session[BaseClass.EnumPageSessions.DATATABLE] = objBEAuditor.DtResult;
             //ViewState[BaseClass.EnumPageSessions.CurrentPage] = CurrentPage;
             //this.BindGrid("LOAD");
             gvStudentLookUp.DataSource = objBEAuditor.DtResult;
         }
         else
         {
             Session[BaseClass.EnumPageSessions.DATATABLE] = objBEAuditor.DtResult;
             //ViewState[BaseClass.EnumPageSessions.CurrentPage] = CurrentPage;
             //this.BindGrid("LOAD");
             gvStudentLookUp.DataSource = new object[] { };;
         }
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
Beispiel #4
0
 protected void LoadData()
 {
     try
     {
         BEAuditor objBEAuditor = new BEAuditor();
         BAuditor  objBAuditor  = new BAuditor();
         objBEAuditor.IntUserID = Convert.ToInt32(Session[EnumPageSessions.USERID]);
         objBAuditor.BProcessedExamRequest(objBEAuditor);
         if (objBEAuditor.DtResult.Rows.Count > 0)
         {
             //  trGridPages.Visible = true;
             Session[BaseClass.EnumPageSessions.DATATABLE] = objBEAuditor.DtResult;
             gvProcessedExamRequest.DataSource             = objBEAuditor.DtResult;
             //ViewState[BaseClass.EnumPageSessions.CurrentPage] = CurrentPage;
             //this.BindGrid("LOAD");
         }
         else
         {
             //  trGridPages.Visible = false;
             Session[BaseClass.EnumPageSessions.DATATABLE] = null;
             //ViewState[BaseClass.EnumPageSessions.CurrentPage] = CurrentPage;
             gvProcessedExamRequest.DataSource = new string[] { };
             //gvProcessedExamRequest.DataBind();
             //this.SetDefaultPagingImages();
         }
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
 public void DGetAddedBy(BEAuditor objBEAuditor)
 {
     try
     {
         objBEAuditor.DsResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, "USP_Auditor_GetProctorsandauditors");
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Beispiel #6
0
 public void BGetAuditorProviderDetails(BEAuditor objBEAuditor1)
 {
     try
     {
         new DAuditor().DGetAuditorProviderDetails(objBEAuditor1);
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
Beispiel #7
0
        protected void lnkDelete_Click(object sender, EventArgs e)
        {
            BEAuditor objBEAuditor = new BEAuditor();
            BAuditor  objBAuditor  = new BAuditor();

            objBEAuditor.IntCommentID = Convert.ToInt32(Request.QueryString["CommentID"].ToString());
            objBAuditor.BDeleteAlertImage(objBEAuditor);
            objBEAuditor          = null;
            objBAuditor           = null;
            trDeleteImage.Visible = false;
        }
Beispiel #8
0
 public void BGetAddedBy(BEAuditor objBEAuditor)
 {
     try
     {
         new DAuditor().DGetAddedBy(objBEAuditor);
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
Beispiel #9
0
 public void BProcessedExamRequest(BEAuditor objBEAuditor)
 {
     try
     {
         new DAuditor().DProcessedExamRequest(objBEAuditor);
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
Beispiel #10
0
 public void BDeleteAlertImage(BEAuditor objBEAuditor)
 {
     try
     {
         new DAuditor().DDeleteAlertImage(objBEAuditor);
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
Beispiel #11
0
 public void BApproveTransaction(BEAuditor objBEAuditor)
 {
     try
     {
         new DAuditor().DApproveTransaction(objBEAuditor);
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
Beispiel #12
0
 public void BGetStudentDetails(BEAuditor objBEAuditor)
 {
     try
     {
         new DAuditor().DGetStudentDetails(objBEAuditor);
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
 public void DSearchStudentDetails(BEAuditor objBEAuditor)
 {
     try
     {
         objBEAuditor.DtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.SearchStudentDetails).Tables[0];
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
Beispiel #14
0
 public void BGetAuditorInbox(BEAuditor objBEAuditor)
 {
     try
     {
         new DAuditor().GetAuditorInbox(objBEAuditor);
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
Beispiel #15
0
 public void BUpdateComments(BEAuditor objBEAuditor)
 {
     try
     {
         new DAuditor().DUpdateComments(objBEAuditor);
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
        public void DGetAuditorProviderDetails(BEAuditor objBEAuditor1)
        {
            try
            {
                SqlParameter[] objSqlParam = new SqlParameter[1];
                objSqlParam[0]       = new SqlParameter("@TransID", SqlDbType.VarChar, 1000);
                objSqlParam[0].Value = objBEAuditor1.strTransID;

                objBEAuditor1.DsResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Auditor_GetProviderDetails, objSqlParam);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public void DGetStudentDetails(BEAuditor objBEAuditor)
        {
            try
            {
                SqlParameter[] objSqlParam = new SqlParameter[1];
                objSqlParam[0]       = new SqlParameter("@StudentID", SqlDbType.Int);
                objSqlParam[0].Value = objBEAuditor.IntStudentID;

                objBEAuditor.DtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Common_ViewStudentDetails, objSqlParam).Tables[0];
            }

            catch (Exception Ex)
            {
                throw Ex;
            }
        }
        public void DDeleteAlertImage(BEAuditor objBEAuditor)
        {
            try
            {
                SqlParameter[] objSqlParam = new SqlParameter[1];

                objSqlParam[0]       = new SqlParameter("@I_CommentID", SqlDbType.BigInt);
                objSqlParam[0].Value = objBEAuditor.IntCommentID;

                SQLHelper.ExecuteNonQuery(DConConfig.ConnectionString, CommandType.StoredProcedure, "USP_Auditor_DeleteAlertImage", objSqlParam);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #19
0
        protected void GetAddedBydropdown()
        {
            try
            {
                BEAuditor objBEAuditor = new BEAuditor();
                BAuditor  objBAuditor  = new BAuditor();

                objBAuditor.BGetAddedBy(objBEAuditor);
                ddlAddedBy.DataSource     = objBEAuditor.DsResult;
                ddlAddedBy.DataValueField = "UserID";
                ddlAddedBy.DataTextField  = "Name";
                ddlAddedBy.DataBind();
            }
            catch
            {
            }
        }
        public void DUpdateComments(BEAuditor objBEAuditor)
        {
            try
            {
                SqlParameter[] objSqlParam = new SqlParameter[10];
                objSqlParam[0]       = new SqlParameter("@CommentID", SqlDbType.Int);
                objSqlParam[0].Value = objBEAuditor.IntCommentID;

                objSqlParam[1]       = new SqlParameter("@Comments", SqlDbType.VarChar, 5000);
                objSqlParam[1].Value = objBEAuditor.StrComments;


                objSqlParam[2]       = new SqlParameter("@TimeStamp", SqlDbType.VarChar, 50);
                objSqlParam[2].Value = objBEAuditor.TimeStamp;

                objSqlParam[3]       = new SqlParameter("@AddedBy", SqlDbType.VarChar, 50);
                objSqlParam[3].Value = objBEAuditor.strAddedBy;

                objSqlParam[4]       = new SqlParameter("@AddedOn", SqlDbType.DateTime);
                objSqlParam[4].Value = objBEAuditor.strAddedOn;

                objSqlParam[5]           = new SqlParameter("@I_Result", SqlDbType.Int);
                objSqlParam[5].Direction = ParameterDirection.Output;

                objSqlParam[6]       = new SqlParameter("@userid", SqlDbType.Int);
                objSqlParam[6].Value = objBEAuditor.IntUserID;

                objSqlParam[7]       = new SqlParameter("@flag", SqlDbType.Int);
                objSqlParam[7].Value = objBEAuditor.IntFlag;

                objSqlParam[8]       = new SqlParameter("@Type", SqlDbType.Int);
                objSqlParam[8].Value = objBEAuditor.IntstatusFlag;
                objSqlParam[9]       = new SqlParameter("@AlertID", SqlDbType.Int);
                objSqlParam[9].Value = objBEAuditor.IntAletID;



                SQLHelper.ExecuteNonQuery(DConConfig.ConnectionString, CommandType.StoredProcedure, "USP_Auditor_UpdateCommentDetails", objSqlParam);

                objBEAuditor.IntResult = Convert.ToInt32(objSqlParam[5].Value.ToString());
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public void DApproveTransaction(BEAuditor objBEAuditor)
        {
            try
            {
                SqlParameter[] objSqlParam = new SqlParameter[2];

                objSqlParam[0]       = new SqlParameter("@I_UserID", SqlDbType.Int);
                objSqlParam[0].Value = objBEAuditor.IntEmployeeID;
                objSqlParam[1]       = new SqlParameter("@TransID", SqlDbType.VarChar, 5000);
                objSqlParam[1].Value = objBEAuditor.strTransID;

                objBEAuditor.IntResult = SQLHelper.ExecuteNonQuery(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Auditor_Approve_Inbox, objSqlParam);
            }
            catch (Exception Ex)
            {
                throw Ex;
            }
        }
        public void DProcessedExamRequest(BEAuditor objBEAuditor)
        {
            try
            {
                SqlParameter[] objSqlParam = new SqlParameter[1];

                objSqlParam[0]       = new SqlParameter("@I_UserID", SqlDbType.Int);
                objSqlParam[0].Value = objBEAuditor.IntUserID;

                //objSqlParam[1] = new SqlParameter("@I_Period", SqlDbType.Int);
                //objSqlParam[1].Value = objBEAuditor.IntPeriod;

                objBEAuditor.DtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Auditor_ProcessedExamRequest, objSqlParam).Tables[0];
            }
            catch (Exception Ex)
            {
                throw Ex;
            }
        }
        public void GetAuditorInbox(BEAuditor objBEAuditor)
        {
            try
            {
                SqlParameter[] objSqlParam = new SqlParameter[1];

                objSqlParam[0]       = new SqlParameter("@I_UserID", SqlDbType.Int);
                objSqlParam[0].Value = objBEAuditor.IntUserID;
                //objBEAuditor.dtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Auditor_Inbox).Tables[0];
                //objBEAuditor.dtResult1 = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Auditor_Inbox).Tables[1];

                objBEAuditor.objDs = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Auditor_Inbox, objSqlParam);
            }

            catch (Exception Ex)
            {
                throw Ex;
            }
        }
        public void DGetComments(BEAuditor objBEAuditor)
        {
            try
            {
                SqlParameter[] objSqlParam = new SqlParameter[2];
                objSqlParam[0]       = new SqlParameter("@CommentID", SqlDbType.Int);
                objSqlParam[0].Value = objBEAuditor.IntCommentID;

                objSqlParam[1]       = new SqlParameter("@UserID", SqlDbType.Int);
                objSqlParam[1].Value = objBEAuditor.IntUserID;



                objBEAuditor.DsResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, "USP_Auditor_GetEditComments", objSqlParam);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        protected void LoadData()
        {
            try
            {
                BEAuditor objBEAuditor = new BEAuditor()
                {
                };
                objBEAuditor.IntUserID = Convert.ToInt32(Session[EnumPageSessions.USERID]);
                new BAuditor().BGetAuditorInbox(objBEAuditor);
                if (objBEAuditor.objDs.Tables[1].Rows.Count > 0)
                {
                    // trGridPages.Visible = true;
                    Session[BaseClass.EnumPageSessions.DATATABLE] = objBEAuditor.objDs.Tables[1];
                    //ViewState[BaseClass.EnumPageSessions.CurrentPage] = CurrentPage;
                    // lblCount.Text = objBEAuditor.objDs.Tables[0].Rows[0]["TRANSID"].ToString();
                    //this.BindGrid("LOAD");
                    gvAuditorInbox.DataSource = objBEAuditor.objDs.Tables[1];
                    //gvAuditorInbox.DataBind();
                    btnApprove.Visible = true;
                }
                else
                {
                    // trGridPages.Visible = false;
                    Session[BaseClass.EnumPageSessions.DATATABLE] = null;
                    //ViewState[BaseClass.EnumPageSessions.CurrentPage] = CurrentPage;
                    //  lblCount.Text = "0";
                    gvAuditorInbox.DataSource = new object[] { };

                    //gvAuditorInbox.DataBind();
                    btnApprove.Visible = false;
                    //this.SetDefaultPagingImages();
                }
            }
            catch (Exception Ex)
            {
                throw Ex;
            }
        }
Beispiel #26
0
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                if (ddlAlerts.SelectedItem.Text.ToString().ToUpper() == "OTHER" && txtComments.Text == string.Empty)
                {
                    RequiredFieldValidator11.Enabled         = true;
                    RequiredFieldValidator11.ValidationGroup = "Edit";
                }
                else
                {
                    BEAuditor objBEAuditor = new BEAuditor();
                    BAuditor  objBAuditor  = new BAuditor();
                    objBEAuditor.IntCommentID = Convert.ToInt32(Request.QueryString["CommentID"].ToString());
                    objBEAuditor.IntUserID    = Convert.ToInt32(Session[EnumPageSessions.USERID]);
                    objBEAuditor.IntAletID    = Convert.ToInt32(ddlAlerts.SelectedValue.ToString());
                    //if (DivTextBox.Visible)
                    //{
                    objBEAuditor.StrComments   = txtComments.Text;
                    objBEAuditor.IntstatusFlag = 1;

                    //}
                    //else
                    //{
                    //    objBEAuditor.StrComments = ddlAlerts.SelectedValue.ToString();
                    //    objBEAuditor.IntstatusFlag = 0;
                    //}

                    //objBEAuditor.TimeStamp = txtincidenttimestamp.Text;
                    string TimeChoosed = string.Empty;
                    if (ddlHours.SelectedIndex != 0 && ddlHours.SelectedIndex != 1)
                    {
                        TimeChoosed = ddlHours.SelectedValue.ToString();

                        if (ddlMinutes.SelectedIndex != 0)
                        {
                            TimeChoosed = TimeChoosed + ":" + ddlMinutes.SelectedValue.ToString();
                        }
                        else
                        {
                            TimeChoosed = TimeChoosed + ":00";
                        }

                        if (ddlsec.SelectedIndex != 0)
                        {
                            TimeChoosed = TimeChoosed + ":" + ddlsec.SelectedValue.ToString();
                        }
                        else
                        {
                            TimeChoosed = TimeChoosed + ":00";
                        }
                    }
                    else if (ddlMinutes.SelectedIndex != 0 && ddlMinutes.SelectedIndex != 1)
                    {
                        TimeChoosed = "00:" + ddlMinutes.SelectedValue.ToString();
                        if (ddlsec.SelectedIndex != 0)
                        {
                            TimeChoosed = TimeChoosed + ":" + ddlsec.SelectedValue.ToString();
                        }
                        else
                        {
                            TimeChoosed = TimeChoosed + ":00";
                        }
                    }
                    else if (ddlsec.SelectedIndex != 0 && ddlsec.SelectedIndex != 1)
                    {
                        TimeChoosed = "00:00:" + ddlsec.SelectedValue.ToString();
                    }
                    else
                    {
                        TimeChoosed = string.Empty;
                    }


                    objBEAuditor.TimeStamp = TimeChoosed;
                    objBEAuditor.IntFlag   = Convert.ToInt32(ddlFlags.SelectedValue);

                    objBEAuditor.strAddedBy = ddlAddedBy.SelectedValue.ToString();

                    objBEAuditor.strAddedOn = Convert.ToDateTime(txtAddedOn.Text);

                    objBAuditor.BUpdateComments(objBEAuditor);

                    trMessage.Visible = true;

                    if (objBEAuditor.IntResult == 1)
                    {
                        lblInfo.Text      = Resources.ResMessages.Auditor_Edit_Success_CommentsUpdated;
                        lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Success);
                        ImgInfo.ImageUrl  = Resources.AppConfigurations.Image_Success;
                        tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Success);
                        //if (DivTextBox.Visible)
                        //{
                        lblComments.Text = txtComments.Text;
                        //DivTextBox_View.Visible = true;
                        //DivDropdown_View.Visible = false;

                        //}
                        //else
                        //{
                        lblDescription.Text = ddlAlerts.SelectedItem.Text.ToString();
                        //    DivTextBox_View.Visible = false;
                        //    DivDropdown_View.Visible = true;

                        //}


                        lblIncidentTimeStamp.Text = TimeChoosed;

                        lblAddedBy.Text        = ddlAddedBy.SelectedItem.Text.ToString();
                        lblAddedOn.Text        = txtAddedOn.Text;
                        lblflag.Text           = ddlFlags.SelectedItem.Text.ToString();
                        trCommentsEdit.Visible = false;
                        trCommentsView.Visible = true;
                    }

                    else
                    {
                        lblInfo.Text      = Resources.ResMessages.Auditor_EditComments_Error_Comments;
                        lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Error);
                        ImgInfo.ImageUrl  = Resources.AppConfigurations.Image_Error;
                        tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Error);
                    }
                }
            }
            catch (Exception Ex)
            {
                ErrorHandlers.ErrorLog.WriteError(Ex);
            }
        }
Beispiel #27
0
        protected void GetComments()
        {
            BEAuditor objBEAuditor = new BEAuditor();
            BAuditor  objBAuditor  = new BAuditor();

            objBEAuditor.IntCommentID = Convert.ToInt32(Request.QueryString["CommentID"].ToString());
            objBEAuditor.IntUserID    = Convert.ToInt32(Session[EnumPageSessions.USERID]);
            objBAuditor.BGetComments(objBEAuditor);
            if (objBEAuditor.DsResult != null && objBEAuditor.DsResult.Tables[0].Rows.Count > 0)
            {
                ddlFlags.SelectedValue = objBEAuditor.DsResult.Tables[0].Rows[0]["CommentTypeID"].ToString();

                txtComments.Text = objBEAuditor.DsResult.Tables[0].Rows[0]["Comments"].ToString();
                //if (objBEAuditor.DsResult.Tables[0].Rows[0]["Type"].ToString() != "0")
                //{
                //    txtComments.Text = objBEAuditor.DsResult.Tables[0].Rows[0]["Comments"].ToString();
                //    DivTextBox.Visible = true;

                //}
                //else
                //    DivTextBox.Visible = false;

                if (objBEAuditor.DsResult.Tables[1] != null)
                {
                    ddlAlerts.DataSource     = objBEAuditor.DsResult.Tables[1];
                    ddlAlerts.DataValueField = "AlertID";
                    ddlAlerts.DataTextField  = "AlertText";
                    ddlAlerts.DataBind();
                }
                ddlAlerts.SelectedValue = objBEAuditor.DsResult.Tables[0].Rows[0]["AlertID"].ToString();

                if (ddlAlerts.SelectedItem.Text.ToString().ToUpper() == "OTHER")
                {
                    RequiredFieldValidator11.Enabled         = true;
                    RequiredFieldValidator11.ValidationGroup = "Edit";
                }
                else
                {
                    RequiredFieldValidator11.Enabled         = false;
                    RequiredFieldValidator11.ValidationGroup = string.Empty;
                }


                txtAddedOn.Text = objBEAuditor.DsResult.Tables[0].Rows[0]["AddedOn"].ToString();

                ddlAddedBy.SelectedValue = objBEAuditor.DsResult.Tables[0].Rows[0]["CommenterID"].ToString();

                string CommentTime = string.Empty;
                CommentTime = objBEAuditor.DsResult.Tables[0].Rows[0]["CommentTime"].ToString();
                if (CommentTime != null && CommentTime != string.Empty)
                {
                    char[] separator = { ':' };
                    //string[] time=new string[3];

                    string[] time = CommentTime.Split(separator);

                    ddlHours.SelectedValue   = time[0];
                    ddlMinutes.SelectedValue = time[1];
                    ddlsec.SelectedValue     = time[2];
                }


                //txtincidenttimestamp.Text = objBEAuditor.DsResult.Tables[0].Rows[0]["CommentTime"].ToString();
            }
        }
        protected void btnApprove_Click(object sender, EventArgs e)
        {
            string strTransID = string.Empty;

            //foreach (GridViewRow row in gvAuditorInbox.Rows)
            //{
            //    CheckBox chk = (CheckBox)row.Cells[0].FindControl("chkSelect");
            //    if (chk.Checked == true)
            //    {
            //        Label lbl = (Label)row.Cells[1].FindControl("lblExamID");
            //        strTransID = strTransID + lbl.Text.ToString() + "$";
            //    }
            //}

            foreach (GridDataItem item in gvAuditorInbox.Items)
            {
                CheckBox chk = (CheckBox)item.Cells[0].FindControl("chkSelect");
                if (chk.Checked == true)
                {
                    Label lbl = (Label)item.Cells[1].FindControl("lblExamID");
                    strTransID = strTransID + lbl.Text.ToString() + "$";
                }
            }
            if (strTransID != string.Empty)
            {
                strTransID = strTransID.Substring(0, strTransID.Length - 1);
                BEAuditor objBEAuditor = new BEAuditor();
                BAuditor  objBAuditor  = new BAuditor();
                objBEAuditor.strTransID    = strTransID;
                objBEAuditor.IntEmployeeID = Convert.ToInt32(Session[BaseClass.EnumPageSessions.USERID]);
                objBAuditor.BApproveTransaction(objBEAuditor);
                objBEAuditor = null;
                objBAuditor  = null;
                //foreach (GridDataItem item in gvAuditorInbox.Items)
                //{
                //    CheckBox chk = (CheckBox)item.Cells[0].FindControl("chkSelect");
                //    //EmailMsg obj;
                //    if (chk.Checked == true)
                //    {
                BEAuditor objBEAuditor1 = new BEAuditor();
                BAuditor  objBAuditor1  = new BAuditor();
                objBEAuditor1.strTransID = strTransID;

                objBAuditor1.BGetAuditorProviderDetails(objBEAuditor1);
                if (objBEAuditor1.DsResult.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < objBEAuditor1.DsResult.Tables[0].Rows.Count; i++)
                    {
                        DataTable objDT = new DataTable();

                        objDT = objBEAuditor1.DsResult.Tables[0];

                        objBEAuditor1.IntUserID = Convert.ToInt32(objDT.Rows[i]["ExamProviderID"]);

                        objBEAuditor1.IntProviderID = Convert.ToInt32(objDT.Rows[i]["UserID"]);

                        objBEAuditor1.IntTransID = Convert.ToInt64(objDT.Rows[i]["TransID"]);


                        BEMail objBEMail = new BEMail();
                        BMail  objBMail  = new BMail();
                        objBEMail.IntTransID = objBEAuditor1.IntTransID;
                        string FYI = "FYI";
                        //string mail = "Mail";
                        //if (mail == "Mail")
                        //{
                        //    objBEMail.IntUserID = objBEAuditor1.IntUserID;
                        //    objBEMail.StrTemplateName = BaseClass.EnumEmails.ExamApprovedbyAuditor.ToString();
                        //    objBMail.BSendEmail(objBEMail);

                        //}

                        if (FYI == "FYI")
                        {
                            BECommon objBECommon = new BECommon();
                            BCommon  objBCommon  = new BCommon();
                            objBECommon.IntTransID = objBEAuditor1.IntTransID;
                            objBCommon.BAuditorCheckEmailForApproval(objBECommon);

                            if (objBECommon.IntstatusFlag == 1)
                            {
                                objBEMail.IntUserID = objBEAuditor1.IntUserID;

                                objBEMail.StrTemplateName = BaseClass.EnumEmails.ExamApprovedbyAuditorFYI.ToString();
                                objBMail.BSendEmail(objBEMail);
                            }
                        }
                    }



                    // Label lbl = (Label)item.Cells[1].FindControl("lblExamID");
                }


                lblSuccess.Text = Resources.ResMessages.Audit_TransApprove;

                // this.LoadData();
                gvAuditorInbox.Rebind();
            }

            else
            {
                lblSuccess.Text = Resources.ResMessages.Audit_TransSelect;
            }
        }