public int UpdateExpenseItemCheckDuplicate(BusinessObject.ExpenseItem expenseItem)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = ExpenseItemMapper.Map <BusinessObject.ExpenseItem, ExpenseItem>(expenseItem);
if (myEntityObj == null)
{
return(-2);
}
using (var db = new ExpenseManagerDBEntities())
{
if (db.ExpenseItems.Count(m => m.Title.ToLower().Replace(" ", string.Empty) == expenseItem.Title.ToLower().Replace(" ", string.Empty) && m.ExpenseItemId != expenseItem.ExpenseItemId) > 0)
{
return(-3);
}
db.ExpenseItems.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 int AddExpenseItemCheckDuplicate(BusinessObject.ExpenseItem expenseItem)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = ExpenseItemMapper.Map <xPlug.BusinessObject.ExpenseItem, ExpenseItem>(expenseItem);
if (myEntityObj == null)
{
return(-2);
}
using (var db = new ExpenseManagerDBEntities())
{
if (db.ExpenseItems.Count(m => m.Title.ToLower().Replace(" ", string.Empty) == expenseItem.Title.ToLower().Replace(" ", string.Empty)) > 0)
{
return(-3);
}
db.AddToExpenseItems(myEntityObj);
db.SaveChanges();
expenseItem.ExpenseItemId = myEntityObj.ExpenseItemId;
return(expenseItem.ExpenseItemId);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public List <BusinessObject.ExpenseItem> GetOrderedExpenseItemsByAccountsHeadId(Int32 accountsHeadId)
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myObjList = db.ExpenseItems.Where(m => m.AccountsHeadId == accountsHeadId).ToList();
var myBusinessObjList = new List <BusinessObject.ExpenseItem>();
if (!myObjList.Any())
{
return(myBusinessObjList);
}
//Re-Map each Entity Object to Business Object
foreach (var item in myObjList)
{
var myBusinessObj = ExpenseItemMapper.Map <ExpenseItem, BusinessObject.ExpenseItem>(item);
if (myBusinessObj == null)
{
continue;
}
myBusinessObjList.Add(myBusinessObj);
}
return(myBusinessObjList.OrderBy(m => m.AccountsHead.Title).ThenBy(m => m.Title).ToList());
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new List <BusinessObject.ExpenseItem>());
}
}
public List <BusinessObject.ExpenseItem> GetExpenseItemsByExpenseCategoryId(Int32 expenseCategoryId)
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myObjList = db.ExpenseItems.ToList().FindAll(m => m.ExpenseCategoryId == expenseCategoryId);
var myBusinessObjList = new List <xPlug.BusinessObject.ExpenseItem>();
if (myObjList == null)
{
return(myBusinessObjList);
}
//Re-Map each Entity Object to Business Object
foreach (var item in myObjList)
{
var myBusinessObj = ExpenseItemMapper.Map <ExpenseItem, xPlug.BusinessObject.ExpenseItem>(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.ExpenseItem>());
}
}
public BusinessObject.ExpenseItem GetExpenseItem(int expenseItemId)
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myObj = db.ExpenseItems.SingleOrDefault(s => s.ExpenseItemId == expenseItemId);
if (myObj == null)
{
return(new xPlug.BusinessObject.ExpenseItem());
}
//Re-Map Entity Object to Business Object
var myBusinessObj = ExpenseItemMapper.Map <ExpenseItem, xPlug.BusinessObject.ExpenseItem>(myObj);
if (myBusinessObj == null)
{
return(new xPlug.BusinessObject.ExpenseItem());
}
{ return(myBusinessObj); }
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new xPlug.BusinessObject.ExpenseItem());
}
}
public Dictionary <List <BusinessObject.TransactionItem>, List <BusinessObject.ExpenseItem> > GetTransactionItemsByExpenseTransaction(long expenseTransactionId)
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myObjList = db.TransactionItems.Where(m => m.ExpenseTransactionId == expenseTransactionId).ToList();
var myBusinessObjList = new List <BusinessObject.TransactionItem>();
var dictCollection = new Dictionary <List <BusinessObject.TransactionItem>, List <BusinessObject.ExpenseItem> >();
var expenseItems = new List <BusinessObject.ExpenseItem>();
if (!myObjList.Any())
{
return(dictCollection);
}
//Re-Map each Entity Object to Business Object
foreach (var item in myObjList)
{
var myBusinessObj = TransactionItemMapper.Map <TransactionItem, BusinessObject.TransactionItem>(item);
if (myBusinessObj == null)
{
continue;
}
var transItem = item;
var expenseItem = (from x in db.ExpenseItems
where x.ExpenseItemId == transItem.ExpensenseItemId
select x).ToList();
if (!expenseItem.Any())
{
return(dictCollection);
}
var itemObj = ExpenseItemMapper.Map <ExpenseItem, BusinessObject.ExpenseItem>(expenseItem.ElementAt(0));
myBusinessObj.TotalPrice = myBusinessObj.RequestedQuantity * myBusinessObj.RequestedUnitPrice;
myBusinessObj.ApprovedTotalPrice = 0;
expenseItems.Add(itemObj);
myBusinessObjList.Add(myBusinessObj);
}
if (!expenseItems.Any() || !myBusinessObjList.Any())
{
return(dictCollection);
}
var orderTransactionItems = myBusinessObjList.OrderBy(m => m.ExpenseItem.Title).ToList();
var orderedExpenseItems = expenseItems.OrderBy(m => m.Title).ToList();
dictCollection.Add(orderTransactionItems, orderedExpenseItems);
return(dictCollection);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new Dictionary <List <BusinessObject.TransactionItem>, List <BusinessObject.ExpenseItem> >());
}
}
public List <BusinessObject.ExpenseItem> GetLastInsertedExpenseItem(int accountHead)
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var itemList = db.ExpenseItems.Where(m => m.AccountsHeadId == accountHead).ToList();
if (!itemList.Any())
{
return(new List <BusinessObject.ExpenseItem>());
}
var myObjList = itemList.OrderByDescending(m => long.Parse(m.Code)).Take(1).ToList();
var myBusinessObjList = new List <BusinessObject.ExpenseItem>();
if (!myObjList.Any())
{
return(myBusinessObjList);
}
//Re-Map each Entity Object to Business Object
foreach (var item in myObjList)
{
var myBusinessObj = ExpenseItemMapper.Map <ExpenseItem, BusinessObject.ExpenseItem>(item);
if (myBusinessObj == null)
{
continue;
}
myBusinessObjList.Add(myBusinessObj);
}
return(myBusinessObjList.OrderBy(m => m.AccountsHead.Title).ThenBy(m => m.Title).ToList());
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new List <xPlug.BusinessObject.ExpenseItem>());
}
}
public bool UpdateExpenseItem(BusinessObject.ExpenseItem expenseItem)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = ExpenseItemMapper.Map <BusinessObject.ExpenseItem, ExpenseItem>(expenseItem);
if (myEntityObj == null)
{
return(false);
}
using (var db = new ExpenseManagerDBEntities())
{
db.ExpenseItems.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 AddExpenseItem(BusinessObject.ExpenseItem expenseItem)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = ExpenseItemMapper.Map <xPlug.BusinessObject.ExpenseItem, ExpenseItem>(expenseItem);
if (myEntityObj == null)
{
return(-2);
}
using (var db = new ExpenseManagerDBEntities())
{
db.AddToExpenseItems(myEntityObj);
db.SaveChanges();
expenseItem.ExpenseItemId = myEntityObj.ExpenseItemId;
return(expenseItem.ExpenseItemId);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
