public bool CreateTag(TagModel model)
{
_entity.Connection.Open();
var transaction = _entity.Connection.BeginTransaction();
try
{
var tag = new Tag_tbl();
tag.Description = model.TagDescription;
_entity.AddToTag_tbl(tag);
_entity.SaveChanges();
transaction.Commit();
_entity.Connection.Close();
model.IsHasError = false;
model.Message = "Succesfully saved new tag";
return(true);
}
catch (Exception e)
{
transaction.Rollback();
_entity.Connection.Close();
model.IsHasError = true;
model.Message = e.Message;
return(false);
}
}
public bool CreateNewExpense(IndexViewModel model, string user)
{
_entity.Connection.Open();
var transaction = _entity.Connection.BeginTransaction();
var currentUser = Membership.GetUser(user, true);
try
{
var expense = new Expense_tbl();
expense.ExpenseDate = model.ExpenseModelEntry.ExpenseDate;
expense.Amount = model.ExpenseModelEntry.Amount;
expense.Description = model.ExpenseModelEntry.Description;
expense.TagID = int.Parse(model.ExpenseModelEntry.Tag);
if (currentUser != null)
{
expense.UserID = currentUser.Email;
}
_entity.AddToExpense_tbl(expense);
_entity.SaveChanges();
transaction.Commit();
_entity.Connection.Close();
model.IsHasError = false;
model.Message = "Succesfully saved new expense";
return(true);
}
catch (Exception e)
{
transaction.Rollback();
_entity.Connection.Close();
model.IsHasError = true;
model.Message = e.Message;
return(false);
}
}