Exemple #1
0
        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);
        }
Exemple #2
0
 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;
     }
 }
Exemple #3
0
 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));
     }
 }
Exemple #4
0
 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));
     }
 }
Exemple #5
0
        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;
                }
            }
        }
Exemple #6
0
        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;
                }
            }
        }