public List <Member_Info> selectallmemberbyteamID(string id) { List <Member_Info> lst = new List <Member_Info>(); Mdao = new Member_DAO(); return(Mdao.selectByTeamID(id)); }
public List <Member_Info> selectallmember() { List <Member_Info> lst = new List <Member_Info>(); Mdao = new Member_DAO(); return(Mdao.SelectAllMember_Info()); }
private void btnSave_Click(object sender, EventArgs e) { try { if (dgvMemberList.Rows.Count > 0) { memberDT = new DataTable(); memberDT.Columns.Add("MemberName"); memberDT.Columns.Add("MemberCode"); memberDT.Columns.Add("Email"); memberDT.Columns.Add("City"); memberDT.Columns.Add("Phone"); memberDT.Columns.Add("Address"); foreach (DataGridViewRow row in dgvMemberList.Rows) { DataRow dr = memberDT.NewRow(); dr["MemberName"] = row.Cells[1].Value.ToString(); dr["MemberCode"] = row.Cells[2].Value.ToString(); dr["Email"] = row.Cells[3].Value.ToString(); dr["City"] = row.Cells[4].Value.ToString(); dr["Phone"] = row.Cells[5].Value.ToString(); dr["Address"] = row.Cells[6].Value.ToString(); memberDT.Rows.Add(dr); dr = null; } if (memberDT.Rows.Count > 0) { if (Member_DAO.SaveNewMember(memberDT) > 0) { MessageBox.Show("Save Successfully.", "Save"); dgvMemberList.DataSource = null; } } } else { MessageBox.Show("No Data found to Save."); } }catch (Exception ex) { MessageBox.Show(ex.Message); } }
//Member Code TextBox Leave private void txtMemberCode_Leave(object sender, EventArgs e) { string code = txtMemberCode.Text.Trim(); //For Member COde try { if (String.IsNullOrEmpty(code)) { if (!code.StartsWith("C")) { code = "C" + code; txtMemberCode.Text = code; } Memberobj = new Member(); Memberobj = Member_DAO.getMemberByCode(code); if (Memberobj != null) { txtMemberName.Text = Memberobj.MemberName; } else { MessageBox.Show("Invalid Member Code"); txtMemberCode.Text = ""; } } else { txtMemberName.Text = ""; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void Insert(Member_Info min) { Mdao = new Member_DAO(); Mdao.MemberInsert(min); }
//Generate Book Code private void GenerateMemberCode() { int Code = Member_DAO.getMemberCount() + dgvMemberList.Rows.Count; txtMemberCode.Text = string.Format("C-" + "{0:00000}", ++Code); }