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