public cls_operations_user select_Profile(string fName)
{
cls_conection obj1 = new cls_conection();
cls_operations_user matchingPerson = new cls_operations_user(0, "", "", "", "", "", "", "");
using (SqlConnection myConnection = new SqlConnection(obj1.getConnection()))
{
string oString = "SELECT * FROM Data_User WHERE FK_ID_user=@fName";
SqlCommand oCmd = new SqlCommand(oString, myConnection);
oCmd.Parameters.AddWithValue("@fname", fName);
myConnection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
//I got problem getting the PRIMARY KEY and the FOREIGN KEY
//matchingPerson.Fk_id_cat = Int32.Parse(oReader["ID_prod"].ToString());
matchingPerson.First_name = oReader["first_name"].ToString();
matchingPerson.Last_name = oReader["last_name"].ToString();
matchingPerson.Number_phone = oReader["number_phone"].ToString();
matchingPerson.Country = oReader["country"].ToString();
matchingPerson.City = oReader["city"].ToString();
matchingPerson.Address = oReader["address"].ToString();
matchingPerson.Zip_code = oReader["zip_code"].ToString();
}
myConnection.Close();
}
}
return(matchingPerson);
}
public cls_operations_user select_Profile1(string fName)
{
cls_conection obj1 = new cls_conection();
cls_operations_user matchingPerson = new cls_operations_user(0, "", "", "", "");
using (SqlConnection myConnection = new SqlConnection(obj1.getConnection()))
{
string oString = "SELECT * FROM Billing_user WHERE FK_ID_user=@fName";
SqlCommand oCmd = new SqlCommand(oString, myConnection);
oCmd.Parameters.AddWithValue("@fname", fName);
myConnection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
//I got problem getting the PRIMARY KEY and the FOREIGN KEY
//matchingPerson.Fk_id_cat = Int32.Parse(oReader["ID_prod"].ToString());
matchingPerson.Number = oReader["number"].ToString();
matchingPerson.type = oReader["type"].ToString();
matchingPerson.Date_end = oReader["date_end"].ToString();
matchingPerson.Code_security = oReader["code_security"].ToString();
}
myConnection.Close();
}
}
return(matchingPerson);
}
