public int DeleteUser(string id)
{
userparameters u = new userparameters();
cmd.CommandText = "user_delete";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(u.id, id);
if (con.State != ConnectionState.Open)
{
con.Open();
}
int r = cmd.ExecuteNonQuery();
con.Close();
return(r);
}
public int PutUser(user_manager _u, string _id)
{
userparameters u = new userparameters();
cmd.CommandText = "user_update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(u.id, _id);
cmd.Parameters.AddWithValue(u.email, _u.p_email);
cmd.Parameters.AddWithValue(u.f_name, _u.p_f_name);
cmd.Parameters.AddWithValue(u.l_address, _u.p_l_address);
cmd.Parameters.AddWithValue(u.l_name, _u.p_l_name);
cmd.Parameters.AddWithValue(u.m_name, _u.p_m_name);
cmd.Parameters.AddWithValue(u.p_address, _u.p_p_address);
cmd.Parameters.AddWithValue(u.phone, _u.p_phone);
if (con.State != ConnectionState.Open)
{
con.Open();
}
int r = cmd.ExecuteNonQuery();
con.Close();
return(r);
}