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); }