private void btnSelect_Click(object sender, EventArgs e)
{
if (radioPrincipal.Checked == true)
{
this.Close();
//Set For Principal
clsMembershipEntry.principal = "1";
MembershipDataEntrycs mementry = new MembershipDataEntrycs();
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(MembershipDataEntrycs))
{
form.Activate();
mementry = (MembershipDataEntrycs)Application.OpenForms["MembershipDataEntrycs"];
mementry.clearAllFields();
mementry.btnEdit.Enabled = false;
mementry.btnNew.Enabled = true;
mementry.btnNew.Text = "SAVE";
mementry.picPicture.Image = mementry.imageList1.Images[0];
mementry.tabControl1.SelectedTab = mementry.tabPage2;
mementry.panel6.Enabled = true;
mementry.dataGridView1.Enabled = true;
//Required fields validation for dependent
//tin sss bank atmno
mementry.txtTINno.BackColor = Color.FromArgb(128, 255, 128);
mementry.txtAccountNo.BackColor = Color.FromArgb(128, 255, 128);
mementry.txtEmail.BackColor = Color.FromArgb(128, 255, 128);
mementry.lblAsteriskEmail.Visible = true;
mementry.lblAsteriskTIN.Visible = true;
mementry.lblAsteriskBank.Visible = true;
mementry.lblAsteriskATMnO.Visible = true;
return;
}
}
mementry.clearAllFields();
mementry.btnEdit.Enabled = false;
mementry.btnNew.Text = "SAVE";
mementry.btnNew.Enabled = true;
mementry.picPicture.Image = mementry.imageList1.Images[0];
mementry.tabControl1.SelectedTab = mementry.tabPage2;
mementry.panel6.Enabled = true;
mementry.dataGridView1.Enabled = true;
//Required fields validation for dependent
//tin sss bank atmno
mementry.txtTINno.BackColor = Color.FromArgb(128, 255, 128);
mementry.txtAccountNo.BackColor = Color.FromArgb(128, 255, 128);
mementry.txtEmail.BackColor = Color.FromArgb(128, 255, 128);
mementry.lblAsteriskEmail.Visible = true;
mementry.lblAsteriskTIN.Visible = true;
mementry.lblAsteriskBank.Visible = true;
mementry.lblAsteriskATMnO.Visible = true;
mementry.Show();
}
else if (radioDependent.Checked == true)
{
this.Close();
//New Window for searching the principal
//controls
//Set For Principal
clsMembershipEntry.principal = "0";
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(MembershipSubForms.subMembershipSearchPrincipal))
{
form.Activate();
return;
}
}
subMembershipSearchPrincipal subSearchPrincipal = new subMembershipSearchPrincipal();
subSearchPrincipal.Show();
}
}
private void button2_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
//No Data to be edit
Alert.show("Please select members you want to edit!", Alert.AlertType.warning);
return;
}
//show form
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(MembershipDataEntrycs))
{
form.Activate();
x = true;
}
else
{
x = false;
}
}
MembershipDataEntrycs mementry = new MembershipDataEntrycs();
mementry.btnEdit.Enabled = true;
mementry.btnNew.Enabled = false;
if (x != true)
{
mementry.Show();
}
MembershipDataEntrycs dataentry = new MembershipDataEntrycs();
dataentry = (MembershipDataEntrycs)Application.OpenForms["MembershipDataEntrycs"];
//get If Principal or not
if (dataGridView1.SelectedRows[0].Cells["Principal"].Value.ToString() == "True")
{
dataentry.panel6.Enabled = true;
dataentry.dataGridView1.Enabled = true;
//Required fields validation for dependent
//tin sss bank atmno
dataentry.txtTINno.BackColor = Color.FromArgb(128, 255, 128);
dataentry.txtAccountNo.BackColor = Color.FromArgb(128, 255, 128);
dataentry.txtEmail.BackColor = Color.FromArgb(128, 255, 128);
dataentry.lblAsteriskEmail.Visible = true;
dataentry.lblAsteriskTIN.Visible = true;
dataentry.lblAsteriskBank.Visible = true;
dataentry.lblAsteriskATMnO.Visible = true;
}
else
{
dataentry.panel6.Enabled = false;
dataentry.dataGridView1.Enabled = false;
//Required fields validation for dependent
//tin sss bank atmno
dataentry.txtTINno.BackColor = SystemColors.Window;
dataentry.txtEmail.BackColor = SystemColors.Window;
dataentry.lblAsteriskEmail.Visible = false;
dataentry.lblAsteriskTIN.Visible = false;
dataentry.dtResignedFromPecci.Enabled = true;
}
dataentry.btnEdit.Enabled = true;
dataentry.btnNew.Enabled = false;
//First Panel (Personal Information)
clsMembershipEntry.userID = dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString();
clsMembershipEntry.principal = dataGridView1.SelectedRows[0].Cells["Principal"].Value.ToString();
dataentry.txtLastName.Text = dataGridView1.SelectedRows[0].Cells["LastName"].Value.ToString();
dataentry.txtFirstName.Text = dataGridView1.SelectedRows[0].Cells["FirstName"].Value.ToString();
dataentry.txtMiddleName.Text = dataGridView1.SelectedRows[0].Cells["MiddleName"].Value.ToString();
dataentry.txtSuffix.Text = dataGridView1.SelectedRows[0].Cells["Suffix"].Value.ToString();
dataentry.txtAddress.Text = dataGridView1.SelectedRows[0].Cells["Residential_Address"].Value.ToString();
dataentry.dtDateOfBirth.Value = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Of_Birth"].Value);
dataentry.cmbGender.Text = dataGridView1.SelectedRows[0].Cells["Gender"].Value.ToString();
dataentry.txtPlaceOfBirth.Text = dataGridView1.SelectedRows[0].Cells["Place_Of_Birth"].Value.ToString();
dataentry.cmbCivilStatus.SelectedItem = dataGridView1.SelectedRows[0].Cells["Civil_Status"].Value.ToString();
dataentry.txtSpouseName.Text = dataGridView1.SelectedRows[0].Cells["Name_Of_Spouse"].Value.ToString();
dataentry.cmbAreaCode.SelectedValue = dataGridView1.SelectedRows[0].Cells["Area_Code"].Value.ToString();
dataentry.txtHomeTel.Text = dataGridView1.SelectedRows[0].Cells["Home_Tel_No"].Value.ToString();
dataentry.txtCellNo.Text = dataGridView1.SelectedRows[0].Cells["Cellphone_No"].Value.ToString();
dataentry.txtTINno.Text = dataGridView1.SelectedRows[0].Cells["TinNo"].Value.ToString();
dataentry.txtSSSNo.Text = dataGridView1.SelectedRows[0].Cells["SSSNo"].Value.ToString();
dataentry.txtEmail.Text = dataGridView1.SelectedRows[0].Cells["Email_Address"].Value.ToString();
dataentry.cmbBankName.Text = clsMembership.returnBankName(dataGridView1.SelectedRows[0].Cells["Bank_Code"].Value.ToString());
dataentry.txtAccountNo.Text = dataGridView1.SelectedRows[0].Cells["Atm_Account_No"].Value.ToString();
dataentry.txtPlacePMS.Text = dataGridView1.SelectedRows[0].Cells["Place_PMS"].Value.ToString();
//For Uploading of members
try
{
dataentry.dtDatePMS.Value = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Of_PMS"].Value);
}
catch
{
}
//Second Panel (Company Information)
dataentry.txtEmployeeIDNo.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
dataentry.cmbCompany.Text = clsMembership.returnCompanyDescription(dataGridView1.SelectedRows[0].Cells["Company_Code"].Value.ToString());
dataentry.cmbPayrollGroup.Text = clsMembership.returnPayrollDescription(dataGridView1.SelectedRows[0].Cells["Payroll_Code"].Value.ToString());
dataentry.cmbCostCenter.Text = clsMembership.returnCostCenter(dataGridView1.SelectedRows[0].Cells["Cost_Center_Code"].Value.ToString());
dataentry.dtDateHired.Value = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Hired"].Value);
dataentry.cmbOfficeArea.SelectedValue = dataGridView1.SelectedRows[0].Cells["Office_Area_Code"].Value.ToString();
dataentry.txtOfficeTelNo.Text = dataGridView1.SelectedRows[0].Cells["Office_Tel_No"].Value.ToString();
dataentry.cmboPrevComp.Text = clsMembership.returnCompanyDescription(dataGridView1.SelectedRows[0].Cells["Prev_Company_Code"].Value.ToString());
if (dataGridView1.SelectedRows[0].Cells["Salary"].Value.ToString() != "")
{
dataentry.txtSalary.Text = Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Salary"].Value).ToString("#,0.00");
}
else
{
dataentry.txtSalary.Text = dataGridView1.SelectedRows[0].Cells["Salary"].Value.ToString();
}
dataentry.txtPrincipalNo.Text = dataGridView1.SelectedRows[0].Cells["PrincipalID"].Value.ToString();
//==================================================================================================
// RESIGN FROM COMPANY
//==================================================================================================
if (dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Company"].Value.ToString() != string.Empty && dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Company"].Value != DBNull.Value)
{
dataentry.dtDateResigned.Text = dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Company"].Value.ToString();
}
else if (dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Company"].Value != DBNull.Value)
{
dataentry.dtDateResigned.Value = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Company"].Value);
}
else
{
dataentry.dtDateResigned.Value = DateTime.Today.Date;
dataentry.dtDateResigned.Checked = false;
}
//==================================================================================================
// RESIGN FROM PECCI
//==================================================================================================
if (dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Pecci"].Value.ToString() != string.Empty && dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Pecci"].Value != DBNull.Value)
{
dataentry.dtResignedFromPecci.Text = dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Pecci"].Value.ToString();
}
else if (dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Pecci"].Value != DBNull.Value)
{
dataentry.dtResignedFromPecci.Value = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Pecci"].Value);
}
else
{
dataentry.dtResignedFromPecci.Value = DateTime.Today.Date;
dataentry.dtResignedFromPecci.Checked = false;
}
//Third Panel (Contact Person)
dataentry.txtContactName.Text = dataGridView1.SelectedRows[0].Cells["Contact_Person"].Value.ToString();
dataentry.txtContactNo1.Text = dataGridView1.SelectedRows[0].Cells["Contact_No1"].Value.ToString();
dataentry.txtContactNo2.Text = dataGridView1.SelectedRows[0].Cells["Contact_No2"].Value.ToString();
dataentry.cmbContactAreaCode.SelectedValue = dataGridView1.SelectedRows[0].Cells["Contact_Area_Code"].Value.ToString();
//Added Feb 17 2019 as per maam vangie
//Relationship and Remarks
dataentry.txtRelationship.Text = dataGridView1.SelectedRows[0].Cells["Relationship"].Value.ToString();
dataentry.txtRemarks.Text = dataGridView1.SelectedRows[0].Cells["Remarks"].Value.ToString();
//Forth Panel (Other Information)
dataentry.dtDateMembership.Value = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Of_Membership"].Value);
try
{
dataentry.dtFirstDeduction.Value = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["First_Deduction"].Value);
}
catch
{
}
//DECIMALS FORMAT
if (dataGridView1.SelectedRows[0].Cells["Membership_Fee"].Value.ToString() != "")
{
dataentry.txtMembershipFee.Text = Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Membership_Fee"].Value).ToString("#,##0.00");
}
else
{
dataentry.txtMembershipFee.Text = dataGridView1.SelectedRows[0].Cells["Membership_Fee"].Value.ToString();
}
if (dataGridView1.SelectedRows[0].Cells["Share_Capital"].Value.ToString() != "")
{
dataentry.txtShareCapital.Text = Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Share_Capital"].Value).ToString("#,##0.00");
}
else
{
dataentry.txtShareCapital.Text = dataGridView1.SelectedRows[0].Cells["Share_Capital"].Value.ToString();
}
if (dataGridView1.SelectedRows[0].Cells["Savings_Deposit"].Value.ToString() != "")
{
dataentry.txtSavingsDeposit.Text = Convert.ToDecimal(dataGridView1.SelectedRows[0].Cells["Savings_Deposit"].Value).ToString("#,##0.00");
}
else
{
dataentry.txtSavingsDeposit.Text = dataGridView1.SelectedRows[0].Cells["Savings_Deposit"].Value.ToString();
}
//For Beneficiaries Panel Principal
if (Convert.ToString(dataGridView1.SelectedRows[0].Cells["PrincipalID"].Value.ToString()) == "")
{
clsMembership.loadBeneficiaries(dataentry.dataGridView1, dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString());
clsMembership.empIDStored = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
}
else
{
//If Dependent remove stored emp id
clsMembership.empIDStored = "";
}
clsMembership.loadPicture(dataGridView1.SelectedRows[0].Cells["userID"].Value.ToString(), dataentry.picPicture);
dataentry = null;
}
private void button2_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
//No Data to be edit
Alert.show("Please select principal!", Alert.AlertType.warning);
return;
}
MembershipDataEntrycs mementry = new MembershipDataEntrycs();
MembershipDataEntrycs dataentry = new MembershipDataEntrycs();
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(MembershipDataEntrycs))
{
//===============================================================================
// If form is already open
//===============================================================================
form.Activate();
mementry = (MembershipDataEntrycs)Application.OpenForms["MembershipDataEntrycs"];
mementry.btnEdit.Enabled = false;
mementry.btnNew.Text = "SAVE";
mementry.picPicture.Image = mementry.imageList1.Images[0];
mementry.panel6.Enabled = false;
mementry.btnNew.Enabled = true;
//clear
mementry.clearAllFieldsFromDependentUsed();
//Move to Company Information
dataentry = (MembershipDataEntrycs)Application.OpenForms["MembershipDataEntrycs"];
//First Panel (Personal Information)
dataentry.txtEmployeeIDNo.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
dataentry.txtPrincipalNo.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
dataentry.cmbCompany.Text = clsmembership.returnCompanyDescription(dataGridView1.SelectedRows[0].Cells["Company_Code"].Value.ToString());
dataentry.cmbPayrollGroup.Text = clsmembership.returnPayrollDescription(dataGridView1.SelectedRows[0].Cells["Payroll_Code"].Value.ToString());
dataentry.cmbCostCenter.Text = clsmembership.returnCostCenter(dataGridView1.SelectedRows[0].Cells["Cost_Center_Code"].Value.ToString());
dataentry.dtDateHired.Value = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Hired"].Value);
dataentry.cmboPrevComp.Text = clsmembership.returnCompanyDescription(dataGridView1.SelectedRows[0].Cells["Prev_Company_Code"].Value.ToString());
//Disable Beneficiary tab
dataentry.dataGridView1.Enabled = false;
dataentry.tabControl1.SelectedTab = dataentry.tabPage2;
this.Close();
//Required fields validation for dependent
//tin sss bank atmno
dataentry.txtTINno.BackColor = SystemColors.Window;
dataentry.txtEmail.BackColor = SystemColors.Window;
dataentry.lblAsteriskEmail.Visible = false;
dataentry.lblAsteriskTIN.Visible = false;
return;
}
}
mementry.Show();
mementry.btnNew.Text = "SAVE";
mementry.btnEdit.Enabled = false;
mementry.panel6.Enabled = false;
//Move to Company Information
dataentry = (MembershipDataEntrycs)Application.OpenForms["MembershipDataEntrycs"];
dataentry.picPicture.Image = dataentry.imageList1.Images[0];
//First Panel (Personal Information)
dataentry.txtEmployeeIDNo.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
dataentry.txtPrincipalNo.Text = dataGridView1.SelectedRows[0].Cells["EmployeeID"].Value.ToString();
dataentry.cmbCompany.Text = clsmembership.returnCompanyDescription(dataGridView1.SelectedRows[0].Cells["Company_Code"].Value.ToString());
dataentry.cmbPayrollGroup.Text = clsmembership.returnPayrollDescription(dataGridView1.SelectedRows[0].Cells["Payroll_Code"].Value.ToString());
dataentry.cmbCostCenter.Text = clsmembership.returnCostCenter(dataGridView1.SelectedRows[0].Cells["Cost_Center_Code"].Value.ToString());
dataentry.dtDateHired.Value = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["Date_Hired"].Value);
dataentry.cmboPrevComp.Text = clsmembership.returnCompanyDescription(dataGridView1.SelectedRows[0].Cells["Prev_Company_Code"].Value.ToString());
dataentry.dtDateResigned.Text = dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Company"].Value.ToString();
dataentry.dtResignedFromPecci.Text = dataGridView1.SelectedRows[0].Cells["Date_Resigned_From_Pecci"].Value.ToString();
//Disable Beneficiary tab
dataentry.dataGridView1.Enabled = false;
dataentry.tabControl1.SelectedTab = dataentry.tabPage2;
//Required fields validation for dependent
//tin sss bank atmno
dataentry.txtTINno.BackColor = SystemColors.Window;
dataentry.txtEmail.BackColor = SystemColors.Window;
dataentry.lblAsteriskEmail.Visible = false;
dataentry.lblAsteriskTIN.Visible = false;
this.Close();
}
