public clsPrescriptionModel GetByPatientId(int selectedPatient) { clsPrescriptionModel result = new clsPrescriptionModel(); DataTable dataTable = new DataTable(); connect = new clsConnectorData(); connect.Link(); connect.con.Open(); connect.cmd.CommandText = clsQuery.GetPrescriptionByPatientId; connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@patient", selectedPatient)); connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd); connect.dta.Fill(dataTable); connect.con.Close(); if (dataTable.Rows.Count > 0) { result = new clsPrescriptionModel() { PrescriptionId = Convert.ToInt32(dataTable.Rows[0][0].ToString()), Advise = dataTable.Rows[0][2].ToString(), Prescription = dataTable.Rows[0][3].ToString() }; } return(result); }
public void Update(int patientId, clsPrescriptionModel prescription) { connect = new clsConnectorData(); connect.Link(); connect.con.Open(); connect.cmd.CommandText = string.Format(clsQuery.UpdatePrescription, patientId); connect.cmd.Parameters.AddWithValue("@advise", prescription.Advise); connect.cmd.Parameters.AddWithValue("@prescription", prescription.Prescription); connect.cmd.ExecuteNonQuery(); connect.con.Close(); }
public void Save(int patientId, clsPrescriptionModel prescription) { connect = new clsConnectorData(); connect.Link(); connect.con.Open(); connect.cmd.CommandText = clsQuery.InsertPrescription; connect.cmd.Parameters.AddWithValue("@pa", patientId); connect.cmd.Parameters.AddWithValue("@advise", prescription.Advise); connect.cmd.Parameters.AddWithValue("@prescription", prescription.Prescription); connect.cmd.ExecuteNonQuery(); connect.con.Close(); }