public static ObservableCollection <Budget_Transactions> GetTransactionsByDateTime(DateTime datetime) { ObservableCollection <Budget_Transactions> transactions = new ObservableCollection <Budget_Transactions>(); try { using (var context = new CarloniusEntities()) { List <TransactionsDatesView> transactionsView = context.TransactionsDatesViews .Where(trans => datetime == trans.Date).ToList(); List <Budget_Transactions> budgetTransactionList = transactionsView .Select(trans => new Budget_Transactions() { Amount = trans.Amount, CategoryID = trans.CategoryID, CreatedDate = trans.CreatedDate, DateTime = trans.DateTime, Description = trans.Description, ModifiedDate = trans.ModifiedDate, TransactionID = trans.TransactionID }) .ToList(); foreach (var trans in budgetTransactionList) { transactions.Add(trans); } } } catch (Exception ex) { HandleException(ex, "GetTransactionByDateTime"); } return(transactions); }
public static void InsertCategory(Budget_Categories category) { try { using (var context = new CarloniusEntities()) { context.Budget_Categories.Add(category); context.SaveChanges(); } } catch (Exception ex) { HandleException(ex, "InsertCategory"); } }
public static void AddTransaction(Budget_Transactions transaction) { try { using (var context = new CarloniusEntities()) { context.Budget_Transactions.Add(transaction); context.SaveChanges(); } } catch (Exception ex) { HandleException(ex, "AddTransaction"); } }
public static void UpdateTransaction(Budget_Transactions transaction) { try { using (var context = new CarloniusEntities()) { context.Budget_Transactions.Attach(transaction); context.Entry(transaction).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } catch (Exception ex) { HandleException(ex, "UpdateTransaction"); } }
public static Budget_Categories GetCategory(string category) { Budget_Categories cat = null; try { using (var context = new CarloniusEntities()) { cat = context.Budget_Categories.FirstOrDefault(c => c.Category.Equals(category, StringComparison.OrdinalIgnoreCase)); } } catch (Exception ex) { HandleException(ex, "GetCategory"); } return(cat); }
public static string GetCategoryByID(int categoryID) { string category = string.Empty; try { using (var context = new CarloniusEntities()) { category = context.Budget_Categories.FirstOrDefault(c => c.CategoryID == categoryID).Category; } } catch (Exception ex) { HandleException(ex, "GetCategoryByID"); } return(category); }
public static List <Budget_GetAllCategories_Result> GetAllCategories() { List <Budget_GetAllCategories_Result> categories = new List <Budget_GetAllCategories_Result>(); try { using (var context = new CarloniusEntities()) { ObjectResult <Budget_GetAllCategories_Result> resultSet = context.Budget_GetAllCategories(); List <Budget_GetAllCategories_Result> resultList = (from cat in resultSet select cat).ToList(); foreach (Budget_GetAllCategories_Result result in resultList) { categories.Add(result); } } } catch (Exception ex) { HandleException(ex, "GetAllCategories"); } return(categories.OrderBy(c => c.Category).ToList()); }
public static void AddDateTimeLookup(DateTime date) { try { using (var context = new CarloniusEntities()) { DateTime shortDate = GetDateTime(date); Budget_DateTimeLookup lookup = context.Budget_DateTimeLookup.FirstOrDefault(l => l.DateTime.Equals(shortDate)); if (lookup == null) { context.Budget_DateTimeLookup.Add(new Budget_DateTimeLookup { DateTime = shortDate }); context.SaveChanges(); } } } catch (Exception ex) { HandleException(ex, "AddDateTimeLookup"); } }