static public Employee FromModelEmployee(Expenses.Model.Employee employee) { return new Employee() { Alias = employee.Alias, EmployeeId = employee.EmployeeId, Manager = employee.Manager, Name = employee.Name, }; }
public Facede(Bll.Facede Application) { corporationExpenses = new CorporationExpenses(Application); corporationRevenues = new CorporationRevenues(Application); expenseItem = new ExpenseItem(Application); expenses = new Expenses(Application); memberExpenses = new MemberExpenses(Application); memberRevenues = new MemberRevenues(Application); revenueItem = new RevenueItem(Application); revenues = new Revenues(Application); }
public async Task <IActionResult> Create([Bind("Id,Name,Details,Amount,Date")] Expenses expenses) { if (ModelState.IsValid) { _context.Add(expenses); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(expenses)); }
public void GetExpenses() { var expenses = Expense.GetExpenses(); Expenses.Clear(); foreach (var expense in expenses) { Expenses.Add(expense); } }
public async Task <IHttpActionResult> PostExpenses(Expenses expenses) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Expenses.Add(expenses); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = expenses.Id }, expenses)); }
public void Save(ExpensesModel expeModel) { using (var c = new EntityContext()) { ExpensesOperation operation = new ExpensesOperation(); Expenses dto = new Expenses(); dto.Amount = Amount; dto.Description = Description; dto.BudgetId = expeModel.BudgetId; operation.Add(dto, c); } }
public async Task <IActionResult> Delete(int id) { Expenses expenses = await _expensesRepository.GetItem(id); if (expenses == null) { return(NotFound()); } await _expensesRepository.Remove(expenses); return(Ok()); }
private Expenses toExpenses(Expenses p, ExpensesModel i) { p.Category_FK = i.Category_FK; p.Date_purchase = i.Date_purchase; p.Expenses_PK = i.Expenses_PK; p.Login_FK = i.Login_FK; p.Name_expenses = i.Name_expenses; p.Necessity = i.Necessity; p.Sum_expenses = i.Sum_expenses; return(p); }
public static void GetCSVData(ref Expenses dtsExpenses, ref List <string> errorlog) { string[] csvFiles = Directory.GetFiles(Model.ModelBusinessRules.GetCSVLocation()); foreach (string csvFile in csvFiles) { MessageBox.Show("" + csvFile); DataTable t = DataUtils.GetDataTabletFromCSVFile(csvFile); DataUtils.ConsolidateDataTableToExpenses(t, ref dtsExpenses, csvFile, ref errorlog); } }
public double GetMaxExpense() { try { return(Expenses.Max(x => x.Value)); } catch (Exception e) { Console.WriteLine(e); return(0); } }
public Result GetExpenses(int ExpenseTypeId, string descriptionSearch, DateTime fromDate, DateTime toDate, string orderBy, string direction, int startRowIndex, int maximumRows, int branchId) { Result objResult = new Result(); try { var param = new DbParam[9]; param[0] = new DbParam("@SortBy", orderBy, SqlDbType.VarChar); param[1] = new DbParam("@SortDirection", direction, SqlDbType.VarChar); param[2] = new DbParam("@StartRowIndex", startRowIndex, SqlDbType.Int); param[3] = new DbParam("@MaximumRows", maximumRows, SqlDbType.Int); param[4] = new DbParam("@ExpenseTypeId", ExpenseTypeId, SqlDbType.Int); param[5] = new DbParam("@DescriptionSearch", descriptionSearch, SqlDbType.VarChar); param[6] = new DbParam("@FromDate", fromDate, SqlDbType.DateTime); param[7] = new DbParam("@ToDate", toDate, SqlDbType.DateTime); param[8] = new DbParam("@BranchId", branchId, SqlDbType.Int); DataSet ds = Db.GetDataSet("SP_EXPENSES_GET", param); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { IList <Expenses> expenses = new List <Expenses>(); foreach (DataRow row in ds.Tables[0].Rows) { Expenses expense = new Expenses(); expense.ExpenseId = Db.ToInteger(row["ExpenseId"]); expense.ExpenseType = new ExpenseType(); expense.ExpenseType.TypeName = Db.ToString(row["TypeName"]); expense.ExpenseAmount = Db.ToString(row["ExpenseAmount"]); expense.ExpenseDate = Db.ToDateTime(row["ExpenseDate"]); expense.ExpenseDescription = Db.ToString(row["ExpenseDescription"]); expenses.Add(expense); } objResult.Items = expenses; objResult.ItemCount = 0; if (ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0) { objResult.ItemCount = Db.ToInteger(ds.Tables[1].Rows[0]["ExpenseCount"]); } } } catch (Exception ex) { //CommonFunctions.LogError(ex, ErrorLog.LogSeverity.Error); } return(objResult); }
private async Task ExecuteLoadExpenses() { Initialized = true; IsBusy = true; Expenses.Clear(); //var expenses = await AzureService.Instance.GetExpensesAsync(); //foreach (var expense in expenses) // Expenses.Add(expense); IsBusy = false; }
public async Task <IActionResult> PostExpenses([FromBody] Expenses expenses) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.Expenses.Add(expenses); await _context.SaveChangesAsync(); return(CreatedAtAction("GetExpenses", new { id = expenses.ExpenseId }, expenses)); }
public async Task <IActionResult> PostExpenses([FromBody] Expenses expenses) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _expensesRepository.CreateExpense(expenses); await _expensesRepository.Save(); return(CreatedAtAction("GetExpenses", new { id = expenses.Id }, expenses)); }
public async Task CreateComunication(Expenses expenses, ExpensesCategory expensesCategory) { var expCategory = new ExpCategory() { ExpensesId = expenses.Id, ExpensesCategoryId = expensesCategory.Id }; _context.ExpCategories.Add(expCategory); await _context.SaveChangesAsync(); }
public IHttpActionResult PostExpenses(Expenses expenses) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Expenses.Add(expenses); db.SaveChanges(); return(CreatedAtRoute("API", new { id = expenses.Id }, expenses)); }
public IEnumerator SaveData(Expenses a_expenses) { ExpenseDataHandler.m_yearlyExpenseInfo.expenseInfo[m_myDate.Month - 1].Bazaar[m_myDate.Day - 1] = a_expenses.Bazaar; ExpenseDataHandler.m_yearlyExpenseInfo.expenseInfo[m_myDate.Month - 1].Shopping[m_myDate.Day - 1] = a_expenses.Shopping; ExpenseDataHandler.m_yearlyExpenseInfo.expenseInfo[m_myDate.Month - 1].Office[m_myDate.Day - 1] = a_expenses.Office; ExpenseDataHandler.m_yearlyExpenseInfo.expenseInfo[m_myDate.Month - 1].Others[m_myDate.Day - 1] = a_expenses.Other; yield return(new WaitForSeconds(0.5f)); ExpenseDataHandler.SaveData("2018", ExpenseDataHandler.m_yearlyExpenseInfo); MonthManager.m_instance.m_Start(); }
public static Expenses GetDailyExpenseData(DateTime a_dateTime) { Expenses expenses = new Expenses(); ExpenseInfo l_expenseInfo = m_yearlyExpenseInfo.expenseInfo[a_dateTime.Month - 1]; expenses.Bazaar = l_expenseInfo.Bazaar[a_dateTime.Day - 1]; expenses.Shopping = l_expenseInfo.Shopping[a_dateTime.Day - 1]; expenses.Office = l_expenseInfo.Office[a_dateTime.Day - 1]; expenses.Other = l_expenseInfo.Others[a_dateTime.Day - 1]; return(expenses); }
public async Task DeleteExpense(Expense expense) { var result = await _apiClient.DeleteAsync($"Expenses/{expense.StatementId}"); if (!result.IsSuccessStatusCode) { return; } Expenses.Remove(expense); await OnDeleted(); }
public void ReadExpenses() { IsRefreshing = true; var expenses = Expense.ReadExpenses(); Expenses.Clear(); foreach (var expense in expenses) { Expenses.Add(expense); } IsRefreshing = false; }
public static Expenses ReadExpense(string prompt) { Expenses result = new Expenses(); Console.WriteLine(prompt); result.expense = ReadInteger("Enter Cost: "); result.kind = Expenses.ReadKind("Enter type of expense: "); return(result); }
public Expenses GetExpenses(int id) { List <Expenses> Expensess = new List <Expenses>(); DataTable data = DataProvider.Instance.ExecuteQuery("Select * from doan where id_chi_phi = @id ;", new object[] { id }); foreach (DataRow item in data.Rows) { Expenses Expenses = new Expenses(item); Expensess.Add(Expenses); } return(Expensess[0]); }
public List <Expenses> GetAllExpenses() { List <Expenses> expensess = new List <Expenses>(); DataTable data = DataProvider.Instance.ExecuteQuery("Select * from chi_phi;"); foreach (DataRow item in data.Rows) { Expenses expenses = new Expenses(item); expensess.Add(expenses); } return(expensess); }
public double GetSpendings() { try { return(Expenses.Sum(x => x.Value)); } catch (Exception e) { Console.WriteLine(e); return(0); } }
public async Task <bool> DeleteExpenseAsync(int id) { var item = await Expenses.FirstOrDefaultAsync(x => x.Id == id).ConfigureAwait(false); if (item != null) { Expenses.Remove(item); await SaveChangesAsync().ConfigureAwait(false); } return(true); }
static void Main(string[] args) { /* CRIANDO OS QUARTOS DO HOTEL */ //var _simple = new SimpleBuilder(); //var _double = new DoubleBuilder(); //var _triple = new TripleBuilder(); /* DIRETORES QUE CONSTROEM PELO TIPO DO HOTEL*/ //var _DirectorSimple = new DirectorRoom(_simple); //var _DirectorDouble = new DirectorRoom(_double); //var _DirectorTriple = new DirectorRoom(_triple); //_DirectorSimple.Make(); //SimpleRoom a = _simple.build(); //Console.WriteLine(a.DescriptionRoom); //a.Message(); // FACTORYYYYYYYYYYYY ExpensesFactory expensesFactory = null; Console.Write("Digite o tipo de cartão que gostaria de obter:"); string console = Console.ReadLine(); switch (console.ToLower()) { case "diaria": expensesFactory = new DailyFactory("Diaria Do Hotel", 200); break; case "alimento": expensesFactory = new FoodFactory("Barra de Cereal", 5); break; case "Telefone": expensesFactory = new TelephoneFactory("Ligação 01", 19); break; default: break; } Expenses expenses = expensesFactory.getExpenses(); Console.WriteLine($"Tipo de despesa: {expenses.DescricaoDespesa} e valor: {expenses.Valor}"); Console.ReadKey(); expensesFactory = new TelephoneFactory("Ligação 01", 19); }
public async Task <IActionResult> Edit(int id, [Bind("ExpenseId,UserId,MortgageRent,Phone,Gas,WaterSewerTrash,Electricity,CableInternet,HomeAlarmSystem,MaintenanceRepairs,VehiclePayment,Insurance,Fuel,UberLyft,LicenseRegistration,Maintenance,HomeRenters,Health,Dental,Vision,Pet,Life,Groceries,DiningOut,Coffee,ClothesShoes,SchoolTuitionSupplies,SportsOrganizationFees,Childcare,LunchMoney,ToysGames,HairCutsSalon,ManiPediWaxing,ClothesShoesAccessories,DryCleaning,GymSupplements,OrganizationDuesFees,Music,Video,MovieTheater,Concerts,SportingEvents,DateNights,Alchohol,TobaccoVaping,PersonalLoan,CreditCard,StudentLoan,Federal,State,Medicare,SocialSecurityFICA,EmergencySavings,CDsMoneyMarkets,IRA401k,StocksMutualFunds,Tithesffering,Charity,RetirementHome,Attorney,AlimonyChildSupport,LienJudgmentPayment,MonthlyIncome,TotalCost,IncomeVsTotal")] Expenses expenses) { expenses.ExpenseId = id; if (id != expenses.ExpenseId) { return(NotFound()); } if (ModelState.IsValid) { try { expenses.UserId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value; expenses.TotalCost = expenses.MortgageRent + expenses.Phone + expenses.Gas + expenses.WaterSewerTrash + expenses.Electricity + expenses.CableInternet + expenses.HomeAlarmSystem + expenses.MaintenanceRepairs + expenses.VehiclePayment + expenses.Insurance + expenses.Fuel + expenses.UberLyft + expenses.LicenseRegistration + expenses.Maintenance + expenses.HomeRenters + expenses.Health + expenses.Dental + expenses.Vision + expenses.Pet + expenses.Life + expenses.Groceries + expenses.DiningOut + expenses.Coffee + expenses.ClothesShoes + expenses.SchoolTuitionSupplies + expenses.SportsOrganizationFees + expenses.Childcare + expenses.LunchMoney + expenses.ToysGames + expenses.HairCutsSalon + expenses.ManiPediWaxing + expenses.ClothesShoesAccessories + expenses.DryCleaning + expenses.GymSupplements + expenses.OrganizationDuesFees + expenses.Music + expenses.Video + expenses.MovieTheater + expenses.Concerts + expenses.SportingEvents + expenses.DateNights + expenses.Alchohol + expenses.TobaccoVaping + expenses.PersonalLoan + expenses.CreditCard + expenses.StudentLoan + expenses.Federal + expenses.State + expenses.Medicare + expenses.SocialSecurityFICA + expenses.EmergencySavings + expenses.CDsMoneyMarkets + expenses.IRA401k + expenses.StocksMutualFunds + expenses.Tithesffering + expenses.Charity + expenses.RetirementHome + expenses.Attorney + expenses.AlimonyChildSupport + expenses.LienJudgmentPayment; expenses.IncomeVsTotal = expenses.MonthlyIncome - expenses.TotalCost; _context.Update(expenses); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ExpensesExists(expenses.ExpenseId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["UserId"] = new SelectList(_context.ApplicationUsers, "Id", "Id", expenses.UserId); return(View(expenses)); }
private Expenses convertSelectedRowDataToExpenses(DataGridView dtGridExpenses) { if (dtGridExpenses.SelectedRows.Count >= 1) { DataRow dr = getSelectedDataRowForExpenses(dtGridExpenses); if (dr != null) { Expenses Expenses = GetById(int.Parse(dr.Field <string>("ID")), int.Parse(dr.Field <string>("PID"))); return(Expenses); } } return(null); }
private void _PopulateDetails(Expenses trans) { lblID.Text = trans.Id.ToString(); txtAmount.Text = trans.Amount.ToString(); txtCostCenter.Text = trans.CostCenter; txtCurrency.Text = trans.Currency; txtDate.Text = trans.DateofExpenses.ToString("dd-MMM-yyyy"); txtDescription.Text = trans.Description; txtExchangeRate.Text = trans.ExchangeRate.ToString(); txtGLCode.Text = trans.GLCode; txtGST.Text = trans.GST.ToString(); txtTotalAmount.Text = trans.TotalAmount.ToString(); }
public object Clone() { FinancialPlan clone = new FinancialPlan { Income = Income, Savings = Savings, PlannedSavings = PlannedSavings, FinancialGoals = (List <FinancialGoal>)FinancialGoals.Clone(), Expenses = (List <Expense>)Expenses.Clone() }; return(clone); }
private async Task UpdateExpensesInView() { Expenses.Clear(); var expenses = await GetExpenses(); var sortedExpenses = expenses.Cast <Expense>().OrderByDescending((x) => x.CreationDateTime).Select(x => x); foreach (var expense in sortedExpenses) { Expenses.Add(expense); } //Expenses = new ObservableCollection<Expense>(sortedExpenses); }
public static int DeleteOtherExpense(int id) { Entities entities = new Entities(); DateTime current = DateTime.Now; Expenses otherExpense = entities.Expenses.Where(x => x.Id == id).FirstOrDefault(); otherExpense.DisabledDate = current; otherExpense.DisabledBy = Constants.Constants.USER; entities.Expenses.Attach(otherExpense); entities.Entry(otherExpense).State = System.Data.Entity.EntityState.Modified; return(entities.SaveChanges()); }
static public SummaryItem FromModelSummaryItem(Expenses.Model.SummaryItem summaryItem) { return new SummaryItem() { Amount = summaryItem.Amount, Date = summaryItem.Date, Description = summaryItem.Description, Id = summaryItem.Id, ItemType = (ItemType) summaryItem.ItemType, Submitter = summaryItem.Submitter, }; }
static public ExpenseReport FromModelExpenseReport(Expenses.Model.ExpenseReport expenseReport) { return new ExpenseReport() { Amount = expenseReport.Amount, Approver = expenseReport.Approver, CostCenter = expenseReport.CostCenter, DateResolved = expenseReport.DateResolved, DateSaved = expenseReport.DateSaved, DateSubmitted = expenseReport.DateSubmitted, EmployeeId = expenseReport.EmployeeId, ExpenseReportId = expenseReport.ExpenseReportId, Notes = expenseReport.Notes, OwedToCreditCard = expenseReport.OwedToCreditCard, OwedToEmployee = expenseReport.OwedToEmployee, Purpose = expenseReport.Purpose, Status = (int) expenseReport.Status, }; }
static public Charge FromModelCharge(Expenses.Model.Charge charge) { Charge newCharge = new Charge() { AccountNumber = charge.AccountNumber, BilledAmount = charge.BilledAmount, ChargeId = charge.ChargeId, Category = charge.Category, Description = charge.Description, EmployeeId = charge.EmployeeId, ExpenseDate = charge.ExpenseDate, ExpenseReportId = charge.ExpenseReportId, ExpenseType = charge.ExpenseType, Location = charge.Location, Merchant = charge.Merchant, Notes = charge.Notes, ReceiptRequired = charge.ReceiptRequired, TransactionAmount = charge.TransactionAmount, }; return newCharge; }
public static void ProcessExpensesRepaidClosed (BasicEvent newEvent) { Person expenser = Person.FromIdentity(newEvent.VictimPersonId); Person payer = Person.FromIdentity(newEvent.PerpetratorPersonId); // The ParameterText field is like a,b,c,d where a..d are expense IDs string[] idStrings = newEvent.ParameterText.Split(','); Expenses expenses = new Expenses(); decimal totalAmount = 0.0m; foreach (string idString in idStrings) { Expense newExpense = Expense.FromIdentity(Int32.Parse(idString)); totalAmount += newExpense.Amount; expenses.Add (newExpense); } string body = "The following expenses, totaling " + totalAmount.ToString ("#,##0.00") + ", have been repaid to your registered account, " + expenser.BankName + " " + expenser.BankAccount + ".\r\n\r\n"; body += FormatExpenseLine ("#", "Description", "Amount"); body += FormatExpenseLine ("===", "========================================", "========="); foreach (Expense expense in expenses) { body += FormatExpenseLine (expense.Identity.ToString(), expense.Description, expense.Amount.ToString ("#,##0.00")); } body += FormatExpenseLine ("---", "----------------------------------------", "---------"); body += FormatExpenseLine (string.Empty, "TOTAL", totalAmount.ToString ("#,##0.00")); body += "\r\nIf you see any problems with this, please contact the treasurer, " + payer.Name + ", at " + payer.PPMailAddress + ". Thank you for helping the pirate movement succeed.\r\n"; new PirateWeb.Utility.Mail.MailTransmitter("PirateWeb", "*****@*****.**", "Expenses Repaid: " + totalAmount.ToString("#,##0.00"), body, expenser, true).Send(); }
public static ICollection<Expenses> ReadExpensesFromXml() { Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture; using (supermarketEntities sqlDb = new supermarketEntities()) { Dictionary<string, int> vendorIds = new Dictionary<string, int>(); var vendors = sqlDb.Vendors; foreach (var item in vendors) { vendorIds.Add(item.VendorName, item.ID); } List<Expenses> expenses = new List<Expenses>(); using (XmlReader reader = XmlReader.Create("../../../Vendor-Expences.xml")) { string name = ""; string date = null; decimal expense = 0; while (reader.Read()) { if ((reader.NodeType == XmlNodeType.Element) && (reader.Name == "sale")) { name = reader.GetAttribute(0); } else if ((reader.NodeType == XmlNodeType.Element) && (reader.Name == "expenses")) { date = reader.GetAttribute("month"); expense = decimal.Parse(reader.ReadElementContentAsString()); Expenses newExpense = new Expenses() { ID = expenses.Count+1, VendorID = vendorIds[name], Expenses1 = expense, Mounth = date }; expenses.Add(newExpense); } } } return expenses; } }
/// <summary> /// There are no comments for Expenses in the schema. /// </summary> public void AddToExpenses(Expenses expenses) { base.AddObject("Expenses", expenses); }
/// <summary> /// Create a new Expenses object. /// </summary> /// <param name="id">Initial value of Id.</param> /// <param name="description">Initial value of Description.</param> /// <param name="title">Initial value of Title.</param> public static Expenses CreateExpenses(long id, string description, string title) { Expenses expenses = new Expenses(); expenses.Id = id; expenses.Description = description; expenses.Title = title; return expenses; }