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