public int UpdateAccountsHead(BusinessObject.AccountsHead accountsHead)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = AccountsHeadMapper.Map <BusinessObject.AccountsHead, AccountsHead>(accountsHead);
if (myEntityObj == null)
{
return(-2);
}
using (var db = new ExpenseManagerDBEntities())
{
var objTitle = myEntityObj.Title.ToLower().Replace(" ", string.Empty.Trim());
if (db.AccountsHeads.Count(m => m.Title.ToLower().Replace(" ", string.Empty.Trim()) == objTitle && m.AccountsHeadId != myEntityObj.AccountsHeadId) > 0)
{
return(-3);
}
db.AccountsHeads.Attach(myEntityObj);
db.ObjectStateManager.ChangeObjectState(myEntityObj, EntityState.Modified);
db.SaveChanges();
return(accountsHead.AccountsHeadId);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public int AddAccountsHeadCheckDuplicate(BusinessObject.AccountsHead accountsHead)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = AccountsHeadMapper.Map <BusinessObject.AccountsHead, AccountsHead>(accountsHead);
if (myEntityObj == null)
{
return(-2);
}
using (var db = new ExpenseManagerDBEntities())
{
if (db.AccountsHeads.Count(m => m.Title.ToLower().Replace(" ", string.Empty) == accountsHead.Title.ToLower().Replace(" ", string.Empty)) > 0)
{
return(-3);
}
db.AddToAccountsHeads(myEntityObj);
db.SaveChanges();
accountsHead.AccountsHeadId = myEntityObj.AccountsHeadId;
return(accountsHead.AccountsHeadId);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
