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