private void DeleteBudget()
{
string message;
if (Budget.Transactions?.Count > 0)
{
message =
$"Wenn sie das Budget von {Budget.Year} löschen, werden alle zugehörigen Buchungen ({Budget.Transactions.Count}) ebenfalls gelöscht. " +
"Wollen sie das Budget trotzdem löschen?";
}
else
{
message = $"Wollen sie das Budget von {Budget.Year} wirklich löschen?";
}
if (MessageBox.Show(message, "Budget löschen?", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
var deletedBudget = Budget;
var deletedTransactions = Budget.Transactions?.ToList() ?? new List <Transaction>();
UnitOfWork.Transactions.RemoveRange(deletedTransactions);
UnitOfWork.Budgets.Remove(deletedBudget);
UnitOfWork.Complete();
foreach (var t in deletedTransactions)
{
TransactionList.Remove(t);
}
BudgetList.Remove(deletedBudget);
Budget = BudgetList.Count > 0 ? BudgetList[0] : null;
}
}
protected override void RefreshMainData()
{
PgMng.Grow(string.Empty, "Proforma");
_selectedOid = ActiveOID;
switch (DataType)
{
case EntityMngFormTypeData.Default:
if (Library.Common.ModulePrincipal.GetUseActiveYear())
{
List = BudgetList.GetList(false, Library.Common.ModulePrincipal.GetActiveYear().Year);
}
else
{
List = BudgetList.GetList(false);
}
break;
case EntityMngFormTypeData.ByParameter:
_sorted_list = List.GetSortedList();
break;
}
PgMng.Grow(string.Empty, "Lista de Proformas");
}
public async Task <IActionResult> delete(BudgetList budgetList)
{
try
{
List <Budget> list = budgetList.Budgets;
for (int i = 0; i < list.Count; i++)
{
var budget = _context.Budget.Where(x => x.StoreCode == list[i].StoreCode).First();
_context.Budget.Remove(budget);
_context.SaveChanges();
}
return(StatusCode(200, new
{
status = "200",
delete = true,
message = "Deleted successfully!"
}));
}
catch (Exception ex)
{
return(StatusCode(500, new
{
status = "500",
delete = false,
message = ex.ToString()
}));
}
}
public BudgetList SyncBudgets(BudgetList budgets)
{
try
{
var budgetsList = new BudgetList();
var budgetIDs = budgets.Select(x => x.BudgetId).ToList();
using (EntityContext context = new EntityContext())
{
var query = (from i in context.Budget
where budgetIDs.Contains(i.BudgetId)
select i).ToList();
//investigate if there is a better way to convert the generic list to ObservableCollection
foreach (var item in query)
{
var tempItem = budgets.FirstOrDefault(x => x.BudgetId == item.BudgetId);
if (tempItem.ModifiedDate < item.ModifiedDate)
budgets.Remove(tempItem);
}
}
return SaveBudgets(budgets);
}
catch (Exception)
{
throw;
}
}
public BudgetSelectForm(Form parent, BudgetList lista)
: base(true, parent, lista)
{
InitializeComponent();
_view_mode = molView.Select;
_action_result = DialogResult.Cancel;
}
/// <summary>
/// Retrieve a budget list from the repository.
/// </summary>
/// <returns>Reference to the budget list in the repository. Guaranteed to be not <c>null</c>.</returns>
public BudgetList Find()
{
var list = this.readStore.RetrieveSingleton <BudgetList>();
if (list == null)
{
list = new BudgetList();
this.Save(list);
}
return(list);
}
/// <summary>
/// Get an initialized budget list
/// </summary>
/// <returns>initialized budget list</returns>
private BudgetList GetBudgetList()
{
var budgetList = this.budgetListRepository.Find();
if (budgetList == null)
{
budgetList = new BudgetList();
this.budgetListRepository.Save(budgetList);
}
return(budgetList);
}
public override void UpdateList()
{
switch (_current_action)
{
case molAction.Add:
if (_entity == null)
{
return;
}
List.AddItem(_entity.GetInfo(false));
if (FilterType == IFilterType.Filter)
{
BudgetList listA = BudgetList.GetList(_filter_results);
listA.AddItem(_entity.GetInfo(false));
_filter_results = listA.GetSortedList();
}
break;
case molAction.Edit:
case molAction.Lock:
case molAction.Unlock:
if (_entity == null)
{
return;
}
ActiveItem.CopyFrom(_entity);
break;
case molAction.Delete:
if (ActiveItem == null)
{
return;
}
List.RemoveItem(ActiveOID);
if (FilterType == IFilterType.Filter)
{
BudgetList listD = BudgetList.GetList(_filter_results);
listD.RemoveItem(ActiveOID);
_filter_results = listD.GetSortedList();
}
break;
}
RefreshSources();
if (_entity != null)
{
Select(_entity.Oid);
}
_entity = null;
}
private void NewBudget()
{
var budget = new Budget();
var vm = new EditBudgetViewModel(new UnitOfWorkFactory(), budget);
vm.Init();
var window = new EditBudgetView(vm);
if (window.ShowDialog() ?? false)
{
BudgetList.Add(budget);
Budget = budget;
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
DataAbstract DA = new DataAbstract();
if (Convert.ToInt32(Session["userID"]) != 0)
{
userID = Convert.ToInt32(Session["userID"]);
DataSet accountData = DA.returnAccounts(userID); //gets all accounts
System.Data.DataTable accountsTable = accountData.Tables[0]; //table holding all account entries for the user
object s = accountsTable.Rows[0].Field <object>("AcctNumber"); //sets the default account to the first of the user's accounts. LIKELY CHANGE LATER.
if (Convert.ToInt64(Session["account"]) == 0)
{
Session["account"] = Convert.ToInt64(s); //saves the first account as the default account during the session
}
userID = Convert.ToInt16(Session["userID"]); //saves the Session userID to the variable on this page
}
else
{
Session["userID"] = 1; //temporary solution for demo 3/19/2017
Session["account"] = 211111110;
}
BudgetDS = DA.returnBoundedBudgets(Convert.ToInt64(Session["account"]), d1, d2);
//Sets the source for the listview
BudgetList.DataSource = BudgetDS;
BudgetList.DataBind();
//LoadSubjects();
DataTable accounts = DA.returnAccounts(userID).Tables[0];
DropDownList DDL = AccountList;
DDL.Items.Insert(0, new ListItem("Select Account", "0"));
DDL.DataSource = accounts;
DDL.DataTextField = "AcctNumber";
DDL.DataValueField = "AcctNumber";
DDL.DataBind();
DataTable categories = DA.returnCategories(userID).Tables[0];
DropDownList DDL2 = CategorySelect;
DDL2.Items.Insert(0, new ListItem("Select Category", "0"));
DDL2.DataSource = categories;
DDL2.DataTextField = "Name";
DDL2.DataValueField = "CategoryID";
DDL2.DataBind();
}
public override void PrintList()
{
PgMng.Reset(3, 1, Face.Resources.Messages.LOADING_DATA, this);
BudgetReportMng reportMng = new BudgetReportMng(AppContext.ActiveSchema, this.Text, this.FilterValues);
PgMng.Grow(Face.Resources.Messages.BUILDING_REPORT);
ReportClass report = reportMng.GetListReport(BudgetList.GetList(Datos.DataSource as IList <BudgetInfo>),
null,
SerieList.GetList(false));
PgMng.FillUp();
ShowReport(report);
}
public BudgetMngForm(bool isModal, Form parent, BudgetList list)
: base(isModal, parent, list)
{
InitializeComponent();
SetView(molView.Normal);
// Parche para poder abrir el formulario en modo diseño y no perder la configuracion de columnas
DatosLocal_BS = Datos;
Tabla.DataSource = DatosLocal_BS;
SetMainDataGridView(Tabla);
Datos.DataSource = BudgetList.NewList().GetSortedList();
SortProperty = Fecha.DataPropertyName;
SortDirection = ListSortDirection.Descending;
}
public async Task <IActionResult> update(BudgetList budgetList)
{
try
{
List <Budget> list = budgetList.Budgets;
for (int i = 0; i < list.Count; i++)
{
bool discExist = false;
discExist = _context.Budget.Any(c => c.StoreCode == list[i].StoreCode);
if (discExist == true)
{
var budget = _context.Budget.Where(x => x.StoreCode == list[i].StoreCode).First();
budget.Amount = list[i].Amount;
budget.TransactionDate = list[i].TransactionDate;
budget.JournalNumber = list[i].JournalNumber;
_context.Budget.Update(budget);
_context.SaveChanges();
}
else
{
return(StatusCode(404, new
{
status = "404",
update = false,
message = "Discount code not found."
}));
}
}
return(StatusCode(200, new
{
status = "200",
update = true,
message = "updated successfully!"
}));
}
catch (Exception ex)
{
return(StatusCode(500, new
{
status = "500",
update = false,
message = ex.ToString()
}));
}
}
public ActionResult List(DateTime bDate, DateTime eDate, string SearchType = "", int codeID = 0, string code = "", int codeID2 = 0)
{
IEnumerable <programeventbudget> BudgetList;
if (SearchType == "EventSearch")
{
BudgetList = ProgramEventBudgetRepository.GetEventBudgetByEventID(codeID);
}
else if (SearchType == "StatusSearch")
{
BudgetList = ProgramEventBudgetRepository.GetEventBudgetByStatus(code);
}
else
{
BudgetList = ProgramEventBudgetRepository.GetEventBudgetByDueDateRange(bDate, eDate);
}
ViewBag.RecordCount = BudgetList.Count();
return(View(BudgetList));
}
public async Task <IActionResult> create(BudgetList budgetList)
{
try
{
List <Budget> list = budgetList.Budgets;
for (int i = 0; i < list.Count; i++)
{
Budget budget = new Budget();
budget.StoreCode = list[i].StoreCode;
budget.StoreId = list[i].StoreId;
budget.StoreName = list[i].StoreName;
budget.Amount = list[i].Amount;
budget.JournalNumber = list[i].JournalNumber;
budget.TransactionDate = list[i].TransactionDate;
_context.Add(budget);
_context.SaveChanges();
}
return(StatusCode(200, new
{
status = "200",
create = true,
message = "Created successfully!"
}));
}
catch (Exception ex)
{
return(StatusCode(500, new
{
status = "500",
create = false,
message = ex.ToString()
}));
}
}
public static BudgetList GetBudgets()
{
// Retrieve the Budget records from the data store
List<BudgetDetails> details = SiteProvider.Accounts.GetBudgets();
BudgetList list = new BudgetList();
// Copy from the Budget records to the Budget objects
foreach (BudgetDetails bd in details)
{
if (bd != null)
{
// Create the new Budget object from the Budget Details retrieved
// from the database.
Budget b = new Budget(bd);
// Retrieve the list of Budget Items for the specified Budget.
List<BudgetItemDetails> itemDetails = SiteProvider.Accounts.GetBudgetItems(bd.ID);
BudgetItemList items = new BudgetItemList();
foreach (BudgetItemDetails bid in itemDetails)
{
if (bid != null)
{
BudgetItem bi = new BudgetItem(bid);
bi.Budget = b;
if (bid.TagID != -1)
bi.Tag = KapitalManager.Instance.Tags.FindByID(bid.TagID);
// Add the Budget Item to the list of BudgetItems.
items.Add(bi);
}
}
// Attach the list of items to the current Budget
b.BudgetItems = items;
list.Add(b);
}
}
return list;
}
public BudgetList SaveBudgets(BudgetList budgets)
{
try
{
bool updateFound = false;
using (EntityContext context = new EntityContext())
{
foreach (var item in budgets)
{
if (item.BudgetId > 0) //Update
{
var original = context.Budget.Where(t =>
t.BudgetId == item.BudgetId &&
t.ModifiedDate < item.ModifiedDate &&
!t.IsDeleted).FirstOrDefault();
//update database only if the transaction in DB is older
if (original != null)
{
item.HasChanges = false;
original.CreatedUser = context.User.Where(k => !k.IsDeleted).Single(p => p.UserId == item.CreatedUser.UserId);
original.ModifiedUser = context.User.Where(k => !k.IsDeleted).Single(p => p.UserId == item.ModifiedUser.UserId);
item.FromDate = new DateTime(item.FromDate.Year, item.FromDate.Month, item.FromDate.Day, 0, 0, 0);
item.ToDate = new DateTime(item.ToDate.Year, item.ToDate.Month, item.ToDate.Day, 0, 0, 0);
context.Entry(original).CurrentValues.SetValues(item);
updateFound = true;
}
}
else //Insert
{
item.CreatedUser = context.User.Where(k => !k.IsDeleted).Single(p => p.UserId == item.CreatedUser.UserId);
item.ModifiedUser = context.User.Where(k => !k.IsDeleted).Single(p => p.UserId == item.ModifiedUser.UserId);
item.FromDate = new DateTime(item.FromDate.Year, item.FromDate.Month, item.FromDate.Day, 0, 0, 0);
item.ToDate = new DateTime(item.ToDate.Year, item.ToDate.Month, item.ToDate.Day, 0, 0, 0);
context.Budget.Add(item);
updateFound = true;
}
}
if (updateFound)
context.SaveChanges();
}
GetTransactionsForBudgets(budgets);
budgets.PrepareForServiceSerialization();
return budgets;
}
catch (DbEntityValidationException e)
{
StringBuilder s = new StringBuilder();
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);
s.Append(string.Format("{0} - {1}", ve.PropertyName, ve.ErrorMessage));
}
}
throw new DbEntityValidationException(s.ToString());
}
catch (Exception)
{
throw;
}
}
private void GetTransactionsForBudgets(BudgetList budgetList)
{
try
{
using (EntityContext context = new EntityContext())
{
foreach (var item in budgetList)
{
var inQuery = from t in context.Transaction
.Include(t => t.TransactionType).Where(k => !k.IsDeleted)
where t.TransactionDate >= item.FromDate && t.TransactionDate <= item.ToDate
&& !t.IsDeleted && t.ModifiedUser.UserId == item.ModifiedUser.UserId
select t;
TransactionList tl = new TransactionList();
foreach (var inItem in inQuery.ToList())
tl.Add(inItem);
item.Transactions = tl;
////Apply the rule to create a new budget if the expired one is set to Repeat
//if (item.Repeat && item.ToDate < DateTime.Now)
//{
// var dataSpanRange = item.ToDate - item.FromDate;
// var dataSpanToday = DateTime.Now - item.ToDate;
// var dateDif = dataSpanRange.Days;
// var diff = dataSpanToday.Days % dataSpanRange.Days;
// var newFromDate = DateTime.Now.AddDays(-diff + 1);
// var newToDate = newFromDate.AddDays(dataSpanRange.Days);
// var test = newToDate - newFromDate;
// var newBudget = item.Clone();
// newBudget.FromDate = newFromDate;
// newBudget.ToDate = newToDate;
// item.Repeat = false;
// context.Budget.Add(newBudget);
// //context.SaveChanges();
//}
}
//return budgetList;
}
}
catch (Exception)
{
throw;
}
}
public BudgetList GetAllBudgets(int userId)
{
try
{
BudgetList budgetList = new BudgetList();
using (EntityContext context = new EntityContext())
{
var query = (from i in context.Budget
.Include(i => i.CreatedUser)
.Include(i => i.ModifiedUser)
where !i.IsDeleted && i.ModifiedUser.UserId == userId
select i).ToList();
//investigate if there is a better way to convert the generic list to ObservableCollection
foreach (var item in query)
budgetList.Add(item);
GetTransactionsForBudgets(budgetList);
budgetList.PrepareForServiceSerialization();
return budgetList;
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Save the budget list, or add it to the repository. Beware: replaces existing budget list in repository.
/// </summary>
/// <param name="budgetList">Budget list to save</param>
internal void Save(BudgetList budgetList)
{
this.readStore.StoreSingleton(budgetList);
}
public ServiceData()
{
TransactionList = new TransactionList();
TransactionImageList = new TransactionImageList();
BudgetList = new BudgetList();
}
private async void LoadCachedBudgets(Action<BudgetList, Exception> callback)
{
var retVal = new BudgetList();
try
{
foreach (var item in await StorageUtility.ListItems(BUDGETS_FOLDER, App.Instance.User.UserName))
{
var budget = await StorageUtility.RestoreItem<Budget>(BUDGETS_FOLDER, item, App.Instance.User.UserName);
BudgetList.Add(budget);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
//callback(null, ex);
}
//SetupBudgetList(retVal, false);
//BudgetList = retVal;
callback(BudgetList, null);
}
