public bool UpdateSharePointServerSettings(SharePointSettings sps) { SharePointSettings ReturnStObject = new SharePointSettings(); try { System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); cmd.CommandText = "IF EXISTS ( SELECT 1 FROM SharePointServerSettings WHERE ServerID = @ID ) BEGIN " + " UPDATE SharePointServerSettings SET ConflictingContentType = @ConflictingContentType, CustomizedFiles = @CustomizedFiles, MissingGalleries = @MissingGalleries, MissingParentContentTypes = @MissingParentContentTypes, " + " MissingSiteTemplates = @MissingSiteTemplates, UnsupportedLanguagePack = @UnsupportedLanguagePack, UnsupportedMUI = @UnsupportedMUI WHERE ServerID = @ID " + " END ELSE BEGIN " + " INSERT INTO SharePointServerSettings (ServerID, ConflictingContentType, CustomizedFiles, MissingGalleries, MissingParentContentTypes, MissingSiteTemplates, UnsupportedLanguagePack, UnsupportedMUI) " + " VALUES (@ID, @ConflictingContentType, @CustomizedFiles, @MissingGalleries, @MissingParentContentTypes, @MissingSiteTemplates, @UnsupportedLanguagePack, @UnsupportedMUI) END"; cmd.Parameters.AddWithValue("@ID", sps.ServerId); cmd.Parameters.AddWithValue("@ConflictingContentType", sps.ConflictingContentTypes); cmd.Parameters.AddWithValue("@CustomizedFiles", sps.CustomizedFiles); cmd.Parameters.AddWithValue("@MissingGalleries", sps.MissingGalleries); cmd.Parameters.AddWithValue("@MissingParentContentTypes", sps.MissingParentContentTypes); cmd.Parameters.AddWithValue("@MissingSiteTemplates", sps.MissingSiteTemplates); cmd.Parameters.AddWithValue("@UnsupportedLanguagePack", sps.UnsupportedLanguagePackReferences); cmd.Parameters.AddWithValue("@UnsupportedMUI", sps.UnsupportedMUIReferences); return(objAdaptor.ExecuteNonQuerywithcmd(cmd)); } catch (Exception ex) { throw ex; } finally { } return(false); }
public object DeleteData(SharePointSettings StObject) { try { return(VSWebDAL.SharePointSettingsDAL.Ins.DeleteData(StObject)); } catch (Exception ex) { throw ex; } }
public bool UpdateSharePointSettings(SharePointSettings StObject, string strSname) { try { return(VSWebDAL.SharePointSettingsDAL.Ins.UpdateSharePointSettings(StObject, strSname)); } catch (Exception ex) { throw ex; } }
public bool UpdateSharePointServerSettings(SharePointSettings sps) { try { return(VSWebDAL.SharePointSettingsDAL.Ins.UpdateSharePointServerSettings(sps)); } catch (Exception ex) { throw ex; } }
public bool UpdateSharePointSettings(SharePointSettings StObject, string strSname) { bool UpdateRet = false; int Update = 0; try { if (strSname != "") { string SqlQuery = ""; if (StObject.ServerId.ToString() != "") { SqlQuery = "UPDATE SharePointSettings set svalue='" + StObject.Svalue + "',ServerId='" + StObject.ServerId + "' where Sname='" + strSname + "'"; } else { SqlQuery = "UPDATE SharePointSettings set svalue='" + StObject.Svalue + "' where Sname='" + strSname + "'"; } Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery); } } catch { Update = 0; } if (Update == 0) { try { string SqlQuery = ""; if (StObject.ServerId.ToString() != "") { SqlQuery = "INSERT INTO SharePointSettings VALUES('" + StObject.ServerId + "','" + StObject.Sname + "','" + StObject.Svalue + "')"; } else { SqlQuery = "INSERT INTO SharePointSettings VALUES('" + StObject.Sname + "','" + StObject.Svalue + "','System.String')"; } Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery); } catch { Update = 0; } } if (Update == 1) { UpdateRet = true; } return(UpdateRet); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1); var sharepointsettings = new SharePointSettings(); Configuration.Bind("SharePointSettings", sharepointsettings); services.AddSingleton(sharepointsettings); services.AddSingleton <IWebContentRepo, WebContentRepo>(); services.AddSingleton <IWebContentProvider, WebContentProvider>(); }
private static async Task <LeaveRequestModel> LeaveRequestDialogCompleted(IBotContext context, LeaveRequestModel model) { LeaveRequest request = new LeaveRequest() { StartTime = model.StartTime, EndTime = model.EndTime, Title = model.Title }; string token = await context.GetADALAccessToken(_resourceUriSharePoint); await SharePointConnector.CreateLeaveRequest(request, token, SharePointSettings.GetFromEnvironment()); var message = "I've saved your leave request in SharePoint! An approval request will be sent out automatically. Enjoy!"; await context.PostAsync(message); return(model); }
public DataTable GetFarmSettings(string farm) { SharePointSettings ReturnStObject = new SharePointSettings(); DataTable SharePointSettingsDataTable = new DataTable(); try { string SqlQuery = "SELECT * FROM SharePointFarmSettings WHERE FarmName='" + farm + "'"; SharePointSettingsDataTable = objAdaptor.FetchData(SqlQuery); } catch (Exception ex) { throw ex; } finally { } return(SharePointSettingsDataTable); }
/// <summary> /// Get all Data from DominoCluster /// </summary> public SharePointSettings GetData(SharePointSettings StObject) { SharePointSettings ReturnStObject = new SharePointSettings(); DataTable SharePointSettingsDataTable = new DataTable(); try { string SqlQuery = "SELECT Svalue FROM SharePointSettings WHERE Sname='" + StObject.Sname + "'"; SharePointSettingsDataTable = objAdaptor.FetchData(SqlQuery); ReturnStObject.Svalue = SharePointSettingsDataTable.Rows[0]["Svalue"].ToString(); } catch (Exception ex) { throw ex; } finally { } return(ReturnStObject); }
public object DeleteData(SharePointSettings StObject) { bool UpdateRet = false; int Update = 0; try { string SqlQuery = "delete SharePointSettings where Sname='" + StObject.Sname + "'"; Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery); } catch { Update = 0; } if (Update == 1) { UpdateRet = true; } return(UpdateRet); }
public DataTable GetAllData() { SharePointSettings ReturnStObject = new SharePointSettings(); DataTable SharePointSettingsDataTable = new DataTable(); try { string SqlQuery = "SELECT * FROM SharePointSettings"; SharePointSettingsDataTable = objAdaptor.FetchData(SqlQuery); //ReturnStObject.svalue = SettingsDataTable.Rows[0]["svalue"].ToString(); //ReturnStObject.sname = SettingsDataTable.Rows[0]["sname"].ToString(); //ReturnStObject.stype = SettingsDataTable.Rows[0]["stype"].ToString(); } catch (Exception ex) { throw ex; } finally { } return(SharePointSettingsDataTable); }
public bool UpdateFarmSettings(SharePointFarmSettings settings) { SharePointSettings ReturnStObject = new SharePointSettings(); try { string SqlQuery = "IF EXISTS(Select * from SharePointFarmSettings where FarmName='" + settings.FarmName + "') BEGIN "; SqlQuery += " UPDATE SharePointFarmSettings set LogOnTest='" + settings.LogOnTest + "', SiteCreationTest='" + settings.SiteCreationTest + "', "; SqlQuery += " FileUploadTest='" + settings.FileUploadTest + "', TestApplicationURL='" + settings.TestAppURL + "' where FarmName='" + settings.FarmName + "' "; SqlQuery += " END ELSE BEGIN "; SqlQuery += " Insert into SharePointFarmSettings (FarmName, LogOnTest, SiteCreationTest, FileUploadTest, TestApplicationURL) VALUES "; SqlQuery += " ('" + settings.FarmName + "', '" + settings.LogOnTest + "', '" + settings.SiteCreationTest + "', '" + settings.FileUploadTest + "', '" + settings.TestAppURL + "') END"; return(objAdaptor.ExecuteNonQuery(SqlQuery)); } catch (Exception ex) { throw ex; } finally { } return(false); }
private static async Task <SickLeaveModel> SickLeaveDialogCompleted(IBotContext context, SickLeaveModel model) { LeaveRequest request = new LeaveRequest() { StartTime = model.StartTime, EndTime = model.EndTime, Title = $"Leave Request" }; string token = await context.GetADALAccessToken(_resourceUriSharePoint); await SharePointConnector.CreateLeaveRequest(request, token, SharePointSettings.GetFromEnvironment()); var message = "Done! I've saved your sick leave in SharePoint."; if (model.StillSick) { message += " Get well soon!"; } await context.PostAsync(message); return(model); }
public WebContentProvider(SharePointSettings sharePointSettings) { _SharePointSettings = sharePointSettings; }