public bool DeleteTag(TagModel model)
{
_entity.Connection.Open();
var transaction = _entity.Connection.BeginTransaction();
try
{
var tag = _entity.Tag_tbl.FirstOrDefault(e => e.ID == model.ID);
_entity.DeleteObject(tag);
_entity.SaveChanges();
transaction.Commit();
_entity.Connection.Close();
model.IsHasError = false;
model.Message = "Succesfully deleted tag";
return(true);
}
catch (Exception e)
{
transaction.Rollback();
_entity.Connection.Close();
model.IsHasError = true;
model.Message = e.Message;
return(false);
}
}
public bool DeleteNewExpense(ExpenseModel model, out bool isHasError, out string errMessage)
{
_entity.Connection.Open();
var transaction = _entity.Connection.BeginTransaction();
try
{
var expense = _entity.Expense_tbl.Where(e => e.ID == model.ID).First();
_entity.DeleteObject(expense);
_entity.SaveChanges();
transaction.Commit();
_entity.Connection.Close();
isHasError = false;
errMessage = "Succesfully saved new expense";
return(true);
}
catch (Exception e)
{
transaction.Rollback();
_entity.Connection.Close();
isHasError = true;
errMessage = e.Message;
return(false);
}
}