private void button1_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(textBox1.Text))
{
try
{
int ID = int.Parse(textBox1.Text);
using (BlogDbContext mc = new BlogDbContext())
{
MembersTbl removeMem = mc.MembersTbls.Where(x => x.ID == ID).FirstOrDefault();
if (removeMem != null)
{
mc.MembersTbls.Remove(removeMem);
mc.SaveChanges();
MessageBox.Show("The member removed successfully.");
}
else
{
MessageBox.Show("Member not found.", "NOT FOUND!");
}
}
this.Close();
}
catch (FormatException)
{
MessageBox.Show("ID must be a number!", "INCORRECT FORMAT!");
}
catch (OverflowException ex)
{
MessageBox.Show(ex.Message, "OVERFLOW!");
}
}
}
private void btn_borrowedB_Click(object sender, EventArgs e)
{
MembersTbl _member = (MembersTbl)dataGridView1.SelectedRows[0].DataBoundItem;
BooksBorrowed Bfrm = new BooksBorrowed(_member.ID);
Bfrm.MdiParent = this.MdiParent;
Bfrm.Show();
}
private void btn_save_Click(object sender, EventArgs e)
{
if (!validDataForm())
{
return;
}
using (BlogDbContext le2 = new BlogDbContext())
{
try
{
if (condition == Condition.Add)
{
MembersTbl mtbl = new MembersTbl()
{
FullName = textBox1.Text,
City = textBox2.Text,
Address = textBox3.Text,
PhoneNumber = Int32.Parse(textBox4.Text),
JoinDate = (DateTime)dateTimePicker1.Value,
ExpiryDate = new DateTime(dateTimePicker1.Value.Year + 1, dateTimePicker1.Value.Month, dateTimePicker1.Value.Day)
};
le2.MembersTbls.Add(mtbl);
le2.SaveChanges();
}
else
{
MembersTbl mtbl = le2.MembersTbls.Where(x => x.ID == this.ID).FirstOrDefault();
if (mtbl != null)
{
mtbl.FullName = textBox1.Text;
mtbl.City = textBox2.Text;
mtbl.Address = textBox3.Text;
mtbl.PhoneNumber = Int32.Parse(textBox4.Text);
mtbl.JoinDate = (DateTime)dateTimePicker1.Value;
mtbl.ExpiryDate = new DateTime(dateTimePicker1.Value.Year + 1, dateTimePicker1.Value.Month, dateTimePicker1.Value.Day);
le2.SaveChanges();
}
}
this.Close();
}
catch (FormatException)
{
MessageBox.Show("For inserting Phone number turn your keyboard Language to English .", "ATTENTION");
}
catch (OverflowException ex)
{
MessageBox.Show(ex.Message, "OVERFLOW!");
}
}
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
MembersTbl _member = (MembersTbl)dataGridView1.SelectedRows[0].DataBoundItem;
Form3 frm3 = new Form3(_member.ID);
frm3.FormClosed += F3_FormClosed;
frm3.Show();
}
catch (ArgumentOutOfRangeException) { }
}
private void setData()
{
using (BlogDbContext mc = new BlogDbContext())
{
MembersTbl member = mc.MembersTbls.Where(x => x.ID == ID).FirstOrDefault();
if (member != null)
{
textBox1.Text = member.FullName;
textBox2.Text = member.City;
textBox3.Text = member.Address;
textBox4.Text = member.PhoneNumber.ToString();
dateTimePicker1.Value = (DateTime)member.JoinDate;
;
mc.SaveChanges();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
using (BlogDbContext mc = new BlogDbContext())
{
int ID = Int32.Parse(txt_ID.Text);
MembersTbl memberList = mc.MembersTbls.Where(x => x.ID == ID).FirstOrDefault();
if (memberList == null)
{
txt_message.Text = "شناسه کاربری نامعتبر است";
return;
}
else if (memberList.ExpiryDate < DateTime.Now)
{
txt_message.Text = "تاریخ عضوبت شما به اتمام رسیده";
}
else
{
BooksBorrowed Bfrm = new BooksBorrowed(ID);
Bfrm.Show();
}
}
}
