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())));
if (!(db.ProjectInformations.Count(c => c.project_id == (int)blob["project_id"]) > 0))
{
return(new PagedData("UpdateProjectStatus.ashx requires a valid project ID"));
}
if (db.StatusTypes.Count(a => a.type.Equals((string)blob["type"])) > 0)
{
ProjectStatus status = new ProjectStatus();
status.project_id = (int)blob["project_id"];
status.date = (string)blob["date"];
status.status_type_id = db.StatusTypes.Single(a => a.type.Equals((string)blob["type"])).status_type_id;
db.ProjectStatus.InsertOnSubmit(status);
db.SubmitChanges();
//update project histories
ProjectHistory history = new ProjectHistory();
history.project_id = (int)blob["project_id"];
history.user_name = (string)blob["name"];
history.date = (string)blob["date"];
history.description = "Project status changed to \"" + db.StatusTypes.Single(a => a.type.Equals((string)blob["type"])).type + "\"";
history.status_id = status.project_status_id;
db.ProjectHistories.InsertOnSubmit(history);
db.SubmitChanges();
//update current_project_status
var currProject = db.ProjectInformations.Single(a => a.project_id.Equals((int)blob["project_id"]));
currProject.current_project_status = (string)blob["type"];
db.SubmitChanges();
return(new PagedData("ProjectStatus and ProjectHistory updated", true));
}
else
{
return(new PagedData("Error: Status not found. Please enter status via Status Editor or select an available status.", false));
}
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call RemoveDeliveryFormat.ashx without parameters"));
}
if (context.Request.Params.Get("format") == null)
{
return(new PagedData("Format is null"));
}
DeliveryFormat name = db.DeliveryFormats.Single(a => a.format.Equals(context.Request.Params.Get("format")));
db.DeliveryFormats.DeleteOnSubmit(name);
db.SubmitChanges();
return(new PagedData(""));
}
public override string SetProperty(CookDBDataContext db, string prop, string value)
{
string msg = prop + ": ";
if (prop.Equals("contact_id"))
{
if (!DatabaseHandler.isNull(value))
{
int cid = int.Parse(value);
if (cid != this.contact_id)
{
msg += (this.Contact != null ? this.Contact.contact_name : "") + " -> "
+ Contact.getContactName(db, cid);
this.contact_id = cid;
}
}
}
return(msg);
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call RemoveGrammar.ashx without parameters"));
}
if (context.Request.Params.Get("name") == null)
{
return(new PagedData("Name is null"));
}
Grammar gram = db.Grammars.Single(a => a.name.Equals(context.Request.Params.Get("name")));
db.Grammars.DeleteOnSubmit(gram);
db.SubmitChanges();
return(new PagedData(""));
}
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");
string username = context.Request.Params.Get("user_name");
if (!isNull(filter))
{
/*
* Begin: QA Total Hours added 2-1-13
*/
if (blob["submittedTotalQAHours"] != null)
{
var currentRec = db.SWDSchedules.Single(a => a.project_id.Equals(int.Parse(filter)));
currentRec.total_qa_hours = (string)blob["submittedTotalQAHours"];
db.SubmitChanges();
}
/*
* Begin: Comments Area
*/
if (blob["qaCommentsArea"] != null)
{
var oldComments = db.SWDSchedules.Single(a => a.project_id.Equals(int.Parse(filter)));
oldComments.qa_comments = (string)blob["qaCommentsArea"];
db.SubmitChanges();
}
return(new PagedData("UpdateQAPage successfully updated|" + comment));
}
else
{
return(new PagedData("UpdateQAPage expects a project id"));
}
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
IQueryable <GMVoicePromptDetail> q = db.GMVoicePromptDetails;
string filter = context.Request.Params.Get("project_id");
if (!isNull(filter))
{
q = q.Where(a => a.project_id == int.Parse(filter));
return(new PagedData(q.Select(a => new
{
a.project_id,
a.language,
a.prompts_recorded,
a.prompts_billed,
a.prompts_provided,
a.min_fee,
a.num_words,
a.order_type,
a.recording_sessions,
a.recording_studio,
a.prompts_converted,
a.conversion_sessions,
a.prompts_digitized,
a.fee_required,
a.cd_required,
a.cd_mailing_address,
a.prompt_format,
a.converted_prompt_format,
a.needs_approval,
a.setup_fee,
a.recording1_fee,
a.recording3_fee,
a.translation_fee,
a.delivery_fee,
a.total_recording_fee
})));
}
return(new PagedData("GetGMVoicePromptDetails expects 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);
IQueryable <ProjectInformation> q = db.ProjectInformations;
var jsonSerializer = new JsonSerializer();
String blob = (String)jsonSerializer.Deserialize(new JsonTextReader(new StringReader(reader.ReadToEnd())));
String[] projectsToFind = blob.Split('|');
List <ProjectReports> returnProjects = new List <ProjectReports>
{
};
foreach (string currentCriteria in projectsToFind)
{
returnProjects = getRecords(returnProjects, currentCriteria, db);
}
return(new PagedData(returnProjects, true));
}
//2nd group of parsing methods for just doing email
public string parseEmailString(String incString, CookDBDataContext db, string filter)
{
//contacts
incString = findContactEmail(incString, "[USANDevPM]", "USAN Dev PM", db, filter);
incString = findContactEmail(incString, "[USANTC]", "USAN TC", db, filter);
incString = findContactEmail(incString, "[USANBA]", "USAN BA", db, filter);
incString = findContactEmail(incString, "[USANDeveloper]", "USAN Developer", db, filter);
incString = findContactEmail(incString, "[USANMIS]", "USAN MIS", db, filter);
incString = findContactEmail(incString, "[USANQA]", "USAN QA", db, filter);
incString = findContactEmail(incString, "[USANOpsPM]", "USAN Ops PM", db, filter);
incString = findContactEmail(incString, "[USANTLSIP]", "USAN TLS-IP", db, filter);
incString = findContactEmail(incString, "[USANTLSSaaS]", "USAN TLS-SaaS", db, filter);
incString = findContactEmail(incString, "[USANSystemsEngineer]", "USAN Systems Engineer", db, filter);
incString = findContactEmail(incString, "[CustomerPM]", "Customer PM", db, filter);
incString = findContactEmail(incString, "[CustomerRFQ]", "Customer RFQ", db, filter);
incString = findContactEmail(incString, "[CustomerTC]", "Customer TC", db, filter);
incString = findContactEmail(incString, "[CustomerHost]", "Customer Host", db, filter);
incString = findContactEmail(incString, "[CustomerTesting]", "Customer Testing", db, filter);
return(incString);
}
public static IQueryable <ProjectContact> getContactsFromRequest(CookDBDataContext db, HttpRequest req)
{
IQueryable <ProjectContact> q = db.ProjectContacts;
if (!DatabaseHandler.isNull(req.Params.Get("project_id")))
{
q = q.Where(a => a.project_id == int.Parse(req.Params.Get("project_id")));
}
if (!DatabaseHandler.isNull(req.Params.Get("contact_id")))
{
q = q.Where(a => a.contact_id == int.Parse(req.Params.Get("contact_id")));
}
if (!DatabaseHandler.isNull(req.Params.Get("contact_type")))
{
q = q.Where(a => a.contact_type == int.Parse(req.Params.Get("contact_type")));
}
return(q);
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
string project_id = context.Request.Params.Get("project_id");
if (!isNull(project_id))
{
string assessment_id = context.Request.Params.Get("assessment_id");
if (!isNull(assessment_id))
{
AccessUSANReq record = db.AccessUSANReqs.Single(a => a.accessusan_req_id.Equals(assessment_id));
db.AccessUSANReqs.DeleteOnSubmit(record);
db.SubmitChanges();
return new PagedData("AccessUSANAssessment deleted");
}
return new PagedData("RemoveAccessUSANAssessment.ashx requires an assessment_id");
}
return new PagedData("RemoveAccessUSANAssessment.ashx requires a project_id");
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddCompany.ashx without parameters"));
}
if (context.Request.Params.Get("company_name") == null)
{
return(new PagedData("Company is null"));
}
Company company = new Company();
company.company_name = context.Request.Params.Get("company_name");
db.Companies.InsertOnSubmit(company);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddStatusType.ashx without parameters"));
}
if (context.Request.Params.Get("type") == null)
{
return(new PagedData("Type is null"));
}
StatusType type = new StatusType();
type.type = context.Request.Params.Get("type");
db.StatusTypes.InsertOnSubmit(type);
db.SubmitChanges();
return(new PagedData(""));
}
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");
if (!isNull(filter))
{
var wiping = db.LinkedProjects.Where(a => a.project_id.Equals(int.Parse(filter)));
db.LinkedProjects.DeleteAllOnSubmit(wiping);
db.SubmitChanges();
comment += "[Project ID: " + int.Parse(filter) + " cleared]";
return(new PagedData("success! " + comment));
}
return(new PagedData("no proj id submitted"));
}
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)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddFaxForm.ashx without parameters"));
}
if (context.Request.Params.Get("name") == null)
{
return(new PagedData("Name is null"));
}
FaxForm ff = new FaxForm();
ff.name = context.Request.Params.Get("name");
db.FaxForms.InsertOnSubmit(ff);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
IQueryable <RoutingRequirement> q = db.RoutingRequirements;
//one-time script
/*List<RoutingRequirement> adds = db.RoutingRequirements.Where(a => a.remove_from.Equals(null) && a.route_to.Length > 1).ToList<RoutingRequirement>();
* for (int i = 0; i < adds.Count(); i++ )
* {
* adds[i].type = "add";
* }
*
* List<RoutingRequirement> changes = db.RoutingRequirements.Where(a => a.remove_from.Length > 1 && a.route_to.Length > 1).ToList<RoutingRequirement>();
* for (int i = 0; i < changes.Count(); i++)
* {
* changes[i].type = "change";
* }
*
* List<RoutingRequirement> deletes = db.RoutingRequirements.Where(a => a.remove_from.Length > 1 && a.route_to.Equals(null)).ToList<RoutingRequirement>();
* for (int i = 0; i < deletes.Count(); i++)
* {
* deletes[i].type = "remove";
* }
* db.SubmitChanges();*/
string filter = context.Request.Params.Get("project_id");
if (!isNull(filter))
{
int id = int.Parse(filter);
q = q.Where(a => a.project_id.Equals(id));
return(new PagedData(q.Select(a => new { a.routing_requirements_id, a.dnis, a.route_to, a.remove_from, a.platform, a.description, a.platform_from, a.usan_date, a.usan_time, a.dnis_date, a.dnis_time, a.carrier_date, a.carrier_time, a.alias, a.type })));
}
return(new PagedData(q.Select(a => new { a.project_id, a.dnis })));
//return new PagedData("GetRoutingRequirements expects a project_id");
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddFileXferDownload.ashx without parameters"));
}
if (context.Request.Params.Get("name") == null)
{
return(new PagedData("Name is null"));
}
FileXferDownload file = new FileXferDownload();
file.name = context.Request.Params.Get("name");
db.FileXferDownloads.InsertOnSubmit(file);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddBackofficeProcess.ashx without parameters"));
}
if (context.Request.Params.Get("name") == null)
{
return(new PagedData("Name is null"));
}
BackofficeProcess bp = new BackofficeProcess();
bp.name = context.Request.Params.Get("name");
db.BackofficeProcesses.InsertOnSubmit(bp);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddConfigurationFile.ashx without parameters"));
}
if (context.Request.Params.Get("name") == null)
{
return(new PagedData("Name is null"));
}
ConfigurationFile cf = new ConfigurationFile();
cf.name = context.Request.Params.Get("name");
db.ConfigurationFiles.InsertOnSubmit(cf);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddPlatform.ashx without parameters"));
}
if (context.Request.Params.Get("platform") == null)
{
return(new PagedData("Platform is null"));
}
Platform plat = new Platform();
plat.platform1 = context.Request.Params.Get("platform");
db.Platforms.InsertOnSubmit(plat);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
IQueryable <BusinessUnit> q = db.BusinessUnits;
return(new PagedData(q.Select(a => new { a.name, a.business_units_id, a.Company.company_name })));
/* (smm - Commenting out since we only want all applications)
*
* string cid = context.Request.Params.Get("business_units_id"); //("biz_id"); //("company_id");
* if (!isNull(cid))
* {
* q = q.Where(a => a.company_id == int.Parse(cid));
* }
* else
* {
* //smm (we don't want to do this anymore) return new PagedData("Required parameter company_id missing", false);
*
* //smm We want to grab all business units if a company_id wasn't supplied!
* string filter = context.Request.Params.Get("name"); //("biz_name");
* if (!isNull(filter))
* {
* q = q.Where(a => a.name.IndexOf(filter) != -1);
* }
*
* return new PagedData(q.Select(a => new { a.name, a.business_units_id }));
* }
*
* IQueryable retq = (from a in q
* select new
* {
* a.business_units_id,
* a.name,
* a.Company.company_name,
* });
*
* return new PagedData(retq);
*/
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddReportName.ashx without parameters"));
}
if (context.Request.Params.Get("name") == null)
{
return(new PagedData("Name is null"));
}
ReportName name = new ReportName();
name.name = context.Request.Params.Get("name");
db.ReportNames.InsertOnSubmit(name);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddLanguage.ashx without parameters"));
}
if (context.Request.Params.Get("language") == null)
{
return(new PagedData("Language is null"));
}
Language language = new Language();
language.language1 = context.Request.Params.Get("language");
db.Languages.InsertOnSubmit(language);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddDeliveryFrequency.ashx without parameters"));
}
if (context.Request.Params.Get("frequency") == null)
{
return(new PagedData("Frequency is null"));
}
DeliveryFrequency frequency = new DeliveryFrequency();
frequency.frequency = context.Request.Params.Get("frequency");
db.DeliveryFrequencies.InsertOnSubmit(frequency);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call RemoveContact.ashx without parameters"));
}
if (context.Request.Params.Get("name") == null)
{
return(new PagedData("Name is null"));
}
if (context.Request.Params.Get("email") == null)
{
return(new PagedData("Email is null"));
}
Contact contact = db.Contacts.Single(a => a.name.Equals(context.Request.Params.Get("name")) && a.email1.Equals(context.Request.Params.Get("email")));
db.Contacts.DeleteOnSubmit(contact);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddDeliveryFormat.ashx without parameters"));
}
if (context.Request.Params.Get("format") == null)
{
return(new PagedData("Format is null"));
}
DeliveryFormat format = new DeliveryFormat();
format.format = context.Request.Params.Get("format");
db.DeliveryFormats.InsertOnSubmit(format);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddManager.ashx without parameters"));
}
if (context.Request.Params.Get("name") == null)
{
return(new PagedData("Name is null"));
}
Manager mang = new Manager();
mang.name = context.Request.Params.Get("name");
db.Managers.InsertOnSubmit(mang);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddDeliveryMethod.ashx without parameters"));
}
if (context.Request.Params.Get("method") == null)
{
return(new PagedData("Method is null"));
}
DeliveryMethod method = new DeliveryMethod();
method.method = context.Request.Params.Get("method");
db.DeliveryMethods.InsertOnSubmit(method);
db.SubmitChanges();
return(new PagedData(""));
}
public override PagedData ProcessRequest(HttpContext context, CookDBDataContext db)
{
if (context.Request.Params.Count == 0)
{
return(new PagedData("Can't call AddServiceID.ashx without parameters"));
}
if (context.Request.Params.Get("name") == null)
{
return(new PagedData("Name is null"));
}
ServiceID serviceID = new ServiceID();
serviceID.name = context.Request.Params.Get("name");
db.ServiceIDs.InsertOnSubmit(serviceID);
db.SubmitChanges();
return(new PagedData(""));
}
/*
* public static User getUser(HttpContext context, CookDBDataContext db)
* {
* return db.Users.SingleOrDefault(a => a.username.Equals(context.Request.ServerVariables["AUTH_USER"]));
* }
*/
public void ProcessRequest(HttpContext context)
{
bool debug = false;
if (context.Request.Url.AbsolutePath.Contains("CookbookDEV") || !isNull(context.Request.Params.Get("CookbookDEV")))
{
debug = false; // change back if you need...
}
CookDBDataContext db = getDataContext(context);
PagedData ret = null;
context.Response.ContentType = "text/html";
//User u = getUser(context, db);
string msg = "Unknown failure";
try {
int start = intParse(context.Request.Params.Get("start"));
int limit = intParse(context.Request.Params.Get("limit"));
ret = ProcessRequest(context, db, start, limit);
}
catch (Exception e) {
msg = e.Message;
if (debug)
{
throw new Exception("Error", e);
}
}
if (ret == null)
{
ret = new PagedData(msg, false);
}
context.Response.Write(JsonConvert.SerializeObject(ret,
new JsonConverter[] { new JavaScriptDateTimeConverter() }));
}
