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