public int ModifyDietLifestyle(DietLifestyle dobj)
{
DietLifestyleDataManager obj = new DietLifestyleDataManager();
try
{
return(obj.ModifyDietLifestyle(dobj));
}
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;
}
}