public static void saveVisit(Visit visit) { if (visit.VisitType == "1") { saveMonthlyCareVisit(visit); } }
private static void saveMonthlyCareVisit(Visit visit) { CareVisit mcv = (CareVisit)visit; string query; if (!visitIdExist(mcv.VisitId)) { query = string.Format("insert into monthly_care_visit values( {0},{1},'{2}','{3}','{4}','{5}',{6},{7},'{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}',{18},{19},{20},'{21}',{22},'{23}',{24},{25},{26},'{27}','{28}',{29})", mcv.PatientId, mcv.VisitId, formartDateForMySQL(mcv.VisitDate), parseString(mcv.ClinicalFindings), parseString(mcv.Treatment), parseString(mcv.Remarks), mcv.UserId, mcv.SiteId, parseable(mcv.ReceivedPainManagement), parseable(mcv.ConfirmedHivStatus), parseable(mcv.IsOnART), parseable(mcv.IsAdhering), parseable(mcv.ReceivedSupplement), parseString(mcv.NameOfReceivedSupplement), parseable(mcv.DischargeOrTranfer), parseString(mcv.TransferedTo), parseable(mcv.ReceivedCounselling), parseable(mcv.TBStatus), mcv.IsOnDOTS, mcv.IsAdhereToDOTS, mcv.PainManagementLevel, parseable(mcv.ReferPainManagement), mcv.HasDied, formartDateForMySQL(mcv.DateDied), mcv.IsOtherDisease, mcv.HasTBCounselling, mcv.AdhereingToTBCounselling, parseable(mcv.OtherDiseaseDetails), mcv.OnARTStatus, mcv.ReceivedAdheranceCounselling); } else { query = string.Format(@"UPDATE monthly_care_visit SET patientId = {0}, visitId = {1}, visit_date = '{2}', clinical_findings = '{3}', treatment = '{4}', remarks = '{5}', userId = {6}, siteid = {7}, receivedpainmanagement = '{8}', confirmedhivstatus = '{9}', isOnArt = '{10}', isAdheringtoART = '{11}', receivedSupplement = '{12}', nameOfSupplement = '{13}', dischargeortransfer = '{14}', transferedTo = '{15}', receivedHIVCounselling = '{16}', isTBPositive = '{17}', isOnDOTS = {18}, AdhereToDOTS = {19}, painManagementLevel = {20}, referPainManagement = '{21}', hasDied = {22}, dateDied = '{23}', IsOtherDisease = {24}, hasTBCounselling = {25}, adhereingToTBCounselling = {26}, OtherDiseaseDetails = '{27}', OnARTStatus = '{28}', adherancetoHIVCounselling = {29} where visitId = {1}", mcv.PatientId, mcv.VisitId, formartDateForMySQL(mcv.VisitDate), parseString(mcv.ClinicalFindings), parseString(mcv.Treatment), parseString(mcv.Remarks), mcv.UserId, mcv.SiteId, parseable(mcv.ReceivedPainManagement), parseable(mcv.ConfirmedHivStatus), parseable(mcv.IsOnART), parseable(mcv.IsAdhering), parseable(mcv.ReceivedSupplement), parseString(mcv.NameOfReceivedSupplement), parseable(mcv.DischargeOrTranfer), parseString(mcv.TransferedTo), parseable(mcv.ReceivedCounselling), parseable(mcv.TBStatus), mcv.IsOnDOTS, mcv.IsAdhereToDOTS, mcv.PainManagementLevel, parseable(mcv.ReferPainManagement), mcv.HasDied, formartDateForMySQL(mcv.DateDied), mcv.IsOtherDisease, mcv.HasTBCounselling, mcv.AdhereingToTBCounselling, parseable(mcv.OtherDiseaseDetails), mcv.OnARTStatus, mcv.ReceivedAdheranceCounselling); /* mcv.PatientId, mcv.VisitId, formartDateForMySQL(mcv.VisitDate), parseString(mcv.ClinicalFindings),parseString(mcv.Treatment), parseString(mcv.Remarks), mcv.UserId, mcv.SiteId, parseable(mcv.ReceivedPainManagement), parseable(mcv.ConfirmedHivStatus), parseable(mcv.IsOnART), parseable(mcv.IsAdhering), parseable(mcv.ReceivedSupplement), parseString(mcv.NameOfReceivedSupplement), parseable(mcv.DischargeOrTranfer), parseString(mcv.TransferedTo), parseable(mcv.ReceivedCounselling), mcv.PainManagementLevel, parseable(mcv.ReferPainManagement), mcv.HasDied, formartDateForMySQL(mcv.DateDied), mcv.ReceivedAdheranceCounselling);*/ } db.runNonQuery(query); }
public static Visit[] LoadVisits(String patientId) { Visit[] visit = new Visit[1]; return visit; }