Beispiel #1
0
        public async Task <IActionResult> PutRevenue(int id, Revenue revenue)
        {
            if (id != revenue.revenuesID)
            {
                return(BadRequest());
            }

            _context.Entry(revenue).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!RevenueExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
        private Dto.Xsd.InvoiceDetail GetInvoiceDetail(Revenue revenueItem)
        {
            var invoiceDetail = new Dto.Xsd.InvoiceDetail
            {
                LineNumber           = revenueItem.LineNumber.Value,
                NetValue             = revenueItem.NetValue.Value,
                VatAmount            = revenueItem.VatValue.Value,
                VatCategory          = MapVatCategory(revenueItem.TaxType),
                IncomeClassification = revenueItem.IncomeClassifications.Select(invoiceIncomeClassification => GetIncomeClassification(invoiceIncomeClassification)).ToArray()
            };

            if (revenueItem.VatExemption.HasValue)
            {
                invoiceDetail.VatExemptionCategory          = MapVatExemptionCategory(revenueItem.VatExemption.Value);
                invoiceDetail.VatExemptionCategorySpecified = true;
            }

            if (revenueItem.CityTax != null)
            {
                invoiceDetail.OtherTaxesCategory          = MapOtherTaxCategory(revenueItem.CityTax.Type);
                invoiceDetail.OtherTaxesAmount            = revenueItem.CityTax.Amount.Value;
                invoiceDetail.OtherTaxesCategorySpecified = true;
                invoiceDetail.OtherTaxesAmountSpecified   = true;
            }

            return(invoiceDetail);
        }
Beispiel #3
0
        public async Task <ActionResult <Revenue> > PostRevenue(Revenue revenue)
        {
            _context.Revenues.Add(revenue);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetRevenue", new { id = revenue.revenuesID }, revenue));
        }
Beispiel #4
0
 private void SaveRevenue(Revenue revenue)
 {
     ValidationContract.Required <ArgumentNullException>(revenue != null, "Revenue can never be null");
     ValidationContract.Required <ArgumentException>(revenue != null && revenue.CategoryId > 0, "At least one Category must be selected");
     ValidationContract.Required <ArgumentException>(revenue != null && revenue.PayMethodId > 0, "At least one payment method must be selected");
     _revenueRepository.SaveRevenue(revenue);
 }
Beispiel #5
0
 /*
  * Do work on a task given the member who's working on it's morale.
  * Called once per second by Employee update function
  */
 public bool Work(int morale)
 {
     if (DependentCompleted && !Completed)
     {
         // task progress = morale/5 (=1 if progress is <1)
         if (morale > 100 || morale < 0)
         {
             throw new System.Exception("Morale should not exceed 100 or be below 0. Morale was " + morale + ".");
         }
         int progress = morale / 5;
         if (progress <= 1)
         {
             progress = 1;
         }
         Completion += progress;
         Revenue.Earn(progress);
         if (Completion >= 100)
         {
             Completion = 100;
             Completed  = true;
             Revenue.CompleteTask();
         }
     }
     return(Completed);
 }
Beispiel #6
0
        public async Task <IActionResult> Edit(int id, [Bind("RevenueId,produk,total,bulan")] Revenue revenue)
        {
            if (id != revenue.RevenueId)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(revenue);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!RevenueExists(revenue.RevenueId))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(revenue));
        }
