private ExMOAAdd handlingExMOADetailData(List <ExtraMOA> mouExList)
{
ExMOAAdd newObj = new ExMOAAdd();
newObj.ExMOABasicInfo = new ExMOABasicInfo();
newObj.PartnerScopeInfoMOA = new List <PartnerScopeInfoMOA>();
//Partner
foreach (ExtraMOA item in mouExList.ToList())
{
newObj.ExMOABasicInfo.ex_moa_code = item.moa_bonus_code;
newObj.ExMOABasicInfo.ex_moa_end_date = item.moa_bonus_end_date.ToString("dd'/'MM'/'yyyy");
newObj.ExMOABasicInfo.ex_moa_sign_date = item.moa_bonus_decision_date.ToString("dd'/'MM'/'yyyy");
PartnerScopeInfoMOA p = newObj.PartnerScopeInfoMOA.Find(x => x.partner_id == item.partner_id);
if (p == null)
{
PartnerScopeInfoMOA obj = new PartnerScopeInfoMOA();
obj.partner_id = item.partner_id;
obj.scopes_id = new List <int>();
obj.scopes_id.Add(item.scope_id);
obj.scopes_name = item.scope_abbreviation;
obj.partner_name = item.partner_name;
newObj.PartnerScopeInfoMOA.Add(obj);
}
else
{
p.scopes_id.Add(item.scope_id);
p.scopes_name += "," + item.scope_abbreviation;
}
}
return(newObj);
}
public ExMOAAdd getExtraMOADetail(int moa_id, int moa_bonus_id)
{
try
{
string sql_moaEx =
@"select t1.moa_bonus_code, t1.moa_bonus_decision_date,t1.moa_bonus_end_date,
t4.partner_name,t5.scope_abbreviation,t1.evidence,t1.moa_id,t1.moa_bonus_id,
t5.scope_id,t4.partner_id
from IA_Collaboration.MOABonus t1 left join
IA_Collaboration.MOAPartnerScope t2 on
t1.moa_bonus_id = t2.moa_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.moa_id = @moa_id and t1.moa_bonus_id = @moa_bonus_id order by partner_id";
List <ExtraMOA> moaExList = db.Database.SqlQuery <ExtraMOA>(sql_moaEx
, new SqlParameter("moa_id", moa_id)
, new SqlParameter("moa_bonus_id", moa_bonus_id)).ToList();
ExMOAAdd moaEx = handlingExMOADetailData(moaExList);
return(moaEx);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult ViewExMOADetail(int moa_bonus_id)
{
try
{
string moa_id = Session["moa_detail_id"].ToString();
ExMOAAdd mouObj = moa.getExtraMOADetail(int.Parse(moa_id), moa_bonus_id);
return(Json(mouObj, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(new HttpStatusCodeResult(400));
}
}
public ActionResult Edit_Ex_Moa(ExMOAAdd input)
{
try
{
string id = Session["moa_detail_id"].ToString();
moa.editExtraMOA(input, int.Parse(id));
return(Json("", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public void editExtraMOA(ExMOAAdd input, int moa__id)
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
//edit MOABonus
//MOABonu mb = db.MOABonus.Find(moa_bonus_id);
//mb.moa_bonus_code = input.moa_bonus_code;
//mb.moa_bonus_decision_date = input.moa_bonus_decision_date;
//mb.moa_bonus_end_date = input.moa_bonus_end_date;
//mb.moa_id = input.moa_id;
//mb.evidence = input.evidence;
//db.Entry(mb).State = EntityState.Modified;
//finding old exScope of exMOA.
//List<MOAPartnerScope> exList = db.MOAPartnerScopes.Where(x => x.moa_bonus_id == moa_bonus_id).ToList();
//exList.Clear();
//db.Entry(exList).State = EntityState.Modified;
//add new record of MOAPartnerScope
//foreach (CustomPartner cp in input.ListPartnerExMOA.ToList())
//{
// foreach (CustomScope cs in cp.ListScopeExMOU.ToList())
// {
// MOAPartnerScope m = new MOUPartnerScope();
// m.mou_id = input.moa_id;
// m.partner_id = cp.partner_id;
// m.scope_id = cs.scope_id;
// m.mou_bonus_id = moa_bonus_id;
// db.MOUPartnerScopes.Add(m);
// }
//}
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
public void addExtraMOA(ExMOAAdd input, int moa_id)
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
DateTime sign_date = DateTime.ParseExact(input.ExMOABasicInfo.ex_moa_sign_date, "dd/MM/yyyy", CultureInfo.InvariantCulture);
DateTime end_date = DateTime.ParseExact(input.ExMOABasicInfo.ex_moa_end_date, "dd/MM/yyyy", CultureInfo.InvariantCulture);
//add MOABonus
MOABonu objMOABonusAdded = db.MOABonus.Add(new MOABonu
{
moa_bonus_code = input.ExMOABasicInfo.ex_moa_code,
moa_bonus_decision_date = sign_date,
moa_bonus_end_date = end_date,
moa_id = moa_id,
evidence = ""
});
db.SaveChanges();
//check PartnerScope and add MOAPartnerScope.
foreach (PartnerScopeInfoMOA psMOA in input.PartnerScopeInfoMOA.ToList())
{
foreach (int scopeItem in psMOA.scopes_id.ToList())
{
int partner_scope_id_item = 0;
PartnerScope psCheck = db.PartnerScopes.Where(x => x.partner_id == psMOA.partner_id && x.scope_id == scopeItem).First();
if (psCheck == null)
{
PartnerScope psAdded = db.PartnerScopes.Add(new PartnerScope
{
partner_id = psMOA.partner_id,
scope_id = scopeItem,
reference_count = 1
});
partner_scope_id_item = psAdded.partner_scope_id;
}
else
{
partner_scope_id_item = psCheck.partner_scope_id;
psCheck.reference_count += 1;
}
db.SaveChanges();
//add to MOAPartnerScope
db.MOAPartnerScopes.Add(new MOAPartnerScope
{
partner_scope_id = partner_scope_id_item,
moa_id = moa_id,
moa_bonus_id = objMOABonusAdded.moa_bonus_id
});
db.SaveChanges();
}
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
