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