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