//--------Public Functions------------- public static DataSet DataForLoadingControls(ControlDataLoader.ControlType NameOfTable) { string strCacheString = ""; switch (NameOfTable) { case ControlDataLoader.ControlType.AnnualIncomeRange: strCacheString = "AnnualIncomeRange"; break; case ControlDataLoader.ControlType.BloodGroup: strCacheString = "BloodGroup"; break; case ControlDataLoader.ControlType.Cast: strCacheString = "Cast"; break; case ControlDataLoader.ControlType.Complexion: strCacheString = "Complexion"; break; case ControlDataLoader.ControlType.Country: strCacheString = "Country"; break; case ControlDataLoader.ControlType.Currency: strCacheString = "Currency"; break; case ControlDataLoader.ControlType.Diet: strCacheString = "Diet"; break; case ControlDataLoader.ControlType.Education: strCacheString = "Education"; break; case ControlDataLoader.ControlType.EduDetails: strCacheString = "EduDetails"; break; case ControlDataLoader.ControlType.EmployedIn: strCacheString = "EmployedIn"; break; case ControlDataLoader.ControlType.FamilyStatus: strCacheString = "FamilyStatus"; break; case ControlDataLoader.ControlType.Familytype: strCacheString = "Familytype"; break; case ControlDataLoader.ControlType.FamilyValue: strCacheString = "FamilyValue"; break; case ControlDataLoader.ControlType.HoroManglic: strCacheString = "HoroManglic"; break; case ControlDataLoader.ControlType.Hobbies: strCacheString = "Hobbies"; break; case ControlDataLoader.ControlType.Interests: strCacheString = "Interests"; break; case ControlDataLoader.ControlType.Star: strCacheString = "Star"; break; case ControlDataLoader.ControlType.MaritalStatus: strCacheString = "MaritalStatus"; break; case ControlDataLoader.ControlType.MoonSign: strCacheString = "MoonSign"; break; case ControlDataLoader.ControlType.MotherTongue: strCacheString = "MotherTongue"; break; case ControlDataLoader.ControlType.Occupation: strCacheString = "Occupation"; break; case ControlDataLoader.ControlType.ProfileCreatedBy: strCacheString = "ProfileCreatedBy"; break; case ControlDataLoader.ControlType.ReferenceBy: strCacheString = "ReferenceBy"; break; case ControlDataLoader.ControlType.Religion: strCacheString = "Religion"; break; case ControlDataLoader.ControlType.ResidenceStatus: strCacheString = "ResidenceStatus"; break; case ControlDataLoader.ControlType.SmokeNDrink: strCacheString = "SmokeNDrink"; break; case ControlDataLoader.ControlType.State: strCacheString = "State"; break; case ControlDataLoader.ControlType.Sequrity: strCacheString = "Sequrity"; break; } DataSet objReturnDataset = new DataSet(); if (HttpContext.Current.Cache[strCacheString] == null) { objReturnDataset = LoadingFirst(strCacheString); } else { objReturnDataset = (DataSet)HttpContext.Current.Cache[strCacheString]; } return(objReturnDataset); }
public static string GetIndexValue(ControlDataLoader.ControlType NameOfTable, int Index) { string strCacheString = ""; switch (NameOfTable) { case ControlDataLoader.ControlType.AnnualIncomeRange: strCacheString = "AnnualIncomeRange"; break; case ControlDataLoader.ControlType.BloodGroup: strCacheString = "BloodGroup"; break; case ControlDataLoader.ControlType.Cast: strCacheString = "Cast"; break; case ControlDataLoader.ControlType.Complexion: strCacheString = "Complexion"; break; case ControlDataLoader.ControlType.Country: strCacheString = "Country"; break; case ControlDataLoader.ControlType.Currency: strCacheString = "Currency"; break; case ControlDataLoader.ControlType.Diet: strCacheString = "Diet"; break; case ControlDataLoader.ControlType.Education: strCacheString = "Education"; break; case ControlDataLoader.ControlType.EduDetails: strCacheString = "EduDetails"; break; case ControlDataLoader.ControlType.EmployedIn: strCacheString = "EmployedIn"; break; case ControlDataLoader.ControlType.FamilyStatus: strCacheString = "FamilyStatus"; break; case ControlDataLoader.ControlType.Familytype: strCacheString = "Familytype"; break; case ControlDataLoader.ControlType.FamilyValue: strCacheString = "FamilyValue"; break; case ControlDataLoader.ControlType.HoroManglic: strCacheString = "HoroManglic"; break; case ControlDataLoader.ControlType.Hobbies: strCacheString = "Hobbies"; break; case ControlDataLoader.ControlType.Interests: strCacheString = "Interests"; break; case ControlDataLoader.ControlType.Star: strCacheString = "Star"; break; case ControlDataLoader.ControlType.MaritalStatus: strCacheString = "MaritalStatus"; break; case ControlDataLoader.ControlType.MoonSign: strCacheString = "MoonSign"; break; case ControlDataLoader.ControlType.MotherTongue: strCacheString = "MotherTongue"; break; case ControlDataLoader.ControlType.Occupation: strCacheString = "Occupation"; break; case ControlDataLoader.ControlType.ProfileCreatedBy: strCacheString = "ProfileCreatedBy"; break; case ControlDataLoader.ControlType.ReferenceBy: strCacheString = "ReferenceBy"; break; case ControlDataLoader.ControlType.Religion: strCacheString = "Religion"; break; case ControlDataLoader.ControlType.ResidenceStatus: strCacheString = "ResidenceStatus"; break; case ControlDataLoader.ControlType.SmokeNDrink: strCacheString = "SmokeNDrink"; break; case ControlDataLoader.ControlType.State: strCacheString = "State"; break; case ControlDataLoader.ControlType.Sequrity: strCacheString = "Sequrity"; break; } string strRetrunString = null; // is it in cacahe? try { if (HttpContext.Current.Cache[strCacheString] != null) { strRetrunString = ((DataSet)HttpContext.Current.Cache[strCacheString]).Tables["IndexTable"].Rows[Index]["Item"].ToString(); } else { strRetrunString = (LoadingFirst(strCacheString)).Tables["IndexTable"].Rows[Index]["Item"].ToString(); } } catch (Exception Ex) { ErrorLog.WriteErrorLog("ControlDataLoader.GetIndexValue(" + strCacheString + "," + Index.ToString() + ")", Ex); strRetrunString = "-"; } return(strRetrunString); }