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); } } }
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; } } }
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(); }
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); } }
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(); } }
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 { } }
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); } }
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); } } }
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(); } }
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)); }