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