public void populateMembershipFeeStatistic()
{
var member = members[selectedMemberRowIndex];
lblFeePrice.Text = MembershipTypeDAO.getById(member.membership_type_id).fee_price.ToString();
var month = MembershipFeePaymentDAO.getLastPaidMonth(member.member_id);
if (month == 0)
{
lblLastPayedMonth.Text = "/";
}
else
{
lblLastPayedMonth.Text = ((months)month).ToString();
}
lblFeeSummary.Text = MembershipFeePaymentDAO.getNumberOfPaidMembershipFees(member.member_id).ToString();
}
private void ReportMemberFeesLoad()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable("MembershipFee");
dt.Columns.Add("member_id");
dt.Columns.Add("first_name");
dt.Columns.Add("last_name");
dt.Columns.Add("month");
dt.Columns.Add("paying_date");
dt.Columns.Add("issuer_username");
dt.Columns.Add("price");
dt.Columns.Add("category");
ds.Tables.Add(dt);
List <MemberFeeDTO> membershipFees =
MembershipFeePaymentDAO.getMembershipFeePaymentsInDateRange(dateFrom, dateTo);
foreach (var memberFee in membershipFees)
{
DataRow dr = ds.Tables[0].NewRow();
dr["member_id"] = memberFee.member_id;
dr["first_name"] = memberFee.first_name;
dr["last_name"] = memberFee.last_name;
dr["month"] = ((months)memberFee.month).ToString();
dr["paying_date"] = memberFee.payingDate.ToString("dd.MM.yyyy.");
dr["issuer_username"] = memberFee.issuer_user_name;
dr["price"] = memberFee.price;
dr["category"] = memberFee.category;
ds.Tables[0].Rows.Add(dr);
}
rptMembershipFees1.SetDataSource(ds);
rptMembershipFees1.SetParameterValue("pDateFrom", dateFrom.ToString("dd.MM.yyyy."));
rptMembershipFees1.SetParameterValue("pDateTo", dateTo.ToString("dd.MM.yyyy."));
rptMembershipFees1.SetParameterValue("pDatum", DateTime.Now.ToString("dd.MM.yyyy."));
crystalReportViewer.ReportSource = rptMembershipFees1;
crystalReportViewer.Refresh();
}
private void btnSubmitPayment_Click(object sender, EventArgs e)
{
membeship_fee_payment membershipFeePayment = new membeship_fee_payment();
member member = members[selectedMemberRowIndex];
membershipFeePayment.member_id = member.member_id;
//hardcoded
membershipFeePayment.issuer_user_account_id = 1;
Enum.TryParse(comboBoxMonthMembershipFee.Text, out months month);
membershipFeePayment.month = (sbyte)month;
membershipFeePayment.year = short.Parse(comboBoxYearMembershipFee.Text);
membershipFeePayment.is_free_of_charge = checkBoxFreeOfCharge.Checked;
if (checkBoxFreeOfCharge.Checked)
{
membershipFeePayment.price = 0;
}
else
{
membershipFeePayment.price = MembershipTypeDAO.getById(member.membership_type_id).fee_price;
}
membershipFeePayment.is_paid = true;
membershipFeePayment.payment_date = DateTime.Now;
int result = MembershipFeePaymentDAO.insert(membershipFeePayment);
if (result == 1)
{
MessageBox.Show("Uspješno uplaćena članarina za mjesec " + month);
displayMemberInfo(members[selectedMemberRowIndex]);
}
else
{
MessageBox.Show("Došlo je do greške prilikom uplate za mjesec " + month);
}
}
//Set users status and login image depending on user payments history
private void setMemberLoginStatus(member m, out String text, out Image img)
{
//Default values
text = "Neuspješna prijava!";
img = Properties.Resources.loginFAIL;
int forMonth = DateTime.Now.Month;
int forYear = DateTime.Now.Year;
int forDate = DateTime.Now.Day;
//Gdje ide provjera da li clan uopste POSTOJI! KADA BUDE CITAC??
Boolean paidForCurrentMonth = MembershipFeePaymentDAO.isPaidFor(m.member_id, forMonth, forYear);
Boolean CheckedInForCurrentDate = AttendanceDAO.isAlreadyCheckedIn(m.member_id, forDate, forMonth, forYear);
if (!CheckedInForCurrentDate)
{
if (paidForCurrentMonth)
{
if (saveAttendance(m, true))
{
//CheckIn successfull - display infromation and close dialog after x seconds
text = "Uspješna prijava!";
lblWarning.Text = "Plaćena članarina!";
img = Properties.Resources.loginOK;
timer.Start();
}
}
else
{ //Memeber can CheckIn with warning
if (DateTime.Now.Day > 5)
{
if (saveAttendance(m, false))
{
//Login successfull - display warning to pay fee
text = "Uspješna prijava";
lblWarning.Text = "Platiti članarinu!";
img = Properties.Resources.loginWRN;
}
}
else
{
//Members who paid fee for the last month can chekcIn regularly unitl 5th in next month
//Check if it's end of year
if (forMonth == 1)
{
forMonth = 13;
forYear--;
}
Boolean paidForLastMonth = MembershipFeePaymentDAO.isPaidFor(m.member_id, forMonth - 1, forYear);
if (paidForLastMonth)
{
if (saveAttendance(m, true))
{
//Login successfull - display infromation and remark to pay fee current month also
text = "Uspješna prijava";
lblWarning.Text = "Platiti članarinu!";
img = Properties.Resources.loginWRN;
}
}
else
{
if (saveAttendance(m, false))
{
//Login successfull - display warning to pay fee
text = "Uspješna prijava";
lblWarning.Text = "Platiti članarinu!";
img = Properties.Resources.loginWRN;
}
}
}
}
}
else
{
//CheckIn failed - display infromation and warning - member already CheckedIn
text = "Član već prijavljen!";
img = Properties.Resources.loginERR;
}
}
public void displayMemberInfo(member member)
{
panelNoMemberSelected.Hide();
lblAddEducationLevelError.Text = "";
lblFirstNameProfileView.Text = member.first_name;
lblLastNameProfileView.Text = member.last_name;
lblBirthDateProfileView.Text = String.Format("{0:dd.MM.yyyy}", member.birth_date);
lblAddressProfileView.Text = member.address;
lblSexProfileView.Text = member.sex;
lblPhoneNumberProfileView.Text = member.phone_number;
lblEmailProfileView.Text = member.email;
lblRegistrationDateProfileView.Text = String.Format("{0:dd.MM.yyyy}", member.registration_date);
lblMembershipTypeProfileView.Text = MembershipTypeDAO.getById(member.membership_type_id).name;
lblFirstAndLastNameAttendance.Text = member.first_name + " " + member.last_name;
lblFirstAndLastNameMembershipFee.Text = member.first_name + " " + member.last_name;
lblFirstAndLastNameEducation.Text = member.first_name + " " + member.last_name;
lblMeberIdProfileView.Text = member.member_id.ToString();
if (String.IsNullOrEmpty(member.profile_picture))
{
pictureBoxProfilePicture.Image = Properties.Resources.user;
}
else
{
pictureBoxProfilePicture.Image = Image.FromFile(member.profile_picture);
}
var lastAttendance = AttendanceDAO.getLastById(member.member_id);
lblLastAttendance.Text = lastAttendance;
populateCalendar(member.member_id);
//You can pay for the month three days before
var payingMonth = DateTime.Now.AddDays(3).Month;
var payingYear = DateTime.Now.AddDays(3).Year;
comboBoxMonthMembershipFee.SelectedIndex = 0;
comboBoxYearMembershipFee.SelectedIndex = 0;
populateMembershipFeeStatistic();
var memberEducations = MemberEducationDAO.getById(member.member_id);
comboBoxEducationLevel4.Items.Clear();
comboBoxEducationLevel3.Items.Clear();
comboBoxEducationLevel2.Items.Clear();
comboBoxEducationLevel1.Items.Clear();
lblEducationLevelExamDate4.Text = "/";
lblEducationLevelExamDate3.Text = "/";
lblEducationLevelExamDate2.Text = "/";
lblEducationLevelExamDate1.Text = "/";
comboBoxEducationLevel4.Enabled = false;
comboBoxEducationLevel3.Enabled = false;
comboBoxEducationLevel2.Enabled = false;
comboBoxEducationLevel1.Enabled = false;
switch (memberEducations.Count)
{
case 4:
lblEducationLevelExamDate4.Text = memberEducations[3].exam_date.ToString("dd.MM.yyyy.");
comboBoxEducationLevel4.Items.Add(memberEducations[3].commission_member_1);
comboBoxEducationLevel4.Items.Add(memberEducations[3].commission_member_2);
comboBoxEducationLevel4.Items.Add(memberEducations[3].commission_member_3);
comboBoxEducationLevel4.SelectedIndex = 0;
comboBoxEducationLevel4.Enabled = true;
goto case 3;
case 3:
lblEducationLevelExamDate3.Text = memberEducations[2].exam_date.ToString("dd.MM.yyyy.");
comboBoxEducationLevel3.Items.Add(memberEducations[2].commission_member_1);
comboBoxEducationLevel3.Items.Add(memberEducations[2].commission_member_2);
comboBoxEducationLevel3.Items.Add(memberEducations[2].commission_member_3);
comboBoxEducationLevel3.SelectedIndex = 0;
comboBoxEducationLevel3.Enabled = true;
goto case 2;
case 2:
lblEducationLevelExamDate2.Text = memberEducations[1].exam_date.ToString("dd.MM.yyyy.");
comboBoxEducationLevel2.Items.Add(memberEducations[1].commission_member_1);
comboBoxEducationLevel2.Items.Add(memberEducations[1].commission_member_2);
comboBoxEducationLevel2.Items.Add(memberEducations[1].commission_member_3);
comboBoxEducationLevel2.SelectedIndex = 0;
comboBoxEducationLevel2.Enabled = true;
goto case 1;
case 1:
lblEducationLevelExamDate1.Text = memberEducations[0].exam_date.ToString("dd.MM.yyyy.");
comboBoxEducationLevel1.Items.Add(memberEducations[0].commission_member_1);
comboBoxEducationLevel1.Items.Add(memberEducations[0].commission_member_2);
comboBoxEducationLevel1.Items.Add(memberEducations[0].commission_member_3);
comboBoxEducationLevel1.SelectedIndex = 0;
comboBoxEducationLevel1.Enabled = true;
break;
}
int lastPayedMonth = MembershipFeePaymentDAO.getLastPaidMonth(member.member_id);
if (lastPayedMonth == payingMonth)
{
comboBoxMonthMembershipFee.Enabled = false;
comboBoxYearMembershipFee.Enabled = false;
btnSubmitPayment.Enabled = false;
}
else
{
comboBoxMonthMembershipFee.Enabled = true;
comboBoxYearMembershipFee.Enabled = true;
btnSubmitPayment.Enabled = true;
}
}
