private void updateExpensesButton_Click(object sender, RoutedEventArgs e) { Expens expens = (Expens)expensesListView.SelectedItem; descriptionExpensesTextBox.Text = expens.Expenses_Description; expensesMoneyTextBox.Text = decimal.ToInt32(expens.Expenses_Money ?? 0).ToString(); }
public ActionResult SaveExpense(Expens expense) { String catName = Request["ddl_cat"]; exp.saveExpense(expense, catName, (int)Session["key"]); return(Redirect("/DashBoard/Expenses")); }
public List <(int payerId, decimal amount)> Calculate(Expens expens, Building building, int unit) { var dayOfLiving = building.GetDayOfLivingForPayers(unit, expens.From, expens.To); //Calculate based on date for each payer throw new NotImplementedException(); }
private void btnSave_Click(object sender, EventArgs e) { try { Expens expense = new Expens(); var model = Entities.Expenses; expense.Name = txtName.Text; expense.Date = dtpExpenseDate.Value; expense.Description = rtbDescription.Text; expense.Amount = Convert.ToDecimal(txtAmount.Text); expense.Category = Convert.ToInt32(cmCategory.SelectedValue); expense.Remark = rtbRemarks.Text; model.Add(expense); int results = Entities.SaveChanges(); if (results <= 0) { MessageBox.Show("An error occured while trying to save record", "Exply", MessageBoxButtons.OK); } else { ClearControls(); MessageBox.Show("Record Saved Successfully", "Exply", MessageBoxButtons.OK); } } catch (Exception ex) { MessageBox.Show("Error " + ex.Message, "Exply", MessageBoxButtons.OK); } }
private void saveButton_Click(object sender, RoutedEventArgs e) { var ValidationWindowScreen = new ValidationWindow("SAVE"); if (ValidationWindowScreen.ShowDialog() == true) { Expens newExpenses = new Expens() { Electric = float.Parse(electricTextBox.Text), Water = float.Parse(waterTextBox.Text), Rent_Premises = float.Parse(premisesTextBox.Text), DateTime = date.SelectedDate, SalaryStaff = float.Parse(salaryTextBox.Text), Goods = float.Parse(goodsTextBox.Text), Total = float.Parse(totalTextBlock.Text), }; busExpenses.AddExpenses(newExpenses); this.DialogResult = true; this.Close(); } else { return; } }
public IHttpActionResult PutExpens(int id, Expens expens) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != expens.EID) { return(BadRequest()); } db.Entry(expens).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ExpensExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public List <(int payerId, decimal amount)> Calculate(Expens expens, Building building, int unit) { var result = new List <(int payerId, decimal amount)>(); result.Add((payerId: 1, amount: 1458)); return(result); }
public async Task <IActionResult> Create(Expens expens, List <IFormFile> idpro) { foreach (var item in idpro) { if (item.Length > 0) { using (var stream = new MemoryStream()) { await item.CopyToAsync(stream); expens.idpro = stream.ToArray(); } } } ViewBag.data = HttpContext.Session.GetObject(SD.Sessionname); string Name = ViewBag.data; ViewBag.branch = HttpContext.Session.GetObject(SD.Statusbranch); string Branch = ViewBag.branch; if (ModelState.IsValid) { expens.branch = Branch; expens.entryby = Name; _context.Add(expens); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
private void addExpensesButton_Click(object sender, RoutedEventArgs e) { Expens expens = new Expens(); expens.ID_Journey = _journey.ID_Journey; expens.ID_Expenses = _maxIDExpenses++; if (expensesMoneyTextBox.Text.Length == 0) { notiMessageSnackbar.MessageQueue.Enqueue($"Không được bỏ trống tiền thu", "OK", () => { }); return; } expens.Expenses_Money = decimal.Parse(expensesMoneyTextBox.Text, NumberStyles.AllowDecimalPoint | NumberStyles.AllowThousands | NumberStyles.AllowCurrencySymbol | NumberStyles.Currency, new CultureInfo("en-US")); expens.Expenses_For_Binding = _appUtilities.GetMoneyForBinding(decimal.ToInt32(expens.Expenses_Money ?? 0)); expens.Expenses_Description = descriptionExpensesTextBox.Text; if (expens.Expenses_Description.Length <= 0) { notiMessageSnackbar.MessageQueue.Enqueue($"Không được bỏ trống tiền mô tả khoản chi", "OK", () => { }); return; } expensesMoneyTextBox.Text = ""; descriptionExpensesTextBox.Text = ""; _journey.Expenses.Add(expens); expensesListView.ItemsSource = _journey.Expenses.ToList(); }
public ActionResult Add(Expens emp) { bool status = false; using (MyDatabaseEntities dc = new MyDatabaseEntities()) { //Save dc.Expenses.Add(emp); try { dc.SaveChanges(); status = true; } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } return(new JsonResult { Data = new { status = status } }); }
public static int InsertExpenses(string vendorName, DateTime date, decimal expenses) { int vendorID; SupermarketReportsEntities db = new SupermarketReportsEntities(); using (db) { vendorID = db.Vendors .Where(v => v.VendorName == vendorName) .First() .VendorId; Expens newExpense = new Expens { VendorId = vendorID, Date = date, Expenses = expenses }; db.Expenses.Add(newExpense); db.SaveChanges(); } return(vendorID); }
public ActionResult AddTransaction(Expens expense) { try { var transaction = new Expens() { Amount = expense.Amount, CreatedDate = DateTime.Now, Date = expense.Date, Name = expense.Name, TransactionMonth = expense.Date.Month.ToString(), TransactionType = expense.TransactionType, WorkExpense = expense.WorkExpense, }; DB.Expenses.Add(transaction); } catch (Exception e) { Console.WriteLine(e.Message); } DB.SaveChanges(); return(View("Submit")); }
public bool AddExpenses(ExpensesDTO expensesDTO) { var flag = true; try { using (var entities = new ManiMotorsEntities1()) { var expense = new Expens() { Description = expensesDTO.Description, CreatedDate = expensesDTO.CreatedDate, Createdby = expensesDTO.CreatedBy, Modifiedby = expensesDTO.ModifiedBy, ModifiedDate = expensesDTO.ModifiedDate }; entities.Expenses.Add(expense); entities.SaveChanges(); flag = true; } } catch (Exception ex) { flag = false; throw ex; } return(flag); }
public IHttpActionResult AddExpenses(int odeyenId, int personId, float value, string expensesName, int quantity, int groupId) { try { Expens expens = new Expens(); expens.ExpenesesName = expensesName; expens.ExpensesQuantity = quantity; expens.GroupId = groupId; expens.OdeyenId = odeyenId; expens.PersonId = personId; expens.ExpensesValue = value; db.Expenses.Add(expens); if (odeyenId == personId) { db.SaveChanges(); return(Ok(1)); } Person person = db.People.Where(x => x.PersonID == personId).FirstOrDefault(); person.GunlukHarcama += quantity * value; Person odeyen = db.People.Where(x => x.PersonID == odeyenId).FirstOrDefault(); odeyen.GunlukHarcama += (-1) * quantity * value; db.SaveChanges(); return(Ok(1)); } catch (Exception ex) { return(Ok(ex.Message)); } }
private void btnAddExpense_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtExpTitle.Text) && !string.IsNullOrEmpty(cmbExpType.Text)) { ve = new VehicleManagementEntities(); if (ve.Expenses.Any(r => r.ExpenseTitle == txtExpTitle.Text)) { MessageBox.Show("This expense is already exists!"); } else { Expens expenses = new Expens() { ExpenseTitle = txtExpTitle.Text, VehicleId = vehicleId, ExpenseType = cmbExpType.Text, Amount = long.Parse(numExpAmount.Value.ToString()), DateCreated = DateTime.Now }; ve.Expenses.Add(expenses); ve.SaveChanges(); MessageBox.Show("Expense successfully added!"); fetchExpenses(); clearExpenseFields(); } } else { MessageBox.Show("You must fill all fields!"); } }
// // GET: /Expenses/Create public ActionResult Create() { var expns = new Expens { ExpenseNames = new SelectList(db.ExpenseTypes.ToList(), "ID", "ExpenseName") }; return View(expns); }
public ActionResult DeleteConfirmed(int id) { Expens expens = db.Expenses.Find(id); db.Expenses.Remove(expens); db.SaveChanges(); return(RedirectToAction("Index")); }
public void Add(ExpenseDTO DTO) { using (var container = new InventoryContainer()) { Expens gur = new Expens(); container.Expenses.AddObject((Expens)DTOMapper.DTOObjectConverter(DTO, gur)); container.SaveChanges(); } }
public List <(int payerId, decimal amount)> Calculate(Expens expens, Building building, int unit) { //var dayOfLiving=building.GetDayOfLivingForPayers(unit,expens.From,expens.To); ////Calculate based on date for each payer //throw new NotImplementedException(); var result = new List <(int payerId, decimal amount)>(); result.Add((payerId: 1, amount: 1458)); return(result); }
public ActionResult Create([Bind(Include = "Id,TransactionType,Name,Amount,WorkExpense,Date,CreatedDate,TransactionMonth")] Expens expens) { if (ModelState.IsValid) { db.Expenses.Add(expens); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(expens)); }
public IHttpActionResult GetExpens(int id) { Expens expens = db.Expenses.Find(id); if (expens == null) { return(NotFound()); } return(Ok(expens)); }
public ActionResult Edit([Bind(Include = "Expense_Id,category_Id,Details,Date,Amount")] Expens expens) { if (ModelState.IsValid) { db.Entry(expens).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.category_Id = new SelectList(db.Expense_Information, "category_Id", "Category", expens.category_Id); return(View(expens)); }
public ActionResult Edit(Expens expense) { if (ModelState.IsValid) { this.DataBridge.Entry(expense).State = System.Data.Entity.EntityState.Modified; this.DataBridge.SaveChanges(); return(RedirectToAction("Index")); } return(View(expense)); }
public ActionResult Create(Expens expens) { if (ModelState.IsValid) { db.Expenses.Add(expens); db.SaveChanges(); return RedirectToAction("Index"); } return View(expens); }
public ActionResult DeleteConfirmed(int id) { if (!User.Identity.IsAuthenticated) { return(RedirectToAction("Login", "Account")); } Expens expens = db.Expenses.Find(id); db.Expenses.Remove(expens); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ReceiptNo,Receiptdate,Receiptamount,UploadReceipt,EmployeeId,StatusofReceipt")] Expens expens) { if (ModelState.IsValid) { db.Entry(expens).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EmployeeId = new SelectList(db.Employees, "EmployeeId", "EmployeeName", expens.EmployeeId); ViewBag.StatusofReceipt = new SelectList(db.Status, "StatusofReceipt", "StatusofReceipt", expens.StatusofReceipt); return(View(expens)); }
public ActionResult Create(Expens expense) { if (ModelState.IsValid) { expense.ExpenseId = Guid.NewGuid(); this.DataBridge.Expenses.Add(expense); this.DataBridge.SaveChanges(); return(RedirectToAction("Index")); } return(View(expense)); }
public ActionResult Create([Bind(Include = "category_Id,Details,Date,Amount")] Expens expens) { if (ModelState.IsValid) { db.Expenses.Add(expens); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.category_Id = new SelectList(db.Expense_Information, "category_Id", "Category", expens.category_Id); return(View(expens)); }
public ActionResult Save(Expens emp) { bool status = false; if (ModelState.IsValid) { using (MyDatabaseEntities dc = new MyDatabaseEntities()) { if (emp.Id > 0) { //Edit var v = dc.Expenses.Where(a => a.Id == emp.Id).FirstOrDefault(); if (v != null) { // v.ProyectID = emp.ProyectID; v.Name = emp.Name; v.ExpenseDate = emp.ExpenseDate; v.Amount = emp.Amount; v.Description = emp.Description; } } else { //Save dc.Expenses.Add(emp); } try { dc.SaveChanges(); status = true; } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } } return(new JsonResult { Data = new { status = status } }); }
public IHttpActionResult UpdateEmployee(Expens expens) { try { Expens updated = db.Expenses.Find(expens.ExpensesId); db.Entry(updated).CurrentValues.SetValues(expens); db.SaveChanges(); return(Ok(1)); } catch { return(Ok(0)); } }
// GET: Expens/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Expens expens = db.Expenses.Find(id); if (expens == null) { return(HttpNotFound()); } return(View(expens)); }
public IHttpActionResult DeleteExpens(int id) { Expens expens = db.Expenses.Find(id); if (expens == null) { return(NotFound()); } db.Expenses.Remove(expens); db.SaveChanges(); return(Ok(expens)); }
public ActionResult Edit(Expens expens) { if (ModelState.IsValid) { db.Entry(expens).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } return View(expens); }