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