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