public ActionResult CheckPartner(string partner_name) { try { CustomPartner partner = mou.CheckPartner(partner_name); return(partner is null?Json("") : Json(partner)); } catch (Exception ex) { return(new HttpStatusCodeResult(400)); } }
public CustomPartner CheckPartner(string partner_name) { try { string sql = @"select t1.partner_id,t1.partner_name,t2.country_id,t2.country_name ,t1.address,t1.website from IA_Collaboration.Partner t1 left join General.Country t2 on t1.country_id = t2.country_id where t1.partner_name = @partner_name"; CustomPartner p = db.Database.SqlQuery <CustomPartner>(sql, new SqlParameter("partner_name", partner_name)).FirstOrDefault(); return(p); } catch (Exception ex) { throw ex; } }