public string RegisterANewPatient(NewPatient newPatient)
{
using (MySqlConnection db = new MySqlConnection(ConfigurationValues.GroveHillConnection))
{
newPatient.UniqueID = Guid.NewGuid().ToString();
try
{
const string query = "insert into patientswhoregister(UniqueID,FirstName,LastName,Email,CellPhone,DateofBirth,DateCreated,View)"
+ " values(@UniqueID,@FirstName,@LastName,@Email,@CellPhone,@DateofBirth,@DateCreated,@View)";
int rowsAffectd = db.Execute(query, new
{
@UniqueID = newPatient.UniqueID,
@FirstName = newPatient.FirstName,
@LastName = newPatient.LastName,
@Email = newPatient.Email,
@CellPhone = newPatient.CellPhone,
@DateofBirth = newPatient.DateOfBirth,
@DateCreated = DateTime.Now,
@View = "T"
});
int r = 5;
Patient patients = GetPreRegistrationPatientInformationFromEmail(newPatient.Email);
return patients.UniqueID;
}
catch (Exception er)
{
string s1 = er.ToString();
return string.Empty;
//Log.LogMessage(er.ToString());
}
}
}
public void CreateNewPatient(NewPatient newPatient)
{
using (MySqlConnection db = new MySqlConnection(ConfigurationValues.GroveHillConnection))
{
newPatient.UniqueID = Guid.NewGuid().ToString();
try
{
const string query = "insert into patients(UniqueID,FirstName,LastName,CellPhone,Email)"
+ " values(@UniqueID,@FirstName,@LastName,@CellPhone,@Email)";
int rowsAffectd = db.Execute(query, new
{
@UniqueID = newPatient.UniqueID,
@FirstName = newPatient.FirstName,
@LastName = newPatient.LastName,
@CellPhone = newPatient.CellPhone,
@Email = newPatient.Email
});
int r = 5;
}
catch (Exception er)
{
string s1 = er.ToString();
//Log.LogMessage(er.ToString());
}
}
}