private get_response_market _getMarketer_ext(long m_id) { var mx = db.MARKETER_ext.Where(a => a.rel_MARKETER_id == m_id); get_response_market resp = new get_response_market(); foreach (var n in mx) { switch (n.attr_name) { case "fax_number": resp.fax_number = n.value; break; case "process_external_transfer": resp.process_external_transfer = n.value; break; case "intake_entity": resp.intake_entity = n.value; break; case "pharmacy_relationship": resp.pharmacy_relationship = n.value; break; case "technology_platform": resp.technology_platform = n.value; break; case "pharmacy_customer_number": resp.pharmacy_customer_number = n.value; break; case "pharmacy_fax": resp.pharmacy_fax = n.value; break; case "preferred_geographic_market": resp.preferred_geographic_market = n.value; break; } } return(resp); }
public IHttpActionResult GetMarketer([FromUri] get_market marketer) { var m = db.MARKETERs.Find(marketer.id); List <get_response_market> resp = new List <get_response_market>(); if (m != null) { var ref_zip = db.ref_zip.Find(m.addr_zip_id); get_response_market ext = _getMarketer_ext(m.id); List <zip_search_address2> addr = new List <zip_search_address2>(); if (ref_zip != null) { addr.Add(new zip_search_address2 { address1 = m.addr_address1, address2 = m.addr_address2 == null ? "" : m.addr_address2, city = ref_zip == null ? "" : ref_zip.city_name, state = ref_zip == null ? "" : ref_zip.city_state, state_long = ref_zip == null ? "" : ref_zip.city_state_long, zip = ref_zip == null ? "" : ref_zip.zip }); } resp.Add(new get_response_market { legal_entity_name = m.legal_entity_name, healthsplash_contact = m.healthsplash_contact, address = addr == null? new List <zip_search_address2>() { } : addr, // public long zip_id { get; set; } federal_tax_number = m.federal_tax_number, primary_phone = m.primary_phone, telemedicine_partner = m.telemedicine_partner, supplier_partner = m.supplier_partner, primary_contact_name_first = m.prim_contact_name_first, primary_contact_name_last = m.prim_contact_name_last, primary_contacty_phone = m.prim_contact_phone, primary_contact_email = m.prim_contact_email, operational_contact_name_first = m.oper_contact_name_first, operational_contact_name_last = m.oper_contact_name_last, operational_contact_phone = m.oper_contact_phone, operational_contact_email = m.oper_contact_email, financial_contact_name_first = m.fina_contact_name_first, financial_contact_name_last = m.fina_contact_name_last, financial_contact_phone = m.fina_contact_phone, financial_contact_email = m.fina_contact_email, authorize_contact_signatory_name_first = m.auth_contact_name_first, authorize_contact_signatory_name_last = m.auth_contact_name_last, authorize_contact_signatory_phone = m.auth_contact_phone, authorize_contact_signatory_email = m.auth_contact_email, fax_number = ext.fax_number == null ? "" : ext.fax_number, process_external_transfer = ext.process_external_transfer == null ? "" : ext.process_external_transfer, intake_entity = ext.intake_entity == null ? "" : ext.intake_entity, pharmacy_relationship = ext.pharmacy_relationship == null ? "" : ext.pharmacy_relationship, technology_platform = ext.technology_platform == null ? "" : ext.technology_platform, pharmacy_customer_number = ext.pharmacy_customer_number == null ? "" : ext.pharmacy_customer_number, pharmacy_fax = ext.pharmacy_fax == null ? "" : ext.pharmacy_fax, preferred_geographic_market = ext.preferred_geographic_market == null ? "" : ext.preferred_geographic_market }); var ret1 = JsonConvert.SerializeObject(resp); var json1 = Newtonsoft.Json.Linq.JArray.Parse(ret1); string msg = resp.Count() + " Record found."; return(Json(new { data = json1, message = msg, success = true })); } return(Json(new { data = new string[] { }, message = "", success = false })); }