public bool updateOtherMembers(AreobicMember arem) { bool temp = false; DataLayer.dbConnect con = new DataLayer.dbConnect(); con.openConnection(); SqlTransaction trn = con.getConnection().BeginTransaction(); try { //qery one string q1 = "update tbl_member set name=@name, dob=@dob,address=@address,nic=@nic,gender=@gender,phone=@phone where regNo=@regNo"; SqlCommand cmd1 = new SqlCommand(q1, con.getConnection()); cmd1.Parameters.AddWithValue("@regNo", arem.MemberID); cmd1.Parameters.AddWithValue("@name", arem.name); cmd1.Parameters.AddWithValue("@dob", arem.dob); cmd1.Parameters.AddWithValue("@address", arem.addresss); cmd1.Parameters.AddWithValue("@nic", arem.nic); cmd1.Parameters.AddWithValue("@gender", arem.gender); cmd1.Parameters.AddWithValue("@phone", arem.phone); cmd1.Transaction = trn; cmd1.ExecuteNonQuery(); //qery two string q2 = "update tbl_areobic_member set service_type=@st where memberID=@regNo"; SqlCommand cmd2 = new SqlCommand(q2, con.getConnection()); cmd2.Parameters.AddWithValue("@regNo", arem.MemberID); cmd2.Parameters.AddWithValue("@st", arem.service_type); cmd2.Transaction = trn; cmd2.ExecuteNonQuery(); trn.Commit(); con.closeConnection(); temp = true; } catch (Exception dd) { trn.Rollback(); throw; } if (temp == true) { return(true); } else { return(false); } }
public bool searchAerobicMemOnly(int memID, string name, string nic, AreobicMember arm) { DataLayer.dbConnect con = new DataLayer.dbConnect(); con.openConnection(); bool temp = false; try { string q1 = "select * from veiw_areobicMember where memberID=@regNo or nic=@nic or name=@name"; SqlCommand cmd1 = new SqlCommand(q1, con.getConnection()); cmd1.Parameters.AddWithValue("@regNo", memID); cmd1.Parameters.AddWithValue("@nic", nic); cmd1.Parameters.AddWithValue("@name", name); SqlDataAdapter da1 = new SqlDataAdapter(cmd1); DataTable dt1 = new DataTable(); da1.Fill(dt1); if (dt1.Rows.Count > 0) { arm.MemberID = int.Parse(dt1.Rows[0]["memberID"].ToString()); arm.name = dt1.Rows[0]["name"].ToString(); arm.nic = dt1.Rows[0]["nic"].ToString(); arm.dob = dt1.Rows[0]["dob"].ToString(); arm.gender = dt1.Rows[0]["gender"].ToString(); arm.addresss = dt1.Rows[0]["address"].ToString(); arm.phone = dt1.Rows[0]["phone"].ToString(); arm.service_type = dt1.Rows[0]["service_type"].ToString(); temp = true; } } catch (Exception df) { throw; } if (temp == true) { return(true); } else { return(false); } }