public void AddExpenceRange(string title, decimal amount, DateTime dateFirstIncome, DateTime dateLastIncome) { // add first income Expences.Add(new Expence { Amount = amount, Date = dateFirstIncome, Title = title }); // add last income Expences.Add(new Expence { Amount = amount, Date = dateLastIncome, Title = title }); // add income inbetween var startDate = dateFirstIncome.AddMonths(1); while (startDate < dateLastIncome) { Expences.Add(new Expence { Amount = amount, Date = startDate, Title = title }); startDate = startDate.AddMonths(1); } }
public void verifydata() { if (Expences.Text == "") { MessageBox.Show("Please Select Expences"); Expences.Focus(); } }
public ExpencesControllerTests() { var mockingEntities = new EntitiesMock(); mock = mockingEntities.Mock; validController = mockingEntities.ValidController; notValidController = mockingEntities.NotValidController; entity = mockingEntities.singleEntity; }
public decimal GetTotalExpenceAmount(int year) { decimal sum = 0; foreach (var ex in Expences.Where(x => x.Date.Year == year)) { sum += ex.Amount; } return(sum); }
public ExpenceWindow(Expences expence) { InitializeComponent(); _expence = expence; btnConfirm.Visibility = Visibility.Hidden; btnDeny.Visibility = Visibility.Hidden; SetIsEnabledFalse(); SetExpenceFields(); }
public bool InsertExpence(Expences expences) { SqlCommand cmd = GetCommand("spInsertExpence"); cmd.Parameters.AddWithValue("@ExpenceDetails", expences.ExpenceDetail); cmd.Parameters.AddWithValue("@ExpenceCost", expences.ExpenceCost); cmd.Parameters.AddWithValue("@ExpenceDate", expences.ExpenceDate); int rowAffected = cmd.ExecuteNonQuery(); con.Close(); return(rowAffected > 0 ? true : false); }
private Expences GetExpenceFromData() { var result = new Expences(); string name; //50 is max length if (boxName.Text == "" || boxName.Text.Length > 50) { throw new Exception(); } else { name = boxName.Text; } string comment; if (boxComment.Text == "" || boxComment.Text.Length > 50) { throw new Exception(); } else { comment = boxComment.Text; } int moneyValue; if (!Int32.TryParse(boxMoney.Text, out moneyValue)) { throw new Exception(); } int idType = Queries.GetExpenceTypeId(comboType.Text); DateTime date = DatePicker.SelectedDate.Value.Date; result.Name = name; result.BillDate = date; result.Comment = comment; result.MonthAmount = moneyValue; result.IdExpenceType = idType; result.IdUser = UserInfo.UserId; result.IdExpence = (_expence != null) ? _expence.IdExpence : 0; return(result); }
private async Task <bool> IsAdminOrOwner(Expences entity, bool ownerCheck) { var currentUser = await _userManager.GetUserAsync(User); var personRoles = _userManager.GetRolesAsync(currentUser); if (personRoles.Result.Intersect(Constants.rolesExpences_Admin.Split(',').Select(x => x.Trim())).Count() != 0) { return(true); } if (ownerCheck && entity != null) { return(entity.User == currentUser); } return(false); }
public async Task <IActionResult> Edit(long id, [Bind("Id,DocumentNumber,DocumentDate,DocumentTypeId,PersonId,UserId,OurCompanyId,CompanyId,DesiredPaymentDate,AmountOfPayment,CurrencyId,PurposeOfPayment")] Expences expences) { if (id != expences.Id) { return(NotFound()); } if (ModelState.IsValid) { if (!await _expencesService.UpdateAsync(expences)) { return(NotFound()); } return(RedirectToAction(nameof(Index))); } SetViewData(); return(View(expences)); }
public decimal GetBalanceForDate(DateTime date) { var lastBalanceBeforeDate = Balances.Where(x => x.Date <= date).OrderByDescending(x => x.Date).FirstOrDefault(); if (lastBalanceBeforeDate != null) { var sumExpences = Expences.Where(x => x.Date > lastBalanceBeforeDate.Date && x.Date <= date).Sum(x => x.Amount); var sumIncome = Income.Where(x => x.Date > lastBalanceBeforeDate.Date && x.Date <= date).Sum(x => x.Amount); var sum = sumIncome - sumExpences; return(lastBalanceBeforeDate.Amount + sum); } else { var sumExpences = Expences.Where(x => x.Date <= date).Sum(x => x.Amount); var sumIncome = Income.Where(x => x.Date <= date).Sum(x => x.Amount); return(sumIncome - sumExpences); } }
public async Task <IActionResult> Create([Bind("Id,DocumentNumber,DocumentDate,DocumentTypeId,PersonId,UserId,OurCompanyId,CompanyId,DesiredPaymentDate,ApprovedPaymentDate,AmountOfPayment,CurrencyId,Approved,Declined,PurposeOfPayment")] Expences expences) { if (ModelState.IsValid) { #region можно взять юзера из куков. но не буду (предпочту лишний раз обратиться в базу, возможно зря). А делается это так // Получаем user ID не делая дополнительную вылазку в базу /* * var claimsIdentity = (ClaimsIdentity)this.User.Identity; * var claim = claimsIdentity.FindFirst(System.Security.Claims.ClaimTypes.NameIdentifier); * var userId = claim.Value; * * // Но можно выкинуть этот код в отдельный класс * * public static class UserHelpers * { * public static string GetUserId(this IPrincipal principal) * { * var claimsIdentity = (ClaimsIdentity)principal.Identity; * var claim = claimsIdentity.FindFirst(System.Security.Claims.ClaimTypes.NameIdentifier); * return claim?.Value; * } * } * * // И обращаться так: var userId = this.User.GetUserId(); * /**/ #endregion expences.UserId = _userManager.GetUserId(User); await _expencesService.AddAsync(expences); return(RedirectToAction(nameof(Index))); } SetViewData(); return(View(expences)); }
public void AddExpence(IExpence expence) { Expences.Add(expence); }
public bool InsertExpence(Expences expences) { return(repository.InsertExpence(expences)); }