protected void Submit_PA(object sender, EventArgs e)
        {
            int check = 0;

            try
            {
                MembershipDAO user_PA = new MembershipDAO();
                if (Session["Person"] != null)
                {
                    check = user_PA.AddPA(modalDDList.SelectedValue.ToString(), modalFName.Value, modalSname.Value, modalTelNo.Value, modalEmail.Value);
                }
                if (Session["IndivEdit"] != null)
                {
                    check = user_PA.AddPALater(hiddentextPersonID.Value, modalDDList.SelectedValue.ToString(), modalFName.Value, modalSname.Value, modalTelNo.Value, modalEmail.Value);
                }
                if (check == 1 || check == 2)
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "displaySuccess('Successfully Created New Personal Assistant: " + modalSname.Value + " " + modalFName.Value + "');", true);
                    UserTable.DataSource = db.GetIndivPAInfo();
                    UserTable.DataBind();
                }
                else if (check == 0)
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true);
                }
            }
            catch (Exception ex)
            {
                ErrorLog.WriteErrorLog(ex.ToString());
                ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true);
            }
        }
        protected void Submit_PA(object sender, EventArgs e)
        {
            bool flag = false;

            ArrayList indiv_PAList = new ArrayList();

            if (validatePAFields().Equals(true))
            {
                indiv_PAList.Add(modalDDList.SelectedValue); //0
                indiv_PAList.Add(modalFName.Value);          //1
                indiv_PAList.Add(modalSname.Value);          //2
                indiv_PAList.Add(modalEmail.Value);          //3
                indiv_PAList.Add(modalTelNo.Value);          //4
                flag = true;
            }
            else
            {
            }

            if (flag != false)
            {
                string pid   = hiddentextPersonID.Value.ToString();
                int    check = 0;
                try
                {
                    MembershipDAO user_PA = new MembershipDAO();
                    if (Session["Person"] != null)
                    {
                        ScriptManager.RegisterStartupScript(Page, GetType(), "script", "hideToggle();", true);
                        check = user_PA.AddPA(indiv_PAList);
                    }
                    if (Session["IndivEdit"] != null)
                    {
                        check = user_PA.AddPALater(hiddentextPersonID.Value, modalDDList.SelectedValue.ToString(), modalFName.Value, modalSname.Value, modalTelNo.Value, modalEmail.Value);
                    }
                    if (check == 1 || check == 2)
                    {
                        ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "displaySuccess('Successfully Created New Personal Assistant: " + modalSname.Value + " " + modalFName.Value + "');", true);
                        UserTable.DataSource = db.GetIndivPAInfo(pid);
                        UserTable.DataBind();
                    }
                    else if (check == 0)
                    {
                        ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true);
                    }
                }
                catch (Exception ex)
                {
                    ErrorLog.WriteErrorLog(ex.ToString());
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true);
                }
            }
            else
            {
                if (Session["Person"] != null)
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), "script", "hideToggle();", true);
                }
            }
        }
        public void updateINDIV(object sender, EventArgs e)
        {
            string genderChk;

            if (Male.Checked == true)
            {
                genderChk = Male.Value;
            }
            else
            {
                genderChk = Female.Value;
            }
            if (validateUpdateFields() == true)
            {
                int           personId = int.Parse(hiddentextPersonID.Value);
                MembershipDAO d1       = new MembershipDAO();
                int           check    = d1.UpdateIndividual(personId, txtFirstName.Value, txtSurname.Value, genderChk, ddlSource.SelectedValue, ddlList.SelectedValue, txtSalutationField.Value, txtTelephone.Value, txtEmail.Value, ddlNationality.SelectedValue, DateTime.Now, txtDesig1.Value, txtDept1.Value, txtOrg1.Value, txtDesig2.Value, txtDept2.Value, txtOrg2.Value, txtSDR.Value, txtFullNameNameTag.Value, ddlStatus.SelectedValue, ddlCat1.SelectedValue, ddlCat2.SelectedValue);
                if (check == 2)
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "displaySuccess('Successfully Updated for Individual Associate: " + txtFullNameNameTag.Value + "');", true);
                    enableFields();
                }
                else if (check == 0)
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailureMsg('testing');", true);
                }
            }
        }
