public List <xPlug.BusinessObject.ExpenseCategory> GetExpenseCategories()
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myObjList = db.ExpenseCategories.ToList();
var myBusinessObjList = new List <xPlug.BusinessObject.ExpenseCategory>();
if (myObjList == null)
{
return(myBusinessObjList);
}
//Re-Map each Entity Object to Business Object
foreach (var item in myObjList)
{
var myBusinessObj = ExpenseCategoryMapper.Map <ExpenseCategory, xPlug.BusinessObject.ExpenseCategory>(item);
if (myBusinessObj == null)
{
continue;
}
myBusinessObjList.Add(myBusinessObj);
}
return(myBusinessObjList);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new List <xPlug.BusinessObject.ExpenseCategory>());
}
}
public xPlug.BusinessObject.ExpenseCategory GetExpenseCategory(int expenseCategoryId)
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myObj = db.ExpenseCategories.SingleOrDefault(s => s.ExpenseCategoryId == expenseCategoryId);
if (myObj == null)
{
return(new xPlug.BusinessObject.ExpenseCategory());
}
//Re-Map Entity Object to Business Object
var myBusinessObj = ExpenseCategoryMapper.Map <ExpenseCategory, xPlug.BusinessObject.ExpenseCategory>(myObj);
if (myBusinessObj == null)
{
return(new xPlug.BusinessObject.ExpenseCategory());
}
{ return(myBusinessObj); }
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new xPlug.BusinessObject.ExpenseCategory());
}
}
public int UpdateExpenseCategoryCheckDuplicate(BusinessObject.ExpenseCategory expenseCategory)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = ExpenseCategoryMapper.Map <BusinessObject.ExpenseCategory, ExpenseCategory>(expenseCategory);
if (myEntityObj == null)
{
return(-2);
}
using (var db = new ExpenseManagerDBEntities())
{
if (db.ExpenseCategories.Count(m => m.Title.ToLower().Replace(" ", string.Empty) == expenseCategory.Title.ToLower().Replace(" ", string.Empty) && m.ExpenseCategoryId != expenseCategory.ExpenseCategoryId) > 0)
{
return(-3);
}
db.ExpenseCategories.Attach(myEntityObj);
db.ObjectStateManager.ChangeObjectState(myEntityObj, EntityState.Modified);
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public List <BusinessObject.ExpenseCategory> GetAllActiveExpenseCategories()
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myBusinessObjList = new List <xPlug.BusinessObject.ExpenseCategory>();
var expenseCategoryList = db.ExpenseCategories.Where(m => m.Status == 1).ToList();
if (!expenseCategoryList.Any())
{
return(myBusinessObjList);
}
//Re-Map each Entity Object to Business Object
//myBusinessObjList.AddRange(accountsHeadsObjList.Select(item => ExpenseCategoryMapper.Map<ExpenseCategory, xPlug.BusinessObject.ExpenseCategory>(item.ExpenseCategory)).Where(myBusinessObj => myBusinessObj != null));
foreach (var item in expenseCategoryList)
{
bool any = myBusinessObjList.Any(m => m.ExpenseCategoryId == item.ExpenseCategoryId);
if (!any)
{
var myBusinessObj = ExpenseCategoryMapper.Map <ExpenseCategory, xPlug.BusinessObject.ExpenseCategory>(item);
if (myBusinessObj == null)
{
continue;
}
myBusinessObjList.Add(myBusinessObj);
}
}
if (!myBusinessObjList.Any())
{
return(myBusinessObjList);
}
return(myBusinessObjList.OrderBy(m => m.Title).ToList());
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new List <xPlug.BusinessObject.ExpenseCategory>());
}
}
public bool UpdateExpenseCategory(xPlug.BusinessObject.ExpenseCategory expenseCategory)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = ExpenseCategoryMapper.Map <xPlug.BusinessObject.ExpenseCategory, ExpenseCategory>(expenseCategory);
if (myEntityObj == null)
{
return(false);
}
using (var db = new ExpenseManagerDBEntities())
{
db.ExpenseCategories.Attach(myEntityObj);
db.ObjectStateManager.ChangeObjectState(myEntityObj, EntityState.Modified);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(false);
}
}
public int AddExpenseCategory(xPlug.BusinessObject.ExpenseCategory expenseCategory)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = ExpenseCategoryMapper.Map <xPlug.BusinessObject.ExpenseCategory, ExpenseCategory>(expenseCategory);
if (myEntityObj == null)
{
return(-2);
}
using (var db = new ExpenseManagerDBEntities())
{
db.AddToExpenseCategories(myEntityObj);
db.SaveChanges();
expenseCategory.ExpenseCategoryId = myEntityObj.ExpenseCategoryId;
return(expenseCategory.ExpenseCategoryId);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
