public xPlug.BusinessObject.PaymentVoucherNumber GetPaymentVoucherNumber(int paymentVoucherNumberId)
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myObj = db.PaymentVoucherNumbers.SingleOrDefault(s => s.PaymentVoucherNumberId == paymentVoucherNumberId);
if (myObj == null)
{
return(new xPlug.BusinessObject.PaymentVoucherNumber());
}
//Re-Map Entity Object to Business Object
var myBusinessObj = PaymentVoucherNumberMapper.Map <PaymentVoucherNumber, xPlug.BusinessObject.PaymentVoucherNumber>(myObj);
if (myBusinessObj == null)
{
return(new xPlug.BusinessObject.PaymentVoucherNumber());
}
{ return(myBusinessObj); }
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(new xPlug.BusinessObject.PaymentVoucherNumber());
}
}
public List <xPlug.BusinessObject.PaymentVoucherNumber> GetPaymentVoucherNumbers()
{
try
{
using (var db = new ExpenseManagerDBEntities())
{
var myObjList = db.PaymentVoucherNumbers.ToList();
var myBusinessObjList = new List <xPlug.BusinessObject.PaymentVoucherNumber>();
if (myObjList == null)
{
return(myBusinessObjList);
}
//Re-Map each Entity Object to Business Object
foreach (var item in myObjList)
{
var myBusinessObj = PaymentVoucherNumberMapper.Map <PaymentVoucherNumber, xPlug.BusinessObject.PaymentVoucherNumber>(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.PaymentVoucherNumber>());
}
}
public long AddExpenseTransactionPaymentHistory(xPlug.BusinessObject.ExpenseTransactionPaymentHistory expenseTransactionPaymentHistory)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = ExpenseTransactionPaymentHistoryMapper.Map <xPlug.BusinessObject.ExpenseTransactionPaymentHistory, ExpenseTransactionPaymentHistory>(expenseTransactionPaymentHistory);
if (myEntityObj == null)
{
return(-2);
}
using (var db = new ExpenseManagerDBEntities())
{
db.AddToExpenseTransactionPaymentHistories(myEntityObj);
db.SaveChanges();
expenseTransactionPaymentHistory.ExpenseTransactionPaymentHistoryId = myEntityObj.ExpenseTransactionPaymentHistoryId;
var paymentVoucher = new BusinessObject.PaymentVoucherNumber
{
TransactionId = expenseTransactionPaymentHistory.ExpenseTransactionPaymentHistoryId,
TransactionTotalAmount = expenseTransactionPaymentHistory.ExpenseTransaction.TotalApprovedAmount,
PaymentDate = expenseTransactionPaymentHistory.PaymentDate,
DateSubmitted = DateMap.GetLocalDate()
};
var pcvEntityObj = PaymentVoucherNumberMapper.Map <BusinessObject.PaymentVoucherNumber, PaymentVoucherNumber>(paymentVoucher);
db.AddToPaymentVoucherNumbers(pcvEntityObj);
db.SaveChanges();
return(expenseTransactionPaymentHistory.ExpenseTransactionPaymentHistoryId);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public bool UpdatePaymentVoucherNumber(xPlug.BusinessObject.PaymentVoucherNumber paymentVoucherNumber)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = PaymentVoucherNumberMapper.Map <xPlug.BusinessObject.PaymentVoucherNumber, PaymentVoucherNumber>(paymentVoucherNumber);
if (myEntityObj == null)
{
return(false);
}
using (var db = new ExpenseManagerDBEntities())
{
db.PaymentVoucherNumbers.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 AddPaymentVoucherNumber(xPlug.BusinessObject.PaymentVoucherNumber paymentVoucherNumber)
{
try
{
//Re-Map Object to Entity Object
var myEntityObj = PaymentVoucherNumberMapper.Map <xPlug.BusinessObject.PaymentVoucherNumber, PaymentVoucherNumber>(paymentVoucherNumber);
if (myEntityObj == null)
{
return(-2);
}
using (var db = new ExpenseManagerDBEntities())
{
db.AddToPaymentVoucherNumbers(myEntityObj);
db.SaveChanges();
paymentVoucherNumber.PaymentVoucherNumberId = myEntityObj.PaymentVoucherNumberId;
return(paymentVoucherNumber.PaymentVoucherNumberId);
}
}
catch (Exception ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
