private void btnSearchMember_Click(object sender, EventArgs e)
{
try
{
_db = new AcmDbContext();
var serchTxt = txtBoxMemberSearch.Text;
var member = _db.Members.FirstOrDefault(c => c.MobileNo == serchTxt || c.Name == serchTxt);
if (member == null)
{
MessageBox.Show("Have not any member whth this information! Please input valid information!");
}
else
{
txtBoxMemberName.Text = member.Name;
txtBoxMemberMobileNo.Text = member.MobileNo;
txtBoxDepositAmount.ReadOnly = false;
btnDeposit.Enabled = true;
_memberId = member.Id;
}
}
catch (Exception ex)
{
MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString());
}
}
private void btnWithdraw_Click(object sender, EventArgs e)
{
try
{
if (Convert.ToDouble(txtBoxWithdrawAmount.Text) <= 0 || txtBoxPurpose.Text == "")
{
MessageBox.Show("Input amount value is not a right format");
return;
}
_db = new AcmDbContext();
Withdraw withdraw = new Withdraw();
withdraw.Amount = Convert.ToDecimal(txtBoxWithdrawAmount.Text);
withdraw.WithdrowDateTime = dateTimePickerWithdraw.Value;
withdraw.Purpose = txtBoxPurpose.Text;
if (withdraw.Amount > 0 && withdraw.Purpose != "" && withdraw.WithdrowDateTime != null)
{
_db.Withdraws.Add(withdraw);
_db.SaveChanges();
ClearTextBox();
MessageBox.Show("Successfully withdrawn");
}
else
{
MessageBox.Show("Failed to withdraw!");
}
}
catch (Exception ex)
{
MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString());
}
}
private void btnMemberSearch_Click(object sender, EventArgs e)
{
try
{
_db = new AcmDbContext();
var serchTxt = txtBoxMemberSearch.Text;
var member = _db.DepositMemberLists.Include(d => d.Member).Where(c => c.Member.MobileNo.StartsWith(serchTxt) || c.Member.Name.StartsWith(serchTxt)).ToList();
if (member.Count == 0)
{
MessageBox.Show("Have not any deposit member whth this information! Please input valid information!");
return;
}
dataGridViewDepositMemberList.Refresh();
var srcDepositMember = (from srcMem in member
select new
{
srcMem.MemberId,
Name = srcMem.Member.Name,
MobileNo = srcMem.Member.MobileNo,
JoinDate = srcMem.Member.CreateDateTime,
srcMem.DepositStartDate
}).ToList();
dataGridViewDepositMemberList.DataSource = srcDepositMember;
var dataGridViewColumn = dataGridViewDepositMemberList.Columns["MemberId"];
if (dataGridViewColumn != null)
{
dataGridViewColumn.Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString());
}
}
private void LoadDataGridView()
{
try
{
_db = new AcmDbContext();
List <DepositMemberList> depositMemberList = _db.DepositMemberLists.Include(c => c.Member).ToList();
var dgvList = (from memberList in depositMemberList
select new
{
memberList.MemberId,
Name = memberList.Member.Name,
MobileNo = memberList.Member.MobileNo,
JoinDate = memberList.Member.CreateDateTime,
memberList.DepositStartDate
}).ToList();
dataGridViewDepositMemberList.DataSource = dgvList;
var dataGridViewColumn = dataGridViewDepositMemberList.Columns["MemberId"];
if (dataGridViewColumn != null)
{
dataGridViewColumn.Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString());
}
}
private void btnCreateMember_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtBoxMemberName.Text))
{
MessageBox.Show("Please provide member name!");
return;
}
if (string.IsNullOrEmpty(txtBoxMemberMobileNo.Text))
{
MessageBox.Show("Please provide member mobile no!");
return;
}
_db = new AcmDbContext();
Member member = new Member
{
Name = txtBoxMemberName.Text,
MobileNo = txtBoxMemberMobileNo.Text,
CreateDateTime = DateTime.Now
};
if (member.Name != "" && member.MobileNo != "")
{
_db.Members.Add(member);
_db.SaveChanges();
var feeAmount = Convert.ToDouble(txtBoxDepositFeeAmount.Text);
if (feeAmount > 0 && member.Id > 0)
{
MemberFeeAmount memberFeeAmount = new MemberFeeAmount
{
MemberId = member.Id,
FeeAmount = Convert.ToDouble(txtBoxDepositFeeAmount.Text)
};
_db.MemberFeeAmounts.Add(memberFeeAmount);
_db.SaveChanges();
ClearTextBox();
MessageBox.Show("Member created successfully with fee amount");
}
else
{
ClearTextBox();
MessageBox.Show("Member created successully but fee amount not created");
}
}
else
{
MessageBox.Show("Failed to create member");
}
}
catch (Exception ex)
{
MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString());
}
}
private void GetValueFromEmpId(int id)
{
try
{
_db = new AcmDbContext();
var memberInfo = _db.Members.Find(id);
if (memberInfo != null)
{
txtBoxMemberName.Text = memberInfo.Name;
txtBoxMemberMobileNo.Text = memberInfo.MobileNo;
}
var memberFeeAmount = _db.MemberFeeAmounts.FirstOrDefault(c => c.MemberId == id);
if (memberFeeAmount != null)
{
txtBoxDepositFeeAmount.Text = memberFeeAmount.FeeAmount.ToString(CultureInfo.InvariantCulture);
}
var memberDepositHistory = _db.Deposits.Where(c => c.MemberId == id).ToList();
if (memberDepositHistory.Count > 0)
{
var dgvList = (from depositList in memberDepositHistory
select new
{
depositList.Id,
depositList.Amount,
depositList.DepositDateTime,
}).ToList();
dataGridViewMemberDetails.DataSource = dgvList;
var dataGridViewColumn = dataGridViewMemberDetails.Columns["Id"];
if (dataGridViewColumn != null)
{
dataGridViewColumn.Visible = false;
}
if (memberFeeAmount != null)
{
var totalPay = memberDepositHistory.Sum(s => Convert.ToDecimal(s.Amount));
var amount = memberFeeAmount.FeeAmount;
txtDueAmount.Text = (amount - (double)totalPay).ToString(CultureInfo.InvariantCulture);
txtBoxTotalPay.Text = totalPay.ToString(CultureInfo.InvariantCulture);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString());
}
}
private void btnDeposit_Click(object sender, EventArgs e)
{
try
{
if (Convert.ToDouble(txtBoxDepositAmount.Text) <= 0 || txtBoxDepositAmount.Text == "")
{
MessageBox.Show("Provided amount is not a right value");
return;
}
Deposit deposit = new Deposit();
deposit.MemberId = _memberId;
deposit.Amount = Convert.ToDecimal(txtBoxDepositAmount.Text);
deposit.DepositDateTime = depositDateTimePicker.Value;
if (deposit.Amount > 0 && deposit.MemberId > 0 && deposit.DepositDateTime != null)
{
_db = new AcmDbContext();
_db.Deposits.Add(deposit);
var count = _db.SaveChanges() > 0;
if (count)
{
var depositMemberId = _db.DepositMemberLists.FirstOrDefault(c => c.MemberId == _memberId);
if (depositMemberId == null)
{
DepositMemberList depositMemberList = new DepositMemberList();
depositMemberList.DepositStartDate = DateTime.Now;
depositMemberList.MemberId = _memberId;
_db.DepositMemberLists.Add(depositMemberList);
_db.SaveChanges();
}
}
ClearTextBox();
MessageBox.Show("Deposit successfully saved!");
}
else
{
MessageBox.Show("Fail to save! Please check your input value!");
}
}
catch (Exception ex)
{
MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString());
}
}
private void LoadDataGridView()
{
try
{
_db = new AcmDbContext();
var memberList = _db.Members.ToList();
dataGridViewMemberList.DataSource = memberList;
var dataGridViewColumn = dataGridViewMemberList.Columns["Id"];
if (dataGridViewColumn != null)
{
dataGridViewColumn.Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString());
}
}
private void btnMemberSearch_Click(object sender, EventArgs e)
{
try
{
_db = new AcmDbContext();
var serchTxt = txtBoxMemberSearch.Text;
var member = _db.Members.Where(c => c.MobileNo.StartsWith(serchTxt) || c.Name.StartsWith(serchTxt)).ToList();
if (member.Count == 0)
{
MessageBox.Show("Have not any member whth this information! Please input valid information!");
return;
}
dataGridViewMemberList.Refresh();
dataGridViewMemberList.DataSource = member;
}
catch (Exception ex)
{
MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString());
}
}
private void btnFeeUpdate_Click(object sender, EventArgs e)
{
try
{
if (Convert.ToDouble(txtBoxNewFeeAmount.Text) <= 0 || txtBoxNewFeeAmount.Text == "")
{
MessageBox.Show("New fee amount value is not a right format");
return;
}
_db = new AcmDbContext();
var memberFeeAmount = _db.MemberFeeAmounts.FirstOrDefault(c => c.Id == _updateFeeId);
if (memberFeeAmount != null)
{
memberFeeAmount.FeeAmount = Convert.ToDouble(txtBoxNewFeeAmount.Text);
_db.MemberFeeAmounts.Attach(memberFeeAmount);
_db.Entry(memberFeeAmount).State = EntityState.Modified;
_db.SaveChanges();
ClearTextBox();
MessageBox.Show("Member fee amount updated successfully");
}
if (memberFeeAmount == null)
{
MemberFeeAmount newFeeAmount = new MemberFeeAmount();
newFeeAmount.MemberId = _memberId;
newFeeAmount.FeeAmount = Convert.ToDouble(txtBoxNewFeeAmount.Text);
_db.MemberFeeAmounts.Add(newFeeAmount);
_db.SaveChanges();
ClearTextBox();
MessageBox.Show("Member fee amount added successfully");
}
}
catch (Exception ex)
{
MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString());
}
}
private void btnSearchMember_Click(object sender, EventArgs e)
{
try
{
_db = new AcmDbContext();
var serchTxt = txtBoxMemberSearch.Text;
var member = _db.Members.FirstOrDefault(c => c.MobileNo == serchTxt || c.Name == serchTxt);
if (member == null)
{
MessageBox.Show("Have not any member whth this information! Please input valid information!");
return;
}
txtBoxMemberName.Text = member.Name;
txtBoxMemberMobileNo.Text = member.MobileNo;
_memberId = member.Id;
var feeAmount = _db.MemberFeeAmounts.FirstOrDefault(c => c.MemberId == member.Id);
if (feeAmount != null)
{
txtBoxOldFeeAmount.Text = feeAmount.FeeAmount.ToString(CultureInfo.InvariantCulture);
_updateFeeId = feeAmount.Id;
}
if (feeAmount == null)
{
btnFeeUpdate.Text = "Add";
}
txtBoxNewFeeAmount.ReadOnly = false;
btnFeeUpdate.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString());
}
}
