protected void Button1_Click(object sender, EventArgs e) { string message = ""; Hashtable Properties = intadmin.GetCurrentPageProperties(); SPSecurity.RunWithElevatedPrivileges(delegate() { if (intcore.TestModuleConnection(intadmin.ModuleID, intlistid, new Guid(Request["List"]), Properties, out message)) { lblError.Visible = false; Hashtable hshProps = new Hashtable(); if (Request["wizard"] == "1") { intadmin.CreateIntegration(Web.Site.ID, Web.ID, new Guid(Request["List"]), Guid.NewGuid().ToString("N") + Guid.NewGuid().ToString("N"), false, false, false, false); intadmin.SaveProperties(hshProps); SPUtility.Redirect("epmlive/integration/properties.aspx?intlistid=" + intadmin.intlistid + "&LIST=" + Request["List"] + "&wizard=1&ret=" + Request["ret"], SPRedirectFlags.RelativeToLayoutsPage, System.Web.HttpContext.Current); } else { SPList list = Web.Lists[new Guid(Request["List"])]; //intadmin.UpdateIntegration(intlistid, lblKey.Text, chkLout.Checked, chkLin.Checked, chkTout.Checked, chkTin.Checked); intadmin.SaveProperties(hshProps); intadmin.InstallEventHandlers(list); if (Request["ret"] == "Manage") { SPUtility.Redirect("epmlive/integration/manage.aspx", SPRedirectFlags.RelativeToLayoutsPage, System.Web.HttpContext.Current); } else { SPUtility.Redirect("epmlive/integration/integrationlist.aspx?LIST=" + Request["List"], SPRedirectFlags.RelativeToLayoutsPage, System.Web.HttpContext.Current); } } } else { lblError.Visible = true; lblError.Text = message; } }); }
protected void Button1_Click(object sender, EventArgs e) { string message = ""; SPSecurity.RunWithElevatedPrivileges(delegate() { if (intcore.TestModuleConnection(intadmin.ModuleID, intlistid, new Guid(Request["List"]), out message)) { lblError.Visible = false; Hashtable hshProps = new Hashtable(); hshProps.Add("AllowDeleteList", chkDeleteList.Checked.ToString()); hshProps.Add("AllowDeleteInt", chkDeleteInt.Checked.ToString()); hshProps.Add("AllowAddList", chkAddList.Checked.ToString()); hshProps.Add("AllowAddInt", chkAddInt.Checked.ToString()); intadmin.UpdateIntegration(intlistid, lblKey.Text, chkLout.Checked, chkLin.Checked, ddlTimed.SelectedValue == "out", ddlTimed.SelectedValue == "in"); intadmin.SaveProperties(hshProps); using (var connection = new SqlConnection(CoreFunctions.getConnectionString(Web.Site.WebApplication.Id))) { connection.Open(); using (var command = new SqlCommand("DELETE FROM TIMERJOBS WHERE listguid=@listid and jobtype=70 and [key]=@data", connection)) { command.Parameters.AddWithValue("@listid", Request["LIST"]); command.Parameters.AddWithValue("@data", Request["intlistid"]); command.ExecuteNonQuery(); } if (!string.IsNullOrWhiteSpace(ddlTimed.SelectedValue)) { var days = string.Empty; var stringBuilder = new StringBuilder(); var runtime = 0; if (ddlScheduleType.SelectedValue == "3") { runtime = int.Parse(ddlDayOfMonth.SelectedValue); } else if (ddlScheduleType.SelectedValue == "2") { runtime = int.Parse(ddlHour.SelectedValue); foreach (ListItem listItem in chkDayOfWeek.Items) { if (listItem.Selected) { stringBuilder.Append(",") .Append(listItem.Value); } } days = stringBuilder.ToString().Trim(','); } using (var command = new SqlCommand("INSERT INTO TIMERJOBS (jobname, siteguid, webguid, listguid, jobtype, runtime, scheduletype, days, [key]) VALUES ('Integration', @siteguid, @webguid, @listguid, 70, @runtime, @scheduletype, @days, @key)", connection)) { command.Parameters.AddWithValue("@siteguid", Web.Site.ID); command.Parameters.AddWithValue("@webguid", Web.ID); command.Parameters.AddWithValue("@listguid", Request["LIST"]); command.Parameters.AddWithValue("@runtime", runtime); command.Parameters.AddWithValue("@scheduletype", ddlScheduleType.SelectedValue); command.Parameters.AddWithValue("@days", days); command.Parameters.AddWithValue("@key", Request["intlistid"]); command.ExecuteNonQuery(); } } } if (Request["wizard"] == "1") { SPUtility.Redirect("epmlive/integration/columns.aspx?intlistid=" + intadmin.intlistid + "&LIST=" + Request["List"] + "&wizard=1&ret=" + Request["ret"], SPRedirectFlags.RelativeToLayoutsPage, System.Web.HttpContext.Current); } else { if (Request["ret"] == "Manage") { SPUtility.Redirect("epmlive/integration/manage.aspx", SPRedirectFlags.RelativeToLayoutsPage, System.Web.HttpContext.Current); } else { SPUtility.Redirect("epmlive/integration/integrationlist.aspx?LIST=" + Request["List"], SPRedirectFlags.RelativeToLayoutsPage, System.Web.HttpContext.Current); } } } else { lblError.Visible = true; lblError.Text = message; } }); }