public int ModifyComorbidity(Comorbidity objc)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@ComorbidityID", objc.ComorbidityID),
new SqlParameter("@CustomerID", objc.CustomerID),
new SqlParameter("@Hypertension", objc.Hypertension),
new SqlParameter("@Diabetes", objc.Diabetes),
new SqlParameter("@CHF", objc.CHF),
new SqlParameter("@Asthma", objc.Asthma),
new SqlParameter("@IHD", objc.IHD),
new SqlParameter("@Thyroid", objc.Thyroid),
new SqlParameter("@ThyroidType", objc.ThyroidType),
new SqlParameter("@SleepApnea", objc.SleepApnea),
new SqlParameter("@FunctionalStatus", objc.FunctionalStatus),
new SqlParameter("@ComorbidityOthers", objc.ComorbidityOthers),
new SqlParameter("@ComorbidityNotes", objc.ComorbidityNotes),
new SqlParameter("@CardiacDisorders", objc.CardiacDisorders),
new SqlParameter("@KidneyDisorders", objc.CardiacDisorders),
new SqlParameter("@LeverDisorders", objc.LeverDisorders),
new SqlParameter("@FollowedParticularDietForProb", objc.FollowedParticularDietForProb),
new SqlParameter("@ReturnVal", SqlDbType.Int)
};
return(DBOperate.ExecuteProcedure("usp_ModifyComorbidity", parameter));
}
catch
{
throw;
}
}
public int ModifyClinicalComplaints(ClinicalComplaints obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
//new SqlParameter("@ChronicDiseaseID",obj.ChronicDiseaseID),
new SqlParameter("@CustomerID", obj.CustomerID),
//new SqlParameter("@DiabetesChronDis",obj.DiabetesChronDis),
//new SqlParameter("@HypertensionChronDis",obj.HypertensionChronDis),
//new SqlParameter("@CardiacDisorders",obj.CardiacDisorders),
//new SqlParameter("@KidneyDisorders",obj.CardiacDisorders),
//new SqlParameter("@LeverDisorders",obj.LeverDisorders),
//new SqlParameter("@OtherChronicDiseases",obj.OtherChronicDiseases),
//new SqlParameter("@FollowedParticularDietForProb",obj.FollowedParticularDietForProb),
new SqlParameter("@GastProbID", obj.GastProbID),
new SqlParameter("@Heartburn", obj.Heartburn),
new SqlParameter("@Bloating", obj.Bloating),
new SqlParameter("@Gas", obj.Gas),
new SqlParameter("@Diarrhoea", obj.Diarrhoea),
new SqlParameter("@Vomiting", obj.Vomiting),
new SqlParameter("@Constipation", obj.Constipation),
new SqlParameter("@LaxativeAntacide", obj.LaxativeAntacide),
new SqlParameter("@HomeRemedy", obj.HomeRemedy),
new SqlParameter("@GastroOthers", obj.GastroOthers),
new SqlParameter("@MedicationID", obj.MedicationID),
new SqlParameter("@TakeVitaminSup", obj.TakeVitaminSup),
new SqlParameter("@VitaminSupDet", obj.VitaminSupDet),
new SqlParameter("@TakeMineralSup", obj.TakeMineralSup),
new SqlParameter("@MineralSupDet", obj.MineralSupDet),
new SqlParameter("@OralDrugDType", obj.OralDrugDType),
new SqlParameter("@OralDrugDet", obj.OralDrugDet),
new SqlParameter("@MedicationOthers", obj.MedicationOthers),
new SqlParameter("@ClinicCompID", obj.ClinicCompID),
new SqlParameter("@ClinicCompGastProbID", obj.ClinicCompGastProbID),
new SqlParameter("@ClinicCompChronDisID", obj.ClinicCompChronDisID),
new SqlParameter("@ClinicCompMedicationID", obj.ClinicCompMedicationID),
new SqlParameter("@ClinicComplaintsNotes", obj.ClinicComplaintsNotes),
new SqlParameter("@ReturnVal", SqlDbType.Int)
};
return(DBOperate.ExecuteProcedure("usp_ModifyClinicalComplaints", parameter));
}
catch
{
throw;
}
}
public int ModifyDietLifestyle(DietLifestyle obj)
{
try
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@CustomerID", obj.CustomerID),
new SqlParameter("@DietAndLifeStyleID", obj.DietAndLifeStyleID),
new SqlParameter("@RegularExcercise", obj.RegularExcercise),
new SqlParameter("@Smoking", obj.Smoking),
new SqlParameter("@Alcohol", obj.Alcohol),
new SqlParameter("@NoOfDrinks", obj.NoOfDrinks),
new SqlParameter("@FrequencyOfDrinks", obj.FrequencyOfDrinks),
new SqlParameter("@TypeOfDrink", obj.TypeOfDrink),
new SqlParameter("@ExcersizeDetail", obj.ExcersizeDetail),
new SqlParameter("@SleepHoursPerDay", obj.SleepHoursPerDay),
new SqlParameter("@ActivityFactor", obj.ActivityFactor),
new SqlParameter("@DietLifeHistoryID", obj.DietLifeHistoryID),
new SqlParameter("@DietAndLifeStyleNotes", obj.DietAndLifeStyleNotes),
new SqlParameter("@OilUseDetail", obj.OilUseDetail),
new SqlParameter("@SugarQuantityForMonth", obj.SugarQuantityForMonth),
new SqlParameter("@OilQuantityForMonth", obj.OilQuantityForMonth),
new SqlParameter("@NoOfMembersInFamily", obj.NoOfMembersInFamily),
new SqlParameter("@BMR", obj.BMR),
new SqlParameter("@Calorie", obj.Calorie),
new SqlParameter("@CarbhohydratesPercent", obj.CarbhohydratesPercent),
new SqlParameter("@FatPercent", obj.FatPercent),
new SqlParameter("@ProteinPercent", obj.ProteinPercent),
new SqlParameter("@Calorie1", obj.Calorie1),
new SqlParameter("@CarbhohydratesPercent1", obj.CarbhohydratesPercent1),
new SqlParameter("@FatPercent1", obj.FatPercent1),
new SqlParameter("@ProteinPercent1", obj.ProteinPercent1),
new SqlParameter("@GrainsServings", obj.GrainsServings),
new SqlParameter("@DalsServings", obj.DalsServings),
new SqlParameter("@MilkServings", obj.MilkServings),
new SqlParameter("@NonvegServings", obj.NonvegServings),
new SqlParameter("@VegetablesServings", obj.VegetablesServings),
new SqlParameter("@FruitsServings", obj.FruitsServings),
new SqlParameter("@SugarServings", obj.SugarServings),
new SqlParameter("@FatServings", obj.FatServings),
new SqlParameter("@WaterServings", obj.WaterServings),
new SqlParameter("@BiscuitServings", obj.BiscuitServings),
new SqlParameter("@NonvegQuantity", obj.NonvegQuantity),
new SqlParameter("@NonvegTypes", obj.NonvegTypes),
new SqlParameter("@NonvegValues", obj.NonvegValues),
//DietHistory
new SqlParameter("@DietHistoryID", obj.DietHistoryID),
new SqlParameter("@DietType", obj.DietType),
new SqlParameter("@DietTypeDetails", obj.DietTypeDetails),
new SqlParameter("@FreqOutFoodEat", obj.FreqOutFoodEat),
new SqlParameter("@NoOfTypicalMealsInDay", obj.NoOfTypicalMealsInDay),
new SqlParameter("@NoOfTypicalSnaxsInDay", obj.NoOfTypicalSnaxsInDay),
new SqlParameter("@NoOfTeaCoffeeInDay", obj.NoOfTeaCoffeeInDay),
new SqlParameter("@TeaCoffeeFrequency", obj.TeaCoffeeFrequency),
new SqlParameter("@Caloricbeverages", obj.Caloricbeverages),
new SqlParameter("@BreakfastEveryDay", obj.BreakfastEveryDay),
new SqlParameter("@EatWhenBored", obj.EatWhenBored),
new SqlParameter("@EatWhenStressed", obj.EatWhenStressed),
new SqlParameter("@EatWhenWatchTV", obj.EatWhenWatchTV),
new SqlParameter("@Pregnant", obj.Pregnant),
new SqlParameter("@LactatingMother", obj.LactatingMother),
new SqlParameter("@BabyAge", obj.BabyAge),
new SqlParameter("@TriedWeightLossDiet", obj.TriedWeightLossDiet),
new SqlParameter("@WtLossGainSixMon", obj.WtLossGainSixMon),
new SqlParameter("@ReturnVal", SqlDbType.Int)
};
return(DBOperate.ExecuteProcedure("usp_ModifyDietLifestyle", parameter));
}
catch
{
throw;
}
}