public ActionResult ExtendAgreement(int id, int ivar)
        {
            ExtendAgreement extendModel = new ExtendAgreement();
            Agreement       iAgr        = db.Agreements.Single(x => x.AgreementNumber == id && x.VariantNumber == ivar);

            if (iAgr.RFONumbers.Count > 0)
            {
                extendModel.RFONumber = iAgr.RFONumbers.First().RFONumber1;
            }
            extendModel.Name            = iAgr.Name;
            extendModel.AgreementNumber = iAgr.AgreementNumber;
            extendModel.VariantNumber   = iAgr.VariantNumber;
            extendModel.StartDate       = (DateTime)iAgr.StartDate;
            extendModel.EndDate         = (DateTime)iAgr.EndDate;
            extendModel.StatusId        = (int)iAgr.StatusId;

            return(View(extendModel));
        }
        public ActionResult DisposeExtendAgreement()
        {
            ExtendAgreement extendModel = new ExtendAgreement();

            if (TryUpdateModel(extendModel))
            {
                //Agreement NewAgreement = db.Agreements.AsNoTracking().Single(x => x.AgreementNumber == extendModel.AgreementNumber && x.VariantNumber == extendModel.VariantNumber);

                ////------------Add new agreement------------
                //NewAgreement.VariantNumber = db.Agreements.Where(x => x.AgreementNumber == extendModel.AgreementNumber).OrderByDescending(x => x.VariantNumber).First().VariantNumber + 1;
                //NewAgreement.StatusId = 1;
                //NewAgreement.StartDate = extendModel.StartDate;
                //NewAgreement.EndDate = extendModel.EndDate;
                ////add agreementRFO
                //NewAgreement.RFONumbers = db.Agreements.Find(extendModel.AgreementNumber, extendModel.VariantNumber).RFONumbers;


                ////------------send email------------
                //Company CompanySendEmail = db.Companies.Find(db.Agreements.Find(extendModel.AgreementNumber, extendModel.VariantNumber).RFONumbers.First().CompanyId);

                //string subject = "Hello, " + CompanySendEmail.Name + ".";
                //string body = "We are System Administrator. We wanted inform with you.\n" + "The system been create new variant based on the previous agreement and add new entry to audit trail."
                //    + " New variant  have AgreementNumber = " + NewAgreement.AgreementNumber + ", VariantNumber = " + NewAgreement.VariantNumber;
                //SendEmail(CompanySendEmail.Emailaddress, subject, body);

                ////------------discounts: Replace UC11------------
                //if (extendModel.EndDate < DateTime.Now)
                //{
                //    int afterCharge = (int)NewAgreement.HandlingCharge - (int)NewAgreement.DiscountUnit;
                //    if (afterCharge < 0)
                //        afterCharge = 0;
                //    NewAgreement.HandlingCharge = afterCharge;
                //}

                ////------------save------------
                //db.Agreements.Add(NewAgreement);
                //db.SaveChanges();
            }
            //RedirectToAction: trả về hàm index-> để show ra trang chính
            return(RedirectToAction("HomePage"));
        }