private void GetRefundToCustomerDetails(string cashChequeNo) { IsNew = false; RefundToCustomerForm pqf = psRepository.GetRefundToCustomerDetails(cashChequeNo); GetModelData(pqf); }
private void GetPSData(object param) { if (SelectedCustomerID != null && SelectedCustomerID != 0) { RefundToCustomerForm pqf = psRepository.GetNewPS(SelectedCustomerID); GetModelData(pqf); } }
public int UpdateRefundToCustomer(RefundToCustomerForm psForm) { try { using (SDNSalesDBEntities entities = new SDNSalesDBEntities()) { foreach (var item in psForm.RefundToCustomerDetails) { CashAndBankTransaction obj = entities.CashAndBankTransactions.Where(e => e.Cash_Cheque_No == psForm.RefundToCustomer.CashChequeNo && e.SO_CN_PO_DN_No == item.SalesNo).SingleOrDefault(); if (obj != null) { obj.Acc_Id = psForm.RefundToCustomer.AccountId; obj.Amount = psForm.RefundToCustomer.Amount; obj.Cash_Cheque_No = psForm.RefundToCustomer.CashChequeNo; obj.Cash_Cheque_Date = psForm.RefundToCustomer.Date; obj.Remarks = psForm.RefundToCustomer.Remarks; obj.Is_Cheque = psForm.RefundToCustomer.IsCheque; //saving details entity obj.SO_CN_PO_DN_No = item.SalesNo; obj.SO_CN_PO_DN_Date = item.SalesDate; obj.SO_CN_PO_DN_Amt = item.SalesAmount; obj.Amt_Due = obj.Amt_Due = item.AmountDue - item.AmountAdjusted; obj.Amt_Refunded = item.AmountAdjusted; obj.Discount = item.Discount; obj.UpdatedBy = 0; obj.UpdatedDate = DateTime.Now; entities.SaveChanges(); if (item.AmountDue == 0 && item.AmountAdjusted == item.SalesAmount) { CreditNote dn = entities.CreditNotes.Where(e => e.CN_No == item.SalesNo).SingleOrDefault(); SalesOrder order = entities.SalesOrders.Where(e => e.SO_No == item.SalesNo).SingleOrDefault(); if (dn != null) { dn.CN_Status = Convert.ToByte(DN_Status.Refunded); entities.SaveChanges(); } else if (order != null) { order.SO_Status = Convert.ToByte(PO_Status.Refunded); entities.SaveChanges(); } } } } } } catch (Exception ex) { throw ex; } return(psForm.RefundToCustomer.ID); }
public RefundToCustomerForm GetRefundToCustomerDetails(string cashChequeNo) { string str = Convert.ToString(Convert.ToByte(CashBankTransactionType.RefundToCustomer)); RefundToCustomerForm pqf = new RefundToCustomerForm(); try { using (SDNSalesDBEntities entities = new SDNSalesDBEntities()) { var pq = (from pqs in entities.CashAndBankTransactions where pqs.Cash_Cheque_No == cashChequeNo && pqs.Type == str select new RefundToCustomerEntity { ID = pqs.ID, CustomerID = pqs.Cus_Sup_Id, Amount = pqs.Amount, AccountId = pqs.Acc_Id, Remarks = pqs.Remarks, Date = pqs.Cash_Cheque_Date, IsCheque = pqs.Is_Cheque, CashChequeNo = pqs.Cash_Cheque_No, }).FirstOrDefault(); if (pq != null) { pq.AmountStr = Convert.ToString(pq.Amount); pqf.RefundToCustomer = pq; } var pqd = (from pqs in entities.CashAndBankTransactions where pqs.Cash_Cheque_No == cashChequeNo && pqs.Type == str select new RefundToCustomerDetailsEntity { SalesNo = pqs.SO_CN_PO_DN_No, SalesDate = pqs.SO_CN_PO_DN_Date, SalesAmount = pqs.SO_CN_PO_DN_Amt, AmountDue = pqs.Amt_Due, Discount = pqs.Discount, AmountAdjusted = pqs.Amt_Refunded }).ToList <RefundToCustomerDetailsEntity>(); if (pqd != null) { pqf.RefundToCustomerDetails = pqd; } return(pqf); } } catch (Exception ex) { throw ex; } }
public RefundToCustomerForm GetDataIntoModel() { OptionsEntity oData = new OptionsEntity(); ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository(); oData = purchaseRepository.GetOptionSettings(); RefundToCustomerForm PQForm = new RefundToCustomerForm(); PQForm.RefundToCustomerDetails = new List <RefundToCustomerDetailsEntity>(); RefundToCustomerEntity model = new RefundToCustomerEntity(); // this.ID = pqf.RefundToCustomer.ID; model.CustomerID = this.SelectedCustomerID; model.AccountId = this.SelectedAccountID; model.Date = DateTime.ParseExact(this.DateStr, oData.DateFormat, null); model.AmountStr = this.AmountStr; model.Amount = Convert.ToDecimal(this.AmountStr); model.IsCheque = this.IsCheque; model.CashChequeNo = this.CashChequeNo; model.Remarks = this.Remarks; if (this.IsChequeTrue == true) { model.IsCheque = true; } else { model.IsCheque = false; } PQForm.RefundToCustomer = model; foreach (var item in PQDetailsEntity.Where(e => Convert.ToDecimal(e.AmountAdjustedStr) != 0)) { RefundToCustomerDetailsEntity pqEntity = new RefundToCustomerDetailsEntity(); pqEntity.SalesNo = item.SalesNo; pqEntity.SalesDate = item.SalesDate; pqEntity.SalesAmount = Convert.ToDecimal(item.SalesAmountStr); //pqEntity.PaymentDueDate = Convert.ToDateTime(item.PaymentDueDateStr); pqEntity.PaymentDueDate = Utility.SimpleDateTime(item.PaymentDueDateStr);//Sunil Sharma //pqEntity.AmountDueStr = Convert.ToString(item.AmountDue); pqEntity.AmountDue = Convert.ToDecimal(item.AmountDueStr); // pqEntity.AmountAdjustedStr = Convert.ToString(item.AmountAdjusted); pqEntity.AmountAdjusted = Convert.ToDecimal(item.AmountAdjustedStr); pqEntity.Discount = Convert.ToDecimal(item.DiscountStr); PQForm.RefundToCustomerDetails.Add(pqEntity); } return(PQForm); }
private void GetRefundToCustomerDetails(string cashChequeNo) { OptionsEntity oData = new OptionsEntity(); ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository(); oData = purchaseRepository.GetOptionSettings(); IsNew = false; RefundToCustomerForm pqf = psRepository.GetRefundToCustomerDetails(cashChequeNo); DateTime Dateinstr = (DateTime)pqf.RefundToCustomer.Date; this.DateStr = Dateinstr.ToString(oData.DateFormat); GetModelData(pqf); }
private void GetModelData(RefundToCustomerForm pqf) { if (IsNew == false) { this.ID = pqf.RefundToCustomer.ID; this.SelectedCustomerID = pqf.RefundToCustomer.CustomerID; this.SelectedAccountID = pqf.RefundToCustomer.AccountId; this.AmountStr = pqf.RefundToCustomer.AmountStr; this.IsCheque = pqf.RefundToCustomer.IsCheque; if (IsCheque == true) { IsChequeTrue = true; } else { IsChequeFalse = true; } this.CashChequeNo = pqf.RefundToCustomer.CashChequeNo; this.Remarks = pqf.RefundToCustomer.Remarks; } this.PQDetailsEntity = new ObservableCollection <CollectSalesAmountDataGridViewModel>(); foreach (var item in pqf.RefundToCustomerDetails) { CollectSalesAmountDataGridViewModel pqEntity = new CollectSalesAmountDataGridViewModel(); pqEntity.SalesNo = item.SalesNo; pqEntity.SalesDate = item.SalesDate; pqEntity.SalesDateStr = changedateformat(item.SalesDate); pqEntity.SalesAmount = Math.Abs(decimal.Parse(item.SalesAmount.ToString())); pqEntity.SalesAmountStr = Convert.ToString(pqEntity.SalesAmount); pqEntity.PaymentDueDate = item.PaymentDueDate; pqEntity.PaymentDueDateStr = changedateformat(item.PaymentDueDate); pqEntity.AmountDue = Math.Abs(decimal.Parse(item.AmountDue.ToString())); pqEntity.AmountDueStr = Convert.ToString(pqEntity.AmountDue); pqEntity.AmountAdjusted = Math.Abs(decimal.Parse(item.AmountAdjusted.ToString())); pqEntity.AmountAdjustedStr = Convert.ToString(pqEntity.AmountAdjusted); pqEntity.Discount = item.Discount; PQDetailsEntity.Add(pqEntity); OnPropertyChanged("PQDetailsEntity"); } TotalSalesAmount = Convert.ToString(PQDetailsEntity.Sum(e => e.SalesAmount)); TotalAmountDue = Convert.ToString(PQDetailsEntity.Sum(e => e.AmountDue)); TotalAmountPaid = Convert.ToString(PQDetailsEntity.Sum(e => e.AmountAdjusted)); PQDetailsEntityLst = PQDetailsEntity; }
public RefundToCustomerForm GetDataIntoModel() { RefundToCustomerForm PQForm = new RefundToCustomerForm(); PQForm.RefundToCustomerDetails = new List <RefundToCustomerDetailsEntity>(); RefundToCustomerEntity model = new RefundToCustomerEntity(); // this.ID = pqf.RefundToCustomer.ID; model.CustomerID = this.SelectedCustomerID; model.AccountId = this.SelectedAccountID; model.Date = this.Date; model.AmountStr = this.AmountStr; model.Amount = Convert.ToDecimal(this.AmountStr); model.IsCheque = this.IsCheque; model.CashChequeNo = this.CashChequeNo; model.Remarks = this.Remarks; if (this.IsChequeTrue == true) { model.IsCheque = true; } else { model.IsCheque = false; } PQForm.RefundToCustomer = model; foreach (var item in PQDetailsEntity) { RefundToCustomerDetailsEntity pqEntity = new RefundToCustomerDetailsEntity(); pqEntity.SalesNo = item.SalesNo; pqEntity.SalesDate = item.SalesDate; pqEntity.SalesAmount = Convert.ToDecimal(item.SalesAmountStr); //item.SalesAmount=pqEntity.SalesAmount; pqEntity.PaymentDueDate = Convert.ToDateTime(item.PaymentDueDateStr); //pqEntity.AmountDueStr = Convert.ToString(item.AmountDue); pqEntity.AmountDue = Convert.ToDecimal(item.AmountDueStr); // pqEntity.AmountAdjustedStr = Convert.ToString(item.AmountAdjusted); pqEntity.AmountAdjusted = Convert.ToDecimal(item.AmountAdjustedStr); pqEntity.Discount = Convert.ToDecimal(item.DiscountStr); PQForm.RefundToCustomerDetails.Add(pqEntity); } return(PQForm); }
public RefundToCustomerForm GetNewPS(int?CustomerID) { RefundToCustomerForm pqf = new RefundToCustomerForm(); try { using (SDNSalesDBEntities entities = new SDNSalesDBEntities()) { var pqd = entities.Database.SqlQuery <RefundToCustomerDetailsEntity>("SRC_GetSalesDataForRefundToCustomers @CustomerID={0}", CustomerID).ToList(); if (pqd != null) { pqf.RefundToCustomerDetails = pqd; } return(pqf); } } catch (Exception ex) { throw ex; } }
void OnSavePS(object param) { MessageBoxResult result = System.Windows.MessageBox.Show("Do you want to save changes?", "Save Confirmation", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { Mouse.OverrideCursor = Cursors.Wait; RefundToCustomerForm PSForm = GetDataIntoModel(); string msg = ValidateRefundToCustomer(); if (msg != string.Empty) { PSErrors = msg; Mouse.OverrideCursor = null; return; } PSErrors = string.Empty; if (PSForm != null) { if (IsNew == true) { int i = psRepository.SaveRefundToCustomer(PSForm); IsCustomerEnabled = false; IsTextBoxReadOnly = true; } else { int i = psRepository.UpdateRefundToCustomer(PSForm); IsCustomerEnabled = false; IsTextBoxReadOnly = true; } Mouse.OverrideCursor = null; } } }
public int SaveRefundToCustomer(RefundToCustomerForm psForm) { IRefundToCustomersBL psBL = new RefundToCustomersBL(); return(psBL.SavePaymentToSupplier(psForm)); }
public int UpdatePaymentToSupplier(RefundToCustomerForm psForm) { IRefundToCustomersDAL psDAL = new RefundToCustomersDAL(); return(psDAL.UpdateRefundToCustomer(psForm)); }
public int SaveRefundToCustomer(RefundToCustomerForm psForm) { int autoId = 0; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { foreach (var item in psForm.RefundToCustomerDetails) { CashAndBankTransaction obj = new CashAndBankTransaction(); obj.Cus_Sup_Id = psForm.RefundToCustomer.CustomerID; obj.Acc_Id = psForm.RefundToCustomer.AccountId; obj.Amount = psForm.RefundToCustomer.Amount; obj.Cash_Cheque_No = psForm.RefundToCustomer.CashChequeNo; obj.Cash_Cheque_Date = psForm.RefundToCustomer.Date; obj.Remarks = psForm.RefundToCustomer.Remarks; obj.Type = Convert.ToString(Convert.ToByte(CashBankTransactionType.RefundToCustomer)); //obj.Type = "C"; obj.Is_Cheque = psForm.RefundToCustomer.IsCheque; //saving details entity obj.SO_CN_PO_DN_No = item.SalesNo; obj.SO_CN_PO_DN_Date = item.SalesDate; obj.SO_CN_PO_DN_Amt = item.SalesAmount; obj.Amt_Due = item.AmountDue - item.AmountAdjusted; //obj.Amt_Due = item.AmountDue; obj.Amt_Refunded = item.AmountAdjusted; obj.Discount = item.Discount; obj.UpdatedBy = 0; obj.UpdatedDate = DateTime.Now; entities.CashAndBankTransactions.Add(obj); entities.SaveChanges(); if (item.AmountAdjusted == item.SalesAmount) { CreditNote dn = entities.CreditNotes.Where(e => e.CN_No == item.SalesNo).SingleOrDefault(); SalesOrder order = entities.SalesOrders.Where(e => e.SO_No == item.SalesNo).SingleOrDefault(); if (dn != null) { dn.CN_Status = Convert.ToByte(DN_Status.Refunded); entities.SaveChanges(); } else if (order != null) { order.SO_Status = Convert.ToByte(PO_Status.Refunded); entities.SaveChanges(); } } //} } } } catch (Exception ex) { throw ex; } return(autoId); }