private void dgvSelectBc_Click(object sender, EventArgs e)
{
try
{
if (dgvSelectBc.CurrentRow.Index != -1)
{
model.id = Convert.ToInt32(dgvSelectBc.CurrentRow.Cells["idDataGridViewTextBoxColumn"].Value);
using (MonthlyContributionEntities mc = new MonthlyContributionEntities())
{
model = mc.Bcs.Where(x => x.id == model.id).FirstOrDefault();
labelBcName.Text = model.fullName;
txtTotalAmount.Text = model.totalAmount;
txtStartDate.Text = model.startDate.ToString();
txtEndDate.Text = model.endDate.ToString();
txtDuration.Text = model.duration;
txtMonthlyAmount.Text = model.monthlyContryPerPerson;
}
}
}
catch (NullReferenceException)
{
MessageBox.Show("There Are No Beesi Available");
}
dgvSelectBc.Visible = false;
dgvSelectBc.Visible = false;
}
private void btnAprilSave_Click(object sender, EventArgs e)
{
fourt_mr April = new fourt_mr();
April.memberName = comboBox1.Text.Trim();
April.monthlyAmount = txtMonthlyAmount.Text.Trim();
April.interest = txtInterest.Text.Trim();
April.paidAmount = txtPaidAmount.Text.Trim();
April.collectedAmount = txtCollectAmt.Text.Trim();
April.bcName = labelBcName.Text.Trim();
if (txtInterest.Text == "")
{
MessageBox.Show("Enter The Interest % Amount");
}
else if (txtPaidAmount.Text == "")
{
MessageBox.Show("Enter Paid Amount");
}
else
{
using (MonthlyContributionEntities ma = new MonthlyContributionEntities())
{
ma.fourt_mr.Add(April);
ma.SaveChanges();
MessageBox.Show(" Record Save For" + Environment.NewLine +
" Member: " + comboBox1.Text + Environment.NewLine +
" To Beei Name: " + labelBcName.Text);
}
}
}
private void dgvBeesi_Click_1(object sender, EventArgs e)
{
try
{
if (dgvBeesi.CurrentRow.Index != -1)
{
model.id = Convert.ToInt32(dgvBeesi.CurrentRow.Cells["idDataGridViewTextBoxColumn1"].Value);
using (MonthlyContributionEntities mc = new MonthlyContributionEntities())
{
model = mc.Bcs.Where(x => x.id == model.id).FirstOrDefault();
txtBcName.Text = model.fullName;
txtCountry.Text = model.monthlyContryPerPerson;
txtDuration.Text = model.duration;
txtTotalAmount.Text = model.totalAmount;
txtTotalMember.Text = model.totalAmount;
btnDelete.Enabled = true;
txtCreate.Enabled = false;
}
}
}
catch (NullReferenceException)
{
MessageBox.Show("Beesi Not Available");
}
}
private void dvgMembers_Click(object sender, EventArgs e)
{
try
{
if (dvgMembers.CurrentRow.Index != -1)
{
model.id = Convert.ToInt32(dvgMembers.CurrentRow.Cells["id"].Value);
using (MonthlyContributionEntities mc = new MonthlyContributionEntities())
{
model = mc.Members.Where(x => x.id == model.id).FirstOrDefault();
txtFullName.Text = model.fullName;
txtMobile.Text = model.mobile;
txtEmailId.Text = model.emailId;
txtCity.Text = model.city;
// model.updatedAt = DateTime.Now;
}
btnAdd.Text = "Update";
btnDelete.Enabled = true;
}
}
catch (NullReferenceException)
{
MessageBox.Show("There Are No Member Available");
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtFullName.Text == "" || txtEmailId.Text == "" || txtMobile.Text == "")
{
MessageBox.Show("Fill The Required Fields ");
}
else if (!this.txtEmailId.Text.Contains('@') || !this.txtEmailId.Text.Contains('.'))
{
MessageBox.Show("Enter Wright Email Address");
}
else
{
ReloadForm();
model.fullName = txtFullName.Text.Trim();
model.mobile = txtMobile.Text.Trim();
model.emailId = txtEmailId.Text.Trim();
model.DOB = dateTimePickerDOB.Value;
model.city = txtCity.Text.Trim();
//model.createdAt = DateTime.Now;
using (MonthlyContributionEntities MC = new MonthlyContributionEntities())
{
if (model.id == 0) //for Insert
{
MC.Members.Add(model);
}
else
{
MC.Entry(model).State = EntityState.Modified;//for Update
}
try
{
MC.SaveChanges();
}
catch (DbEntityValidationException c)
{
foreach (var eve in c.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
}
clear();
MessageBox.Show("Submitted Successfully.");
dvg();
}
}
// Button click
private void txtCreate_Click(object sender, EventArgs e)
{
if (txtBcName.Text == "" || txtTotalAmount.Text == "" || txtTotalMember.Text == "") // validation for empty textbox
{
MessageBox.Show("Fill The Required Fields");
}
else
{
model.fullName = txtBcName.Text.Trim();
model.totalAmount = txtTotalAmount.Text.Trim();
model.totalMember = txtTotalMember.Text.Trim();
model.duration = txtDuration.Text.Trim();
model.monthlyContryPerPerson = txtCountry.Text.Trim();
model.startDate = dtpStartdate.Value;
model.endDate = dtpEndDate.Value;
int i = 0;
List <int> ChkedRow = new List <int>();
using (MonthlyContributionEntities mc = new MonthlyContributionEntities())
{
if (model.id == 0)
{
mc.Bcs.Add(model);
}
try // for Entity Exception
{
mc.SaveChanges();
}
catch (DbEntityValidationException c)
{
foreach (var eve in c.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
MessageBox.Show("Beesi Created Succefully.");
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are You Sure to Delete this Record ?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (MonthlyContributionEntities MC = new MonthlyContributionEntities())
{
var entry = MC.Entry(model);
if (entry.State == EntityState.Detached)
{
MC.Members.Attach(model);
MC.Members.Remove(model);
MC.SaveChanges();
clear();
MessageBox.Show("Deleted Successfully");
dvg();
}
}
}
}
private void dgvBcName_Click(object sender, EventArgs e)
{
try
{
if (dgvBcName.CurrentRow.Index != -1)
{
modelb.id = Convert.ToInt32(dgvBcName.CurrentRow.Cells["idDataGridViewTextBoxColumn1"].Value);
using (MonthlyContributionEntities mc = new MonthlyContributionEntities())
{
modelb = mc.Bcs.Where(x => x.id == modelb.id).FirstOrDefault();
txtBcName.Text = modelb.fullName;
}
}
}
catch (NullReferenceException)
{
MessageBox.Show("No Details Available");
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (txtFisrtN.Text == "")
{
MessageBox.Show("Enter First Name");
}
else if (txtUserN.Text == "")
{
MessageBox.Show("Enter User Name");
}
else if (txtPassword.Text == "" || txtconfpass.Text == "")
{
MessageBox.Show("Enter Password");
}
else if (txtPassword.Text != txtconfpass.Text)
{
MessageBox.Show("Password and confirm password not same");
}
else
{
model.FirstName = txtFisrtN.Text.Trim();
model.LastName = txtLastN.Text.Trim();
model.UserName = txtUserN.Text.Trim();
model.Email = txteml.Text.Trim();
model.PhoneNo = txtPhoneN.Text.Trim();
model.Password = txtPassword.Text.Trim();
model.ConfirmPassword = txtconfpass.Text.Trim();
using (MonthlyContributionEntities m = new MonthlyContributionEntities())
{
if (m.Users.Any(o => o.UserName == txtUserN.Text))
{
MessageBox.Show("User Name Alreaady Exists !");
}
else
{
m.Users.Add(model);
m.SaveChanges();
MessageBox.Show("Account Created. ");
clear();
}
}
}
}
private void dgvSeven_Click(object sender, EventArgs e)
{
try{
if (dgvSeven.CurrentRow.Index != -1)
{
m7.id = Convert.ToInt32(dgvSeven.CurrentRow.Cells["sevenId"].Value);
using (MonthlyContributionEntities mc = new MonthlyContributionEntities())
{
m7 = mc.Seven_mR.Where(x => x.id == m7.id).FirstOrDefault();
textBox1.Text = m7.bcName;
btnDelSeven.Enabled = true;
}
}
}
catch (NullReferenceException)
{
MessageBox.Show("There Are no Record Available");
}
}
// delet buttons
private void btnDeleteFirst_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are You Sure to Delete this Record ?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (MonthlyContributionEntities MC = new MonthlyContributionEntities())
{
var entry = MC.Entry(m1);
if (entry.State == EntityState.Detached)
{
MC.First_mR.Attach(m1);
MC.First_mR.Remove(m1);
MC.SaveChanges();
MessageBox.Show("Deleted Successfully");
}
}
}
dgvFirstR.DataSource = mc.First_mR.ToList();
}
private void metroGrid1_Click(object sender, EventArgs e)
{
try
{
if (dgvFourth.CurrentRow.Index != -1)
{
m4.id = Convert.ToInt32(dgvFourth.CurrentRow.Cells["founthId"].Value);
using (MonthlyContributionEntities mc = new MonthlyContributionEntities())
{
m4 = mc.fourt_mr.Where(x => x.id == m4.id).FirstOrDefault();
textBox1.Text = m4.bcName;
btnDelFour.Enabled = true;
}
}
}
catch (NullReferenceException)
{
MessageBox.Show("There Are no Record Available");
}
}
// grid view click
private void dgvFirstR_Click(object sender, EventArgs e)
{
try
{
if (dgvFirstR.CurrentRow.Index != -1)
{
m1.id = Convert.ToInt32(dgvFirstR.CurrentRow.Cells["idDataGridViewTextBoxColumn"].Value);
using (MonthlyContributionEntities mc = new MonthlyContributionEntities())
{
m1 = mc.First_mR.Where(x => x.id == m1.id).FirstOrDefault();
textBox1.Text = m1.bcName;
btnDeleteFirst.Enabled = true;
}
}
}
catch (NullReferenceException)
{
MessageBox.Show("There Are no Record Available");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are You Sure to Delete this Details ?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (MonthlyContributionEntities MC = new MonthlyContributionEntities())
{
var entry = MC.Entry(model);
if (entry.State == EntityState.Detached)
{
MC.Bcs.Attach(model);
MC.Bcs.Remove(model);
MC.SaveChanges();
clear();
MessageBox.Show("Deleted Successfully");
dgvBeesi.DataSource = mc.Bcs.ToList();
}
}
}
btnDelete.Enabled = false;
txtCreate.Enabled = true;
}
private void btnLogin_Click(object sender, EventArgs e)
{
using (MonthlyContributionEntities m = new MonthlyContributionEntities())
{
var user = m.Users.FirstOrDefault(o => o.UserName == txtUserName.Text);
if (user != null)
{
if (user.Password == txtPass.Text)
{
HomePage f1 = new HomePage();
f1.Show();
this.Hide();
}
else
{
MessageBox.Show("Wrong Password");
}
}
else
{
MessageBox.Show("No User found");
}
}
}
public BC_Current()
{
InitializeComponent();
MC = new MonthlyContributionEntities();
}
public MemberForm()
{
InitializeComponent();
MC = new MonthlyContributionEntities();
LoadTheme();
}
// Data Grid View
public void dvg()
{
MC = new MonthlyContributionEntities();
memberBindingSource.DataSource = MC.Members.ToList();
clear();
}
