protected void Page_Load(object sender, EventArgs e) { var pm = Request.QueryString["pm"]; pageMode.Value = pm; EncounterService service = new EncounterService(); if (pm == "edit") { var medId = Request.QueryString["medId"]; mId.Value = medId; medication = service.GetMedication(Convert.ToInt64(medId)); medications.Text = medication.Medicine; dosage.Text = medication.Dosage; var atv = medication.IsActive; radioMedications.Items[0].Selected = atv; radioMedications.Items[1].Selected = !atv; startDate.Text = medication.StartDate == SqlDateTime.MinValue ? string.Empty : medication.StartDate.ToString(Utility.GlobalDateFormat); medicationStop.Text = medication.StopDate == SqlDateTime.MinValue ? string.Empty : medication.StartDate.ToString(Utility.GlobalDateFormat); } else if (pm == "add") { var aId = Request.QueryString["aId"]; asId.Value = aId; } }
public Medication EditMedication(string id, string medication, string isActive, string dosage, string type, string startDate, string stopDate) { List<SqlParameter> sqlParms = new List<SqlParameter>(); CreateMedicationParams(id, medication, isActive, dosage, type, startDate, stopDate, sqlParms); var robj = new Medication(); using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "Encounters_EditMedication", sqlParms.ToArray())) { while (sqlobj.Read()) { robj = GetMedicationData(sqlobj); } } return robj; }
private static Medication GetMedicationData(SqlDataReader sqlobj) { var robj = new Medication(); robj.Id = DBHelper.getInt64(sqlobj, "Id"); robj.AssessmentId = DBHelper.getInt64(sqlobj, "AssessmentId"); robj.Medicine = DBHelper.getString(sqlobj, "Medication"); robj.IsActive = DBHelper.getBool(sqlobj, "IsActive"); robj.Dosage = DBHelper.getString(sqlobj, "Dosage"); robj.Type = DBHelper.getString(sqlobj, "Type"); var sDate = DBHelper.getDateTime(sqlobj, "StartDate"); robj.StartDate = sDate; robj.StopDate = DBHelper.getDateTime(sqlobj, "StopDate"); robj.StartDateString = sDate == SqlDateTime.MinValue ? string.Empty : sDate.ToString(Utility.GlobalDateFormat); return robj; }
public Medication GetMedication(long medicationId) { SqlParameter[] sqlParms = new SqlParameter[]{ new SqlParameter("MedicationId",medicationId) }; var robj = new Medication(); using (SqlDataReader sqlobj = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "Encounters_GetMedication", sqlParms)) { while (sqlobj.Read()) { robj = GetMedicationData(sqlobj); } } return robj; }