private void GetModelData(AdjustDebitNoteForm pqf) { if (IsNew == false) { this.ID = pqf.AdjustDebitNote.ID; this.SelectedSupplierID = pqf.AdjustDebitNote.SupplierID; this.DebitNoteNo = pqf.AdjustDebitNote.DebitNoteNo; this.SelectedAccountID = pqf.AdjustDebitNote.AccountId; this.Date = pqf.AdjustDebitNote.Date; this.AmountStr = pqf.AdjustDebitNote.AmountStr; this.IsCheque = pqf.AdjustDebitNote.IsCheque; if (IsCheque == true) { IsChequeTrue = true; } else { IsChequeFalse = true; } //this.CashChequeNo = pqf.AdjustDebitNote.CashChequeNo; this.Remarks = pqf.AdjustDebitNote.Remarks; if (this.ListSuppliers != null) { foreach (var item in this.ListSuppliers) { if (item.ID == this.SelectedSupplierID) { this.SelectedSupplierName = item.SupplierName; } } } } var result = pqf.AdjustDebitNoteDetails.OrderByDescending(e => e.UpdatedDate).GroupBy(e => e.PurchaseNo).Select(e => e.First()).ToList(); this.PQDetailsEntity = new ObservableCollection <CollectAmountDataGridViewModel>(); if (result != null) { foreach (var item in result) { CollectAmountDataGridViewModel pqEntity = new CollectAmountDataGridViewModel(); pqEntity.PurchaseNo = item.PurchaseNo; pqEntity.PurchaseDate = item.PurchaseDate; pqEntity.PurchaseDateStr = changedateformat(item.PurchaseDate); pqEntity.PurchaseAmountStr = Convert.ToString(item.PurchaseAmount); pqEntity.PurchaseAmount = item.PurchaseAmount; pqEntity.PaymentDueDate = item.PaymentDueDate; pqEntity.PaymentDueDateStr = changedateformat(item.PaymentDueDate); pqEntity.AmountDueStr = Convert.ToString(item.AmountDue); //pqEntity.AmountDue = item.AmountDue; //pqEntity.AmountAdjusted = item.AmountAdjusted; //pqEntity.AmountAdjustedStr = Convert.ToString(item.AmountAdjusted); //pqEntity.Discount = item.Discount; PQDetailsEntity.Add(pqEntity); OnPropertyChanged("PQDetailsEntity"); } } PQDetailsEntityLst = PQDetailsEntity; }
private void GetPSData(object param) { if (SelectedSupplierID != null && SelectedSupplierID != 0) { AdjustDebitNoteForm pqf = psRepository.GetNewPS(SelectedSupplierID); GetModelData(pqf); } }
public int SaveAdjustDebitNote(AdjustDebitNoteForm psForm) { int autoId = 0; try { using (SDNPurchasingDBEntities entities = new SDNPurchasingDBEntities()) { foreach (var item in psForm.AdjustDebitNoteDetails) { CashAndBankTransaction obj = new CashAndBankTransaction(); obj.Cus_Sup_Id = psForm.AdjustDebitNote.SupplierID; obj.Acc_Id = psForm.AdjustDebitNote.AccountId; obj.Amount = psForm.AdjustDebitNote.Amount; //obj.Cash_Cheque_No = psForm.AdjustDebitNote.CashChequeNo; obj.Cash_Cheque_Date = psForm.AdjustDebitNote.Date; obj.Remarks = psForm.AdjustDebitNote.Remarks; obj.Type = "S"; //obj.Is_Cheque = psForm.AdjustDebitNote.IsCheque; //saving details entity obj.SO_CN_PO_DN_No = item.PurchaseNo; obj.SO_CN_PO_DN_Date = item.PurchaseDate; obj.SO_CN_PO_DN_Amt = item.PurchaseAmount; obj.Amt_Due = item.AmountDue; obj.Amt_Refunded = item.AmountAdjusted; obj.Discount = item.Discount; obj.UpdatedBy = 0; obj.UpdatedDate = DateTime.Now.Date; entities.CashAndBankTransactions.Add(obj); entities.SaveChanges(); if (item.AmountDue == 0 && item.AmountAdjusted == item.PurchaseAmount) { PurchaseInvoice invoice = entities.PurchaseInvoices.Where(e => e.PI_No == item.PurchaseNo).SingleOrDefault(); PurchaseOrder order = entities.PurchaseOrders.Where(e => e.PO_No == item.PurchaseNo).SingleOrDefault(); if (invoice != null) { invoice.PI_Status = Convert.ToByte(PI_Status.Paid); entities.SaveChanges(); } else if (order != null) { } } //} } } } catch (Exception ex) { throw ex; } return(autoId); }
public AdjustDebitNoteForm AdjustDebitNoteDetails(string AdjustedNo) { AdjustDebitNoteForm pqf = new AdjustDebitNoteForm(); try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { var pq = (from pqs in entities.AdjustedDebitNotes join pi in entities.AdjustedDebitNoteDetails on pqs.ID equals pi.ADN_ID where pqs.AdjustDebitNoteNumber == AdjustedNo select new AdjustDebitNoteEntity { ID = pqs.ID, SupplierID = pqs.SupplierID, //Amount = pi.SI_Tot_aft_Tax, Amount = pqs.DebitNoteAmount, Date = pqs.DebitNoteDate, DebitNoteNo = pqs.DebitNoteNumber, AdjustDebitNoteNumber = pqs.AdjustDebitNoteNumber, AdjustDebitNoteDate = pqs.AdjustDebitNoteDate //CashChequeNo = pqs.Cash_Cheque_No, }).FirstOrDefault(); if (pq != null) { pq.AmountStr = Convert.ToString(pq.Amount); pqf.AdjustDebitNote = pq; } var pqd = (from s in entities.AdjustedDebitNotes join t in entities.AdjustedDebitNoteDetails on s.ID equals t.ADN_ID where s.AdjustDebitNoteNumber == AdjustedNo select new AdjustDebitNoteDetailsEntity { PurchaseNo = t.PurchaseInvoiceNo, PurchaseDate = t.PurchaseInvoiceDate, PaymentDueDate = t.PaymentDueDate, PurchaseAmount = t.PurchaseInvoiceAmount, AmountDue = t.AmountDue, AmountAdjusted = t.AmountAdjusted }).ToList(); if (pqd != null) { pqf.AdjustDebitNoteDetails = pqd; } } return(pqf); } catch (Exception e) { throw e; } }
private void GetAdjustDebitNoteDetails(string DebitNoteNo) { IsNew = false; AdjustDebitNoteForm pqf = psRepository.GetAdjustDebitNoteDetails(DebitNoteNo); pqf.AdjustDebitNote.Amount = Math.Abs(decimal.Parse(pqf.AdjustDebitNote.Amount.ToString())); pqf.AdjustDebitNote.AmountStr = Math.Abs(decimal.Parse(pqf.AdjustDebitNote.AmountStr)).ToString(); GetModelData(pqf); }
public AdjustDebitNoteForm GetDataIntoModel() { OptionsEntity oData = new OptionsEntity(); ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository(); oData = purchaseRepository.GetOptionSettings(); AdjustDebitNoteForm PQForm = new AdjustDebitNoteForm(); PQForm.AdjustDebitNoteDetails = new List <AdjustDebitNoteDetailsEntity>(); AdjustDebitNoteEntity model = new AdjustDebitNoteEntity(); // this.ID = pqf.AdjustDebitNote.ID; model.SupplierID = this.SelectedSupplierID; 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; model.DebitNoteNo = this.DebitNoteNo; model.AdjustDebitNoteNumber = this.AdjustDebitNoteNumber; model.AdjustDebitNoteDate = DateTime.ParseExact(this.AdjustDebitNoteDateStr, oData.DateFormat, null); if (this.IsChequeTrue == true) { model.IsCheque = true; } else { model.IsCheque = false; } PQForm.AdjustDebitNote = model; foreach (var item in PQDetailsEntity.Where(e => !(string.IsNullOrEmpty(e.AmountAdjustedStr)))) { AdjustDebitNoteDetailsEntity pqEntity = new AdjustDebitNoteDetailsEntity(); pqEntity.PurchaseNo = item.PurchaseNo; pqEntity.PurchaseDate = item.PurchaseDate; pqEntity.PurchaseAmount = Convert.ToDecimal(item.PurchaseAmountStr); //item.PurchaseAmount=pqEntity.PurchaseAmount; //pqEntity.PaymentDueDate = Convert.ToDateTime(item.PaymentDueDateStr); pqEntity.PaymentDueDate = DateTime.ParseExact(item.PaymentDueDateStr, "dd'/'MM'/'yy", CultureInfo.InvariantCulture); //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); pqEntity.CheckAmountAdjusted = item.CheckAmountAdjusted; PQForm.AdjustDebitNoteDetails.Add(pqEntity); } return(PQForm); }
public AdjustDebitNoteForm GetDataIntoModel() { AdjustDebitNoteForm PQForm = new AdjustDebitNoteForm(); PQForm.AdjustDebitNoteDetails = new List <AdjustDebitNoteDetailsEntity>(); AdjustDebitNoteEntity model = new AdjustDebitNoteEntity(); // this.ID = pqf.AdjustDebitNote.ID; model.SupplierID = this.SelectedSupplierID; 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; model.DebitNoteNo = this.DebitNoteNo; if (this.IsChequeTrue == true) { model.IsCheque = true; } else { model.IsCheque = false; } PQForm.AdjustDebitNote = model; foreach (var item in PQDetailsEntity) { AdjustDebitNoteDetailsEntity pqEntity = new AdjustDebitNoteDetailsEntity(); pqEntity.PurchaseNo = item.PurchaseNo; pqEntity.PurchaseDate = item.PurchaseDate; pqEntity.PurchaseAmount = Convert.ToDecimal(item.PurchaseAmountStr); //item.PurchaseAmount=pqEntity.PurchaseAmount; //pqEntity.PaymentDueDate = Convert.ToDateTime(item.PaymentDueDateStr); pqEntity.PaymentDueDate = DateTime.ParseExact(item.PaymentDueDateStr, "dd'/'MM'/'yyyy", CultureInfo.InvariantCulture); //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); pqEntity.CheckAmountAdjusted = item.CheckAmountAdjusted; PQForm.AdjustDebitNoteDetails.Add(pqEntity); } return(PQForm); }
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; string msg = ValidateAdjustDebitNote(); AdjustDebitNoteForm PSForm = GetDataIntoModel(); if (msg != string.Empty) { PSErrors = msg; Mouse.OverrideCursor = null; return; } PSErrors = string.Empty; if (PSForm != null) { int type = Convert.ToInt32(CashBankTransactionType.AdjustDebitNote); if (IsNew == true) { int i = psRepository.SaveAdjustDebitNote(PSForm, type); } else { int i = psRepository.UpdateAdjustDebitNote(PSForm, type); if (i != null || i != 0) { this.EnableSaveButton = false; } else { this.EnableSaveButton = true; } } Mouse.OverrideCursor = null; } } }
private void AdjustedDebitNoteDetails(string AdjustedNo) { OptionsEntity oData = new OptionsEntity(); ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository(); oData = purchaseRepository.GetOptionSettings(); IsNew = false; AdjustDebitNoteForm pqf = psRepository.AdjustDebitNoteDetails(AdjustedNo); pqf.AdjustDebitNote.Amount = Math.Abs(decimal.Parse(pqf.AdjustDebitNote.Amount.ToString())); pqf.AdjustDebitNote.AmountStr = Math.Abs(decimal.Parse(pqf.AdjustDebitNote.AmountStr)).ToString(); pqf.AdjustDebitNote.MustCompare = true; if (pqf.AdjustDebitNote.AdjustDebitNoteDate == null) { this.AdjustDebitNoteDateStr = ""; } else { DateTime Dateinstr = (DateTime)pqf.AdjustDebitNote.AdjustDebitNoteDate; this.AdjustDebitNoteDateStr = Dateinstr.ToString(oData.DateFormat); } GetModelData(pqf); }
public AdjustDebitNoteForm GetNewPS(int?SupplierID) { AdjustDebitNoteForm pqf = new AdjustDebitNoteForm(); try { using (SDNPurchasingDBEntities entities = new SDNPurchasingDBEntities()) { var pqd = entities.Database.SqlQuery <AdjustDebitNoteDetailsEntity>("PRC_GetPurchaseDataForAdjustDebitNotes @SupplierID={0}", SupplierID).ToList(); if (pqd != null) { pqf.AdjustDebitNoteDetails = pqd; } return(pqf); } } catch (Exception ex) { throw ex; } }
private void GetModelData(AdjustDebitNoteForm pqf) { if (IsNew == false) { this.ID = pqf.AdjustDebitNote.ID; this.SelectedSupplierID = pqf.AdjustDebitNote.SupplierID; this.DebitNoteNo = pqf.AdjustDebitNote.DebitNoteNo; this.SelectedAccountID = pqf.AdjustDebitNote.AccountId; this.Date = pqf.AdjustDebitNote.Date; this.AmountStr = pqf.AdjustDebitNote.AmountStr; this.IsCheque = pqf.AdjustDebitNote.IsCheque; this.AdjustDebitNoteNumber = pqf.AdjustDebitNote.AdjustDebitNoteNumber; if (IsCheque == true) { IsChequeTrue = true; } else { IsChequeFalse = true; } //this.CashChequeNo = pqf.AdjustDebitNote.CashChequeNo; this.Remarks = pqf.AdjustDebitNote.Remarks; if (this.ListSuppliers != null) { foreach (var item in this.ListSuppliers) { if (item.ID == this.SelectedSupplierID) { this.SelectedSupplierName = item.SupplierName; } } } } var result = pqf.AdjustDebitNoteDetails.OrderByDescending(e => e.UpdatedDate).GroupBy(e => e.PurchaseNo).Select(e => e.First()).ToList(); OptionsEntity oData = new OptionsEntity(); ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository(); oData = purchaseRepository.GetOptionSettings(); this.PQDetailsEntity = new ObservableCollection <CollectAmountDataGridViewModel>(); if (result != null) { foreach (var item in result) { CollectAmountDataGridViewModel pqEntity = new CollectAmountDataGridViewModel(); pqEntity.PurchaseNo = item.PurchaseNo; if (item.PurchaseDate != null) { pqEntity.PurchaseDate = item.PurchaseDate; DateTime Dateinstr = (DateTime)item.PurchaseDate; pqEntity.PurchaseDateStr = Dateinstr.ToString(oData.DateFormat); } else { } pqEntity.PurchaseAmountStr = Convert.ToString(item.PurchaseAmount); pqEntity.PurchaseAmount = item.PurchaseAmount; if (item.PaymentDueDate != null) { pqEntity.PaymentDueDate = item.PaymentDueDate; DateTime Dateinstr1 = (DateTime)item.PaymentDueDate; pqEntity.PaymentDueDateStr = changedateformat(item.PaymentDueDate); } else { } pqEntity.AmountDueStr = Convert.ToString(item.AmountDue); //pqEntity.AmountDue = item.AmountDue; pqEntity.AmountAdjusted = item.AmountAdjusted; pqEntity.AmountAdjustedStr = Convert.ToString(item.AmountAdjusted); //pqEntity.Discount = item.Discount; PQDetailsEntity.Add(pqEntity); TotalPurchaseAmount = Convert.ToString(PQDetailsEntity.Sum(e => e.PurchaseAmount)); TotalAdjutedAmount = Convert.ToString(PQDetailsEntity.Sum(e => e.AmountAdjusted)); OnPropertyChanged("PQDetailsEntity"); } } PQDetailsEntityLst = PQDetailsEntity; }
public int SaveAdjustDebitNote(AdjustDebitNoteForm psForm) { IAdjustDebitNoteBL psBL = new AdjustDebitNoteBL(); return(psBL.SaveAdjustDebitNote(psForm)); }
public int UpdateAdjustDebitNote(AdjustDebitNoteForm psForm) { try { using (SDNPurchasingDBEntities entities = new SDNPurchasingDBEntities()) { foreach (var item in psForm.AdjustDebitNoteDetails) { if (item.CheckAmountAdjusted == true) { CashAndBankTransaction obj = entities.CashAndBankTransactions.Where(e => e.SO_CN_PO_DN_No == item.PurchaseNo).SingleOrDefault(); if (obj != null) { obj.Acc_Id = psForm.AdjustDebitNote.AccountId; obj.Amount = psForm.AdjustDebitNote.Amount; //obj.Cash_Cheque_No = psForm.AdjustDebitNote.CashChequeNo; obj.Cash_Cheque_Date = psForm.AdjustDebitNote.Date; obj.Remarks = psForm.AdjustDebitNote.Remarks; obj.Is_Cheque = psForm.AdjustDebitNote.IsCheque; //saving details entity obj.SO_CN_PO_DN_No = item.PurchaseNo; obj.SO_CN_PO_DN_Date = item.PurchaseDate; obj.SO_CN_PO_DN_Amt = item.PurchaseAmount; obj.Amt_Due = item.AmountDue; obj.Amt_Refunded = item.AmountAdjusted; obj.Discount = item.Discount; obj.DN_CN_No = psForm.AdjustDebitNote.DebitNoteNo; obj.UpdatedBy = 0; obj.UpdatedDate = DateTime.Now.Date; entities.SaveChanges(); if (item.AmountDue == 0 && item.AmountAdjusted == item.PurchaseAmount) { PurchaseInvoice invoice = entities.PurchaseInvoices.Where(e => e.PI_No == item.PurchaseNo).SingleOrDefault(); //PurchaseOrder order = entities.PurchaseOrders.Where(e => e.PO_No == item.PurchaseNo).SingleOrDefault(); if (invoice != null) { invoice.PI_Status = Convert.ToByte(PI_Status.Paid); entities.SaveChanges(); } //else if (order != null) //{ //} DebitNote debit = entities.DebitNotes.Where(e => e.DN_No == psForm.AdjustDebitNote.DebitNoteNo).SingleOrDefault(); if (debit != null) { debit.DN_Status = Convert.ToByte(DN_Status.Adjusted); entities.SaveChanges(); } } } else { CashAndBankTransaction cashbankobj = new CashAndBankTransaction() { Acc_Id = psForm.AdjustDebitNote.AccountId, Amount = psForm.AdjustDebitNote.Amount, Cash_Cheque_Date = psForm.AdjustDebitNote.Date, Remarks = psForm.AdjustDebitNote.Remarks, Is_Cheque = psForm.AdjustDebitNote.IsCheque, SO_CN_PO_DN_No = item.PurchaseNo, SO_CN_PO_DN_Date = item.PurchaseDate, SO_CN_PO_DN_Amt = item.PurchaseAmount, Amt_Due = item.AmountDue, Amt_Refunded = item.AmountAdjusted, Discount = item.Discount, UpdatedBy = 0, UpdatedDate = DateTime.Now.Date, Cus_Sup_Id = psForm.AdjustDebitNote.SupplierID, DN_CN_No = psForm.AdjustDebitNote.DebitNoteNo, Type = "S" }; entities.CashAndBankTransactions.Add(cashbankobj); entities.SaveChanges(); if (item.AmountDue == 0 && item.AmountAdjusted == item.PurchaseAmount) { PurchaseInvoice invoice = entities.PurchaseInvoices.Where(e => e.PI_No == item.PurchaseNo).SingleOrDefault(); //PurchaseOrder order = entities.PurchaseOrders.Where(e => e.PO_No == item.PurchaseNo).SingleOrDefault(); if (invoice != null) { invoice.PI_Status = Convert.ToByte(PI_Status.Paid); entities.SaveChanges(); } //else if (order != null) //{ //} } DebitNote debit = entities.DebitNotes.Where(e => e.DN_No == psForm.AdjustDebitNote.DebitNoteNo).SingleOrDefault(); if (debit != null) { debit.DN_Status = Convert.ToByte(DN_Status.Adjusted); entities.SaveChanges(); } } } } } } catch (Exception ex) { throw ex; } return(psForm.AdjustDebitNote.ID); }
public int UpdateAdjustDebitNote(AdjustDebitNoteForm psForm, int Type) { int autoID = 0; string AdjustedNo = string.Empty; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { //adjusted table entity //adjusted debit note AdjustedDebitNote Adn = new AdjustedDebitNote(); Adn.SupplierID = psForm.AdjustDebitNote.SupplierID; Adn.AdjustDebitNoteNumber = psForm.AdjustDebitNote.AdjustDebitNoteNumber; Adn.AdjustDebitNoteDate = Convert.ToDateTime(psForm.AdjustDebitNote.AdjustDebitNoteDateStr); Adn.DebitNoteNumber = psForm.AdjustDebitNote.DebitNoteNo; Adn.DebitNoteDate = psForm.AdjustDebitNote.Date; Adn.DebitNoteAmount = psForm.AdjustDebitNote.Amount; Adn.CreatedBy = 0; if (entities.AdjustedDebitNotes.AsNoTracking().FirstOrDefault(x => x.ID == psForm.AdjustDebitNote.ID) == null) { //obj.CreatedBy = invoiceData.SIModel.CreatedBy; Adn.CreatedDate = DateTime.Now; entities.AdjustedDebitNotes.Add(Adn); entities.SaveChanges(); autoID = Adn.ID; AdjustedNo = Adn.AdjustDebitNoteNumber; } else { // obj.ModifiedBy = invoiceData.SIModel.ModifiedBy; Adn.ModifiedDate = DateTime.Now; entities.Entry(Adn).State = EntityState.Modified; autoID = entities.SaveChanges(); } foreach (var item in psForm.AdjustDebitNoteDetails) { if (item.CheckAmountAdjusted == true) { AdjustedDebitNoteDetail ADN = new AdjustedDebitNoteDetail(); if (autoID > 0) { ADN.ADN_ID = autoID; ADN.PurchaseInvoiceNo = item.PurchaseNo; ADN.PurchaseInvoiceDate = item.PurchaseDate; ADN.PaymentDueDate = item.PaymentDueDate; ADN.PurchaseInvoiceAmount = item.PurchaseAmount; ADN.AmountDue = item.AmountDue; ADN.AmountAdjusted = item.AmountAdjusted; ADN.CreatedBy = 0; ADN.CreatedDate = DateTime.Now; if (entities.AdjustedDebitNoteDetails.AsNoTracking().FirstOrDefault(x => x.ID == psForm.AdjustDebitNote.ID) == null) { entities.AdjustedDebitNoteDetails.Add(ADN); entities.SaveChanges(); } else { entities.Entry(ADN).State = EntityState.Modified; entities.SaveChanges(); } } } } //adjusted table entity foreach (var item in psForm.AdjustDebitNoteDetails) { if (item.CheckAmountAdjusted == true) { CashAndBankTransaction obj = entities.CashAndBankTransactions.Where(e => e.SO_CN_PO_DN_No == item.PurchaseNo).OrderByDescending(x => x.ID).ToList().FirstOrDefault(); if (obj != null) { obj.Acc_Id = psForm.AdjustDebitNote.AccountId; obj.Amount = psForm.AdjustDebitNote.Amount; //obj.Cash_Cheque_No = psForm.AdjustDebitNote.CashChequeNo; obj.Cash_Cheque_Date = psForm.AdjustDebitNote.Date; obj.Remarks = psForm.AdjustDebitNote.Remarks; obj.Is_Cheque = psForm.AdjustDebitNote.IsCheque; //saving details entity obj.SO_CN_PO_DN_No = item.PurchaseNo; obj.SO_CN_PO_DN_Date = item.PurchaseDate; obj.SO_CN_PO_DN_Amt = item.PurchaseAmount; obj.Amt_Due = item.AmountDue - item.AmountAdjusted; obj.Amt_Refunded = item.AmountAdjusted; obj.Discount = item.Discount; obj.DN_CN_No = psForm.AdjustDebitNote.DebitNoteNo; obj.Type = Type.ToString(); obj.UpdatedBy = 0; obj.UpdatedDate = DateTime.Now.Date; obj.AD_AC_NO = AdjustedNo; entities.SaveChanges(); if (item.AmountAdjusted == item.PurchaseAmount) { PurchaseInvoice invoice = entities.PurchaseInvoices.Where(e => e.PI_No == item.PurchaseNo).SingleOrDefault(); //PurchaseOrder order = entities.PurchaseOrders.Where(e => e.PO_No == item.PurchaseNo).SingleOrDefault(); if (invoice != null) { invoice.PI_Status = Convert.ToByte(PI_Status.Paid); entities.SaveChanges(); } //else if (order != null) //{ //} } DebitNote debit = entities.DebitNotes.Where(e => e.DN_No == psForm.AdjustDebitNote.DebitNoteNo).SingleOrDefault(); if (debit != null) { debit.DN_Status = Convert.ToByte(DN_Status.Adjusted); entities.SaveChanges(); } } else { CashAndBankTransaction cashbankobj = new CashAndBankTransaction() { Acc_Id = psForm.AdjustDebitNote.AccountId, Amount = psForm.AdjustDebitNote.Amount, Cash_Cheque_Date = psForm.AdjustDebitNote.Date, Remarks = psForm.AdjustDebitNote.Remarks, Is_Cheque = psForm.AdjustDebitNote.IsCheque, SO_CN_PO_DN_No = item.PurchaseNo, SO_CN_PO_DN_Date = item.PurchaseDate, SO_CN_PO_DN_Amt = item.PurchaseAmount, Amt_Due = item.AmountDue - item.AmountAdjusted, Amt_Refunded = item.AmountAdjusted, Discount = item.Discount, UpdatedBy = 0, UpdatedDate = DateTime.Now.Date, Cus_Sup_Id = psForm.AdjustDebitNote.SupplierID, DN_CN_No = psForm.AdjustDebitNote.DebitNoteNo, Type = Type.ToString(), AD_AC_NO = AdjustedNo }; entities.CashAndBankTransactions.Add(cashbankobj); entities.SaveChanges(); if (item.AmountAdjusted == item.PurchaseAmount) { PurchaseInvoice invoice = entities.PurchaseInvoices.Where(e => e.PI_No == item.PurchaseNo).SingleOrDefault(); //PurchaseOrder order = entities.PurchaseOrders.Where(e => e.PO_No == item.PurchaseNo).SingleOrDefault(); if (invoice != null) { invoice.PI_Status = Convert.ToByte(PI_Status.Paid); entities.SaveChanges(); } //else if (order != null) //{ //} } DebitNote debit = entities.DebitNotes.Where(e => e.DN_No == psForm.AdjustDebitNote.DebitNoteNo).SingleOrDefault(); if (debit != null) { debit.DN_Status = Convert.ToByte(DN_Status.Adjusted); entities.SaveChanges(); } } } } } } catch (Exception ex) { throw ex; } return(psForm.AdjustDebitNote.ID); }
public int UpdateAdjustDebitNote(AdjustDebitNoteForm psForm, int Type) { IAdjustDebitNoteDAl psDAL = new AdjustDebitNoteDAl(); return(psDAL.UpdateAdjustDebitNote(psForm, Type)); }
public int UpdateAdjustDebitNote(AdjustDebitNoteForm psForm, int Type) { IAdjustDebitNoteBL psBL = new AdjustDebitNoteBL(); return(psBL.UpdateAdjustDebitNote(psForm, Type)); }
public AdjustDebitNoteForm GetAdjustDebitNoteDetails(string DebitNoteNo) { AdjustDebitNoteForm pqf = new AdjustDebitNoteForm(); try { using (SDNPurchasingDBEntities entities = new SDNPurchasingDBEntities()) { decimal value; var pq = (from pqs in entities.DebitNotes join pi in entities.PurchaseInvoices on pqs.PI_Id equals pi.ID where pqs.DN_No == DebitNoteNo select new AdjustDebitNoteEntity { ID = pqs.ID, SupplierID = pqs.Sup_Id, //Amount = pi.PI_Tot_aft_Tax, Amount = pi.PI_Tot_aft_Tax, Date = pqs.DN_Date, DebitNoteNo = pqs.DN_No //CashChequeNo = pqs.Cash_Cheque_No, }).FirstOrDefault(); if (pq != null) { pq.AmountStr = Convert.ToString(pq.Amount); pqf.AdjustDebitNote = pq; } if (pq.SupplierID != 0 || pq.SupplierID != null) { //var pqd = (from pqs in entities.PurchaseInvoices // where pqs.Sup_Id == pq.SupplierID && pqs.PI_Status == 2 // select new AdjustDebitNoteDetailsEntity // { // PurchaseNo = pqs.PI_No, // PurchaseDate = pqs.PI_Date, // PaymentDueDate = pqs.PI_Pmt_Due_Date, // PurchaseAmount = pqs.PI_Tot_aft_Tax, // //AmountDue = pqs.Amt_Due, // //Discount = pqs.Discount, // //AmountAdjusted = pqs // }).ToList<AdjustDebitNoteDetailsEntity>(); var pqd = entities.Database.SqlQuery <AdjustDebitNoteDetailsEntity>("PRC_GetPurchaseDataForAdjustDebitNotes @SupplierID={0}", pq.SupplierID).ToList(); if (pqd != null) { pqf.AdjustDebitNoteDetails = pqd; } } return(pqf); } } catch (Exception ex) { throw ex; } }
public int SaveAdjustDebitNote(AdjustDebitNoteForm psForm) { IAdjustDebitNoteDAl psDAL = new AdjustDebitNoteDAl(); return(psDAL.SaveAdjustDebitNote(psForm)); }