protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (!IsPostBack)
                {
                    UserName = User.Identity.Name;
                    if (Left(UserName, 4) == "HNBA")
                    {
                        UserName        = Right(UserName, (UserName.Length) - 5);
                        Session["USER"] = UserName;
                        GetUser(UserName.ToString());
                    }
                    else if (Left(UserName, 5) == "HNBGI")
                    {
                        UserName        = Right(UserName, (UserName.Length) - 6);
                        Session["USER"] = UserName;
                        GetUser(UserName.ToString());
                    }

                    DataTable dtconall = CM_Main.SelectJob("CASE2", "", "APPROVE", "", "", "", System.DateTime.Now);
                    grdRequest.DataSource = dtconall;
                    grdRequest.DataBind();

                    if (Request.QueryString["ReqID"] != null)
                    {
                        ReqID = Request.QueryString["ReqID"];

                        DataTable dtcon = CM_Main.SelectJob("CASE11", ReqID, "", "", "", "", System.DateTime.Now);
                        grdRequest.DataSource = dtcon;
                        grdRequest.DataBind();

                        BtnUpdate.Enabled = true;
                        // BtnReject.Enabled = true;

                        txtReqID.Text           = dtcon.Rows[0]["REQUEST_ID"].ToString();
                        lblCompany.Text         = dtcon.Rows[0]["COMPANY"].ToString();
                        lblStatus.Text          = dtcon.Rows[0]["STATUS"].ToString();
                        lblTitle.Text           = dtcon.Rows[0]["TITLE"].ToString();
                        lblSystem.Text          = dtcon.Rows[0]["SYSTEM"].ToString();
                        lblDescription.Text     = dtcon.Rows[0]["DESCRIPTION"].ToString();
                        lblApprovalComment.Text = dtcon.Rows[0]["APPROVE_COMMENT"].ToString();

                        lblRequestUser.Text = dtcon.Rows[0]["RU_FULLNAME"].ToString();
                        lblManager.Text     = dtcon.Rows[0]["MAN_FULLNAME"].ToString();
                        lblImplement.Text   = dtcon.Rows[0]["IMP_FULLNAME"].ToString();
                        lblQA.Text          = dtcon.Rows[0]["QA_FULLNAME"].ToString();
                        lblRelease.Text     = dtcon.Rows[0]["RE_FULLNAME"].ToString();

                        lblRejectRea.Text = dtcon.Rows[0]["REJECT_COMMENT"].ToString();
                        lblImpact.Text    = dtcon.Rows[0]["IMPACT"].ToString();
                        lblOutage.Text    = dtcon.Rows[0]["OUTAGE"].ToString();
                        lblFallBack.Text  = dtcon.Rows[0]["FEEDBACK_PLAN"].ToString();

                        lblParent.Text = dtcon.Rows[0]["PARENT_ID"].ToString();

                        lblCreation.Text   = dtcon.Rows[0]["REQUEST_DATE"].ToString();
                        lblStart.Text      = dtcon.Rows[0]["START_DATE"].ToString();
                        lblEnd.Text        = dtcon.Rows[0]["END_DATE"].ToString();
                        lblLastUpdate.Text = dtcon.Rows[0]["LAST_UPDATE_DATE"].ToString();
                        lblAssign.Text     = dtcon.Rows[0]["ASSIGN_DATE"].ToString();


                        txtApproveComment.Text = dtcon.Rows[0]["IMPLEMENTATION_COMMENT"].ToString();

                        RdGrdEvents.DataSource = CM_Main.SelectJob("CASE10", ReqID, "", "", "", "", System.DateTime.Now);
                        RdGrdEvents.DataBind();


                        DataTable dtDocsJobWise = CM_Main.SelectJob("CASE13", txtReqID.Text, "", "", "", "", System.DateTime.Now);
                        if (dtDocsJobWise.Rows.Count >= 1)
                        {
                            RadListBox2.DataSource     = dtDocsJobWise;
                            RadListBox2.DataTextField  = "DOCUMENT";
                            RadListBox2.DataValueField = "DOCUMENT";
                            RadListBox2.DataBind();
                        }

                        GrdViewDocs.DataSource = CM_Main.SelectJob("CASE15", txtReqID.Text, "", "", "", "", System.DateTime.Now);
                        GrdViewDocs.DataBind();


                        DataTable dt = Main.SelectImages(dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "BRANCH_IMAGE");
                        galleryDataList.DataSource = dt;
                        galleryDataList.DataBind();

                        DataTable dt33 = Main.SelectImages(dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "BRANCH_DOCS");
                        DataList2.DataSource = dt33;
                        DataList2.DataBind();


                        DataTable dtEvents = Main.SelectJobFromRegister("CASE16", dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "", "", System.DateTime.Now);
                        RadGrdEventsITWF.DataSource = dtEvents;
                        RadGrdEventsITWF.DataBind();
                    }

                    ddlStatusSch.Items.Clear();
                    ddlStatusSch.DataSource     = CM_Main.SelectReferanceData("STATUS", "", "");
                    ddlStatusSch.DataValueField = "DESCRIPTION";
                    ddlStatusSch.DataTextField  = "DESCRIPTION";
                    ddlStatusSch.DataBind();
                    ddlStatusSch.Items.Insert(0, new RadComboBoxItem("--Select Status--", ""));

                    ddlRequestUserSch.Items.Clear();
                    ddlRequestUserSch.DataSource     = Main.SelectReferanceData("HELPDESK_USERS", "", "");
                    ddlRequestUserSch.DataValueField = "USER_NAME";
                    ddlRequestUserSch.DataTextField  = "FULL_NAME";
                    ddlRequestUserSch.DataBind();
                    ddlRequestUserSch.Items.Insert(0, new RadComboBoxItem("--Select Request User--", ""));
                }
                if (IsPostBack)
                {
                    return;
                }
            }
            catch (Exception ex)
            {
                lblError.Text    = ex.Message;
                lblError.Visible = true;
                return;
            }
        }
        protected void grdRequest_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
        {
            try
            {
                if (e.CommandName == "Select")
                {
                    GridDataItem dataitem = e.Item as GridDataItem;

                    DataTable dtcon = CM_Main.SelectJob("CASE11", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
                    grdRequest.DataSource = dtcon;
                    grdRequest.DataBind();

                    BtnUpdate.Enabled = true;
                    // BtnReject.Enabled = true;

                    txtReqID.Text           = dtcon.Rows[0]["REQUEST_ID"].ToString();
                    lblCompany.Text         = dtcon.Rows[0]["COMPANY"].ToString();
                    lblStatus.Text          = dtcon.Rows[0]["STATUS"].ToString();
                    lblTitle.Text           = dtcon.Rows[0]["TITLE"].ToString();
                    lblSystem.Text          = dtcon.Rows[0]["SYSTEM"].ToString();
                    lblDescription.Text     = dtcon.Rows[0]["DESCRIPTION"].ToString();
                    lblApprovalComment.Text = dtcon.Rows[0]["APPROVE_COMMENT"].ToString();

                    lblRequestUser.Text = dtcon.Rows[0]["RU_FULLNAME"].ToString();
                    lblManager.Text     = dtcon.Rows[0]["MAN_FULLNAME"].ToString();
                    lblImplement.Text   = dtcon.Rows[0]["IMP_FULLNAME"].ToString();
                    lblQA.Text          = dtcon.Rows[0]["QA_FULLNAME"].ToString();
                    lblRelease.Text     = dtcon.Rows[0]["RE_FULLNAME"].ToString();

                    lblRejectRea.Text = dtcon.Rows[0]["REJECT_COMMENT"].ToString();
                    lblImpact.Text    = dtcon.Rows[0]["IMPACT"].ToString();
                    lblOutage.Text    = dtcon.Rows[0]["OUTAGE"].ToString();
                    lblFallBack.Text  = dtcon.Rows[0]["FEEDBACK_PLAN"].ToString();

                    lblParent.Text = dtcon.Rows[0]["PARENT_ID"].ToString();

                    lblCreation.Text   = dtcon.Rows[0]["REQUEST_DATE"].ToString();
                    lblStart.Text      = dtcon.Rows[0]["START_DATE"].ToString();
                    lblEnd.Text        = dtcon.Rows[0]["END_DATE"].ToString();
                    lblLastUpdate.Text = dtcon.Rows[0]["LAST_UPDATE_DATE"].ToString();
                    lblAssign.Text     = dtcon.Rows[0]["ASSIGN_DATE"].ToString();


                    txtApproveComment.Text = dtcon.Rows[0]["IMPLEMENTATION_COMMENT"].ToString();

                    RdGrdEvents.DataSource = CM_Main.SelectJob("CASE10", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
                    RdGrdEvents.DataBind();


                    DataTable dtDocsJobWise = CM_Main.SelectJob("CASE13", txtReqID.Text, "", "", "", "", System.DateTime.Now);
                    if (dtDocsJobWise.Rows.Count >= 1)
                    {
                        RadListBox2.DataSource     = dtDocsJobWise;
                        RadListBox2.DataTextField  = "DOCUMENT";
                        RadListBox2.DataValueField = "DOCUMENT";
                        RadListBox2.DataBind();
                    }

                    GrdViewDocs.DataSource = CM_Main.SelectJob("CASE15", txtReqID.Text, "", "", "", "", System.DateTime.Now);
                    GrdViewDocs.DataBind();



                    DataTable dt = Main.SelectImages(dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "BRANCH_IMAGE");
                    galleryDataList.DataSource = dt;
                    galleryDataList.DataBind();

                    DataTable dt33 = Main.SelectImages(dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "BRANCH_DOCS");
                    DataList2.DataSource = dt33;
                    DataList2.DataBind();


                    DataTable dtEvents = Main.SelectJobFromRegister("CASE16", dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "", "", System.DateTime.Now);
                    RadGrdEventsITWF.DataSource = dtEvents;
                    RadGrdEventsITWF.DataBind();
                }
            }
            catch (Exception ex)
            {
                lblError.Text    = ex.Message;
                lblError.Visible = true;
                return;
            }
        }
Example #3
0
        protected void grdRequest_ItemCommand(object sender, GridCommandEventArgs e)
        {
            try
            {
                if (e.CommandName == "Select")
                {
                    GridDataItem dataitem = e.Item as GridDataItem;

                    DataTable dtcon = CM_Main.SelectJob("CASE3", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
                    grdRequest.DataSource = dtcon;
                    grdRequest.DataBind();

                    BtnUpdate.Enabled = true;
                    BtnReject.Enabled = true;

                    lblID.Text    = dtcon.Rows[0]["REQUEST_ID"].ToString();
                    txtReqID.Text = dtcon.Rows[0]["REQUEST_ID"].ToString();

                    if (dtcon.Rows[0]["START_DATE"].ToString() != "")
                    {
                        Start.SelectedDate = Convert.ToDateTime(dtcon.Rows[0]["START_DATE"]);
                    }
                    if (dtcon.Rows[0]["END_DATE"].ToString() != "")
                    {
                        End.SelectedDate = Convert.ToDateTime(dtcon.Rows[0]["END_DATE"]);
                    }

                    if (dtcon.Rows[0]["IMPACT"].ToString() != "")
                    {
                        txtImpact.Text = dtcon.Rows[0]["IMPACT"].ToString();
                    }

                    if (dtcon.Rows[0]["FEEDBACK_PLAN"].ToString() != "")
                    {
                        txtFallback.Text = dtcon.Rows[0]["FEEDBACK_PLAN"].ToString();
                    }

                    if (dtcon.Rows[0]["REJECT_COMMENT"].ToString() != "")
                    {
                        txtReject.Text = dtcon.Rows[0]["REJECT_COMMENT"].ToString();
                    }

                    DataTable Users = CM_Main.SelectJob("CASE1", "", "", "", "", "", System.DateTime.Now);

                    CmbUsers1.DataSource     = Users;
                    CmbUsers1.DataValueField = "USER_NAME";
                    CmbUsers1.DataTextField  = "FULL_NAME";
                    CmbUsers1.DataBind();

                    if (dtcon.Rows[0]["MANAGER"].ToString() != "")
                    {
                        CmbUsers1.Items.Insert(0, new RadComboBoxItem(dtcon.Rows[0]["MANAGER"].ToString(), dtcon.Rows[0]["MANAGER"].ToString()));
                    }
                    else
                    {
                        CmbUsers1.Items.Insert(0, new RadComboBoxItem("--Select User--", ""));
                    }

                    CmbUsers2.DataSource     = Users;
                    CmbUsers2.DataValueField = "USER_NAME";
                    CmbUsers2.DataTextField  = "FULL_NAME";
                    CmbUsers2.DataBind();

                    if (dtcon.Rows[0]["IMPLEMENTOR"].ToString() != "")
                    {
                        CmbUsers2.Items.Insert(0, new RadComboBoxItem(dtcon.Rows[0]["IMPLEMENTOR"].ToString(), dtcon.Rows[0]["IMPLEMENTOR"].ToString()));
                    }
                    else
                    {
                        CmbUsers2.Items.Insert(0, new RadComboBoxItem("--Select User--", ""));
                    }

                    CmbUsers3.DataSource     = Users;
                    CmbUsers3.DataValueField = "USER_NAME";
                    CmbUsers3.DataTextField  = "FULL_NAME";
                    CmbUsers3.DataBind();

                    if (dtcon.Rows[0]["QA_AGENT"].ToString() != "")
                    {
                        CmbUsers3.Items.Insert(0, new RadComboBoxItem(dtcon.Rows[0]["QA_AGENT"].ToString(), dtcon.Rows[0]["QA_AGENT"].ToString()));
                    }
                    else
                    {
                        CmbUsers3.Items.Insert(0, new RadComboBoxItem("--Select User--", ""));
                    }

                    CmbUsers4.DataSource     = Users;
                    CmbUsers4.DataValueField = "USER_NAME";
                    CmbUsers4.DataTextField  = "FULL_NAME";
                    CmbUsers4.DataBind();

                    if (dtcon.Rows[0]["RELEASE_TEAM"].ToString() != "")
                    {
                        CmbUsers4.Items.Insert(0, new RadComboBoxItem(dtcon.Rows[0]["RELEASE_TEAM"].ToString(), dtcon.Rows[0]["RELEASE_TEAM"].ToString()));
                    }
                    else
                    {
                        CmbUsers4.Items.Insert(0, new RadComboBoxItem("--Select User--", ""));
                    }


                    if (dtcon.Rows[0]["OUTAGE"].ToString() != "")
                    {
                        CmbOutage.Items.Insert(0, new RadComboBoxItem(dtcon.Rows[0]["OUTAGE"].ToString(), dtcon.Rows[0]["OUTAGE"].ToString()));
                        CmbOutage.Items.Insert(1, new RadComboBoxItem("YES", "YES"));
                        CmbOutage.Items.Insert(2, new RadComboBoxItem("NO", "NO"));
                    }
                    else
                    {
                        CmbOutage.Items.Insert(0, new RadComboBoxItem("YES", "YES"));
                        CmbOutage.Items.Insert(1, new RadComboBoxItem("NO", "NO"));
                    }


                    //-------IT Work Flow Details

                    DataTable dtconIT = CM_Main.SelectJob("CASE11", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);

                    txtReqID.Text        = dtconIT.Rows[0]["REQUEST_ID"].ToString();
                    lblCompany.Text      = dtconIT.Rows[0]["COMPANY"].ToString();
                    lblStatus.Text       = dtconIT.Rows[0]["STATUS"].ToString();
                    lblTitle.Text        = dtconIT.Rows[0]["TITLE"].ToString();
                    lblSystem.Text       = dtconIT.Rows[0]["SYSTEM"].ToString();
                    lblDescription.Text  = dtconIT.Rows[0]["IT_DES"].ToString();
                    lblITWorkFlowID.Text = dtconIT.Rows[0]["IT_REQUEST_ID"].ToString();


                    lblParent.Text = dtconIT.Rows[0]["PARENT_ID"].ToString();

                    DataTable dt = Main.SelectImages(lblITWorkFlowID.Text, "BRANCH_IMAGE");
                    galleryDataList.DataSource = dt;
                    galleryDataList.DataBind();

                    DataTable dt33 = Main.SelectImages(lblITWorkFlowID.Text, "BRANCH_DOCS");
                    DataList2.DataSource = dt33;
                    DataList2.DataBind();

                    RdGrdEvents.DataSource = CM_Main.SelectJob("CASE10", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
                    RdGrdEvents.DataBind();

                    DataTable dtEvents = Main.SelectJobFromRegister("CASE16", lblITWorkFlowID.Text, "", "", System.DateTime.Now);
                    RadGrdEventsITWF.DataSource = dtEvents;
                    RadGrdEventsITWF.DataBind();


                    DataTable dtDocsSysWise = CM_Main.SelectJob("CASE12", txtReqID.Text, "", "", "", "", System.DateTime.Now);
                    RadListBox1.DataSource     = dtDocsSysWise;
                    RadListBox1.DataTextField  = "DOCUMENT";
                    RadListBox1.DataValueField = "DOCUMENT";
                    RadListBox1.DataBind();

                    DataTable dtDocsJobWise = CM_Main.SelectJob("CASE13", txtReqID.Text, "", "", "", "", System.DateTime.Now);
                    if (dtDocsJobWise.Rows.Count >= 1)
                    {
                        RadListBox2.DataSource     = dtDocsJobWise;
                        RadListBox2.DataTextField  = "DOCUMENT";
                        RadListBox2.DataValueField = "DOCUMENT";
                        RadListBox2.DataBind();
                    }
                }
            }
            catch (Exception ex)
            {
                lblError.Text    = ex.Message;
                lblError.Visible = true;
                return;
            }
        }
Example #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (!IsPostBack)
                {
                    DataTable dtconall = CM_Main.SelectJob("CASE2", "", "INTIMATE", "", "", "", System.DateTime.Now);
                    grdRequest.DataSource = dtconall;
                    grdRequest.DataBind();

                    UserName = User.Identity.Name;
                    if (Left(UserName, 4) == "HNBA")
                    {
                        UserName        = Right(UserName, (UserName.Length) - 5);
                        Session["USER"] = UserName;
                        GetUser(UserName.ToString());
                    }
                    else if (Left(UserName, 5) == "HNBGI")
                    {
                        UserName        = Right(UserName, (UserName.Length) - 6);
                        Session["USER"] = UserName;
                        GetUser(UserName.ToString());
                    }
                    //DataTable dtconall = CM_Main.SelectJob("CASE2", "", "INTIMATE", "", "", "", System.DateTime.Now);
                    //grdRequest.DataSource = dtconall;
                    //grdRequest.DataBind();

                    if (Request.QueryString["ReqID"] != null)
                    {
                        ReqID = Request.QueryString["ReqID"];

                        DataTable dtcon = CM_Main.SelectJob("CASE3", ReqID, "", "", "", "", System.DateTime.Now);
                        grdRequest.DataSource = dtcon;
                        grdRequest.DataBind();

                        BtnUpdate.Enabled = true;
                        BtnReject.Enabled = true;

                        lblID.Text    = dtcon.Rows[0]["REQUEST_ID"].ToString();
                        txtReqID.Text = dtcon.Rows[0]["REQUEST_ID"].ToString();

                        if (dtcon.Rows[0]["START_DATE"].ToString() != "")
                        {
                            Start.SelectedDate = Convert.ToDateTime(dtcon.Rows[0]["START_DATE"]);
                        }
                        if (dtcon.Rows[0]["END_DATE"].ToString() != "")
                        {
                            End.SelectedDate = Convert.ToDateTime(dtcon.Rows[0]["END_DATE"]);
                        }

                        if (dtcon.Rows[0]["IMPACT"].ToString() != "")
                        {
                            txtImpact.Text = dtcon.Rows[0]["IMPACT"].ToString();
                        }

                        if (dtcon.Rows[0]["FEEDBACK_PLAN"].ToString() != "")
                        {
                            txtFallback.Text = dtcon.Rows[0]["FEEDBACK_PLAN"].ToString();
                        }

                        if (dtcon.Rows[0]["REJECT_COMMENT"].ToString() != "")
                        {
                            txtReject.Text = dtcon.Rows[0]["REJECT_COMMENT"].ToString();
                        }

                        DataTable Users = CM_Main.SelectJob("CASE1", "", "", "", "", "", System.DateTime.Now);

                        CmbUsers1.DataSource     = Users;
                        CmbUsers1.DataValueField = "USER_NAME";
                        CmbUsers1.DataTextField  = "FULL_NAME";
                        CmbUsers1.DataBind();

                        if (dtcon.Rows[0]["MANAGER"].ToString() != "")
                        {
                            CmbUsers1.Items.Insert(0, new RadComboBoxItem(dtcon.Rows[0]["MANAGER"].ToString(), dtcon.Rows[0]["MANAGER"].ToString()));
                        }
                        else
                        {
                            CmbUsers1.Items.Insert(0, new RadComboBoxItem("--Select User--", ""));
                        }

                        CmbUsers2.DataSource     = Users;
                        CmbUsers2.DataValueField = "USER_NAME";
                        CmbUsers2.DataTextField  = "FULL_NAME";
                        CmbUsers2.DataBind();

                        if (dtcon.Rows[0]["IMPLEMENTOR"].ToString() != "")
                        {
                            CmbUsers2.Items.Insert(0, new RadComboBoxItem(dtcon.Rows[0]["IMPLEMENTOR"].ToString(), dtcon.Rows[0]["IMPLEMENTOR"].ToString()));
                        }
                        else
                        {
                            CmbUsers2.Items.Insert(0, new RadComboBoxItem("--Select User--", ""));
                        }

                        CmbUsers3.DataSource     = Users;
                        CmbUsers3.DataValueField = "USER_NAME";
                        CmbUsers3.DataTextField  = "FULL_NAME";
                        CmbUsers3.DataBind();

                        if (dtcon.Rows[0]["QA_AGENT"].ToString() != "")
                        {
                            CmbUsers3.Items.Insert(0, new RadComboBoxItem(dtcon.Rows[0]["QA_AGENT"].ToString(), dtcon.Rows[0]["QA_AGENT"].ToString()));
                        }
                        else
                        {
                            CmbUsers3.Items.Insert(0, new RadComboBoxItem("--Select User--", ""));
                        }

                        CmbUsers4.DataSource     = Users;
                        CmbUsers4.DataValueField = "USER_NAME";
                        CmbUsers4.DataTextField  = "FULL_NAME";
                        CmbUsers4.DataBind();

                        if (dtcon.Rows[0]["RELEASE_TEAM"].ToString() != "")
                        {
                            CmbUsers4.Items.Insert(0, new RadComboBoxItem(dtcon.Rows[0]["RELEASE_TEAM"].ToString(), dtcon.Rows[0]["RELEASE_TEAM"].ToString()));
                        }
                        else
                        {
                            CmbUsers4.Items.Insert(0, new RadComboBoxItem("--Select User--", ""));
                        }


                        if (dtcon.Rows[0]["OUTAGE"].ToString() != "")
                        {
                            CmbOutage.Items.Insert(0, new RadComboBoxItem(dtcon.Rows[0]["OUTAGE"].ToString(), dtcon.Rows[0]["OUTAGE"].ToString()));
                            CmbOutage.Items.Insert(1, new RadComboBoxItem("YES", "YES"));
                            CmbOutage.Items.Insert(2, new RadComboBoxItem("NO", "NO"));
                        }
                        else
                        {
                            CmbOutage.Items.Insert(0, new RadComboBoxItem("YES", "YES"));
                            CmbOutage.Items.Insert(1, new RadComboBoxItem("NO", "NO"));
                        }

                        //-------IT Work Flow Details

                        DataTable dtconIT = CM_Main.SelectJob("CASE11", ReqID, "", "", "", "", System.DateTime.Now);

                        txtReqID.Text        = dtconIT.Rows[0]["REQUEST_ID"].ToString();
                        lblCompany.Text      = dtconIT.Rows[0]["COMPANY"].ToString();
                        lblStatus.Text       = dtconIT.Rows[0]["STATUS"].ToString();
                        lblTitle.Text        = dtconIT.Rows[0]["TITLE"].ToString();
                        lblSystem.Text       = dtconIT.Rows[0]["SYSTEM"].ToString();
                        lblDescription.Text  = dtconIT.Rows[0]["IT_DES"].ToString();
                        lblITWorkFlowID.Text = dtconIT.Rows[0]["IT_REQUEST_ID"].ToString();


                        lblParent.Text = dtconIT.Rows[0]["PARENT_ID"].ToString();

                        DataTable dt = Main.SelectImages(lblITWorkFlowID.Text, "BRANCH_IMAGE");
                        galleryDataList.DataSource = dt;
                        galleryDataList.DataBind();

                        DataTable dt33 = Main.SelectImages(lblITWorkFlowID.Text, "BRANCH_DOCS");
                        DataList2.DataSource = dt33;
                        DataList2.DataBind();

                        RdGrdEvents.DataSource = CM_Main.SelectJob("CASE10", ReqID, "", "", "", "", System.DateTime.Now);
                        RdGrdEvents.DataBind();

                        DataTable dtEvents = Main.SelectJobFromRegister("CASE16", lblITWorkFlowID.Text, "", "", System.DateTime.Now);
                        RadGrdEventsITWF.DataSource = dtEvents;
                        RadGrdEventsITWF.DataBind();

                        DataTable dtDocsSysWise = CM_Main.SelectJob("CASE12", txtReqID.Text, "", "", "", "", System.DateTime.Now);
                        RadListBox1.DataSource     = dtDocsSysWise;
                        RadListBox1.DataTextField  = "DOCUMENT";
                        RadListBox1.DataValueField = "DOCUMENT";
                        RadListBox1.DataBind();

                        DataTable dtDocsJobWise = CM_Main.SelectJob("CASE13", txtReqID.Text, "", "", "", "", System.DateTime.Now);
                        if (dtDocsJobWise.Rows.Count >= 1)
                        {
                            RadListBox2.DataSource     = dtDocsJobWise;
                            RadListBox2.DataTextField  = "DOCUMENT";
                            RadListBox2.DataValueField = "DOCUMENT";
                            RadListBox2.DataBind();
                        }
                    }

                    ddlStatusSch.Items.Clear();
                    ddlStatusSch.DataSource     = CM_Main.SelectReferanceData("STATUS", "", "");
                    ddlStatusSch.DataValueField = "DESCRIPTION";
                    ddlStatusSch.DataTextField  = "DESCRIPTION";
                    ddlStatusSch.DataBind();
                    ddlStatusSch.Items.Insert(0, new RadComboBoxItem("--Select Status--", ""));

                    ddlRequestUserSch.Items.Clear();
                    ddlRequestUserSch.DataSource     = Main.SelectReferanceData("HELPDESK_USERS", "", "");
                    ddlRequestUserSch.DataValueField = "USER_NAME";
                    ddlRequestUserSch.DataTextField  = "FULL_NAME";
                    ddlRequestUserSch.DataBind();
                    ddlRequestUserSch.Items.Insert(0, new RadComboBoxItem("--Select Request User--", ""));
                }
            }
            catch (Exception ex)
            {
                lblError.Text    = ex.Message;
                lblError.Visible = true;
                return;
            }
        }
        protected void grdRequest_ItemCommand(object sender, GridCommandEventArgs e)
        {
            try
            {
                if (e.CommandName == "Select")
                {
                    BtnInsert.Enabled = false;
                    BtnUpdate.Enabled = true;


                    GridDataItem dataitem = e.Item as GridDataItem;

                    DataTable dtcon = CM_Main.SelectJob("CASE3", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
                    grdRequest.DataSource = dtcon;
                    grdRequest.DataBind();

                    lblID.Text           = dtcon.Rows[0]["REQUEST_ID"].ToString();
                    lblParentChange.Text = dtcon.Rows[0]["PARENT_ID"].ToString();
                    lblWorkFlowID.Text   = dtcon.Rows[0]["IT_REQUEST_ID"].ToString();
                    lblCompany.Text      = dtcon.Rows[0]["COMPANY"].ToString();
                    txtStatus.Text       = dtcon.Rows[0]["STATUS"].ToString();
                    txtTitle.Text        = dtcon.Rows[0]["TITLE"].ToString();
                    lblSystem.Text       = dtcon.Rows[0]["SYSTEM"].ToString();
                    txtDesciption.Text   = dtcon.Rows[0]["DESCRIPTION"].ToString();


                    RdGrdContacts.DataSource = CM_Main.SelectJob("CASE6", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
                    RdGrdContacts.DataBind();

                    RdGrdCIPath.DataSource = CM_Main.SelectJob("CASE7", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
                    RdGrdCIPath.DataBind();

                    RdGrdChildChanges.DataSource = CM_Main.SelectJob("CASE8", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
                    RdGrdChildChanges.DataBind();


                    DataList1.DataSource = CM_Main.SelectJob("CASE9", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
                    DataList1.DataBind();

                    RdGrdEvents.DataSource = CM_Main.SelectJob("CASE10", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
                    RdGrdEvents.DataBind();


                    DataTable dtEvents = Main.SelectJobFromRegister("CASE16", lblWorkFlowID.Text, "", "", System.DateTime.Now);
                    RadGrdEventsITWF.DataSource = dtEvents;
                    RadGrdEventsITWF.DataBind();

                    DataTable dt = Main.SelectImages(lblWorkFlowID.Text, "BRANCH_IMAGE");
                    galleryDataList.DataSource = dt;
                    galleryDataList.DataBind();

                    DataTable dt33 = Main.SelectImages(lblWorkFlowID.Text, "BRANCH_DOCS");
                    DataList2.DataSource = dt33;
                    DataList2.DataBind();
                }
            }
            catch (Exception ex)
            {
                lblError.Text    = ex.Message;
                lblError.Visible = true;
                return;
            }
        }