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);
}