Exemplo n.º 4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (Session["Person"] != null)
                {
                    Session["EDIT_ORG_ID"] = null;
                    orgList = (ArrayList)Session["Person"];
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "hideToggle();", true);
                }
                else
                {
                    Session["Person"] = null;
                }

                if (Session["EDIT_ORG_ID"] != null)
                {
                    Session["Person"] = null;
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "hideBtnNext();", true);

                    OrgInfo       o1     = new OrgInfo();
                    MembershipDAO dalMem = new MembershipDAO();
                    string        org_id = Session["EDIT_ORG_ID"].ToString();
                    o1 = dalMem.getAllOrgInfo(org_id);

                    txtOrgNameField.Value  = o1.orgName.ToString();
                    txtMailAddrLine1.Value = o1.mailLine1.ToString();
                    txtMailAddrLine2.Value = o1.mailLine2.ToString();
                    txtCity.Value          = o1.city.ToString();
                    txtPostalCode.Value    = o1.postalCode.ToString();
                    txtTelephone.Value     = o1.telNo.ToString();
                    txtOffice.Value        = o1.officeNo.ToString();
                    txtWebsiteURL.Value    = o1.websiteURL.ToString();
                    txtbDesc.Value         = o1.busDesc.ToString();
                    pointOfContact.Value   = o1.PoC.ToString();
                    txtnotes.Value         = o1.notes.ToString();
                    txtUEN.Value           = o1.uen.ToString();
                    orgID.Value            = org_id.ToString();


                    disableFields();
                }
            }
            else
            {
                if (Session["Person"] != null)
                {
                    Session["EDIT_ORG_ID"] = null;
                    orgList = (ArrayList)Session["Person"];
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "hideToggle();", true);
                }
                else
                {
                    Session["Person"] = null;
                }
            }
        }
Exemplo n.º 5
0
        public void getCat1(object sender, EventArgs e)
        {
            MembershipDAO d1 = new MembershipDAO();
            DataTable     DT = new DataTable();

            DT = d1.GetCat1(ddlSource.SelectedValue);
            ddlCat1.DataSource    = DT;
            ddlCat1.DataTextField = "cat_1";
            ddlCat1.DataTextField = "cat_1";
            ddlCat1.DataBind();
        }
Exemplo n.º 6
0
        public void updateCAREP(object sender, EventArgs e)
        {
            string genderChk, faciChk, emailChk;

            if (Male.Checked == true)
            {
                genderChk = Male.Value;
            }
            else                    //2
            {
                genderChk = Female.Value;
            }

            if (FacilitatorBriefed.Checked)
            {
                faciChk = FacilitatorBriefed.Value; //18
            }
            else
            {
                faciChk = "NA";
            }
            if (welcomeEmail.Checked)
            {
                emailChk = welcomeEmail.Value; //19
            }
            else
            {
                emailChk = "NA";
            }
            if (validateCAREPFields() == true)
            {
                int           personId = int.Parse(hiddentext.Value);
                MembershipDAO d1       = new MembershipDAO();
                //DALMembership user = new DALMembership();
                int check = d1.UpdateCAREP(personId, txtFirstName.Value, txtSurname.Value, genderChk, ddlSource.SelectedValue, ddlList.SelectedValue, txtSalutationField.Value, txtTelephone.Value, txtEmail.Value, ddlNationality.SelectedValue, DateTime.Now, txtDesig1.Value, txtDept1.Value, txtOrg1.Value, txtDesig2.Value, txtDept2.Value, txtOrg2.Value, txtSDR.Value, txtFullNameNameTag.Value, ddlRole.SelectedValue, ddlStatus.SelectedValue, faciChk, emailChk, ddlCat1.SelectedValue.ToString(), ddlCat2.SelectedValue.ToString());
                if (check == 2)
                {
                    clearPAModal();
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "displaySuccess('Successfully Updated for Coporate Associate: " + txtFullNameNameTag.Value + "');", true);
                    enableFields();
                    //gvPerson.DataSource = mem.getAllMembershipDetailPerson();
                    //gvPerson.DataBind();
                    //gvPerson.HeaderRow.TableSection = TableRowSection.TableHeader;
                }
                else if (check == 0)
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true);
                }
            }
        }
        public void bindtable()
        {
            MembershipDAO db = new MembershipDAO();

            UserTable.DataSource = db.GetIndivPAInfo();
            UserTable.DataBind();
            UserTable.HeaderRow.TableSection = TableRowSection.TableHeader;
            if (IsPostBack)
            {
                UserTable.DataSource = db.GetIndivPAInfo();
                UserTable.DataBind();
                //upPanel.Update();
            }
        }
        public void getCat1(object sender, EventArgs e)
        {
            MembershipDAO d1 = new MembershipDAO();
            DataTable     DT = new DataTable();

            DT = d1.GetCat1(ddlSource.SelectedValue);
            ddlCat1.DataSource    = DT;
            ddlCat1.DataTextField = "cat_1";
            ddlCat1.DataTextField = "cat_1";
            ddlCat1.DataBind();
            if (Session["Person"] != null)
            {
                ScriptManager.RegisterStartupScript(Page, GetType(), "script", "hideToggle();", true);
            }
        }
