public DataTable GetClientDetails(int ReportID) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@ReportID", ReportID) }; return(DBOperate.GetDataTable("csp_GetDashboardData", parameter)); } catch { throw; } }
public DataSet GetDietMaster_History(int customerID) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@customerID", customerID) }; return(DBOperate.GetDataSet("csp_GetDietMaster_History", parameter)); } catch { throw; } }
public DataTable GetRecallDietDetails(int CustID) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@CustID", CustID) }; return(DBOperate.GetDataTable("usp_GetRecallDietDetails", parameter)); } catch { throw; } }
public int UpdateClientData(int customerID) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@CustomerID", customerID), new SqlParameter("@ReturnVal", SqlDbType.Int) }; return(DBOperate.ExecuteProcedure("usp_ModifyClientHistory", parameter)); } catch { throw; } }
public DataTable GetRecallDietDetailsHistory(int CustID, string date) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@CustID", CustID), new SqlParameter("@date", date) }; return(DBOperate.GetDataTable("usp_GetRecallDietDetailsHistory", parameter)); } catch { throw; } }
public DataTable GetFoodMajorNutrients(string foodName, double foodQuantity, string foodUnit) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@foodName", foodName), new SqlParameter("@foodQuantity", foodQuantity), new SqlParameter("@foodUnit", foodUnit) }; return(DBOperate.GetDataTable("usp_GetFoodMajorNutrients", parameter)); } catch { throw; } }
public int AddHistory(int customerID, DateTime appDate) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@CustomerID", customerID), new SqlParameter("@dt", appDate), new SqlParameter("@ReturnVal", SqlDbType.Int) }; return(DBOperate.ExecuteProcedure("usp_AddClientHistory", parameter)); } catch { throw; } }
/// <summary> /// Function to search for Patients /// </summary> /// <param name="searchText">string searchText</param> /// /// <param name="searchCriteria">string searchCriteria</param> /// <returns>DataTable</returns> public DataTable SearchPatients(string searchText, string searchCriteria, string session) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@searchText", searchText), new SqlParameter("@searchCriteria", searchCriteria), new SqlParameter("@Session", session) }; return(DBOperate.GetDataTable("csp_SearchPatients", parameter)); } catch { throw; } }
public int UpdateDashoard(Int32 ID, string column, string session) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@ID", ID), new SqlParameter("@column", column), new SqlParameter("@Session", session), new SqlParameter("@ReturnVal", SqlDbType.Int) }; return(DBOperate.ExecuteProcedure("csp_UpdateDashboardData", parameter)); } catch { throw; } }
public int ModifyBiochemical(BioChemicalLab objBio) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@BioChemicalLabID", objBio.BioChemicalLabID), new SqlParameter("@CustomerID", objBio.CustomerID), new SqlParameter("@TestDate", objBio.TestDate), new SqlParameter("@FastingGlucose", objBio.FastingGlucose), new SqlParameter("@PP", objBio.PP), new SqlParameter("@HB", objBio.HB), new SqlParameter("@Creatinine", objBio.Creatinine), new SqlParameter("@Albumin", objBio.Albumin), new SqlParameter("@HbA1C", objBio.HbA1C), new SqlParameter("@AltSGPT", objBio.AltSGPT), new SqlParameter("@AltSGOT", objBio.AltSGOT), new SqlParameter("@Hematocrit", objBio.Hematocrit), new SqlParameter("@Triglycerides", objBio.Triglycerides), new SqlParameter("@TSH", objBio.TSH), new SqlParameter("@HDL", objBio.HDL), new SqlParameter("@LDL", objBio.LDL), new SqlParameter("@UricAcid", objBio.UricAcid), new SqlParameter("@TotalCholesterol", objBio.TotalCholesterol), new SqlParameter("@AlkalinePhosphatase", objBio.AlkalinePhosphatase), new SqlParameter("@VitaminD3", objBio.VitaminD3), new SqlParameter("@VitaminB12", objBio.VitaminB12), new SqlParameter("@BSL", objBio.BSL), new SqlParameter("@RBC", objBio.RBC), new SqlParameter("@Platelet", objBio.Platelet), new SqlParameter("@OthersBioChemicalLabs", objBio.OthersBioChemicalLabs), new SqlParameter("@BioChemicalLabNotes", objBio.BioChemicalLabNotes), new SqlParameter("@ReturnVal", SqlDbType.Int) }; return(DBOperate.ExecuteProcedure("usp_ModifyBioChemicalLabs", parameter)); } catch { throw; } }
public int SaveSingleMealDetails(int CustID, string MealID, string MealDays, string MealData, DateTime MealTime, string Notes) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@CustID", CustID), new SqlParameter("@MealID", MealID), new SqlParameter("@MealDays", MealDays), new SqlParameter("@MealData", MealData), new SqlParameter("@MealTime", MealTime), new SqlParameter("@Notes", Notes), }; return(DBOperate.ExecuteProcedureWithParameterReturnRowsAffected("usp_SaveSingleMealDetails", parameter)); } catch { throw; } }
public int ModifyAnthropometrics(Anthropometrics objAnthropometrics) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@Operation", objAnthropometrics.Operation), new SqlParameter("@AnthropometricID", objAnthropometrics.AnthropometricID), new SqlParameter("@CustomerID", objAnthropometrics.CustomerID), new SqlParameter("@MeasuredWeight", objAnthropometrics.MeasuredWeight), new SqlParameter("@MeasuredHeight", objAnthropometrics.MeasuredHeight), new SqlParameter("@IdealBodyWeight", objAnthropometrics.IdealBodyWeight), new SqlParameter("@CalculatedBMI", objAnthropometrics.CalculatedBMI), new SqlParameter("@BMICategory", objAnthropometrics.BMICategory), new SqlParameter("@BMIPer", objAnthropometrics.BMIPer), new SqlParameter("@FatPer", objAnthropometrics.FatPer), new SqlParameter("@MeasuredWaist", objAnthropometrics.MeasuredWaist), new SqlParameter("@MeasuredWrist", objAnthropometrics.MeasuredWrist), new SqlParameter("@WeightGainLossMonth", objAnthropometrics.WeightGainLossMonth), new SqlParameter("@WeightGainLossSixMonth", objAnthropometrics.WeightGainLossSixMonth), new SqlParameter("@WeightGainLossYear", objAnthropometrics.WeightGainLossYear), new SqlParameter("@NeckCircumference", objAnthropometrics.NeckCircumference), new SqlParameter("@MUAC", objAnthropometrics.MUAC), new SqlParameter("@BloodPressure", objAnthropometrics.BloodPressure), new SqlParameter("@BodyFrame", objAnthropometrics.BodyFrame), new SqlParameter("@ReasonGainLoss", objAnthropometrics.ReasonGainLoss), new SqlParameter("@AnthrpometricsNotes", objAnthropometrics.AnthrpometricsNotes), new SqlParameter("@MussleMass", objAnthropometrics.MussleMass), new SqlParameter("@BoneMass", objAnthropometrics.BoneMass), new SqlParameter("@BodyWater", objAnthropometrics.BodyWater), new SqlParameter("@VisceralFat", objAnthropometrics.VisceralFat), new SqlParameter("@ReturnVal", SqlDbType.Int) }; return(DBOperate.ExecuteProcedure("usp_ModifyAnthropometrics", parameter)); } catch { throw; } }
public int ModifyCustomerDetail(CustomerDetail objCustDetail) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@Operation", objCustDetail.Operation), new SqlParameter("@CustomerID", objCustDetail.CustomerID), new SqlParameter("@CustomerName", objCustDetail.CustomerName), new SqlParameter("@MiddleName ", objCustDetail.MiddleName), new SqlParameter("@LastName", objCustDetail.LastName), new SqlParameter("@CustomerAge", objCustDetail.CustomerAge), new SqlParameter("@Gender", objCustDetail.Gender), new SqlParameter("@DOB", objCustDetail.DOB), new SqlParameter("@Address1", objCustDetail.Address1), new SqlParameter("@Locality", objCustDetail.Locality), new SqlParameter("@City", objCustDetail.City), new SqlParameter("@State", objCustDetail.State), new SqlParameter("@Country", objCustDetail.Country), new SqlParameter("@Pincode", objCustDetail.Pincode), new SqlParameter("@Profession", objCustDetail.Profession), new SqlParameter("@ProfessionOthers", objCustDetail.ProfessionOthers), new SqlParameter("@Email", objCustDetail.Email), new SqlParameter("@Mobile", objCustDetail.Mobile), new SqlParameter("@Landline", objCustDetail.Landline), new SqlParameter("@PresentExercise", objCustDetail.PresentExercise), new SqlParameter("@ExersizeActivity", objCustDetail.ExersizeActivity), new SqlParameter("@CustomerDetailNotes", objCustDetail.CustomerDetailNotes), new SqlParameter("@Session", objCustDetail.Session), new SqlParameter("@ReturnVal", SqlDbType.Int) }; return(DBOperate.ExecuteProcedure("usp_ModifyCustomerDetail", parameter)); } catch { throw; } }
public int ModifyDietMaster(DietMaster objDietMaster) { try { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@Operation", objDietMaster.Operation), //CustomerDetails new SqlParameter("@CustomerID", objDietMaster.CustomerID), new SqlParameter("@CustomerName", objDietMaster.CustomerName), new SqlParameter("@MiddleName", objDietMaster.MiddleName), new SqlParameter("@LastName", objDietMaster.LastName), new SqlParameter("@CustomerAge", objDietMaster.CustomerAge), new SqlParameter("@Gender", objDietMaster.Gender), new SqlParameter("@DOB", objDietMaster.DOB), new SqlParameter("@Address1", objDietMaster.Address1), new SqlParameter("@Locality", objDietMaster.Locality), new SqlParameter("@City", objDietMaster.City), new SqlParameter("@State", objDietMaster.State), new SqlParameter("@Country", objDietMaster.Country), new SqlParameter("@Pincode", objDietMaster.PinCode), new SqlParameter("@Profession", objDietMaster.Profession), new SqlParameter("@ProfessionOthers", objDietMaster.ProfessionOthers), new SqlParameter("@Email", objDietMaster.Email), new SqlParameter("@Mobile", objDietMaster.Mobile), new SqlParameter("@Landline", objDietMaster.Landline), new SqlParameter("@PresentExercise", objDietMaster.PresentExercise), new SqlParameter("@ExersizeActivity", objDietMaster.ExersizeActivity), new SqlParameter("@CustomerDetailNotes", objDietMaster.CustomerDetailNotes), new SqlParameter("@Session", objDietMaster.Session), //Anthrpometrics new SqlParameter("@AnthropometricID", objDietMaster.AnthropometricID), new SqlParameter("@MeasuredWeight", objDietMaster.MeasuredWeight), new SqlParameter("@MeasuredHeight", objDietMaster.MeasuredHeight), new SqlParameter("@IdealBodyWeight", objDietMaster.IdealBodyWeight), new SqlParameter("@CalculatedBMI", objDietMaster.CalculatedBMI), new SqlParameter("@BMICategory", objDietMaster.BMICategory), new SqlParameter("@BMIPer", objDietMaster.BMIPer), new SqlParameter("@FatPer", objDietMaster.FatPer), new SqlParameter("@MeasuredWaist", objDietMaster.MeasuredWaist), new SqlParameter("@MeasuredWrist", objDietMaster.MeasuredWrist), new SqlParameter("@WeightGainLossMonth", objDietMaster.WeightGainLossMonth), new SqlParameter("@WeightGainLossSixMonth", objDietMaster.WeightGainLossSixMonth), new SqlParameter("@WeightGainLossYear", objDietMaster.WeightGainLossYear), new SqlParameter("@NeckCircumference", objDietMaster.NeckCircumference), new SqlParameter("@MUAC", objDietMaster.MUAC), new SqlParameter("@BloodPressure", objDietMaster.BloodPressure), new SqlParameter("@BodyFrame", objDietMaster.BodyFrame), new SqlParameter("@ReasonGainLoss", objDietMaster.ReasonGainLoss), new SqlParameter("@AnthrpometricsNotes", objDietMaster.AnthrpometricsNotes), new SqlParameter("@MussleMass", objDietMaster.MussleMass), new SqlParameter("@BoneMass", objDietMaster.BoneMass), new SqlParameter("@BodyWater", objDietMaster.BodyWater), new SqlParameter("@VisceralFat", objDietMaster.VisceralFat), //BioChemicalLabs new SqlParameter("@BioChemicalLabID", objDietMaster.BioChemicalLabID), new SqlParameter("@TestDate", objDietMaster.TestDate), new SqlParameter("@FastingGlucose", objDietMaster.FastingGlucose), new SqlParameter("@PP", objDietMaster.PP), new SqlParameter("@HB", objDietMaster.HB), new SqlParameter("@Creatinine", objDietMaster.Creatinine), new SqlParameter("@Albumin", objDietMaster.Albumin), new SqlParameter("@HbA1C", objDietMaster.HbA1C), new SqlParameter("@AltSGPT", objDietMaster.AltSGPT), new SqlParameter("@AltSGOT", objDietMaster.AltSGOT), new SqlParameter("@Hematocrit", objDietMaster.Hematocrit), new SqlParameter("@Triglycerides", objDietMaster.Triglycerides), new SqlParameter("@TSH", objDietMaster.TSH), new SqlParameter("@HDL", objDietMaster.HDL), new SqlParameter("@LDL", objDietMaster.LDL), new SqlParameter("@UricAcid", objDietMaster.UricAcid), new SqlParameter("@TotalCholesterol", objDietMaster.TotalCholesterol), new SqlParameter("@AlkalinePhosphatase", objDietMaster.AlkalinePhosphatase), new SqlParameter("@VitaminD3", objDietMaster.VitaminD3), new SqlParameter("@VitaminB12", objDietMaster.VitaminB12), new SqlParameter("@BSL", objDietMaster.BSL), new SqlParameter("@RBC", objDietMaster.RBC), new SqlParameter("@Platelet", objDietMaster.Platelet), new SqlParameter("@OthersBioChemicalLabs", objDietMaster.OthersBioChemicalLabs), new SqlParameter("@BioChemicalLabNotes", objDietMaster.BioChemicalLabNotes), //Comorbidity new SqlParameter("@ComorbidityID", objDietMaster.ComorbidityID), new SqlParameter("@Hypertension", objDietMaster.Hypertension), new SqlParameter("@Diabetes", objDietMaster.Diabetes), new SqlParameter("@CHF", objDietMaster.CHF), new SqlParameter("@Asthma", objDietMaster.Asthma), new SqlParameter("@IHD", objDietMaster.IHD), new SqlParameter("@Thyroid", objDietMaster.Thyroid), new SqlParameter("@ThyroidType", objDietMaster.ThyroidType), new SqlParameter("@SleepApnea", objDietMaster.SleepApnea), new SqlParameter("@FunctionalStatus", objDietMaster.FunctionalStatus), new SqlParameter("@ComorbidityOthers", objDietMaster.ComorbidityOthers), new SqlParameter("@ComorbidityNotes", objDietMaster.ComorbidityNotes), //ChronicDiseases new SqlParameter("@CardiacDisorders", objDietMaster.CardiacDisorders), new SqlParameter("@KidneyDisorders", objDietMaster.KidneyDisorders), new SqlParameter("@LeverDisorders", objDietMaster.LeverDisorders), new SqlParameter("@FollowedParticularDietForProb", objDietMaster.FollowedParticularDietForProb), //DietAndLifeStyle new SqlParameter("@DietAndLifeStyleID", objDietMaster.DietAndLifeStyleID), new SqlParameter("@RegularExcercise", objDietMaster.RegularExcercise), new SqlParameter("@Smoking", objDietMaster.Smoking), new SqlParameter("@Alcohol", objDietMaster.Alcohol), new SqlParameter("@NoOfDrinks", objDietMaster.NoOfDrinks), new SqlParameter("@FrequencyOfDrinks", objDietMaster.FrequencyOfDrinks), new SqlParameter("@TypeOfDrink", objDietMaster.TypeOfDrink), new SqlParameter("@ExcersizeDetail", objDietMaster.ExcersizeDetail), new SqlParameter("@SleepHoursPerDay", objDietMaster.SleepHoursPerDay), new SqlParameter("@ActivityFactor", objDietMaster.ActivityFactor), new SqlParameter("@DietLifeHistoryID", objDietMaster.DietLifeHistoryID), new SqlParameter("@DietAndLifeStyleNotes", objDietMaster.DietAndLifeStyleNotes), new SqlParameter("@BMR", objDietMaster.BMR), new SqlParameter("@Calorie", objDietMaster.Calorie), new SqlParameter("@CarbhohydratesPercent", objDietMaster.CarbhohydratesPercent), new SqlParameter("@FatPercent", objDietMaster.FatPercent), new SqlParameter("@ProteinPercent", objDietMaster.ProteinPercent), new SqlParameter("@Calorie1", objDietMaster.Calorie1), new SqlParameter("@CarbhohydratesPercent1", objDietMaster.CarbhohydratesPercent1), new SqlParameter("@FatPercent1", objDietMaster.FatPercent1), new SqlParameter("@ProteinPercent1", objDietMaster.ProteinPercent1), new SqlParameter("@GrainsServings", objDietMaster.GrainsServings), new SqlParameter("@DalsServings", objDietMaster.DalsServings), new SqlParameter("@MilkServings", objDietMaster.MilkServings), new SqlParameter("@NonvegServings", objDietMaster.NonvegServings), new SqlParameter("@VegetablesServings", objDietMaster.VegetablesServings), new SqlParameter("@FruitsServings", objDietMaster.FruitsServings), new SqlParameter("@SugarServings", objDietMaster.SugarServings), new SqlParameter("@FatServings", objDietMaster.FatServings), new SqlParameter("@WaterServings", objDietMaster.WaterServings), new SqlParameter("@BiscuitServings", objDietMaster.BiscuitServings), new SqlParameter("@NonvegQuantity", objDietMaster.NonvegQuantity), new SqlParameter("@NonvegTypes", objDietMaster.NonvegTypes), new SqlParameter("@NonvegValues", objDietMaster.NonvegValues), //DietHistory new SqlParameter("@DietHistoryID", objDietMaster.DietHistoryID), new SqlParameter("@DietType", objDietMaster.DietType), new SqlParameter("@DietTypeDetails", objDietMaster.DietTypeDetails), new SqlParameter("@FreqOutFoodEat", objDietMaster.FreqOutFoodEat), new SqlParameter("@NoOfTypicalMealsInDay", objDietMaster.NoOfTypicalMealsInDay), new SqlParameter("@NoOfTypicalSnaxsInDay", objDietMaster.NoOfTypicalSnaxsInDay), new SqlParameter("@NoOfTeaCoffeeInDay", objDietMaster.NoOfTeaCoffeeInDay), new SqlParameter("@TeaCoffeeFrequency", objDietMaster.TeaCoffeeFrequency), new SqlParameter("@Caloricbeverages", objDietMaster.Caloricbeverages), new SqlParameter("@BreakfastEveryDay", objDietMaster.BreakfastEveryDay), new SqlParameter("@EatWhenBored", objDietMaster.EatWhenBored), new SqlParameter("@EatWhenStressed", objDietMaster.EatWhenStressed), new SqlParameter("@EatWhenWatchTV", objDietMaster.EatWhenWatchTV), new SqlParameter("@Pregnant", objDietMaster.Pregnant), new SqlParameter("@LactatingMother", objDietMaster.LactatingMother), new SqlParameter("@BabyAge", objDietMaster.BabyAge), new SqlParameter("@TriedWeightLossDiet", objDietMaster.TriedWeightLossDiet), new SqlParameter("@WtLossGainSixMon", objDietMaster.WtLossGainSixMon), //Clinic Complaints new SqlParameter("@ClinicCompID", objDietMaster.ClinicCompID), new SqlParameter("@ClinicCompGastProbID", objDietMaster.ClinicCompGastProbID), //new SqlParameter("@ClinicCompChronDisID",objDietMaster.ClinicCompChronDisID), new SqlParameter("@ClinicCompMedicationID", objDietMaster.ClinicCompMedicationID), //FatsAndOil new SqlParameter("@OilUseDetail", objDietMaster.OilUseDetail), new SqlParameter("@SugarQuantityForMonth", objDietMaster.SugarQuantityForMonth), new SqlParameter("@OilQuantityForMonth", objDietMaster.OilQuantityForMonth), new SqlParameter("@NoOfMembersInFamily", objDietMaster.NoOfMembersInFamily), new SqlParameter("@ClinicComplaintsNotes", objDietMaster.ClinicComplaintsNotes), //GastroIntenstinalProblems new SqlParameter("@GastProbID", objDietMaster.GastProbID), new SqlParameter("@Heartburn", objDietMaster.Heartburn), new SqlParameter("@Bloating", objDietMaster.Bloating), new SqlParameter("@Gas", objDietMaster.Gas), new SqlParameter("@Diarrhoea", objDietMaster.Diarrhoea), new SqlParameter("@Vomiting", objDietMaster.Vomiting), new SqlParameter("@Constipation", objDietMaster.Constipation), new SqlParameter("@LaxativeAntacide", objDietMaster.LaxativeAntacide), new SqlParameter("@HomeRemedy", objDietMaster.HomeRemedy), new SqlParameter("@GastroOthers", objDietMaster.GastroOthers), //Medication new SqlParameter("@MedicationID", objDietMaster.MedicationID), new SqlParameter("@TakeVitaminSup", objDietMaster.TakeVitaminSup), new SqlParameter("@VitaminSupDet", objDietMaster.VitaminSupDet), new SqlParameter("@TakeMineralSup", objDietMaster.TakeMineralSup), new SqlParameter("@MineralSupDet", objDietMaster.MineralSupDet), new SqlParameter("@OralDrugDType", objDietMaster.OralDrugDType), new SqlParameter("@OralDrugDet", objDietMaster.OralDrugDet), new SqlParameter("@MedicationOthers", objDietMaster.MedicationOthers), //RecallDiet new SqlParameter("@DietRecallID", objDietMaster.DietRecallID), new SqlParameter("@Meal1", objDietMaster.Meal1), new SqlParameter("@Meal2", objDietMaster.Meal2), new SqlParameter("@Meal3", objDietMaster.Meal3), new SqlParameter("@Meal4", objDietMaster.Meal4), new SqlParameter("@Meal5", objDietMaster.Meal5), new SqlParameter("@Meal6", objDietMaster.Meal6), new SqlParameter("@RecallDietNotes", objDietMaster.RecallDietNotes), new SqlParameter("@ReturnVal", SqlDbType.Int) }; return(DBOperate.ExecuteProcedure("usp_ModifyDietMaster", parameter)); } catch { throw; } }