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