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