private void Button2_Click(object sender, EventArgs e)
{
var result = context.Members
.OrderByDescending(m => m.member_ID).First();
int id = int.Parse(result.member_ID);
int newId = id + 1;
string newMemId = "";
if (newId < 10)
{
newMemId = string.Format("00{0}", newId);
}
else if (newId < 100)
{
newMemId = string.Format("0{00}", newId);
}
else
{
newMemId = string.Format("{000}", newId);
}
Member member = new Member();
member.member_ID = newMemId;
member.member_name = textBox1.Text;
member.member_tel = textBox2.Text;
member.member_addr = textBox3.Text;
member.member_picture = ImageToByteArray(pictureBox1.Image);
member.member_birthday = dateTimePicker1.Value.Date;
member.member_date = DateTime.Now.Date;
member.member_user = "";
member.member_pass = "";
member.member_status = 1;
context.Members.Add(member);
int add = context.SaveChanges();
if (add > 0)
{
MessageBox.Show("สมัครสมาชิกเรียบร้อย");
mb.updateDataSource();
this.Close();
}
}
private void Button3_Click(object sender, EventArgs e)
{
mbForm.updateDataSource();
this.Close();
}
