private List<HelpDesk_Setting> GetSettings() { // Get Settings HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext(); List<HelpDesk_Setting> colHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings where HelpDesk_Settings.PortalID == PortalId select HelpDesk_Settings).ToList(); if (colHelpDesk_Setting.Count == 0) { // Create Default vaules HelpDesk_Setting objHelpDesk_Setting1 = new HelpDesk_Setting(); objHelpDesk_Setting1.PortalID = PortalId; objHelpDesk_Setting1.SettingName = "AdminRole"; objHelpDesk_Setting1.SettingValue = "Administrators"; objHelpDeskDALDataContext.HelpDesk_Settings.InsertOnSubmit(objHelpDesk_Setting1); objHelpDeskDALDataContext.SubmitChanges(); HelpDesk_Setting objHelpDesk_Setting2 = new HelpDesk_Setting(); objHelpDesk_Setting2.PortalID = PortalId; objHelpDesk_Setting2.SettingName = "UploFilesPath"; objHelpDesk_Setting2.SettingValue = Server.MapPath("~/DesktopModules/R7.HelpDesk/R7.HelpDesk/Upload"); objHelpDeskDALDataContext.HelpDesk_Settings.InsertOnSubmit(objHelpDesk_Setting2); objHelpDeskDALDataContext.SubmitChanges(); colHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings where HelpDesk_Settings.PortalID == PortalId select HelpDesk_Settings).ToList(); } return colHelpDesk_Setting; }
partial void DeleteHelpDesk_Setting(HelpDesk_Setting instance);
partial void InsertHelpDesk_Setting(HelpDesk_Setting instance);
partial void UpdateHelpDesk_Setting(HelpDesk_Setting instance);
private List<HelpDesk_Setting> GetSettings() { // Get Settings HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext(); List<HelpDesk_Setting> colHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings where HelpDesk_Settings.PortalID == PortalId select HelpDesk_Settings).ToList(); if (colHelpDesk_Setting.Count == 0) { // Create Default vaules HelpDesk_Setting objHelpDesk_Setting1 = new HelpDesk_Setting(); objHelpDesk_Setting1.PortalID = PortalId; objHelpDesk_Setting1.SettingName = "AdminRole"; objHelpDesk_Setting1.SettingValue = "Administrators"; objHelpDeskDALDataContext.HelpDesk_Settings.InsertOnSubmit(objHelpDesk_Setting1); objHelpDeskDALDataContext.SubmitChanges(); HelpDesk_Setting objHelpDesk_Setting2 = new HelpDesk_Setting(); objHelpDesk_Setting2.PortalID = PortalId; objHelpDesk_Setting2.SettingName = "UploFilesPath"; objHelpDesk_Setting2.SettingValue = Server.MapPath("~/DesktopModules/R7.HelpDesk/R7.HelpDesk/Upload"); objHelpDeskDALDataContext.HelpDesk_Settings.InsertOnSubmit(objHelpDesk_Setting2); objHelpDeskDALDataContext.SubmitChanges(); colHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings where HelpDesk_Settings.PortalID == PortalId select HelpDesk_Settings).ToList(); } // Upload Permission HelpDesk_Setting UploadPermissionHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings where HelpDesk_Settings.PortalID == PortalId where HelpDesk_Settings.SettingName == "UploadPermission" select HelpDesk_Settings).FirstOrDefault(); if (UploadPermissionHelpDesk_Setting != null) { // Add to collection colHelpDesk_Setting.Add(UploadPermissionHelpDesk_Setting); } else { // Add Default value HelpDesk_Setting objHelpDesk_Setting = new HelpDesk_Setting(); objHelpDesk_Setting.SettingName = "UploadPermission"; objHelpDesk_Setting.SettingValue = "All"; objHelpDesk_Setting.PortalID = PortalId; objHelpDeskDALDataContext.HelpDesk_Settings.InsertOnSubmit(objHelpDesk_Setting); objHelpDeskDALDataContext.SubmitChanges(); // Add to collection colHelpDesk_Setting.Add(objHelpDesk_Setting); } return colHelpDesk_Setting; }