public PatientObject GetPatient(string PID)
{
IDbConnection connection = null;
PatientObject patientObject = new PatientObject();
var dataReader = DBManager.SetUpDataBase("FinanceSytem").GetDataReader("SSP_GetPatient", System.Data.CommandType.StoredProcedure, new List <IDbDataParameter> {
DBManager.CreateParameter("@PID", PID, DbType.String)
}.ToArray(), out connection);
try
{
while (dataReader.Read())
{
patientObject.ID = (Int64)dataReader["id"];
patientObject.PID = dataReader["pid"].ToString();
patientObject.FirstName = dataReader["first_name"].ToString();
patientObject.LastName = dataReader["last_name"].ToString();
patientObject.MiddleName = dataReader["middle_name"].ToString();
patientObject.DOB = (DateTime)dataReader["dob"];
patientObject.Age = (int)dataReader["age"];
}
}
catch (Exception ex)
{
}
finally
{
dataReader.Close();
connection.Close();
}
//return patientObject;
return(DBManager.SetUpDataBase("FinanceSytem").GetDataTable("SSP_GetPatient", System.Data.CommandType.StoredProcedure, new List <IDbDataParameter> {
DBManager.CreateParameter("@PID", PID, DbType.String)
}.ToArray()).ToList <Patient>().FirstOrDefault().BussinessPatientObject());
}
public async Task <int> InsertPerson(PersonModel person)
{
//List<IDbDataParameter> parameters = new List<IDbDataParameter>();
//foreach (var property in person.GetType().GetProperties())
//{
// parameters.Add(_dBManager.CreateParameter(property.Name,property.GetValue ));
//}
try
{
IDataParameter[] parameters =
{
_dBManager.CreateParameter("@FirstName", person.FirstName, DbType.String),
_dBManager.CreateParameter("@LastName", person.LastName, DbType.String),
_dBManager.CreateParameter("@Email", person.Email == null?"":person.Email, DbType.String),
_dBManager.CreateParameter("@City", person.City.Id, DbType.String)
};
string query = "insert into people(FirstName,LastName,Email,City) values(@FirstName,@LastName,@Email,@City)";
return(await _dBManager.InsertAsync(query, CommandType.Text, parameters));
}
catch (Exception x)
{
return(0);
}
}
