public int UpdateAssetCategory(xPlug.BusinessObject.AssetCategory assetCategory)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = AssetCategoryMapper.Map <xPlug.BusinessObject.AssetCategory, AssetCategory>(assetCategory);
if (myEntityObj == null)
{
return(-2);
}
using (var db = new ExpenseManagerDBEntities())
{
if (db.AssetCategories.Any())
{
if (db.AssetCategories.Count(m => m.Name == myEntityObj.Name && m.AssetCategoryId != myEntityObj.AssetCategoryId) > 0)
{
return(-3);
}
}
db.AssetCategories.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 <xPlug.BusinessObject.AssetCategory> GetAssetCategories()
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myObjList = db.AssetCategories.ToList();
var myBusinessObjList = new List <xPlug.BusinessObject.AssetCategory>();
if (myObjList == null)
{
return(myBusinessObjList);
}
//Re-Map each Entity Object to Business Object
foreach (var item in myObjList)
{
var myBusinessObj = AssetCategoryMapper.Map <AssetCategory, xPlug.BusinessObject.AssetCategory>(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.AssetCategory>());
}
}
public int UpdateAssetCategoryCheckDuplicate(BusinessObject.AssetCategory assetCategory)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = AssetCategoryMapper.Map <BusinessObject.AssetCategory, AssetCategory>(assetCategory);
if (myEntityObj == null)
{
return(-2);
}
using (var db = new ExpenseManagerDBEntities())
{
if (db.AssetCategories.Count(m => m.Name.ToLower().Replace(" ", string.Empty) == assetCategory.Name.ToLower().Replace(" ", string.Empty) && m.AssetCategoryId != assetCategory.AssetCategoryId) > 0)
{
return(-3);
}
db.AssetCategories.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 xPlug.BusinessObject.AssetCategory GetAssetCategory(int assetCategoryId)
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myObj = db.AssetCategories.SingleOrDefault(s => s.AssetCategoryId == assetCategoryId);
if (myObj == null)
{
return(new xPlug.BusinessObject.AssetCategory());
}
//Re-Map Entity Object to Business Object
var myBusinessObj = AssetCategoryMapper.Map <AssetCategory, xPlug.BusinessObject.AssetCategory>(myObj);
if (myBusinessObj == null)
{
return(new xPlug.BusinessObject.AssetCategory());
}
{ return(myBusinessObj); }
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new xPlug.BusinessObject.AssetCategory());
}
}
public List <BusinessObject.AssetCategory> GetFilterdAssetCategories()
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myObjList = db.AssetCategories.Where(m => m.Status == 1 && m.AssetTypes.Any()).ToList();
var myBusinessObjList = new List <BusinessObject.AssetCategory>();
if (!myObjList.Any())
{
return(myBusinessObjList);
}
//Re-Map each Entity Object to Business Object
foreach (var item in myObjList)
{
var myBusinessObj = AssetCategoryMapper.Map <AssetCategory, BusinessObject.AssetCategory>(item);
if (myBusinessObj == null)
{
continue;
}
myBusinessObjList.Add(myBusinessObj);
}
return(myBusinessObjList.OrderBy(m => m.Name).ToList());
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new List <BusinessObject.AssetCategory>());
}
}
