public void addMOAPartner(MOAPartnerInfo input, int moa_id)
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
DateTime moa_start_date = DateTime.ParseExact(input.sign_date_moa_add, "dd/MM/yyyy", CultureInfo.InvariantCulture);
//add MOAPartner
db.MOAPartners.Add(new MOAPartner
{
moa_id = moa_id,
moa_start_date = moa_start_date,
partner_id = input.partner_id
});
foreach (int itemScope in input.coop_scope_add.ToList())
{
PartnerScope psCheck = db.PartnerScopes.Where(x => x.partner_id == input.partner_id && x.scope_id == itemScope).FirstOrDefault();
if (psCheck != null)
{
psCheck.reference_count += 1;
db.MOAPartnerScopes.Add(new MOAPartnerScope
{
partner_scope_id = psCheck.partner_scope_id,
moa_id = moa_id
});
}
else
{
PartnerScope psAdded = db.PartnerScopes.Add(new PartnerScope
{
partner_id = input.partner_id,
scope_id = itemScope,
reference_count = 1
});
db.MOAPartnerScopes.Add(new MOAPartnerScope
{
partner_scope_id = psAdded.partner_scope_id,
moa_id = moa_id
});
}
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
public ActionResult Add_Moa_Partner(MOAPartnerInfo input)
{
try
{
string id = Session["moa_detail_id"].ToString();
moa.addMOAPartner(input, int.Parse(id));
return(Json("", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
