private ExMOUAdd handlingExMOUDetailData(List <ExtraMOU> mouExList)
{
ExMOUAdd newObj = new ExMOUAdd();
//Partner
foreach (ExtraMOU item in mouExList.ToList())
{
newObj.ExBasicInfo.ex_mou_code = item.mou_bonus_code;
newObj.ExBasicInfo.ex_mou_end_date = item.mou_bonus_end_date.ToString("dd'/'MM'/'yyyy");
newObj.ExBasicInfo.ex_mou_sign_date = item.mou_bonus_decision_date.ToString("dd'/'MM'/'yyyy");
PartnerScopeInfo p = newObj.PartnerScopeInfo.Find(x => x.partner_id == item.partner_id);
if (p == null)
{
PartnerScopeInfo obj = new PartnerScopeInfo();
obj.partner_id = item.partner_id;
obj.scopes_id.Add(item.scope_id);
newObj.PartnerScopeInfo.Add(obj);
}
else
{
p.scopes_id.Add(item.scope_id);
}
}
return(newObj);
}
public ExMOUAdd getExtraMOUDetail(int mou_bonus_id, int mou_id)
{
try
{
string sql_mouEx =
@"select t1.mou_bonus_code, t1.mou_bonus_decision_date,t1.mou_bonus_end_date,
t4.partner_name,t5.scope_abbreviation,t1.evidence,t1.mou_id,t1.mou_bonus_id,
t5.scope_id,t4.partner_id
from IA_Collaboration.MOUBonus t1 left join
IA_Collaboration.MOUPartnerScope t2 on
t1.mou_bonus_id = t2.mou_bonus_id inner join
IA_Collaboration.PartnerScope t3 on
t3.partner_scope_id = t2.partner_scope_id
inner join
IA_Collaboration.Partner t4 on t4.partner_id = t3.partner_id
inner join IA_Collaboration.CollaborationScope t5 on t5.scope_id = t3.scope_id
where t1.mou_id = @mou_id and t1.mou_bonus_id = @mou_bonus_id order by partner_id ";
List <ExtraMOU> mouExList = db.Database.SqlQuery <ExtraMOU>(sql_mouEx
, new SqlParameter("mou_id", mou_id)
, new SqlParameter("mou_bonus_id", mou_bonus_id)).ToList();
ExMOUAdd mouEx = handlingExMOUDetailData(mouExList);
return(mouEx);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Edit_Ex_Mou(ExMOUAdd input)
{
try
{
string id = Session["mou_detail_id"].ToString();
mou.editExtraMOU(input, int.Parse(id));
return(Json("", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult ViewExMOUDetail(int mou_bonus_id)
{
try
{
string mou_id = Session["mou_detail_id"].ToString();
ExMOUAdd mouObj = mou.getExtraMOUDetail(mou_bonus_id, int.Parse(mou_id));
return(Json(mouObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(new HttpStatusCodeResult(400));
}
}
public void editExtraMOU(ExMOUAdd input, int mou_id)
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
//edit MOUBonus
//MOUBonu mb = db.MOUBonus.Find(mou_bonus_id);
//mb.mou_bonus_code = input.mou_bonus_code;
//mb.mou_bonus_decision_date = input.mou_bonus_decision_date;
//mb.mou_bonus_end_date = input.mou_bonus_end_date;
//mb.mou_id = input.mou_id;
//mb.evidence = input.evidence;
//db.Entry(mb).State = EntityState.Modified;
//finding old exScope of exMOU.
//List<MOUPartnerScope> exList = db.MOUPartnerScopes.Where(x => x.mou_bonus_id == mou_bonus_id).ToList();
//exList.Clear();
//db.Entry(exList).State = EntityState.Modified;
//add new record of MOuPartnerScope
//foreach (CustomPartner cp in input.ListPartnerExMOU.ToList())
//{
// foreach (CustomScope cs in cp.ListScopeExMOU.ToList())
// {
// MOUPartnerScope m = new MOUPartnerScope();
// m.mou_id = input.mou_id;
// m.partner_id = cp.partner_id;
// m.scope_id = cs.scope_id;
// m.mou_bonus_id = mou_bonus_id;
// db.MOUPartnerScopes.Add(m);
// }
//}
//checkpoint 2
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
public void addExtraMOU(ExMOUAdd input, int mou_id)
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
DateTime sign_date = DateTime.ParseExact(input.ExBasicInfo.ex_mou_sign_date, "dd/MM/yyyy", CultureInfo.InvariantCulture);
DateTime end_date = DateTime.ParseExact(input.ExBasicInfo.ex_mou_end_date, "dd/MM/yyyy", CultureInfo.InvariantCulture);
//add MOUBonus
MOUBonu mb = new MOUBonu();
mb.mou_bonus_code = input.ExBasicInfo.ex_mou_code;
mb.mou_bonus_decision_date = sign_date;
mb.mou_bonus_end_date = end_date;
mb.mou_id = mou_id;
mb.evidence = "";
db.MOUBonus.Add(mb);
//checkpoint 1
db.SaveChanges();
MOUBonu addObj = db.MOUBonus.Where(x => x.mou_bonus_code.Equals(mb.mou_bonus_code)).First();
foreach (PartnerScopeInfo partnerScopeItem in input.PartnerScopeInfo.ToList())
{
foreach (int scopeItem in partnerScopeItem.scopes_id.ToList())
{
db.MOUPartnerScopes.Add(new MOUPartnerScope
{
mou_id = mou_id,
mou_bonus_id = addObj.mou_bonus_id
});
}
}
//checkpoint 2
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
