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;
}
