public member1 Getmember(int memberId) { MemberBroker mb = new MemberBroker(); member1 mem = mb.GetMember(memberId); return(mem); }
public member1 GetMember(int MemberId) { SqlParameter pMemberId = new SqlParameter("@MemberId", SqlDbType.Int); cmSelbyPK.Parameters.Add(pMemberId); pMemberId.Value = MemberId; member1 mem = new member1(); cn.Open(); SqlDataReader dr = cmSelbyPK.ExecuteReader(); if (dr.Read()) { mem.MemberId = Convert.ToInt32(dr["MemberId"]); mem.MemberName = (dr["MemberName"]).ToString(); mem.Address1 = (dr["Address1"]).ToString(); mem.Phone = (dr["Phone"]).ToString(); mem.DateOfBirth = (dr["DateOfBirth"].ToString()); mem.Gender = (dr["Gender"]).ToString(); } else { } cn.Close(); return(mem); }
private void button2_Click(object sender, EventArgs e) { memberController mc = new memberController(); if (this.textBox1.Text == Convert.ToString(mc.GetAllmember().Count() + 1)) { member1 newmember = new member1(); newmember.MemberId = Convert.ToInt32(this.textBox1.Text); newmember.MemberName = this.textBox2.Text; string G = ""; if (this.radioButton1.Checked) { G = "M"; } else { G = "F"; } newmember.Gender = G; newmember.DateOfBirth = this.dateTimePicker1.Value.Date.ToString(); newmember.Address1 = this.textBox3.Text; newmember.Phone = this.textBox4.Text; mc.Addmember(newmember); MessageBox.Show("saved"); button1_Click(null, null); } else { member1 a = mc.Getmember(Convert.ToInt32(this.textBox1.Text)); a.MemberName = this.textBox2.Text; string G = ""; if (this.radioButton1.Checked) { G = "M"; } else { G = "F"; } a.Gender = G; a.DateOfBirth = this.dateTimePicker1.Value.Date.ToString(); a.Address1 = this.textBox3.Text; a.Phone = this.textBox4.Text; mc.ModifymemberInfo(a); MessageBox.Show("update successfully"); button1_Click(null, null); } }
public void insert(member1 mem) { SqlParameter pMemberId = new SqlParameter("@MemberId", SqlDbType.Int); SqlParameter pMemberName = new SqlParameter("@MemberName", SqlDbType.VarChar, 50); SqlParameter pAddress1 = new SqlParameter("@Address1", SqlDbType.VarChar, 100); SqlParameter pPhone = new SqlParameter("@Phone", SqlDbType.VarChar, 50); SqlParameter pDateOfBirth = new SqlParameter("@DateOfBirth", SqlDbType.VarChar, 100); SqlParameter pGender = new SqlParameter("@Gender", SqlDbType.VarChar, 1); cmInsert.Parameters.AddRange(new SqlParameter[] { pMemberId, pMemberName, pAddress1, pPhone, pDateOfBirth, pGender }); pMemberId.Value = mem.MemberId; pMemberName.Value = mem.MemberName; pAddress1.Value = mem.Address1; pPhone.Value = mem.Phone; pDateOfBirth.Value = mem.DateOfBirth; pGender.Value = mem.Gender; cn.Open(); cmInsert.ExecuteNonQuery(); cn.Close(); }
public List <member1> GetAllMember() { cn.Open(); SqlDataReader dr = cmSelAll.ExecuteReader(); List <member1> memlist = new List <member1>(); while (dr.Read()) { member1 mem = new member1(); mem.MemberId = Convert.ToInt32(dr["MemberId"]); mem.MemberName = (dr["MemberName"]).ToString(); mem.Address1 = (dr["Address1"]).ToString(); mem.Phone = (dr["Phone"]).ToString(); mem.DateOfBirth = (dr["DateOfBirth"].ToString()); mem.Gender = (dr["Gender"]).ToString(); memlist.Add(mem); } cn.Close(); return(memlist); }
public void Addmember(member1 mem) { MemberBroker mb = new MemberBroker(); mb.insert(mem); }
public void ModifymemberInfo(member1 mem) { MemberBroker mb = new MemberBroker(); mb.update(mem); }