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); } }