Exemplo n.º 9
0
        public void bindPAtable()
        {
            MembershipDAO db = new MembershipDAO();

            PA_GridView.DataSource = db.GetPAInfo(caID.InnerText.ToString());
            PA_GridView.DataBind();
            PA_GridView.HeaderRow.TableSection = TableRowSection.TableHeader;


            if (!IsPostBack)
            {
                PA_GridView.DataSource = db.GetPAInfo();
                PA_GridView.DataBind();
                //upPanel.Update();
            }
        }
Exemplo n.º 10
0
        protected void bindTableEdit(string ORG_ID)
        {
            MembershipDAO db = new MembershipDAO();

            UserTable.DataSource = db.GetCAREPEDIT(ORG_ID);
            UserTable.DataBind();
            UserTable.HeaderRow.TableSection = TableRowSection.TableHeader;


            if (!IsPostBack)
            {
                UserTable.DataSource = db.GetCAREPEDIT(ORG_ID);
                UserTable.DataBind();
                //upPanel.Update();
            }
        }
        public void btnDeleteInd_ServerClick(object sender, EventArgs e)
        {
            int           personId = Int32.Parse(hiddentextPersonID.Value);
            MembershipDAO d1       = new MembershipDAO();

            if (personId > 0)
            {
                int check = d1.DeleteIARecord(personId);
                if (check == 1 || check == 0)
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "displaySuccess('Successfully Deleted');", true);
                    Response.Redirect("Member_MemberManagement.aspx");
                }
                else
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true);
                }
            }
        }
        public void bindtable()
        {
            MembershipDAO db  = new MembershipDAO();
            string        pid = hiddentextPersonID.Value.ToString();

            UserTable.DataSource   = db.GetIndivPAInfo(pid);
            UserTable.DataSourceID = null;
            UserTable.DataBind();
            //string pid = null ;
            UserTable.HeaderRow.TableSection = TableRowSection.TableHeader;
            if (IsPostBack)
            {
                UserTable.DataSource = db.GetIndivPAInfo(pid);
                UserTable.DataBind();
                //upPanel.Update();
            }
            else
            {
            }
        }
Exemplo n.º 13
0
        protected void Submit_PA(object sender, EventArgs e)
        {
            int check = 0;

            try {
                MembershipDAO user_PA = new MembershipDAO();
                //check = user_PA.AddPA(ddlList.SelectedValue.ToString(), txtFirstName.Value, txtSurname.Value, txtTelephone.Value, txtEmail.Value);

                if (check == 1)
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "displaySuccess('Successfully Created New PA: " + txtSurname.Value + " " + txtFirstName.Value + "');", true);
                }
                else if (check == 0)
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true);
                }
            }
            catch (Exception ex) {
                ErrorLog.WriteErrorLog(ex.ToString());
                ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true);
            }
        }
Exemplo n.º 14
0
        public void btnDeleteCAREP_ServerClick(object sender, EventArgs e)
        {
            int           personId = Int32.Parse(hiddentext.Value);
            MembershipDAO d1       = new MembershipDAO();

            if (personId > 0)
            {
                int check = d1.DeleteCAREPRecord(personId);
                if (check == 1 || check == 0)
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertDisplay", "displaySuccess('Successfully Deleted');", true);
                    Response.Redirect("Member_MemberManagement.aspx");
                    //gvPerson.DataSource = mem.getAllMembershipDetailPerson();
                    //gvPerson.DataBind();
                    //gvPerson.HeaderRow.TableSection = TableRowSection.TableHeader;
                }
                else
                {
                    //  Response.Write("<script>alert('Delete Unsuccessful.');</script>");
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "displayFailure();", true);
                }
            }
        }
