protected void bSave_Click(object sender, EventArgs e) { try { if (ValidateClientInfo()) { MemberID = Convert.ToInt32(Session["MemberID"]); int UserID = Convert.ToInt32(Session["UserID"]); DataClients dC = new DataClients(); string dv = dC.InsertCertifiateOfConfirmation(MemberID, 2, txtName.Text, ddSex.SelectedValue, txtParentFatherName.Text , txtParentMotherName.Text, Convert.ToDateTime(txtDOConfirmation.Text), Convert.ToDateTime(txtDOBaptism.Text) , txtPlaceOfConfirmation.Text, txtMinister.Text, txtParishPriest.Text, Convert.ToDateTime(txtDOGiven.Text) , UserID, Convert.ToDateTime(txtDOB.Text)); if (Utilities.IsNumeric(dv) && Convert.ToInt32(dv) == -1) { lblError.Text = "DB Error.<br/>"; } else { ClearCertificate(); } } } catch (Exception ex) { lblError.Text = "Please validate your information.<br/>" + ex.Message + msgError.ToString(); } }
protected void bSave_Click(object sender, EventArgs e) { try { if (ValidateClientInfo()) { MemberID = Convert.ToInt32(Session["MemberID"]); int UserID = Convert.ToInt32(Session["UserID"]); DataClients dC = new DataClients(); string dv = dC.InsertDonation(MemberID, txtAmount.Text, ddDonationType.SelectedIndex, UserID); if (Utilities.IsNumeric(dv) && Convert.ToInt32(dv) == -1) { lblError.Text = "DB Error.<br/>"; } else { GetDonations(); ClearDonation(); //lblError.Text = "Successfully Saved"; //Page.Response.Redirect(Page.ResolveUrl("~/Member.aspx?success=addmember")); } } } catch (Exception ex) { lblError.Text = "Please validate your information.<br/>" + ex.Message + msgError.ToString(); } }
public virtual void Output(object sender, string outData) { object sendie = (sender as IIdeComponent)?.ParentIDE.Machine ?? sender; if (this.InvokeRequired) { if (!DataClients.ContainsKey(sendie)) { DataClients.Add(sendie, DataClients.Count); if (DataClientsColors.Count > DataClients.Count - 1) { DataClientsColors.RemoveAt(DataClients.Count - 1); } DataClientsColors.Insert(DataClients.Count - 1, XGraphics.HSV(55 * (int)DataClients.Count - 1, 80, 100)); } syncContext.Post(new SendOrPostCallback((o) => { if (!this.IsDisposed) { if (!_IsInputing) { if (ParentConsoleDevice.ColorDataClients) { rtbDisplay.SelectionColor = DataClientsColors[(int)DataClients[sendie]]; } _Output(sender, outData); if (ParentConsoleDevice.ColorDataClients) { rtbDisplay.SelectionColor = System.Drawing.Color.White; } } else { if (ParentConsoleDevice.ColorDataClients) { rtbDisplay.SelectionColor = DataClientsColors[(int)DataClients[sendie]]; } rtbDisplay.AppendText(outData); if (ParentConsoleDevice.ColorDataClients) { rtbDisplay.SelectionColor = System.Drawing.Color.White; } _PreText = rtbDisplay.Text; _PreRtf = rtbDisplay.Rtf; } } }), null); // giving console initializer thread time to update UI Thread.Sleep(10); } else { rtbDisplay.SelectionColor = System.Drawing.Color.White; _Output(sender, outData); } }
protected void GetDependentTypes() { DataClients dC = new DataClients(); DataView dv = dC.GetDependentRelationships(); DataTable oDataTable = dv.Table; ddDependentType.DataSource = oDataTable; ddDependentType.DataTextField = "DependentType"; ddDependentType.DataValueField = "DependentRelationshipID"; ddDependentType.DataBind(); ddDependentType.Items.Insert(0, new ListItem("Select one")); }
protected void GetDonations() { if ((Session["MemberID"] != null) && (Utilities.IsNumeric(Session["MemberID"]))) { MemberID = Convert.ToInt32(Session["MemberID"]); DataClients dC = new DataClients(); DataView dv = dC.GetDonationsByMemberID(MemberID); DataTable oDataTable = dv.Table; grdDonations.DataSource = oDataTable; grdDonations.DataBind(); } }
protected void GetCertificateTypes() { DataClients dC = new DataClients(); DataView dv = dC.GetCertificateTypes(); DataTable oDataTable = dv.Table; ddCertificateType.DataSource = oDataTable; ddCertificateType.DataTextField = "CertificateType"; ddCertificateType.DataValueField = "CertificateTypeID"; ddCertificateType.DataBind(); ddCertificateType.Items.Insert(0, new ListItem("Select one")); //} }
protected void GetMaritalStatus() { DataClients dC = new DataClients(); DataView dv = dC.GetMaritalStatus(); DataTable oDataTable = dv.Table; ddMaritalStatus.DataSource = oDataTable; ddMaritalStatus.DataTextField = "maritalText"; ddMaritalStatus.DataValueField = "maritalStatusID"; ddMaritalStatus.DataBind(); ddMaritalStatus.Items.Insert(0, new ListItem("Select one")); // cn.Close(); //} }
protected void GetDonationTypes() { DataClients dC = new DataClients(); DataView dv = dC.GetDonationTypes(); DataTable oDataTable = dv.Table; ddDonationType.DataSource = oDataTable; ddDonationType.DataTextField = "DonationType"; ddDonationType.DataValueField = "DonationTypeID"; ddDonationType.DataBind(); ddDonationType.Items.Insert(0, new ListItem("Select one")); // cn.Close(); //} }
protected void GetSelectedMember() { //if (Utilities.IsNumeric(ddClient.SelectedItem.Value)) //{ // int memberID = Convert.ToInt32(ddClient.SelectedItem.Value); // Session["MemberID"] = ddClient.SelectedItem.Value; // DataClients dC = new DataClients(); // DataView dv = dC.GetMemberByMemberID(memberID); // DataTable oDataTable = dv.Table; // grdSelectedMember.DataSource = oDataTable; // grdSelectedMember.DataBind(); // divSelectedMember.Visible = true; // divClientinfo.Visible = false; //} if ((Session["MemberID"] != null) && (Utilities.IsNumeric(Session["MemberID"]))) { int memberID = Convert.ToInt32(Session["MemberID"]); DataClients dC = new DataClients(); DataView dv = dC.GetMemberByMemberID(memberID); DataTable oDataTable = dv.Table; DataRow dr = oDataTable.Rows[0]; lblmemberName.Text = dr["FirstName"].ToString() + " " + dr["LastName"].ToString(); grdSelectedMember.DataSource = oDataTable; grdSelectedMember.DataBind(); SetDivNotVisible(); divSelectedMember.Visible = true; divSelectedMemberAction.Visible = true; divClientinfo.Visible = false; divMembers.Visible = false; GetDependents(); GetDonations(); GetCertificates(); } else { _memberID = 0; Session["MemberID"] = null; divClientinfo.Visible = false; divSelectedMember.Visible = false; divMembers.Visible = true; } }
protected void GetClientInfo() { DataClients dC = new DataClients(); DataView dv = dC.GetMemberByMemberID(MemberID); DataTable oDataTable = dv.Table; txtFirstName.Text = oDataTable.Rows[0]["firstName"].ToString(); txtLastName.Text = oDataTable.Rows[0]["lastName"].ToString(); if ((oDataTable.Rows[0]["DOB"] != null) && (oDataTable.Rows[0]["DOB"].ToString().Trim() != "")) { DateTime dt = Convert.ToDateTime(oDataTable.Rows[0]["DOB"]); txtDOB.Text = dt.ToString("MM/dd/yyyy"); } ddSex.SelectedValue = oDataTable.Rows[0]["sex"].ToString(); txtNotes.Text = oDataTable.Rows[0]["Notes"].ToString(); txtAddress.Text = oDataTable.Rows[0]["address1"].ToString(); txtCity.Text = oDataTable.Rows[0]["city"].ToString(); txtPostalCode.Text = oDataTable.Rows[0]["postalCode"].ToString(); txtHomePhone.Text = oDataTable.Rows[0]["homePhone"].ToString(); txtCellPhone.Text = oDataTable.Rows[0]["cellPhone"].ToString(); txtPreContact.Text = oDataTable.Rows[0]["preferredMethodContact"].ToString(); ddMaritalStatus.SelectedValue = oDataTable.Rows[0]["MaritalStatusID"].ToString(); ddChurch.SelectedValue = oDataTable.Rows[0]["ChurchID"].ToString(); txtEmail.Text = oDataTable.Rows[0]["email"].ToString(); string strChurchName = oDataTable.Rows[0]["ChurchID"].ToString(); string strFileName = oDataTable.Rows[0]["PhotoFileName"].ToString(); string strFolder = "~/MemberPhoto/" + strChurchName + "/" + strFileName; Image1.ImageUrl = strFolder; if (!string.IsNullOrWhiteSpace(oDataTable.Rows[0]["FamilyBookNumber"].ToString())) { txtFamilyBookNumber.Text = oDataTable.Rows[0]["FamilyBookNumber"].ToString(); txtFamilyBookNumber.Enabled = false; } else { txtFamilyBookNumber.Text = string.Empty; txtFamilyBookNumber.Enabled = true; } if (!string.IsNullOrWhiteSpace(oDataTable.Rows[0]["FreeToMarry"].ToString())) { DateTime dt = Convert.ToDateTime(oDataTable.Rows[0]["FreeToMarry"]); txtFreeToMarry.Text = dt.ToString("MM/dd/yyyy"); } chkActive.Checked = Convert.ToBoolean(oDataTable.Rows[0]["Active"]); }
protected void GetChurches() { if ((Session["UserID"] != null) && (IsNumeric(Session["UserID"]))) { int UserID = Convert.ToInt32(Session["UserID"]); DataClients dC = new DataClients(); DataView dv = dC.GetChurchByUserID(UserID); DataTable oDataTable = dv.Table; ddChurch.DataSource = oDataTable; ddChurch.DataTextField = "ChurchName"; ddChurch.DataValueField = "ChurchID"; ddChurch.DataBind(); ddChurch.Items.Insert(0, new ListItem("Select one")); } // cn.Close(); //} }
protected void GetMembers() { DataClients dC = new DataClients(); DataView dv = dC.GetMembersFirstLastName(); DataTable oDataTable = dv.Table; //ddClient.DataSource = oDataTable; //ddClient.DataTextField = "name"; //ddClient.DataValueField = "MemberID"; //ddClient.DataBind(); //ddClient.Items.Insert(0, new ListItem("Select one")); DataView dvm = dC.GetMembers(txtSearch.Text.Trim()); DataTable oDataTableMembers = dvm.Table; grdMembers.DataSource = oDataTableMembers; grdMembers.DataBind(); //} }
private void SaveMemberImage(int memberID) { try { string strChurchName = ddChurch.SelectedValue; string strFileName = fileMemberPhoto.PostedFile.FileName; string strFileEx = Path.GetExtension(strFileName); strFileName = memberID.ToString() + strFileEx; string strFilePath; string strFolder = "~/MemberPhoto/" + strChurchName + "/"; strFolder = Server.MapPath(strFolder); if (fileMemberPhoto.HasFile) { if (!Directory.Exists(strFolder)) { Directory.CreateDirectory(strFolder); } strFilePath = strFolder + strFileName; if (File.Exists(strFilePath)) { File.Delete(strFilePath); } fileMemberPhoto.PostedFile.SaveAs(strFilePath); } DataClients dC = new DataClients(); int updateValue = dC.UpdateMemberPhoto(MemberID, strFileName); if (updateValue == -1) { lblError.Text = "DB Error.<br/>"; } else if (updateValue == -2) { lblError.Text = "Family book number exist in the system.<br/>"; } } catch (Exception ex) { lblError.Text = "Please contact admin, uploading image has an issue.<br/>" + ex.Message + msgError.ToString(); } }
// // // #region Thread-safe wrapping public virtual void Input(object sender, out string inData, int length) { object sendie = (sender as IIdeComponent)?.ParentIDE.Machine ?? sender; if (this.InvokeRequired) { if (!DataClients.ContainsKey(sendie)) { DataClients.Add(sendie, DataClients.Count); if (DataClientsColors.Count > DataClients.Count - 1) { DataClientsColors.RemoveAt(DataClients.Count - 1); } DataClientsColors.Insert(DataClients.Count - 1, XGraphics.HSV(55 * (int)DataClients.Count - 1, 80, 100)); } object objInData = ""; if (!DataClients.ContainsKey(sendie)) { DataClients.Add(sendie, DataClients.Count); } this.Invoke(new Action <System.Drawing.Color>((c) => { rtbDisplay.SelectionColor = c; }) , DataClientsColors[(int)DataClients[sendie]]); var d = new Func <object, int, string>(_Input); objInData = this.Invoke(d, sender, length); inData = (string)objInData; if (!this.IsDisposed) { this.Invoke(new Action <System.Drawing.Color>((c) => { rtbDisplay.SelectionColor = c; }), Color.White); } } else { rtbDisplay.SelectionColor = System.Drawing.Color.White; inData = _Input(sender, length); } }
protected void bSave_Click(object sender, EventArgs e) { try { lblError.ForeColor = System.Drawing.Color.Red; if (ValidateClientInfo()) { MemberID = Convert.ToInt32(Session["MemberID"]); int UserID = Convert.ToInt32(Session["UserID"]); DataClients dC = new DataClients(); string dv = dC.InsertCertifiateOfMarriage(MemberID, 4, txtNameOfGroom.Text, txtNameOfBride.Text, txtGroomFatherName.Text , txtGroomMotherName.Text, txtBrideFatherName.Text, txtBrideMotherName.Text, Convert.ToDateTime(txtDOMarriage.Text) , txtWitness1.Text , txtWitness2.Text, txtSigned.Text, txtParishPriest.Text, txtGivenPlace.Text, Convert.ToDateTime(txtDOGivenOnDate.Text) , UserID, Convert.ToDateTime(txtBridegroomDOB.Text), Convert.ToDateTime(txtBrideDOB)); if (Utilities.IsNumeric(dv) && Convert.ToInt32(dv) == -1) { lblError.Text = "DB Error.<br/>"; } else { ClearCertificate(); lblError.Text = "Success: The confirmation certificate added to the system."; lblError.ForeColor = System.Drawing.Color.Green; } } else { lblError.Text = msgError.ToString(); } } catch (Exception ex) { lblError.Text = "Please validate your information.<br/>" + ex.Message + msgError.ToString(); } }
protected void bSave_Click(object sender, EventArgs e) { try { lblError.ForeColor = System.Drawing.Color.Red; if (ValidateClientInfo()) { MemberID = Convert.ToInt32(Session["MemberID"]); int UserID = Convert.ToInt32(Session["UserID"]); DataClients dC = new DataClients(); string dv = dC.InsertCertifiateOfBaptism(MemberID, 1, txtName.Text, ddSex.SelectedValue, txtParentFatherName.Text , txtParentMotherName.Text, Convert.ToDateTime(txtDOB.Text), Convert.ToDateTime(txtDOBaptism.Text), txtSponsor1.Text , txtSponsor2.Text, txtMinister.Text, null, null, Convert.ToDateTime(txtDOGiven.Text) , txtParishPriest.Text, UserID); if (Utilities.IsNumeric(dv) && Convert.ToInt32(dv) == -1) { lblError.Text = "DB Error.<br/>"; } else { ClearCertificate(); lblError.Text = "Success: The confirmation certificate added to the system."; lblError.ForeColor = System.Drawing.Color.Green; } } else { lblError.Text = msgError.ToString(); } } catch (Exception ex) { lblError.Text = "Please validate your information.<br/>" + ex.Message + msgError.ToString(); } }
protected void bSave_Click(object sender, EventArgs e) { try { lblError.ForeColor = System.Drawing.Color.Red; if (ValidateClientInfo()) { MemberID = Convert.ToInt32(Session["MemberID"]); int UserID = Convert.ToInt32(Session["UserID"]); DataClients dC = new DataClients(); string dv = dC.InsertCertifiateOfDeath(MemberID, 3, txtName.Text, ddSex.SelectedValue, Convert.ToInt32(txtAge.Text) , txtAddress.Text, Convert.ToDateTime(txtDODeath.Text), Convert.ToDateTime(txtDOBurial.Text), txtPlaceOfBurial.Text , Convert.ToDateTime(txtDOGiven.Text), txtParishPriest.Text, UserID, txtDeed.Text, Convert.ToDateTime(txtDOB.Text)); if (Utilities.IsNumeric(dv) && Convert.ToInt32(dv) == -1) { lblError.Text = "DB Error.<br/>"; } else { ClearCertificate(); lblError.Text = "Success: The death certificate added to the system."; lblError.ForeColor = System.Drawing.Color.Green; } } else { lblError.Text = msgError.ToString(); } } catch (Exception ex) { lblError.Text = "Please validate your information.<br/>" + ex.Message + msgError.ToString(); } }
protected void bSave_Click(object sender, EventArgs e) { try { if (ValidateClientInfo()) { DateTime?FreeToMarry = null; //int? FamilyBookNumber = null; if (!string.IsNullOrWhiteSpace(txtFreeToMarry.Text.Trim())) { FreeToMarry = Convert.ToDateTime(txtFreeToMarry.Text); } //if (!string.IsNullOrWhiteSpace(txtFamilyBookNumber.Text.Trim())) //{ // FamilyBookNumber = Convert.ToInt32(txtFamilyBookNumber.Text); //} int churchID = Convert.ToInt32(ddChurch.SelectedValue); if ((Session["MemberID"] != null) && (IsNumeric(Session["MemberID"]))) { MemberID = Convert.ToInt32(Session["MemberID"]); DataClients dC = new DataClients(); int updateValue = dC.UpdateMember(MemberID, txtFirstName.Text, txtLastName.Text, Convert.ToDateTime(txtDOB.Text), ddSex.SelectedValue, txtNotes.Text, txtAddress.Text, txtCity.Text, txtPostalCode.Text, txtHomePhone.Text, txtCellPhone.Text, txtPreContact.Text, ddMaritalStatus.SelectedIndex, txtEmail.Text, txtFamilyBookNumber.Text, chkActive.Checked, FreeToMarry, churchID); if (updateValue == -1) { lblError.Text = "DB Error.<br/>"; } else if (updateValue == -2) { lblError.Text = "Family book number exist in the system.<br/>"; } else { SaveMemberImage(MemberID); Page.Response.Redirect(Page.ResolveUrl("~/Member.aspx?success=addmember")); } } else if (bSave.Text == "Save" && Session["MemberID"] == null) { DataClients dC = new DataClients(); string dv = dC.InsertMember(txtFirstName.Text, txtLastName.Text, Convert.ToDateTime(txtDOB.Text), ddSex.SelectedValue, txtNotes.Text, txtAddress.Text, txtCity.Text, txtPostalCode.Text, txtHomePhone.Text, txtCellPhone.Text, txtPreContact.Text, ddMaritalStatus.SelectedIndex, txtEmail.Text, txtFamilyBookNumber.Text, chkActive.Checked, FreeToMarry, churchID); if (IsNumeric(dv) && Convert.ToInt32(dv) == -1) { lblError.Text = "DB Error.<br/>"; } else if (IsNumeric(dv) && Convert.ToInt32(dv) == -2) { lblError.Text = "Family book number exist in the system.<br/>"; } else { //lblError.Text = "Successfully Saved"; SaveMemberImage(Convert.ToInt32(dv)); Page.Response.Redirect(Page.ResolveUrl("~/Member.aspx?success=addmember")); } } } else { lblError.Text = "Please validate your information.<br/>" + msgError.ToString(); } } catch (Exception ex) { lblError.Text = "Please validate your information.<br/>" + ex.Message + msgError.ToString(); } }