public async Task <IActionResult> PutProjectRequirement(int id, ProjectRequirement requirement)
{
if (id != requirement.Id)
{
return(BadRequest());
}
_context.Entry(requirement).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProjectRequirementExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> CreateRequirement([FromBody] ProjectDetailsViewModel projectRequirement)
{
var user = await GetCurrentUserAsync();
var project = _context.Projects.Include(p => p.Updates).FirstOrDefault(x => x.Id == projectRequirement.ProjectId);
List <NotificationUser> notificationUsers = _context.ProjectUser.Where(x => x.ProjectId == projectRequirement.ProjectId).Select(u => new NotificationUser {
UserId = u.UserId
}).ToList();
ProjectRequirement requirement = new ProjectRequirement
{
Project = project,
Name = projectRequirement.RequirementName,
Description = projectRequirement.RequirementDescription,
Priority = projectRequirement.RequirementPriority,
Category = projectRequirement.RequirementCategory
};
ProjectUpdate projectUpdate = new ProjectUpdate
{
Title = "New Requirement Added",
Description = "'" + projectRequirement.RequirementName + "' was added.",
Date = DateTime.UtcNow,
Type = UpdateType.Add
};
project.Updates.Add(projectUpdate);
_context.Requirements.Add(requirement);
var requirementVm = _mapper.Map <RequirementViewModel>(requirement);
Notification notification = new Notification
{
Title = "A new requirement was added to " + project.Name,
Body = user.FirstName + " " + user.LastName + " added the following requirement to the " + project.Name + " project: " + requirementVm.Name + ".",
Type = UpdateType.Add,
Users = notificationUsers,
UserLink = user.Id,
ProjectLink = requirementVm.ProjectId,
DateTime = DateTime.Now
};
_context.Notifications.Add(notification);
await _context.SaveChangesAsync();
return(Ok(new UpdateReqResponse
{
Requirement = requirementVm
}));
}
public async Task <IActionResult> PutProjectRequirement([FromRoute] int id,
[FromBody] ProjectRequirement projectRequirement)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//if (id != projectRequirement.ProjectRequirementId)
//{
// return BadRequest();
//}
var editedRequirement = projectRequirement;
editedRequirement.CreatedUserId = 1;
editedRequirement.ProjectRequirementId = id;
editedRequirement.IsActive = true;
var workFlowId = projectRequirement.workFlowId;
var serviceWorkflow = _context.ServiceWorkflow.First(s => s.ServiceWorkflowId == workFlowId);
serviceWorkflow.NextStepId = 9;
_context.Entry(serviceWorkflow).State = EntityState.Modified;
_context.Entry(editedRequirement).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProjectRequirementExists(id))
{
return(NotFound());
}
throw;
}
return(NoContent());
}
public async Task <IActionResult> PostProjectRequirement([FromBody] ProjectRequirement projectRequirement)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
var editedRequirement = projectRequirement;
editedRequirement.CreatedUserId = 1;
var workFlowId = projectRequirement.workFlowId;
var serviceWorkflow = _context.ServiceWorkflow.First(s => s.ServiceWorkflowId == workFlowId);
serviceWorkflow.NextStepId = 9;
_context.Entry(serviceWorkflow).State = EntityState.Modified;
_context.ProjectRequirement.Add(editedRequirement);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetProjectRequirement", new { id = editedRequirement.ProjectRequirementId },
editedRequirement));
}
public async Task <ActionResult <ProjectRequirement> > PostProjectRequirement(ProjectRequirement requirement)
{
_context.ProjectRequirements.Add(requirement);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetProjectRequirement", new { id = requirement.Id }, requirement));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
IQueryable <ProjectRequirement> q = db.ProjectRequirements;
string filter = context.Request.Params.Get("project_id");
string install_type = context.Request.Params.Get("install_type");
string readOnly = context.Request.Params.Get("read_only");
if (isNull(readOnly))
{
return(new PagedData("read_only flag is expected"));
}
if (isNull(install_type))
{
return(new PagedData("install type is expected"));
}
if (readOnly == "true" && context.Request.RequestType != "GET")
{
return(new PagedData("Read Only"));
}
if (!isNull(filter))
{
q = q.Where(a => a.project_id == int.Parse(filter) && a.type.ToLower().Equals(install_type));
}
else
{
return(new PagedData("ProjectRequirements.ashx expects a project ID"));
}
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())));
switch (context.Request.RequestType)
{
case "GET":
{
return(new PagedData(q.Select(a => new { a.project_requirements_id, a.project_id, a.name, a.filename, a.notes, a.additional_notes, a.RequirementType.type })));
}
case "POST":
{
if (blob["rows"].GetType() == typeof(JObject))
{
JObject obj = (JObject)blob["rows"];
ProjectRequirement record = new ProjectRequirement();
record.project_id = int.Parse(filter);
record.type = install_type.ToLower();
if ((string)obj["name"] != null)
{
record.name = (string)obj["name"];
}
if ((string)obj["filename"] != null)
{
record.filename = (string)obj["filename"];
}
if ((string)obj["additional_notes"] != null)
{
record.additional_notes = (string)obj["additional_notes"];
}
if ((string)obj["notes"] != null)
{
record.notes = (string)obj["notes"];
}
db.ProjectRequirements.InsertOnSubmit(record);
db.SubmitChanges();
if ((string)obj["type"] != null && (string)obj["type"] != "")
{
return(new PagedData(new { record.project_requirements_id, record.project_id, record.name, record.filename, record.additional_notes, record.RequirementType.type, record.notes }));
}
else
{
String type = "";
return(new PagedData(new { record.project_requirements_id, record.project_id, record.name, record.filename, record.additional_notes, type, record.notes }));
}
}
JArray objs = (JArray)blob["rows"];
List <Object> returnList = new List <Object>();
for (int j = 0; j < objs.Count; j++)
{
ProjectRequirement record = new ProjectRequirement();
record.project_id = int.Parse(filter);
record.type = install_type.ToLower();
if ((string)objs[j]["name"] != null)
{
record.name = (string)objs[j]["name"];
}
if ((string)objs[j]["filename"] != null)
{
record.filename = (string)objs[j]["filename"];
}
if ((string)objs[j]["additional_notes"] != null)
{
record.additional_notes = (string)objs[j]["additional_notes"];
}
if ((string)objs[j]["notes"] != null)
{
record.notes = (string)objs[j]["notes"];
}
db.ProjectRequirements.InsertOnSubmit(record);
db.SubmitChanges();
if ((string)objs[j]["type"] != null && (string)objs[j]["type"] != "")
{
returnList.Add(new { record.project_requirements_id, record.project_id, record.name, record.filename, record.additional_notes, record.RequirementType.type, record.notes });
}
else
{
String type = "";
returnList.Add(new { record.project_requirements_id, record.project_id, record.name, record.filename, record.additional_notes, type, record.notes });
}
}
return(new PagedData(returnList));
}
case "PUT":
{
if (blob["rows"].GetType() == typeof(JObject))
{
JObject obj = (JObject)blob["rows"];
ProjectRequirement record = db.ProjectRequirements.Single(a => a.project_requirements_id.Equals((int)obj["project_requirements_id"]));
//record.project_id = int.Parse(filter);
if ((string)obj["name"] != null)
{
record.name = (string)obj["name"];
}
if ((string)obj["filename"] != null)
{
record.filename = (string)obj["filename"];
}
if ((string)obj["additional_notes"] != null)
{
record.additional_notes = (string)obj["additional_notes"];
}
if ((string)obj["type"] != null && (string)obj["type"] != "")
{
record.requirement_type_id = (db.RequirementTypes.Single(a => a.type.Equals((string)obj["type"]))).requirement_type_id;
}
if ((string)obj["notes"] != null)
{
record.notes = (string)obj["notes"];
}
db.SubmitChanges();
if ((string)obj["type"] != null && (string)obj["type"] != "")
{
return(new PagedData(new { record.project_requirements_id, record.project_id, record.name, record.filename, record.additional_notes, record.RequirementType.type, record.notes }));
}
else
{
String type = "";
return(new PagedData(new { record.project_requirements_id, record.project_id, record.name, record.filename, record.additional_notes, type, record.notes }));
}
}
JArray objs = (JArray)blob["rows"];
List <Object> returnList = new List <Object>();
for (int j = 0; j < objs.Count; j++)
{
ProjectRequirement record = db.ProjectRequirements.Single(a => a.project_requirements_id.Equals((int)objs[j]["project_requirements_id"]));
//record.project_id = int.Parse(filter);
if ((string)objs[j]["name"] != null)
{
record.name = (string)objs[j]["name"];
}
if ((string)objs[j]["filename"] != null)
{
record.filename = (string)objs[j]["filename"];
}
if ((string)objs[j]["additional_notes"] != null)
{
record.additional_notes = (string)objs[j]["additional_notes"];
}
if ((string)objs[j]["type"] != null && (string)objs[j]["type"] != "")
{
record.requirement_type_id = (db.RequirementTypes.Single(a => a.type.Equals((string)objs[j]["type"]))).requirement_type_id;
}
if ((string)objs[j]["notes"] != null)
{
record.notes = (string)objs[j]["notes"];
}
db.SubmitChanges();
if ((string)objs[j]["type"] != null && (string)objs[j]["type"] != "")
{
returnList.Add(new { record.project_requirements_id, record.project_id, record.name, record.filename, record.additional_notes, record.RequirementType.type, record.notes });
}
else
{
String type = "";
returnList.Add(new { record.project_requirements_id, record.project_id, record.name, record.filename, record.additional_notes, type, record.notes });
}
}
return(new PagedData(returnList));
}
case "DELETE":
{
if (blob["rows"].GetType() == typeof(JObject))
{
JObject obj = (JObject)blob["rows"];
ProjectRequirement record = db.ProjectRequirements.Single(a => a.project_requirements_id.Equals((int)obj["project_requirements_id"]));
db.ProjectRequirements.DeleteOnSubmit(record);
db.SubmitChanges();
return(new PagedData("good"));
}
JArray objs = (JArray)blob["rows"];
for (int j = 0; j < objs.Count; j++)
{
ProjectRequirement record = db.ProjectRequirements.Single(a => a.project_requirements_id.Equals((int)objs[j]["project_requirements_id"]));
db.ProjectRequirements.DeleteOnSubmit(record);
}
db.SubmitChanges();
return(new PagedData("ProjectRequirements deleted"));
}
default:
return(new PagedData("Unsupported Http Request: " + context.Request.RequestType + " not recognized"));
}
}
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 incomingProjectName = (string)(reader.ReadToEnd());
string filter = context.Request.Params.Get("project_id");
string install_type = context.Request.Params.Get("install_type");
if (!isNull(filter))
{
if (isNull(install_type))
{
return(new PagedData("no install type submitted"));
}
else
{
switch (install_type)
{
case ("uat"):
{
if (db.ProjectRequirements.Count(a => a.project_id.Equals(int.Parse(filter)) && a.type.ToLower().Equals("uat")) > 0)
{
var wiping = db.ProjectRequirements.Where(a => a.project_id.Equals(int.Parse(filter)) && a.type.ToLower().Equals("uat"));
db.ProjectRequirements.DeleteAllOnSubmit(wiping);
db.SubmitChanges();
comment += "[Project ID: " + int.Parse(filter) + " type:" + install_type + " cleared]";
}
break;
}
case ("prod"):
{
if (db.ProjectRequirements.Count(a => a.project_id.Equals(int.Parse(filter)) && a.type.ToLower().Equals("prod")) > 0)
{
var wiping = db.ProjectRequirements.Where(a => a.project_id.Equals(int.Parse(filter)) && a.type.ToLower().Equals("prod"));
db.ProjectRequirements.DeleteAllOnSubmit(wiping);
db.SubmitChanges();
comment += "[Project ID: " + int.Parse(filter) + " type:" + install_type + " cleared]";
}
break;
}
case ("soak"):
{
if (db.ProjectRequirements.Count(a => a.project_id.Equals(int.Parse(filter)) && a.type.ToLower().Equals("soak")) > 0)
{
var wiping = db.ProjectRequirements.Where(a => a.project_id.Equals(int.Parse(filter)) && a.type.ToLower().Equals("soak"));
db.ProjectRequirements.DeleteAllOnSubmit(wiping);
db.SubmitChanges();
comment += "[Project ID: " + int.Parse(filter) + " type:" + install_type + " cleared]";
}
break;
}
default:
return(new PagedData("no valid install type submitted"));
}
}
try
{
//application
if (db.ApplicationReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.ApplicationReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].app_file != null && allTheReqs[i].app_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].app_file;
newReq.name = allTheReqs[i].app_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Application"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].rpt_file != null && allTheReqs[i].rpt_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].rpt_file;
newReq.name = allTheReqs[i].rpt_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Application"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].prm_file != null && allTheReqs[i].prm_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].prm_file;
newReq.name = allTheReqs[i].prm_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Application"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].prm_instructions != null && allTheReqs[i].prm_instructions != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].prm_instructions;
newReq.name = allTheReqs[i].prm_instructions;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Application"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//table
if (db.TableReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.TableReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].xls_csv_file != null && allTheReqs[i].xls_csv_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].xls_csv_file;
newReq.name = allTheReqs[i].xls_csv_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Table"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].def_file != null && allTheReqs[i].def_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].def_file;
newReq.name = allTheReqs[i].def_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Table"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].etm_file != null && allTheReqs[i].etm_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].etm_file;
newReq.name = allTheReqs[i].etm_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Table"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//routing
if (db.RequirementsTabRoutingRequirements.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.RequirementsTabRoutingRequirements.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].description != null && allTheReqs[i].description != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].description;
newReq.name = allTheReqs[i].description;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Routing"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//scraper
if (db.ScraperReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.ScraperReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].exe_file != null && allTheReqs[i].exe_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].exe_file;
newReq.name = allTheReqs[i].exe_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Scraper"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].pdb_file != null && allTheReqs[i].pdb_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].pdb_file;
newReq.name = allTheReqs[i].pdb_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Scraper"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//engine
if (db.EngineReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.EngineReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].exe_file != null && allTheReqs[i].exe_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].exe_file;
newReq.name = allTheReqs[i].exe_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Engine"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].pdb_file != null && allTheReqs[i].pdb_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].pdb_file;
newReq.name = allTheReqs[i].pdb_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Engine"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//manager
if (db.ManagerReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.ManagerReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].exe_file != null && allTheReqs[i].exe_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].exe_file;
newReq.name = allTheReqs[i].exe_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Manager"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].pdb_file != null && allTheReqs[i].pdb_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].pdb_file;
newReq.name = allTheReqs[i].pdb_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Manager"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//grammar
if (db.GrammarReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.GrammarReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].filename != null && allTheReqs[i].filename != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].filename;
newReq.name = allTheReqs[i].filename;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Grammar"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//vxml
if (db.VXMLReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.VXMLReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].description != null && allTheReqs[i].description != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].description;
newReq.name = allTheReqs[i].description;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("VXML"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//backoffice DB
if (db.BackofficeDBReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.BackofficeDBReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].sql_file != null && allTheReqs[i].sql_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].sql_file;
newReq.name = allTheReqs[i].sql_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Backoffice DB"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//backoffice process
if (db.BackofficeProcessReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.BackofficeProcessReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].exe_file != null && allTheReqs[i].exe_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].exe_file;
newReq.name = allTheReqs[i].exe_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Backoffice Process"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//backoffice webservice
if (db.BackofficeWebserviceReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.BackofficeWebserviceReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].war_file != null && allTheReqs[i].war_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].war_file;
newReq.name = allTheReqs[i].war_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Backoffice Webservice"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].tar_file != null && allTheReqs[i].tar_file != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].tar_file;
newReq.name = allTheReqs[i].tar_file;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Backoffice Webservice"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//configuration file
if (db.ConfigFileReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.ConfigFileReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].filename != null && allTheReqs[i].filename != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].filename;
newReq.name = allTheReqs[i].filename;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Configuration File"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].instructions != null && allTheReqs[i].instructions != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].instructions;
newReq.name = allTheReqs[i].instructions;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Configuration File"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//fax form
if (db.FaxFormReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.FaxFormReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].filename != null && allTheReqs[i].filename != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].filename;
newReq.name = allTheReqs[i].filename;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Fax Form"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].instructions != null && allTheReqs[i].instructions != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].instructions;
newReq.name = allTheReqs[i].instructions;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Fax Form"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//file xfer upload/download
if (db.FileXferReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.FileXferReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].name != null && allTheReqs[i].name != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].name;
newReq.name = allTheReqs[i].name;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("File Xfer"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//tts functionality
if (db.TTSFunctionalityReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.TTSFunctionalityReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].call_volume != null && allTheReqs[i].call_volume != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].call_volume;
newReq.name = allTheReqs[i].call_volume;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("TTS Functionality"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//tnt functionality
if (db.TNTFunctionalityReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.TNTFunctionalityReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].call_volume != null && allTheReqs[i].call_volume != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].call_volume;
newReq.name = allTheReqs[i].call_volume;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("TNT Functionality"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//speech recognition
if (db.SpeechRecognitionReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.SpeechRecognitionReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].call_volume != null && allTheReqs[i].call_volume != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].call_volume;
newReq.name = allTheReqs[i].call_volume;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Speech Recognition"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//uui
if (db.UUIReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.UUIReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].call_volume != null && allTheReqs[i].call_volume != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].call_volume;
newReq.name = allTheReqs[i].call_volume;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("UUI"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//service id
if (db.ServiceIDReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.ServiceIDReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].product != null && allTheReqs[i].product != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].product;
newReq.name = allTheReqs[i].product;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Service ID"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
if (allTheReqs[i].service_id != null && allTheReqs[i].service_id != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].service_id;
newReq.name = allTheReqs[i].service_id;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Service ID"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
//other
if (db.OtherReqs.Count(a => a.project_id.Equals(int.Parse(filter))) > 0)
{
var allTheReqs = db.OtherReqs.Where(a => a.project_id.Equals(int.Parse(filter))).ToList();
for (int i = 0; i < allTheReqs.Count(); i++)
{
if (allTheReqs[i].misc != null && allTheReqs[i].misc != "")
{
ProjectRequirement newReq = new ProjectRequirement();
newReq.type = install_type;
newReq.project_id = int.Parse(filter);
newReq.filename = allTheReqs[i].misc;
newReq.name = allTheReqs[i].misc;
newReq.RequirementType = db.RequirementTypes.Single(a => a.type.Equals("Other"));
db.ProjectRequirements.InsertOnSubmit(newReq);
}
}
}
}
catch (Exception e)
{
return(new PagedData("Error: please show cookbook admin this screen: " + e.Message + "|" + e.Source + "|" + e.StackTrace + "|" + e.InnerException));
}
db.SubmitChanges();
return(new PagedData("success! " + comment));
}
return(new PagedData("no proj id submitted"));
}
