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