protected void GetTemplateList()
        {
            //select * from VW_GetTemplateDetails
            iPartRequestClient objService = new iPartRequestClient();
            CustomProfile      profile    = CustomProfile.GetProfile();

            GVRequest.DataSource = null;
            GVRequest.DataBind();

            DataSet dsTemplate = new DataSet();
            string  UserType   = profile.Personal.UserType.ToString();

            if (UserType == "Super Admin")
            {
                dsTemplate = objService.GetTemplateDetailsSuperAdmin(profile.DBConnection._constr);
            }
            else if (UserType == "Admin")
            {
                dsTemplate = objService.GetTemplateDetailsAdmin(profile.Personal.UserID, profile.DBConnection._constr);
            }
            //else
            //{
            //   // dsTemplate = objService.GetTemplateDetails(profile.Personal.UserID, profile.DBConnection._constr);
            //}
            //dsTemplate = objService.GetTemplateDetails(profile.Personal.UserID, profile.DBConnection._constr);

            GVRequest.DataSource = dsTemplate;
            GVRequest.DataBind();
        }