Exemplo n.º 15
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bindtable();
                slidertoggleDIV.Style.Add("display", "block");
                MembershipDAO d1         = new MembershipDAO();
                MembershipDAO d2         = new MembershipDAO();
                MembershipDAO d3         = new MembershipDAO();
                DataTable     DT         = new DataTable();
                DataTable     DTRole     = new DataTable();
                DataTable     DTCAREP_PA = new DataTable();

                DT = d1.GetLookupSearch("HONOURIFIC");
                ddlList.DataSource     = DT;
                ddlList.DataTextField  = "Code_Desc";
                ddlList.DataValueField = "Code"; //When insert, this value
                ddlList.DataBind();
                ddlList.Items.Insert(0, "");



                DTRole                 = d2.GetLookupSearch("CAREP");
                ddlRole.DataSource     = DTRole;
                ddlRole.DataTextField  = "Code_Desc";
                ddlRole.DataValueField = "Code_Desc"; //When insert, this value
                ddlRole.DataBind();



                DT = d3.GetLookupSearch("HONOURIFIC");
                modalDDList.DataSource     = DT;
                modalDDList.DataTextField  = "Code_Desc";
                modalDDList.DataValueField = "Code"; //When insert, this value
                modalDDList.DataBind();
                modalDDList.Items.Insert(0, "");

                DT = d1.GetSource();
                ddlSource.DataSource     = DT;
                ddlSource.DataTextField  = "source";
                ddlSource.DataValueField = "source";
                ddlSource.DataBind();
                ddlSource.SelectedValue = "Acad_TT";



                DT = d1.GetCat2();
                ddlCat2.DataSource     = DT;
                ddlCat2.DataTextField  = "Code_Desc";
                ddlCat2.DataValueField = "Code";
                //ddlCat2.Items.Insert(0, "");
                ddlCat2.DataBind();
                ddlCat2.Items.Insert(0, "");



                DT = d1.GetCat1(ddlSource.SelectedValue);
                ddlCat1.DataSource    = DT;
                ddlCat1.DataTextField = "cat_1";
                ddlCat1.DataTextField = "cat_1";
                ddlCat1.DataBind();

                DT = d1.GetNationality();
                ddlNationality.DataSource     = DT;
                ddlNationality.DataTextField  = "NATIONALITY";
                ddlNationality.DataValueField = "NATIONALITY";
                ddlNationality.DataBind();



                if (Session["Person"] != null)
                {
                    Session["CAREPEDIT"]  = null;
                    Session["CAREPORGID"] = null;
                    orgList = (ArrayList)Session["Person"];
                    lblOrgName.InnerText = orgList[3].ToString();
                    slidertoggleDIV.Style.Add("display", "none");
                    ScriptManager.RegisterStartupScript(Page, GetType(), "script", "hideToggle();", true);
                }
                else
                {
                }

                if (Session["CAREPEDIT"] != null)
                {
                    Session["Person"] = null;
                    //slidertoggleDIV.Style.Add("display", "block");
                    hiddentext.Value = Session["CAREPEDIT"].ToString();
                    string        CAREP_ORG_ID = Session["CAREPORGID"].ToString();
                    MembershipDAO dalMem       = new MembershipDAO();
                    PersonModel   perModel     = new PersonModel();
                    ScriptManager.RegisterStartupScript(Page, GetType(), "script", "showToggle();", true);


                    perModel             = dalMem.GetCAREPData(hiddentext.Value.ToString());
                    lblOrgName.InnerText = perModel.orgName.ToString();

                    txtSalutationField.Value = perModel.salutation.ToString();
                    txtFirstName.Value       = perModel.firstName.ToString();
                    txtSurname.Value         = perModel.surname.ToString();
                    txtFullNameNameTag.Value = perModel.fullNameNametag.ToString();
                    txtEmail.Value           = perModel.email.ToString();
                    txtTelephone.Value       = perModel.telNum.ToString();
                    txtOrg1.Value            = perModel.organisation1.ToString();
                    txtDept1.Value           = perModel.department1.ToString();
                    txtDesig1.Value          = perModel.designation1.ToString();
                    txtOrg2.Value            = perModel.organisation2.ToString();
                    txtDept2.Value           = perModel.department2.ToString();
                    txtDesig2.Value          = perModel.designation2.ToString();
                    txtSDR.Value             = perModel.SDR.ToString();
                    ddlRole.SelectedValue    = perModel.role.ToString();
                    ddlSource.SelectedValue  = perModel.source.ToString();
                    ddlCat1.SelectedValue    = perModel.cat1.ToString();
                    ddlCat2.SelectedValue    = perModel.cat2.ToString();
                    ddlList.SelectedValue    = perModel.honorific.ToString();
                    btnSave.Visible          = false;
                    btnUpdate.Attributes.CssStyle.Remove("display");
                    bindTableEdit(CAREP_ORG_ID);
                    if (perModel.role.Equals("F") == false)
                    {
                        if (perModel.emailSent.Equals("Yes"))
                        {
                            chkbxWelcomeEmail.Style.Add("display", "block");
                            chkbxFaciBriefed.Style.Add("display", "none");
                            welcomeEmail.Checked  = true;
                            welcomeEmail.Disabled = true;
                        }
                        else
                        {
                            chkbxWelcomeEmail.Style.Add("display", "block");
                            chkbxFaciBriefed.Style.Add("display", "none");
                            welcomeEmail.Checked  = false;
                            welcomeEmail.Disabled = true;
                        }
                    }
                    else if (perModel.role.Equals("F") == true)
                    {
                        if (perModel.faciBriefed.Equals("Yes"))
                        {
                            chkbxWelcomeEmail.Style.Add("display", "none");
                            chkbxFaciBriefed.Style.Add("display", "block");
                            FacilitatorBriefed.Checked  = true;
                            FacilitatorBriefed.Disabled = true;
                        }
                        else
                        {
                            chkbxWelcomeEmail.Style.Add("display", "none");
                            chkbxFaciBriefed.Style.Add("display", "block");
                            FacilitatorBriefed.Checked  = false;
                            FacilitatorBriefed.Disabled = true;
                        }
                    }
                    else if (perModel.role.Equals(""))
                    {
                    }

                    disableFields(perModel);
                }

                if (Session["ORG_ID"] != null)
                {
                    Session["Person"]     = null;
                    Session["CAREPEDIT"]  = null;
                    Session["CAREPORGID"] = null;
                    string        org_id = Session["ORG_ID"].ToString();
                    PersonModel   p1     = new PersonModel();
                    MembershipDAO dalMem = new MembershipDAO();
                    p1 = dalMem.getOrgInfo(org_id);
                    lblOrgName.InnerText = p1.orgName;

                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "hideToggle();", true);
                }
            }
            else
            {
                //upPanel.Update();
                //string CAREP_ORG_ID = Session["CAREPORGID"].ToString();
                bindtable();
            }
        }
