public ListMOUPartner getMOUPartnerDetail(int mou_partner_id)
{
try
{
string sql_mouPartnerList =
@"select tb1.mou_partner_id,tb2.partner_name,tb4.specialization_name
,tb2.website, tb1.contact_point_name, tb1.contact_point_phone
,tb1.contact_point_email, tb1.mou_start_date, tb7.scope_abbreviation,
tb1.mou_id
from IA_Collaboration.MOUPartner tb1 inner join IA_Collaboration.Partner tb2
on tb1.partner_id = tb2.partner_id
inner join IA_Collaboration.MOUPartnerSpecialization tb3 on
tb1.mou_partner_id = tb3.mou_partner_id
inner join General.Specialization tb4 on
tb3.specialization_id = tb4.specialization_id
inner join IA_Collaboration.PartnerScope tb5 on
tb5.partner_id = tb1.partner_id
inner join IA_Collaboration.MOUPartnerScope tb6 on
tb6.partner_scope_id = tb5.partner_scope_id
inner join IA_Collaboration.CollaborationScope tb7 on
tb7.scope_id = tb5.scope_id
inner join General.Country tb8 on
tb8.country_id = tb2.country_id
where tb1.mou_partner_id = @mou_partner_id";
List <ListMOUPartner> mouList = db.Database.SqlQuery <ListMOUPartner>(sql_mouPartnerList,
new SqlParameter("mou_partner_id", mou_partner_id)).ToList();
handlingPartnerListData(mouList);
ListMOUPartner obj = mouList.First();
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Get_Data_Partner_Detail(string mou_partner_id)
{
try
{
string result = mou_partner_id;
ListMOUPartner mouObj = mou.getMOUPartnerDetail(int.Parse(mou_partner_id));
return(Json(mouObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public void handlingPartnerListData(List <ListMOUPartner> mouList)
{
//spe_name
//sco_abbre
ListMOUPartner previousItem = null;
foreach (ListMOUPartner item in mouList.ToList())
{
if (previousItem == null) //first record
{
previousItem = item;
previousItem.mou_start_date_string = item.mou_start_date.ToString("dd'/'MM'/'yyyy");
}
else
{
if (item.mou_partner_id.Equals(previousItem.mou_partner_id))
{
if (!previousItem.specialization_name.Contains(item.specialization_name))
{
previousItem.specialization_name = previousItem.specialization_name + "," + item.specialization_name;
}
if (!previousItem.scope_abbreviation.Contains(item.scope_abbreviation))
{
previousItem.scope_abbreviation = previousItem.scope_abbreviation + "," + item.scope_abbreviation;
}
//then remove current object
mouList.Remove(item);
}
else
{
previousItem = item;
}
}
}
return;
}
