public List <FeesInvoiceTransacation> GetFeesInvoice(int clientId)
{
List <FeesInvoiceTransacation> mOMTransactions = new List <FeesInvoiceTransacation>();
try
{
Logger.LogInfo("Get: Fees Invoice information process start");
DataTable dtfeesInvoice = DataBase.DBService.ExecuteCommand(string.Format(SELECT_INVOICE_BY_CLIENT_ID, clientId));
foreach (DataRow dr in dtfeesInvoice.Rows)
{
DataTable dtFeesInvoiceDetails = DataBase.DBService.ExecuteCommand(string.Format(SELECT_INVOICE_DETAILS_BY, dr["InvoiceId"].ToString()));
FeesInvoiceTransacation mOMTransaction = convertToFeesInvoiceTransactionObject(dr, dtFeesInvoiceDetails);
mOMTransactions.Add(mOMTransaction);
}
Logger.LogInfo("Get: Fees invoice details information process completed.");
return(mOMTransactions);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
public void Add(FeesInvoiceTransacation feesInvoiceTransacation)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_CLIENT_NAME_QUERY, feesInvoiceTransacation.CId));
DataBase.DBService.BeginTransaction();
DataBase.DBService.ExecuteCommandString(string.Format(INSERT_FEES_INVOICE,
feesInvoiceTransacation.InvoiceNo,
feesInvoiceTransacation.InvoiceDate.ToString("yyyy-MM-dd"),
feesInvoiceTransacation.CId), true);
foreach (FeesInvoiceDetail point in feesInvoiceTransacation.feesInvoiceDetails)
{
DataBase.DBService.ExecuteCommandString(string.Format(INSERT_FEES_INVOICE_DETAILS,
point.InvoiceNo,
point.Particulars,
point.Amount), true);
}
DataBase.DBService.CommitTransaction();
}
catch (Exception ex)
{
DataBase.DBService.RollbackTransaction();
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
public Result Update(FeesInvoiceTransacation feesInvoiceTransacation)
{
var result = new Result <int>();
try
{
FeesInvoiceService feesInvoiceService = new FeesInvoiceService();
feesInvoiceService.Update(feesInvoiceTransacation);
result.IsSuccess = true;
}
catch (Exception exception)
{
result.IsSuccess = false;
result.ExceptionInfo = exception;
}
return(result);
}
private FeesInvoiceTransacation convertToFeesInvoiceTransactionObject(DataRow dr, DataTable dtFeesInvoiceDetails)
{
FeesInvoiceTransacation feesInvoiceTransacation = new FeesInvoiceTransacation();
feesInvoiceTransacation.InvoiceNo = dr["InvoiceId"].ToString();
feesInvoiceTransacation.InvoiceDate = DateTime.Parse(dr["InvoiceDate"].ToString());
feesInvoiceTransacation.CId = int.Parse(dr["CId"].ToString());
feesInvoiceTransacation.feesInvoiceDetails = new List <FeesInvoiceDetail>();
foreach (DataRow dataRow in dtFeesInvoiceDetails.Rows)
{
FeesInvoiceDetail feesInvoiceDetail = new FeesInvoiceDetail();
feesInvoiceDetail.Id = int.Parse(dataRow["Id"].ToString());
feesInvoiceDetail.InvoiceNo = dataRow.Field <string>("InvoiceId");
feesInvoiceDetail.Particulars = dataRow.Field <string>("Particulars");
feesInvoiceDetail.Amount = double.Parse(dataRow["Amount"].ToString());
feesInvoiceTransacation.feesInvoiceDetails.Add(feesInvoiceDetail);
}
return(feesInvoiceTransacation);
}