Exemplo n.º 16
0
 public void ActivateMembership(long customerId, MembershipDAO membershipProduct)
 {
     throw new NotImplementedException();
 }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                MembershipDAO d1 = new MembershipDAO();
                DataTable     DT = new DataTable();
                DT = d1.GetLookupSearch("HONOURIFIC");
                ddlList.DataSource     = DT;
                ddlList.DataTextField  = "Code_Desc";
                ddlList.DataValueField = "Code"; //When insert, this value
                ddlList.DataBind();
                ddlList.Items.Insert(0, "");

                modalDDList.DataSource     = DT;
                modalDDList.DataTextField  = "Code_Desc";
                modalDDList.DataValueField = "Code"; //When insert, this value
                modalDDList.DataBind();
                modalDDList.Items.Insert(0, "");

                DT = d1.GetSource();
                ddlSource.DataSource     = DT;
                ddlSource.DataTextField  = "source";
                ddlSource.DataValueField = "source";

                ddlSource.DataBind();
                ddlSource.SelectedValue = "Acad_TT";



                DT = d1.GetCat2();
                ddlCat2.DataSource     = DT;
                ddlCat2.DataTextField  = "Code_Desc";
                ddlCat2.DataValueField = "Code";
                ddlCat2.DataBind();
                ddlCat2.Items.Insert(0, "");

                DT = d1.GetCat1(ddlSource.SelectedValue);
                ddlCat1.DataSource    = DT;
                ddlCat1.DataTextField = "cat_1";
                ddlCat1.DataTextField = "cat_1";
                ddlCat1.DataBind();

                DT = d1.GetNationality();
                ddlNationality.DataSource     = DT;
                ddlNationality.DataTextField  = "NATIONALITY";
                ddlNationality.DataValueField = "NATIONALITY";
                ddlNationality.DataBind();


                if (Session["Person"] != null)
                {
                    //IF Session not null, means page is triggered by the add IA from member Registration page
                    //VALUES SUCCESFULY PASSED
                    Session["IndivEdit"] = null;
                    pList            = (ArrayList)Session["Person"];
                    hiddentext.Value = pList[0].ToString();
                    memRegType       = pList[0].ToString();
                    memRegDonorTier  = pList[1].ToString();
                    memRegExpDate    = pList[2].ToString();
                    AddPA.Disabled   = true;
                    ScriptManager.RegisterStartupScript(Page, GetType(), "script", "hideToggle();", true);
                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "showlblShow();", true);
                }
                if (Session["IndivEdit"] != null)
                {
                    Session["Person"] = null;
                    // IF Session not null means that page is triggered by member management page
                    hiddentextPersonID.Value = Session["IndivEdit"].ToString();
                    MembershipDAO dalMem   = new MembershipDAO();
                    PersonModel   perModel = new PersonModel();
                    hiddentext.Value         = "Individual Associate";
                    perModel                 = dalMem.GetPersonData(hiddentextPersonID.Value.ToString());
                    txtSalutationField.Value = perModel.salutation.ToString();
                    txtFirstName.Value       = perModel.firstName.ToString();
                    txtSurname.Value         = perModel.surname.ToString();
                    txtFullNameNameTag.Value = perModel.fullNameNametag.ToString();
                    txtEmail.Value           = perModel.email.ToString();
                    txtTelephone.Value       = perModel.telNum.ToString();
                    txtOrg1.Value            = perModel.organisation1.ToString();
                    txtDept1.Value           = perModel.department1.ToString();
                    txtDesig1.Value          = perModel.designation1.ToString();
                    txtOrg2.Value            = perModel.organisation2.ToString();
                    txtDept2.Value           = perModel.department2.ToString();
                    txtDesig2.Value          = perModel.designation2.ToString();
                    txtSDR.Value             = perModel.SDR.ToString();
                    ddlList.SelectedValue    = perModel.honorific.ToString();
                    ddlCat2.SelectedValue    = perModel.cat2.ToString();

                    txtSalutationField.Disabled = true;
                    txtFirstName.Disabled       = true;
                    txtSurname.Disabled         = true;
                    txtFullNameNameTag.Disabled = true;
                    txtEmail.Disabled           = true;
                    txtTelephone.Disabled       = true;
                    txtOrg1.Disabled            = true;
                    txtDept1.Disabled           = true;
                    txtDesig1.Disabled          = true;
                    txtOrg2.Disabled            = true;
                    txtDept2.Disabled           = true;
                    txtDesig2.Disabled          = true;
                    txtSDR.Disabled             = true;
                    btnSave.Visible             = false;
                    btnUpdate.Attributes.CssStyle.Remove("display");
                    ddlList.Attributes.Add("disabled", "disabled");
                    ddlNationality.Attributes.Add("disabled", "disabled");
                    ddlSource.Attributes.Add("disabled", "disabled");
                    ddlCat1.Attributes.Add("disabled", "disabled");
                    ddlCat2.Attributes.Add("disabled", "disabled");
                    ddlStatus.Attributes.Add("disabled", "disabled");

                    ScriptManager.RegisterStartupScript(Page, GetType(), "AlertFailureDisplay", "hidelblHidden();", true);


                    if (perModel.gender.Equals("M"))
                    {
                        Male.Checked = true;
                    }
                    else
                    {
                        Female.Checked = true;
                    }
                    if (perModel.status.Equals("Active"))
                    {
                        ddlStatus.SelectedValue = "Active";
                    }
                    else
                    {
                        ddlStatus.SelectedValue = "Retired";
                    }
                    AddPA.Disabled   = true;
                    btnSave.Disabled = true;
                }
            }

            if (IsPostBack)
            {
                //bindtable();
            }
            else
            {
                bindtable();
            }
        }
        /// <summary> Retrieves Entity rows in a datatable which match the specified filter. It will always create a new connection to the database.</summary>
        /// <param name="selectFilter">A predicate or predicate expression which should be used as filter for the entities to retrieve.</param>
        /// <param name="maxNumberOfItemsToReturn"> The maximum number of items to return with this retrieval query.</param>
        /// <param name="sortClauses">The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.</param>
        /// <param name="relations">The set of relations to walk to construct to total query.</param>
        /// <param name="pageNumber">The page number to retrieve.</param>
        /// <param name="pageSize">The page size of the page to retrieve.</param>
        /// <returns>DataTable with the rows requested.</returns>
        public static DataTable GetMultiAsDataTable(IPredicate selectFilter, long maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relations, int pageNumber, int pageSize)
        {
            MembershipDAO dao = DAOFactory.CreateMembershipDAO();

            return(dao.GetMultiAsDataTable(maxNumberOfItemsToReturn, sortClauses, selectFilter, relations, pageNumber, pageSize));
        }