public bool UpdateFarmSettings(SharePointFarmSettings settings)
{
try
{
return(VSWebDAL.SharePointSettingsDAL.Ins.UpdateFarmSettings(settings));
}
catch (Exception ex)
{
throw ex;
}
}
protected bool UpdateServersData()
{
SharePointFarmSettings settings = new SharePointFarmSettings();
settings.FarmName = FarmName;
settings.FileUploadTest = FileUploadTest.Checked;
settings.LogOnTest = LogonTest.Checked;
settings.SiteCreationTest = SiteCollectionCreationTest.Checked;
settings.TestAppURL = TestAppTextBox.Text;
return(VSWebBL.SharePointSettingsBL.Ins.UpdateFarmSettings(settings));
}
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);
}
