public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { string project_id = context.Request.Params.Get("project_id"); if (!isNull(project_id)) { string type = context.Request.Params.Get("install_type"); if (!isNull(type)) { StagingFolder record = new StagingFolder(); record.folder = ""; record.notes = ""; record.project_id = int.Parse(project_id); //record.is_buffet = type.Equals(1) ? true : false; record.type = type; db.StagingFolders.InsertOnSubmit(record); db.SubmitChanges(); return(new PagedData(new { record.staging_folder_id })); } return(new PagedData("AddStagingFolder.ashx requires a type")); } return(new PagedData("AddStagingFolder.ashx requires a project_id")); }
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { string project_id = context.Request.Params.Get("project_id"); if (!isNull(project_id)) { string staging_folder_id = context.Request.Params.Get("staging_folder_id"); if (!isNull(staging_folder_id)) { StagingFolder record = db.StagingFolders.Single(a => a.staging_folder_id.Equals(staging_folder_id)); db.StagingFolders.DeleteOnSubmit(record); db.SubmitChanges(); return(new PagedData("Staging folder deleted")); } return(new PagedData("RemoveStagingFolder.ashx requires a staging_folder_id")); } return(new PagedData("RemoveStagingFolder.ashx requires a project_id")); }
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { System.IO.StreamReader reader = new System.IO.StreamReader(context.Request.InputStream, context.Request.ContentEncoding); var jsonSerializer = new JsonSerializer(); JObject blob = (JObject)jsonSerializer.Deserialize(new JsonTextReader(new StringReader(reader.ReadToEnd()))); string filter = context.Request.Params.Get("project_id"); if (!isNull(filter)) { try { //check to see if there already is a prod installation buffet entry with this project id if (db.ProdInstallationBuffets.Count(a => a.project_id.Equals(int.Parse(filter))) > 0) { var wiping = db.ProdInstallationBuffets.Where(a => a.project_id.Equals(int.Parse(filter))); db.ProdInstallationBuffets.DeleteAllOnSubmit(wiping); db.SubmitChanges(); } ProdInstallationBuffet newEntry = new ProdInstallationBuffet(); newEntry.project_id = int.Parse(filter); if (blob["viewBuffetProdInstallDate"] != null) { newEntry.date = (string)blob["viewBuffetProdInstallDate"]; } if (blob["viewBuffetProdInstallConferenceStart"] != null) { newEntry.conference_start = (string)blob["viewBuffetProdInstallConferenceStart"]; } if (blob["viewBuffetProdInstallConferenceBridge"] != null) { newEntry.conference_bridge = (string)blob["viewBuffetProdInstallConferenceBridge"]; } if (blob["buffetprodinstallNodes"] != null) { if (blob["buffetprodinstallNodes"].Type.ToString().Equals("String")) { newEntry.nodes = (string)blob["buffetprodinstallNodes"]; } else { JArray nodes = (JArray)blob["buffetprodinstallNodes"]; if (nodes.Count > 0) { for (int i = 0; i < blob["buffetprodinstallNodes"].Count(); i++) { newEntry.nodes += (string)blob["buffetprodinstallNodes"][i] + ", "; } newEntry.nodes = newEntry.nodes.Substring(0, newEntry.nodes.Length - 2); } } } if (blob["buffetprodinstallComments"] != null) { newEntry.comments = (string)blob["buffetprodinstallComments"]; } if (blob["viewBuffetProdInstallPostMaintenanceMasterProject"] != null) { if (blob["viewBuffetProdInstallPostMaintenanceMasterProject"].Type.ToString().Equals("String")) { //SINGLE INSTANCE newEntry.post_maintenance_notification = (string)blob["viewBuffetProdInstallPostMaintenanceMasterProject"]; } else { //ARRAY OF EMAILS JArray emails = (JArray)blob["viewBuffetProdInstallPostMaintenanceMasterProject"]; if (emails.Count > 0) { for (int i = 0; i < emails.Count; i++) { newEntry.post_maintenance_notification += (string)emails[i] + "; "; } newEntry.post_maintenance_notification = newEntry.post_maintenance_notification.Substring(0, newEntry.post_maintenance_notification.Length - 2); } } } db.ProdInstallationBuffets.InsertOnSubmit(newEntry); db.SubmitChanges(); } catch (Exception e) { return(new PagedData("Error: " + e.Message + e.Source + e.StackTrace + e.TargetSite + e.InnerException + e.HelpLink)); } try { //Staging Folders if (blob["buffetProdInstallStagingFolderLink"] != null) { var wipingStaging = db.StagingFolders.Where(a => a.project_id.Equals(int.Parse(filter)) && a.is_buffet.Equals(true)); db.StagingFolders.DeleteAllOnSubmit(wipingStaging); db.SubmitChanges(); if (blob["buffetProdInstallStagingFolderLink"].Type.ToString().Equals("String")) { StagingFolder newStagingEntry = new StagingFolder(); newStagingEntry.project_id = int.Parse(filter); newStagingEntry.is_buffet = true; newStagingEntry.folder = (string)blob["buffetProdInstallStagingFolderLink"]; if (blob["buffetProdInstallStagingNotes"] != null) { newStagingEntry.notes = (string)blob["buffetProdInstallStagingNotes"]; } db.StagingFolders.InsertOnSubmit(newStagingEntry); db.SubmitChanges(); } else { for (int i = 0; i < blob["buffetProdInstallStagingFolderLink"].Count(); i++) { StagingFolder newStagingEntry = new StagingFolder(); newStagingEntry.project_id = int.Parse(filter); newStagingEntry.is_buffet = true; newStagingEntry.folder = (string)blob["buffetProdInstallStagingFolderLink"][i]; if (blob["buffetProdInstallStagingNotes"][i] != null) { newStagingEntry.notes = (string)blob["buffetProdInstallStagingNotes"][i]; } db.StagingFolders.InsertOnSubmit(newStagingEntry); } db.SubmitChanges(); } } else { try { var wipingStaging = db.StagingFolders.Where(a => a.project_id.Equals(int.Parse(filter)) && a.is_buffet.Equals(true)); db.StagingFolders.DeleteAllOnSubmit(wipingStaging); db.SubmitChanges(); } catch (Exception e) { comment += "[Exception caught when removing existing staging folders: " + e.Message + "]"; } comment += ("[No Staging Folders Submitted]"); } } catch (Exception e) { return(new PagedData("Error: " + e.Message + e.Source + e.StackTrace + e.TargetSite + e.InnerException + e.HelpLink)); } } return(new PagedData("success! " + comment)); }
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db) { System.IO.StreamReader reader = new System.IO.StreamReader(context.Request.InputStream, context.Request.ContentEncoding); var jsonSerializer = new JsonSerializer(); JObject blob = (JObject)jsonSerializer.Deserialize(new JsonTextReader(new StringReader(reader.ReadToEnd()))); string comments = "comments: "; string filter = context.Request.Params.Get("project_id"); //string panelHeaders = context.Request.Params.Get("panel_headers"); if (!isNull(filter)) { try { UatProdInstall currProjUATInfo = db.UatProdInstalls.Single(a => a.project_id.Equals(int.Parse(filter))); //UAT Install Details currProjUATInfo.uat_install_date = processRecord(blob["uatprodinstallUATInstallDate"]); currProjUATInfo.uat_install_node = processRecord(blob["uatprodinstallUATInstallNodes"]); currProjUATInfo.uat_install_comments = processRecord(blob["uatprodinstallUATInstallComments"]); if (blob["uatInstallDetailsStagingFolderId"] != null) { if (blob["uatInstallDetailsStagingFolderId"].GetType() == typeof(JValue)) { StagingFolder link = db.StagingFolders.Single(a => a.staging_folder_id.Equals((String)blob["uatInstallDetailsStagingFolderId"])); link.folder = (String)blob["uatInstallStagingFolderLink"]; link.notes = (String)blob["uatInstallStagingFolderNotes"]; } else { for (int i = 0; i < ((JArray)blob["uatInstallDetailsStagingFolderId"]).Count; i++) { StagingFolder link = db.StagingFolders.Single(a => a.staging_folder_id.Equals((String)((JArray)blob["uatInstallDetailsStagingFolderId"])[i])); link.folder = (String)((JArray)blob["uatInstallStagingFolderLink"])[i]; link.notes = (String)((JArray)blob["uatInstallStagingFolderNotes"])[i]; } } } //PROD Install Details currProjUATInfo.uat_date = processRecord(blob["uatprodinstallUatDate"]); currProjUATInfo.uat_node = processRecord(blob["uatprodinstallUatNode"]); currProjUATInfo.uat_usan_ccr = processRecord(blob["uatprodinstallUatUsanCCR"]); currProjUATInfo.uat_ccr = processRecord(blob["uatprodinstallUatCCR"]); currProjUATInfo.uat_maintenance_start = processRecord(blob["uatprodinstallUatMaintenanceStart"]); currProjUATInfo.uat_conference_start = processRecord(blob["uatprodinstallUatConferenceStart"]); currProjUATInfo.uat_conference_bridge = processRecord(blob["uatprodinstallUatConferenceBridge"]); currProjUATInfo.prod_post_install_notification = processRecord(blob["uatprodinstallProductionPostInstallNotification"]); currProjUATInfo.prod_install_comments = processRecord(blob["uatprodinstallProdInstallComments"]); if (blob["productionInstallDetailsStagingFolderId"] != null) { if (blob["productionInstallDetailsStagingFolderId"].GetType() == typeof(JValue)) { StagingFolder link = db.StagingFolders.Single(a => a.staging_folder_id.Equals((String)blob["productionInstallDetailsStagingFolderId"])); link.folder = (String)blob["productionInstallStagingFolderLink"]; link.notes = (String)blob["productionInstallStagingFolderNotes"]; } else { for (int i = 0; i < ((JArray)blob["productionInstallDetailsStagingFolderId"]).Count; i++) { StagingFolder link = db.StagingFolders.Single(a => a.staging_folder_id.Equals((String)((JArray)blob["productionInstallDetailsStagingFolderId"])[i])); link.folder = (String)((JArray)blob["productionInstallStagingFolderLink"])[i]; link.notes = (String)((JArray)blob["productionInstallStagingFolderNotes"])[i]; } } } //SOAK Install Details //panel 1 - SCU currProjUATInfo.scu_date = processRecord(blob["uatprodinstallSoakPanel1Date"]); currProjUATInfo.scu_node = processRecord(blob["uatprodinstallSoakPanel1Node"]); currProjUATInfo.scu_usan_ccr = processRecord(blob["uatprodinstallSoakPanel1UsanCCR"]); currProjUATInfo.scu_ccr = processRecord(blob["uatprodinstallSoakPanel1CCR"]); currProjUATInfo.scu_maintenance_start = processRecord(blob["uatprodinstallSoakPanel1MaintenanceStart"]); currProjUATInfo.column1 = processRecord(blob["uatProdInstallSoakPanel1Hidden"]); //panel 2 - WOR currProjUATInfo.wor_date = processRecord(blob["uatprodinstallSoakPanel2Date"]); currProjUATInfo.wor_node = processRecord(blob["uatprodinstallSoakPanel2Node"]); currProjUATInfo.wor_usan_ccr = processRecord(blob["uatprodinstallSoakPanel2UsanCCR"]); currProjUATInfo.wor_ccr = processRecord(blob["uatprodinstallSoakPanel2CCR"]); currProjUATInfo.wor_maintenance_start = processRecord(blob["uatprodinstallSoakPanel2MaintenanceStart"]); currProjUATInfo.column2 = processRecord(blob["uatProdInstallSoakPanel2Hidden"]); //panel 3 - CPZ currProjUATInfo.cpz_date = processRecord(blob["uatprodinstallSoakPanel3Date"]); currProjUATInfo.cpz_node = processRecord(blob["uatprodinstallSoakPanel3Node"]); currProjUATInfo.cpz_usan_ccr = processRecord(blob["uatprodinstallSoakPanel3UsanCCR"]); currProjUATInfo.cpz_ccr = processRecord(blob["uatprodinstallSoakPanel3CCR"]); currProjUATInfo.cpz_maintenance_start = processRecord(blob["uatprodinstallSoakPanel3MaintenanceStart"]); currProjUATInfo.column3 = processRecord(blob["uatProdInstallSoakPanel3Hidden"]); //panel 4 - Prod currProjUATInfo.prod_date = processRecord(blob["uatprodinstallSoakPanel4Date"]); currProjUATInfo.prod_node = processRecord(blob["uatprodinstallSoakPanel4Node"]); currProjUATInfo.prod_usan_ccr = processRecord(blob["uatprodinstallSoakPanel4UsanCCR"]); currProjUATInfo.prod_ccr = processRecord(blob["uatprodinstallSoakPanel4CCR"]); currProjUATInfo.prod_maintenance_start = processRecord(blob["uatprodinstallSoakPanel4MaintenanceStart"]); currProjUATInfo.column4 = processRecord(blob["uatProdInstallSoakPanel4Hidden"]); currProjUATInfo.post_install_notification = processRecord(blob["uatprodinstallSoakPostInstallNotification"]); currProjUATInfo.comments = processRecord(blob["uatprodinstallSoakInstallComments"]); if (blob["soakInstallDetailsStagingFolderId"] != null) { if (blob["soakInstallDetailsStagingFolderId"].GetType() == typeof(JValue)) { StagingFolder link = db.StagingFolders.Single(a => a.staging_folder_id.Equals((String)blob["soakInstallDetailsStagingFolderId"])); link.folder = (String)blob["soakInstallStagingFolderLink"]; link.notes = (String)blob["soakInstallStagingFolderNotes"]; } else { for (int i = 0; i < ((JArray)blob["soakInstallDetailsStagingFolderId"]).Count; i++) { StagingFolder link = db.StagingFolders.Single(a => a.staging_folder_id.Equals((String)((JArray)blob["soakInstallDetailsStagingFolderId"])[i])); link.folder = (String)((JArray)blob["soakInstallStagingFolderLink"])[i]; link.notes = (String)((JArray)blob["soakInstallStagingFolderNotes"])[i]; } } } db.SubmitChanges(); } catch (Exception e) { return(new PagedData("Error: Please show Cookbook Admin! " + e.ToString())); } return(new PagedData("Uat Prod Install saved. " + comments)); } return(new PagedData("UpdateUatProdInstall.ashx required a project_id")); }