Beispiel #7
0
        public string ToString(string fmt)
        {
            if (String.IsNullOrEmpty(fmt))
            {
                fmt = "Full";
            }

            NumberFormatInfo nfi = CultureInfo.CreateSpecificCulture("en-US").NumberFormat;

            switch (fmt)
            {
            case "Full":
                return(String.Format("Customer record: {0}, {1}, {2} ", Name, Revenue.ToString("N2", nfi), ContactPhone));

            case "Phone":
                return(String.Format("Customer record: {0}", ContactPhone));

            case "NameRev":
                return(String.Format("Customer record: {0}, {1}", Name, Revenue.ToString("N2", nfi)));

            case "Name":
                return(String.Format("Customer record: {0}", Revenue));

            default:
                String msg = String.Format("'{0}' is an invalid format string",
                                           fmt);
                throw new ArgumentException(msg);
            }
        }
 public ActionResult RevenueGridViewPartialUpdate(Revenue item)
 {
     using (var db = new InnosixEntities())
     {
         var model = db.Revenue;
         if (ModelState.IsValid)
         {
             try
             {
                 var modelItem = model.FirstOrDefault(it => it.Id == item.Id);
                 if (modelItem != null)
                 {
                     UpdateModel(modelItem);
                     db.SaveChanges();
                 }
             }
             catch (Exception e)
             {
                 ViewData["EditError"] = e.Message;
             }
         }
         else
         {
             ViewData["EditError"] = "Please, correct all errors.";
         }
         return(PartialView("_RevenueGridViewPartial", model.ToList()));
     }
 }
        public void PrintDetailsOnScreen()
        {
            var sb = new StringBuilder();

            sb.AppendLine("Employee for ITALY");

            sb.Append("Gross salary: EUR ");
            sb.AppendLine(GrossAumont.ToString());

            sb.AppendLine();
            sb.AppendLine("CalculateDeductions details");
            sb.AppendLine("---------------------------------------");

            sb.Append("Revenue: EUR ");
            sb.AppendLine(Revenue.ToString());

            sb.Append("Pension: EUR ");
            sb.AppendLine(Pension.ToString());
            sb.AppendLine("---------------------------------------");

            sb.Append("Net salary: EUR ");
            sb.AppendLine(NetAumont.ToString());

            Console.WriteLine(sb.ToString());
        }
        public async Task <IActionResult> PutRevenue([FromRoute] int id, [FromBody] Revenue revenue)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != revenue.RevenueId)
            {
                return(BadRequest());
            }

            _context.Entry(revenue).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!RevenueExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
Beispiel #11
0
        // to get the revenue of specific flight on a specific date
        public async Task <Revenue> GetRevenue(string flightNumber, string departureDate)
        {
            Revenue revenue = new Revenue();

            // using with resources to establish the connection and disposes it after it is done with the task
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                //opens connection
                await connection.OpenAsync();

                using (var cmd = connection.CreateCommand())
                {
                    cmd.CommandText = "SELECT SUM(dbo.Flights.Price) AS Revenue, DepCity.City AS Departure, ArrCity.City As Arrival FROM dbo.Flights INNER JOIN dbo.Routes ON dbo.Flights.FlightNumber = dbo.Routes.FlightNumber INNER JOIN dbo.Airports as DepCity ON DepCity.Code = dbo.Routes.Departure INNER JOIN dbo.Airports as ArrCity ON ArrCity.Code = dbo.Routes.Arrival WHERE dbo.Flights.FlightNumber = @FlightNumber AND dbo.Routes.FlightNumber = @FlightNumber AND dbo.Flights.DepartureDate= @DepartureDate GROUP BY dbo.Flights.DepartureDate, DepCity.City, ArrCity.City;";


                    cmd.Parameters.AddWithValue("@FlightNumber", flightNumber);
                    cmd.Parameters.AddWithValue("@DepartureDate", departureDate);


                    using (var reader = await cmd.ExecuteReaderAsync())
                    {
                        while (await reader.ReadAsync())
                        {
                            revenue.TotalSum  = reader.GetInt32(0);
                            revenue.Departure = reader.GetString(1);
                            revenue.Arrival   = reader.GetString(2);
                        }
                    }
                }
            }
            return(revenue);
        }
Beispiel #12
0
        public ResultViewModel Post([FromBody] EditorRevenueViewModel model)
        {
            model.Validate();
            if (model.Invalid)
            {
                return(new ResultViewModel()
                {
                    Success = false,
                    Message = "Não foi possível cadastrar a receita.",
                    Data = model.Notifications
                });
            }

            var revenue = new Revenue();

            revenue.Id     = model.Id;
            revenue.Name   = model.Name;
            revenue.UserId = model.UserId;
            revenue.Value  = model.Value;
            revenue.Date   = System.DateTime.Now;

            _repository.Save(revenue);

            return(new ResultViewModel
            {
                Success = true,
                Message = "Receita cadastrada com sucesso.",
                Data = revenue
            });
        }
