コード例 #1
0
        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());
                }
            }
        }
コード例 #2
0
        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());
                }
            }
        }