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);
}
