public doctor getAccountByPhone(string phone)
{
doctor doc = new doctor();
string connectionString = @"Data Source=cdb.c1lbyzt9l8fn.us-west-2.rds.amazonaws.com,1433;" + "Initial Catalog=cis;" + "User id=sonaaaa;" + "Password=mo7senzzzz;";
SqlConnection myConnection = new SqlConnection(connectionString);
myConnection.Open();
SqlCommand myCommand = new SqlCommand();
myCommand.CommandText = "Select * from doctorAccounts where PNumber = '" + phone + "';";
myCommand.Connection = myConnection;
SqlDataReader reader = myCommand.ExecuteReader();
doc.setID(-1);
if (reader.HasRows)
{
while (reader.Read())
{
doc.setID(reader.GetInt32(reader.GetOrdinal("id")));
doc.setPNumber(Convert.ToString(reader[1]));
doc.setEmail(Convert.ToString(reader[2]));
doc.setPassword(Convert.ToString(reader[3]));
doc.setFname(Convert.ToString(reader[4]));
doc.setLname(Convert.ToString(reader[5]));
doc.setFees(int.Parse(Convert.ToString(reader[6])));
}
}
reader.Close();
myConnection.Close();
return(doc);
}
