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); }
public async Task <ActionResult <Revenue> > PostRevenue(Revenue revenue) { _context.Revenues.Add(revenue); await _context.SaveChangesAsync(); return(CreatedAtAction("GetRevenue", new { id = revenue.revenuesID }, revenue)); }
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); }
/* * 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); }
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)); }
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()); }
// 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); }
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 }); }
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); }
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)); }
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"); } }
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; }
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)); }
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('}', ')') })); } }
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" })); }
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)); }
// 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)); }
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); }
// 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(); }
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 }); }
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); }