Beispiel #13
0
        public async Task Insert(Revenue revenue)
        {
            const string QUERY = @"INSERT INTO public.revenue(id, account_id, reference_name, amount, credit_day_type, credit_day_value)
                                   VALUES (@Id, @AccountId, @ReferenceName, @Amount, @CreditDayType, @CreditDayValue);";

            await _dbConnection.ExecuteAsync(QUERY, revenue);
        }
Beispiel #14
0
        public async Task <IActionResult> Edit(int id, [Bind("Id,ProductId,StoreFrontId,Quantity")] Revenue revenue)
        {
            if (id != revenue.Id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(revenue);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!RevenueExists(revenue.Id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            ViewData["ProductId"]    = new SelectList(_context.Product, "Id", "Id", revenue.ProductId);
            ViewData["StoreFrontId"] = new SelectList(_context.Set <StoreFront>(), "Id", "Id", revenue.StoreFrontId);
            return(View(revenue));
        }
Beispiel #15
0
 public List <Revenue> GetRevenue()
 {
     try
     {
         List <Revenue> revenue = revenue_db.Db_Get_All_Revenue();
         return(revenue);
     }
     catch (Exception)
     {
         // something went wrong connecting to the database, so we will add a fake revenue to the list to make sure the rest of the application continues working!
         List <Revenue> revenue = new List <Revenue>();
         Revenue        a       = new Revenue();
         a.Price         = 2;
         a.StudentNumber = 333;
         a.Date          = Convert.ToDateTime("13/05/2019");
         revenue.Add(a);
         Revenue b = new Revenue();
         b.Price         = 2;
         b.StudentNumber = 666;
         b.Date          = Convert.ToDateTime("14/05/2019");
         revenue.Add(b);
         return(revenue);
         //throw new Exception("Someren couldn't connect to the database");
     }
 }
Beispiel #16
0
        public async Task <IActionResult> PayAccount([Bind("RevenueId,DueDate,AccountBankId,ConditionId,Payment,Tax,Discont,Comment,Active,Image,Id")] PayAccount data, bool Active, List <IFormFile> Image)
        {
            Revenue revenue = await _revenueServices.SingleOrDefaultAsync(a => a.RevenueId == data.RevenueId);

            if (data.Payment.HasValue)
            {
                RevenueTrans revenueTrans = _financialExtension.GetRevenueTrans(data, _BusinessId, "PAG", revenue.DueDate.HasValue ? 2 : 3);
                BankTrans    bankTrans    = _financialExtension.GetBankTrans(data, revenueTrans, _BusinessId, revenue.ChartAccountId);
                //await _revenueTransServices.AddAsyncNoSave(revenue);
                await _bankTransServices.AddAsync(bankTrans, false);
            }
            if (data.Tax.HasValue)
            {
                RevenueTrans revenueTrans = _financialExtension.GetRevenueTrans(data, _BusinessId, "JUR", 1);
                await _revenueTransServices.AddAsync(revenueTrans, false);
            }
            if (data.Discont.HasValue)
            {
                RevenueTrans revenueTrans = _financialExtension.GetRevenueTrans(data, _BusinessId, "DIS", 2);
                await _revenueTransServices.AddAsync(revenueTrans, false);
            }
            if (data.Active)
            {
                revenue.DuePayment = data.DueDate;
                await _revenueServices.UpdateAsync(revenue, false);
            }
            var insert = await _revenueTransServices.SaveAsync();

            return(RedirectToAction(nameof(List)));
        }
        private List <Revenue> ReadTables(Revenue newrevenue)
        {
            List <Revenue> revenues = new List <Revenue>();

            revenues.Add(newrevenue);
            return(revenues);
        }
    //returns list with all characters from db
    public static List <Revenue> GetRevenues(MySqlConnection _connection)
    {
        _connection.Open();
        //retrieve from db
        MySqlCommand command = _connection.CreateCommand();

        command.CommandText = "SELECT * FROM `revenue`";
        MySqlDataReader data = command.ExecuteReader();

        List <Revenue> revenues = new List <Revenue>();

        //read data from dataReader and form list of Character instances
        while (data.Read())
        {
            DateTime revenue_date  = Convert.ToDateTime(data["revenue_date"]);
            decimal  value         = Convert.ToDecimal(data["value"]);
            Int64    id            = Convert.ToInt64(data["id"]);
            Int64    enterprise_id = Convert.ToInt64(data["enterprise_id"]);

            Revenue revenue = new Revenue(id, revenue_date, value, enterprise_id);
            Debug.Log("Get character " + id);
            revenues.Add(revenue);
        }
        _connection.Close();
        return(revenues);
    }
 public RevenueCreateViewModel(Revenue revenue)
 {
     Date        = revenue.Date;
     Value       = revenue.Value;
     RevenueType = revenue.RevenueType;
     OccasionId  = revenue.OccasionId;
 }
Beispiel #20
0
        private void GenerateGrafic(List <Revenue> revenues)
        {
            for (int i = 0; i < revenues.Count - 1; i++)
            {
                if (revenues[i].Date > revenues[i + 1].Date)
                {
                    Revenue aux = revenues[i];
                    revenues[i]     = revenues[i + 1];
                    revenues[i + 1] = aux;
                }
            }

            // Grafico pagina inicial
            chtLastMonthSale.Legends.Clear();
            chtLastMonthSale.Series[0].ChartType = SeriesChartType.Range;
            chtLastMonthSale.Series[0].Color     = Color.Gray;

            if (revenues != null)
            {
                foreach (Revenue r in revenues)
                {
                    chtLastMonthSale.Series[0].Points.AddXY(r.Date, r.GetTotal());
                }
            }
        }
        public IActionResult Add(AddRevenueViewModel addRevenueViewModel)
        {
            if (ModelState.IsValid)
            {
                RevenueCategory newRevenueCategory =
                    context.RevenueCategories.Single(c => c.ID == addRevenueViewModel.RevenueCategoryID);
                // Add the new cheese to my existing cheeses
                Revenue newRevenue = new Revenue
                {
                    Date            = addRevenueViewModel.Date,
                    Reference       = addRevenueViewModel.Reference,
                    Owner           = addRevenueViewModel.Owner,
                    Description     = addRevenueViewModel.Description,
                    Amount          = addRevenueViewModel.Amount,
                    RevenueCategory = newRevenueCategory
                };

                context.Revenues.Add(newRevenue);
                context.SaveChanges();

                return(Redirect("/Revenue"));
            }

            return(View(addRevenueViewModel));
        }
Beispiel #22
0
        public async Task <ActionResult> Delete(int id)
        {
            var     repository = new RevenuesRepository(_context);
            Revenue revenue    = await repository.GetById(id);

            if (revenue == null)
            {
                return(NotFound());
            }

            try
            {
                repository.Delete(revenue);
                repository.Save();

                return(NoContent());
            }
            catch (Exception e)
            {
                return(BadRequest(new
                {
                    message = e.Message.Replace('{', '(').Replace('}', ')')
                }));
            }
        }
Beispiel #23
0
        public async Task <ActionResult> Create([FromBody] Revenue revenue)
        {
            if (ModelState.IsValid)
            {
                if (revenue == null)
                {
                    return(BadRequest());
                }

                var repository = new RevenuesRepository(_context);
                try
                {
                    await repository.Insert(revenue);

                    repository.Save();

                    return(NoContent());
                }
                catch (Exception e)
                {
                    return(BadRequest(new
                    {
                        message = e.Message.Replace('{', '(').Replace('}', ')')
                    }));
                }
            }
            return(BadRequest(new
            {
                message = "ModelState is not valid"
            }));
        }
Beispiel #24
0
        public JsonResult updateRevenueInfoByExRate(Revenue revenue)
        {
            List <Revenue> RevenueList = dbContext.Revenues.Where(x => x.IsActive == true && x.Country == revenue.Country && x.Year == revenue.Year).ToList(); //&& x.CurrencyCode == revenue.CurrencyCode

            try
            {
                foreach (Revenue rv in RevenueList)
                {
                    rv.CurrencyExRate = revenue.CurrencyExRate;

                    rv.YearlyTargetAmt = rv.YearlyTarget * revenue.CurrencyExRate;

                    rv.HalfYearlyTargetAmt = rv.YearlyTargetAmt / 2;
                    rv.QuarterlyTargetAmt  = rv.YearlyTargetAmt / 4;
                    rv.MonthlyTargetAmt    = rv.YearlyTargetAmt / 12;
                    rv.IsActive            = true;

                    rv.ModifiedBy = USER_ID;
                    rv.ModifiedOn = UTILITY.SINGAPORETIME;

                    dbContext.Entry(rv).State = EntityState.Modified;
                }

                dbContext.SaveChanges();
            }
            catch (Exception ex)
            {
                throw ex;
            }

            string message = "Currency Ex. Rate Updated Successfully.";

            return(Json(message, JsonRequestBehavior.AllowGet));
        }
Beispiel #25
0
        // GET: Revenues/Edit/5
        public async Task <ActionResult> Edit(string code)
        {
            if (code == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Revenue revenue = await db.Revenues.Where(r => r.revenue_code == code).FirstOrDefaultAsync();

            if (revenue == null)
            {
                return(HttpNotFound());
            }
            IEnumerable <SelectListItem> items = db.TaxCategories.Select(c => new SelectListItem
            {
                Value = c.category_code,
                Text  = c.title
            });

            IEnumerable <SelectListItem> issuers = db.Issuers.Select(iss => new SelectListItem {
                Value = iss.issuer_code, Text = iss.issuer_name
            });

            ViewBag.TCategory   = items;
            ViewBag.IssuersList = issuers;

            return(View(revenue));
        }
Beispiel #26
0
        public Financial GetFinancialData()
        {
            Financial financial = new Financial();
            DataSet   data      = DBConnection.GetData("getFinancial");

            foreach (DataRow row in data.Tables[0].Rows)
            {
                financial.importantUpdate  = row["important_update"].ToString();
                financial.masterPlanUpdate = row["masterplan_update"].ToString();
            }
            List <Revenue> revenues = new List <Revenue>();

            foreach (DataRow dr in data.Tables[1].Rows)
            {
                Revenue obj = new Revenue();
                obj.act     = (dr["act"].ToString());
                obj.bud     = dr["bud"].ToString();
                obj.var     = (dr["var"].ToString());
                obj.actfor  = (dr["actfor"].ToString());
                obj.budfor  = (dr["budfor"].ToString());
                obj.varfor  = (dr["varfor"].ToString());
                obj.comment = dr["comment"].ToString();
                obj.action  = dr["action"].ToString();
                revenues.Add(obj);
            }
            financial.revenues = revenues;
            return(financial);
        }
Beispiel #27
0
 // Show Budget properties.
 public void ShowBudget(string title)
 {
     Console.WriteLine(title);
     Console.WriteLine("Revenue: " + Revenue.ToString("C"));
     Console.WriteLine("Expenses: " + Expenses.ToString("C"));
     Console.WriteLine();
 }
Beispiel #28
0
        public static void ProjectIndividualPayment(RecurringTransaction transaction)
        {
            var UpsideDb = new DatabaseContext();

            var nextPaymentDate   = transaction.FirstPaymentDate;
            var endProjectionDate = DateTime.Now.AddMonths(6);

            //loop through transaction and project
            while (nextPaymentDate <= endProjectionDate)
            {
                if (transaction.TransactionType == "Revenue")
                {
                    //check if revenue already exists
                    if (!UpsideDb.Revenues.Any(rev => rev.RevenueCategory == transaction.TransactionCategory &&
                                               rev.RevenueDate == nextPaymentDate &&
                                               rev.UserID == transaction.UserID))
                    {
                        //if not, add revenue to table
                        var newRevenue = new Revenue()
                        {
                            RevenueCategory        = transaction.TransactionCategory,
                            RevenueName            = transaction.TransactionName,
                            RevenueDate            = nextPaymentDate,
                            RevenueAmount          = transaction.TransactionAmount,
                            UserID                 = transaction.UserID,
                            RecurringTransactionID = transaction.ID,
                        };

                        UpsideDb.Revenues.Add(newRevenue);
                    }
                }
                else if (transaction.TransactionType == "Expense")
                {
                    //check if expense already exists
                    if (!UpsideDb.Expenses.Any(exp => exp.ExpenseCategory == transaction.TransactionCategory &&
                                               exp.ExpenseDate == nextPaymentDate &&
                                               exp.UserID == transaction.UserID))
                    {
                        //if not, add expense to table
                        var newExpense = new Expense()
                        {
                            ExpenseCategory        = transaction.TransactionCategory,
                            ExpenseName            = transaction.TransactionName,
                            ExpenseDate            = nextPaymentDate,
                            ExpenseAmount          = transaction.TransactionAmount,
                            UserID                 = transaction.UserID,
                            RecurringTransactionID = transaction.ID,
                        };

                        UpsideDb.Expenses.Add(newExpense);
                    }
                }

                //increment nextPaymentDate
                nextPaymentDate = IncrementDate(nextPaymentDate, transaction.RecurringFrequency);
            }

            UpsideDb.SaveChanges();
        }
        public async Task <ActionResult> AddUserRevenue(IncomingRevenueData incomingRevenue)
        {
            //If Revenue Amount equals 0, return BadRequest. Revenues must be greater than 0.
            if (incomingRevenue.RevenueAmount == 0)
            {
                return(BadRequest("Amount must be greater than 0."));
            }

            //Else, get User ID from Claims
            var userId = int.Parse(User.Claims.FirstOrDefault(claim => claim.Type == "ID").Value);

            //Create new Revenue
            var newRevenue = new Revenue
            {
                RevenueCategory = incomingRevenue.RevenueCategory,
                RevenueName     = incomingRevenue.RevenueName,
                RevenueDate     = incomingRevenue.RevenueDate,
                RevenueAmount   = incomingRevenue.RevenueAmount,
                UserID          = userId
            };

            //If Revenue is recurring, create new Recurring Transaction and project it.
            if (incomingRevenue.RecurringFrequency != "One Time")
            {
                var newRecurringTransaction = new RecurringTransaction
                {
                    TransactionType     = "Revenue",
                    TransactionCategory = incomingRevenue.RevenueCategory,
                    TransactionName     = incomingRevenue.RevenueName,
                    FirstPaymentDate    = incomingRevenue.RevenueDate,
                    TransactionAmount   = incomingRevenue.RevenueAmount,
                    RecurringFrequency  = incomingRevenue.RecurringFrequency,
                    UserID = userId
                };

                _context.RecurringTransactions.Add(newRecurringTransaction);

                await _context.SaveChangesAsync();

                RecurringTransactionManager.ProjectIndividualPayment(newRecurringTransaction);

                newRevenue.RecurringTransactionID = newRecurringTransaction.ID;
            }
            //Else, save One Time Revenue record
            else
            {
                _context.Revenues.Add(newRevenue);

                await _context.SaveChangesAsync();
            }

            //Return new Revenue
            return(new ContentResult()
            {
                Content = JsonConvert.SerializeObject(newRevenue),
                ContentType = "application/json",
                StatusCode = 201
            });
        }
Beispiel #30
0
        public JsonResult SaveRevenueInfo(Revenue revenue)
        {
            revenue.Year = revenue.Year == 0 ? DateTime.Now.Year : revenue.Year;

            revenue.HalfYearlyTarget = revenue.YearlyTarget / 2;
            revenue.QuarterlyTarget  = revenue.YearlyTarget / 4;
            revenue.MonthlyTarget    = revenue.YearlyTarget / 12;

            revenue.YearlyTargetAmt = revenue.YearlyTarget * revenue.CurrencyExRate;

            revenue.HalfYearlyTargetAmt = revenue.YearlyTargetAmt / 2;
            revenue.QuarterlyTargetAmt  = revenue.YearlyTargetAmt / 4;
            revenue.MonthlyTargetAmt    = revenue.YearlyTargetAmt / 12;
            revenue.IsActive            = true;

            try
            {
                if (revenue.RevenueId == -1)
                {
                    revenue.CreatedBy = USER_ID;
                    revenue.CreatedOn = UTILITY.SINGAPORETIME;
                    dbContext.Revenues.Add(revenue);
                }
                else
                {
                    Revenue revenueInfo = dbContext.Revenues.
                                          Where(x => x.RevenueId == revenue.RevenueId).FirstOrDefault();

                    revenueInfo.CurrencyExRate = revenue.CurrencyExRate;

                    revenueInfo.YearlyTarget     = revenue.YearlyTarget;
                    revenueInfo.HalfYearlyTarget = revenue.HalfYearlyTarget;
                    revenueInfo.QuarterlyTarget  = revenue.QuarterlyTarget;
                    revenueInfo.MonthlyTarget    = revenue.MonthlyTarget;

                    revenueInfo.YearlyTargetAmt = revenue.YearlyTargetAmt;

                    revenueInfo.HalfYearlyTargetAmt = revenue.HalfYearlyTargetAmt;
                    revenueInfo.QuarterlyTargetAmt  = revenue.QuarterlyTargetAmt;
                    revenueInfo.MonthlyTargetAmt    = revenue.MonthlyTargetAmt;
                    revenueInfo.IsActive            = true;

                    revenueInfo.ModifiedBy = USER_ID;
                    revenueInfo.ModifiedOn = UTILITY.SINGAPORETIME;

                    dbContext.Entry(revenueInfo).State = EntityState.Modified;
                }

                dbContext.SaveChanges();
            }
            catch (Exception ex)
            {
                throw ex;
            }

            string message = "Saved Successfully.";

            return(Json(message, JsonRequestBehavior.AllowGet));
        }
        public ActionResult Create(Revenue revenue)
        {
            if (ModelState.IsValid)
            {
                db.Revenues.Add(revenue);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            return View(revenue);
        }
        // POST api/Revenue
        public HttpResponseMessage PostRevenue(Revenue revenue)
        {
            if (ModelState.IsValid)
            {
                db.Revenues.Add(revenue);
                db.SaveChanges();

                HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, revenue);
                response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = revenue.ID }));
                return response;
            }
            else
            {
                return Request.CreateResponse(HttpStatusCode.BadRequest);
            }
        }
        // PUT api/Revenue/5
        public HttpResponseMessage PutRevenue(long id, Revenue revenue)
        {
            if (ModelState.IsValid && id == revenue.ID)
            {
                db.Entry(revenue).State = EntityState.Modified;

                try
                {
                    db.SaveChanges();
                }
                catch (DbUpdateConcurrencyException)
                {
                    return Request.CreateResponse(HttpStatusCode.NotFound);
                }

                return Request.CreateResponse(HttpStatusCode.OK, revenue);
            }
            else
            {
                return Request.CreateResponse(HttpStatusCode.BadRequest);
            }
        }
 /// <summary>
 /// Saves a revenue account to the data store.
 /// </summary>
 /// <param name="revenue">The revenue account to save.</param>
 public override void PersistRevenue(Revenue revenue)
 {
     SaveAccount(revenue);
 }
 public ActionResult Edit(Revenue revenue)
 {
     if (ModelState.IsValid)
     {
         db.Entry(revenue).State = EntityState.Modified;
         db.SaveChanges();
         return RedirectToAction("Index");
     }
     return View(revenue);
 }