public ReceivePayment Create(ReceivePayment payment) { EReceivePayment eReceivePayment = EReceivePayment(payment); eReceivePayment = _iDReceivePayment.Create(eReceivePayment); return(ReceivePayment(eReceivePayment)); }
public ReceivePayment Save(ReceivePayment payment) { var existPayment = erpNodeDBContext.ReceivePayments.Find(payment.Id); if (existPayment == null) { return(payment); } else if (existPayment != null) { if (existPayment.PostStatus == LedgerPostStatus.Posted) { return(existPayment); } existPayment.TransactionType = this.transactionType; existPayment.CompanyProfile = organization.SelfProfile; existPayment.TransactionDate = payment.TransactionDate; existPayment.ClearingDelayDayCount = payment.ClearingDelayDayCount; existPayment.DiscountAmount = payment.DiscountAmount; existPayment.BankFeeAmount = payment.BankFeeAmount; existPayment.AssetAccountId = payment.AssetAccountId; erpNodeDBContext.SaveChanges(); return(existPayment); } return(null); }
public DataBaseResultSet SaveReceivePayment <T>(T objData) where T : class, IModel, new() { ReceivePayment obj = objData as ReceivePayment; string sQuery = "sprocReceivePaymentInsertUpdateSingleItem"; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo)); list.Add(SqlConnManager.GetConnParameters("EntryTag", "EntryTag", 30, GenericDataType.String, ParameterDirection.Input, obj.EntryTag)); list.Add(SqlConnManager.GetConnParameters("RefNo", "RefNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RefNo)); list.Add(SqlConnManager.GetConnParameters("EntryDate", "EntryDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EntryDate)); list.Add(SqlConnManager.GetConnParameters("ChequeNo", "ChequeNo", 10, GenericDataType.String, ParameterDirection.Input, obj.ChequeNo)); list.Add(SqlConnManager.GetConnParameters("ChequeDate", "ChequeDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ChequeDate)); list.Add(SqlConnManager.GetConnParameters("AccountCode1", "AccountCode1", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode1)); list.Add(SqlConnManager.GetConnParameters("AccountCode2", "AccountCode2", 8, GenericDataType.Long, ParameterDirection.Input, obj.AccountCode2)); list.Add(SqlConnManager.GetConnParameters("Amount", "Amount", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Amount)); list.Add(SqlConnManager.GetConnParameters("RcptMess", "RcptMess", 100, GenericDataType.String, ParameterDirection.Input, obj.RcptMess)); list.Add(SqlConnManager.GetConnParameters("ReconDate", "ReconDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.ReconDate)); list.Add(SqlConnManager.GetConnParameters("ShiftNo", "ShiftNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.ShiftNo)); list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser)); list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime)); list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser)); list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime)); list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy)); list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy)); list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate)); list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount)); list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT)); list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag)); list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null)); list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null)); return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray())); }
public ReceivePayment Create(Models.Profiles.Profile profile, Commercial com, DateTime workingDate) { var payment = new ReceivePayment() { TransactionDate = workingDate, Profile = profile, AssetAccount = organization.SystemAccounts.Cash, TransactionType = TransactionTypes.ReceivePayment, No = this.NextNumber }; erpNodeDBContext.ReceivePayments.Add(payment); if (com != null && com.CommercialPayment == null) { payment.AddCommercial(com); } erpNodeDBContext.SaveChanges(); return(payment); }
public void UnPostLedger(ReceivePayment financialPayment) { Console.WriteLine("> Un Posting,"); organization.LedgersDal.RemoveTransaction(financialPayment.Id); financialPayment.PostStatus = LedgerPostStatus.ReadyToPost; erpNodeDBContext.SaveChanges(); }
public void GetListReceivePayment <T>(T objFilter, ref List <T> listData) where T : class, IModel, new() { string sQuery = "GetListReceivePayment"; ReceivePayment objData = objFilter as ReceivePayment; List <DbParameter> list = new List <DbParameter>(); list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, objData.RecNo)); SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillReceivePaymentDataFromReader, ref listData); }
private void FillReceivePaymentDataFromReader <T>(DbDataReader DbReader, ref List <T> listData) where T : class, IModel, new() { while (DbReader.Read()) { T obj = new T(); ReceivePayment objData = obj as ReceivePayment; obj.FillDataFromDB(DbReader); listData.Add(obj); } }
public bool PostLedger(ReceivePayment tr, bool SaveImmediately = true) { if (tr.PostStatus == LedgerPostStatus.Posted) { throw new Exception("Posted Transaction"); } if (tr.CommercialCount == 0 || tr.TotalCommercialAmount == 0) { throw new Exception("Zero commecial transaction"); } tr.AssetAccount = tr.AssetAccount ?? organization.SystemAccounts.Cash; tr.ReceivableAccount = organization.SystemAccounts.AccountReceivable; tr.UpdateBalance(); var trLedger = new Models.Accounting.LedgerGroup() { Id = tr.Id, TransactionDate = tr.TransactionDate, TransactionName = tr.Name, TransactionNo = tr.No, TransactionType = transactionType, ProfileName = tr.Profile?.Name, }; string memo = ""; //Cr. trLedger.AddCredit(tr.ReceivableAccount, tr.TotalCommercialAmount, memo); //Dr. tr.PaymentRetentions.ToList().ForEach(pr => trLedger.AddDebit(pr.RetentionType.RetentionToAccount, pr.RetentionAmount, memo)); trLedger.AddDebit(organization.SystemAccounts.DiscountGiven, tr.DiscountAmount, memo); trLedger.AddDebit(tr.AssetAccount, tr.AmountPaymentReceive, memo); if (tr.BankFeeAmount > 0) { trLedger.AddDebit(organization.SystemAccounts.BankFee, tr.BankFeeAmount); trLedger.AddCredit(tr.AssetAccount, tr.BankFeeAmount); } if (trLedger.FinalValidate()) { erpNodeDBContext.LedgerGroups.Add(trLedger); tr.PostStatus = LedgerPostStatus.Posted; } else if (tr.PostStatus != LedgerPostStatus.Posted) { return(false); } return(true); }
private ReceivePayment ReceivePayment(EReceivePayment eReceivePayment) { ReceivePayment returnPayment = new ReceivePayment { AmountReceived = eReceivePayment.AmountReceived, DateOfPayment = eReceivePayment.DateOfPayment, PaymentId = eReceivePayment.PaymentId }; return(returnPayment); }
private EReceivePayment EReceivePayment(ReceivePayment payment) { EReceivePayment returnEPayment = new EReceivePayment { AmountReceived = payment.AmountReceived, DateOfPayment = payment.DateOfPayment, PaymentId = payment.PaymentId }; return(returnEPayment); }
public string CreatePayment(ReceivePayment Payment) { requestMsgSet.ClearRequests(); IReceivePaymentAdd PaymentAddRq = requestMsgSet.AppendReceivePaymentAddRq(); PaymentAddRq.CustomerRef.FullName.SetValue(Payment.CustomerName); PaymentAddRq.Memo.SetValue(Payment.Memo); PaymentAddRq.TotalAmount.SetValue(Payment.TotalAmount); //Adding Invoice Reference ...... if (!string.IsNullOrEmpty(Payment.InvoiceTxnID)) { IAppliedToTxnAdd TxnAdd = PaymentAddRq.ORApplyPayment.AppliedToTxnAddList.Append(); TxnAdd.TxnID.SetValue(Payment.InvoiceTxnID); TxnAdd.PaymentAmount.SetValue(Payment.TotalAmount); // TxnAdd.PaymentAmount.SetValue(Payment.TotalAmount); } else { PaymentAddRq.ORApplyPayment.IsAutoApply.SetValue(true); } string xml = requestMsgSet.ToXMLString(); responseMsgSet = sessionManager.DoRequests(requestMsgSet); if (responseMsgSet.ResponseList.GetAt(0).StatusCode == 0) { IResponse response = responseMsgSet.ResponseList.GetAt(0); //the request-specific response is in the details, make sure we have some if (response.Detail != null) { //make sure the response is the type we're expecting ENResponseType responseType = (ENResponseType)response.Type.GetValue(); if (responseType == ENResponseType.rtReceivePaymentAddRs) { //upcast to more specific type here, this is safe because we checked with response.Type check above IReceivePaymentRet PaymentRet = (IReceivePaymentRet)response.Detail; if (PaymentRet != null) { return(PaymentRet.EditSequence.GetValue()); } } } return("-1"); } else { throw new QBException(responseMsgSet.ResponseList.GetAt(0).StatusCode, "QBEngine :" + responseMsgSet.ResponseList.GetAt(0).StatusMessage, requestMsgSet.ToXMLString()); return("-1"); } }
public ActionResult Student(StudentTableRowModels model) { using (IHoneyMustardDataSource ds = Factories.DataSourceFactory.GetDataSource()) { if (ModelState.IsValid) { ReceivePayment payment = new ReceivePayment(); payment.AmountPaid = model.AmountPaid; payment.Date = model.Date; payment.PaymentMethodID = int.Parse(model.PaymentMethod); payment.CoursesID = int.Parse(model.CourseName); payment.ParticipantID = ds.Participant.SingleOrDefault(x => x.ContactID == model.ContactID).ParticipantID; ds.ReceivePayment.Add(payment); ds.SaveChanges(); } return(RedirectToAction("Student", new { id = model.ContactID })); } }
public void Delete(ReceivePayment payment) { _iDReceivePayment.Delete(EReceivePayment(payment)); }
public ReceivePayment Update(ReceivePayment payment) { var eReceivePayment = _iDReceivePayment.Update(EReceivePayment(payment)); return(ReceivePayment(eReceivePayment)); }
private ReceivePayment readReceivePayment( IReceivePaymentRet receiveCheckRet) { ReceivePayment receivePayment = new ReceivePayment(); receivePayment.Date = receiveCheckRet.TxnDate.GetValue(); receivePayment.RefNumber = receiveCheckRet.RefNumber.GetValue(); receivePayment.Amount = receiveCheckRet.TotalAmount.GetValue(); receivePayment.Customer = receiveCheckRet.CustomerRef.FullName.GetValue(); return receivePayment; }