public Models.Patient GetPatientInfo(string firstName, string lastName)
{
string sql = String.Format("SELECT * FROM Patients WHERE FirstName = '{0}' AND LastName = '{1}'",
firstName, lastName);
SqlCommand command = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader reader;
try
{
reader = command.ExecuteReader();
}
catch (Exception e)
{
conn.Close();
throw new FaultException(e.Message);
}
if (reader.HasRows)
{
reader.Read();
Patient result = new Patient()
{
HealthInsuranceNo = reader.GetString(0),
FirstName = reader.GetString(1),
LastName = reader.GetString(2),
PhoneNumber = reader.GetInt32(3),
Address = reader.GetString(4),
Email = reader.GetString(5)
};
reader.Close();
conn.Close();
return result;
}
else
reader.Close();
conn.Close();
return null;
}
public bool PatientRegistration(string healthInsuranceNo, string firstName, string lastName, int phoneNumber, string address, string email)
{
Patient p = new Patient()
{
HealthInsuranceNo = healthInsuranceNo,
FirstName = firstName,
LastName = lastName,
PhoneNumber = phoneNumber,
Address = address,
Email = email
};
string sql = String.Format("INSERT INTO Patients VALUES('{0}', '{1}', '{2}', {3}, '{4}', '{5}')",
p.HealthInsuranceNo, p.FirstName, p.LastName, p.PhoneNumber, p.Address, p.Email);
SqlCommand command = new SqlCommand(sql, conn);
conn.Open();
int num;
try
{
num = command.ExecuteNonQuery();
conn.Close();
}
catch (Exception e)
{
conn.Close();
throw new FaultException(e.Message);
}
if (num > 0)
return true;
else
return false;
}
public Models.Patient GetPatientInfo(string firstName, string lastName)
{
PatientData pData = (from p in db.PatientDatas
where p.FirstName == firstName
&& p.LastName == lastName
select p).FirstOrDefault();
if (pData == null)
{
return null;
}
Patient pModel = new Patient()
{
HealthInsuranceNo = pData.HealthInsuranceNo,
FirstName = pData.FirstName,
LastName = pData.LastName,
PhoneNumber = pData.PhoneNumber,
Address = pData.Address,
Email = pData.Email
};
return pModel;
}