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 GetModelData(PaymentFromCustomerForm pqf)
{
if (IsNew == false)
{
// this.ID = pqf.PaymentFromCustomer.ID;
this.SelectedCustomerID = pqf.PaymentFromCustomer.CustomerID;
this.SelectedAccountID = pqf.PaymentFromCustomer.AccountId;
this.AmountStr = pqf.PaymentFromCustomer.AmountStr;
this.IsCheque = pqf.PaymentFromCustomer.IsCheque;
this.CashChequeNo = pqf.PaymentFromCustomer.CashChequeNo;
this.Remarks = pqf.PaymentFromCustomer.Remarks;
if (IsCheque == true)
{
IsChequeTrue = true;
IsChequeFalse = false;
}
else
{
IsChequeFalse = true;
IsChequeTrue = false;
}
}
var result = pqf.PaymentFromCustomerDetails.OrderByDescending(e => e.CreatedDate).GroupBy(e => e.SalesNo).Select(e => e.First()).ToList();
this.PQDetailsEntity = new ObservableCollection <CollectSalesAmountDataGridViewModel>();
foreach (var item in result)
{
CollectSalesAmountDataGridViewModel pqEntity = new CollectSalesAmountDataGridViewModel();
pqEntity.SalesNo = item.SalesNo;
pqEntity.SalesDate = item.SalesDate;
pqEntity.SalesDateStr = changedateformat(item.SalesDate);
pqEntity.SalesAmountStr = Convert.ToString(item.SalesAmount);
pqEntity.SalesAmount = item.SalesAmount;
pqEntity.PaymentDueDate = item.PaymentDueDate;
pqEntity.PaymentDueDateStr = changedateformat(item.PaymentDueDate);
pqEntity.AmountDue = item.AmountDue;
pqEntity.AmountDueStr = Convert.ToString(item.AmountDue);
pqEntity.AmountAdjusted = item.AmountAdjusted;
pqEntity.AmountAdjustedStr = Convert.ToString(item.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;
}
/// <summary>
/// This method is used to get new PQ
/// </summary>
public void GetNewPQ()
{
VisibilityForImage = Visibility.Collapsed;
IsNew = true;
ID = 0;
SelectedSupplierID = 0;
BillToAddress = string.Empty;
ShipToAddress = string.Empty;
// ValidForDays = 0;
InvoiceNo = GenerateNewInvoiceNo();
TermsAndConditions = TandC;
TotalBeforeTax = 0;
TotalTax = 0;
TotalAfterTax = 0;
TotalBeforeTaxStr = Convert.ToString(0);
TotalTaxStr = Convert.ToString(0);
TotalAfterTaxStr = Convert.ToString(0);
PQErrors = string.Empty;
AllFieldsEnabled = true;
AllFieldsReadonly = false;
SupplierEnabled = true;// added on 23 may 2017
this.PaymentDueDate = null;
this.OurPONo = string.Empty;
PurchaseInvoiceEntity = new PurchaseInvoiceEntity();
PQDetailsEntity.Clear();
LstSuppliers = supplierRepository.GetAllSupplier().Where(s => s.IsInActive != "Y").ToList();
ProductAndServices = ProductAndServices.OrderBy(x => x.PSName).Where(x => x.IsInActive == "N").ToObservable();
// PQDetailsEntity = new ObservableCollection<DataGridViewModel>();
var row = new DataGridViewModel(ProductList.Where(x => x.IsInActive == "N").ToList());
//row.PQQty = 1;
//row.PQDiscount = 0;
//row.GSTRate = TaxRate;
//row.GSTRateStr = Convert.ToString(TaxRate) + "%";
PQDetailsEntity.Add(row);
OnPropertyChanged("PQDetailsEntity");
var lstOptions = pandsRepository.GetOptionDetails();
bool?tax = lstOptions.ShowAmountIncGST;
if (tax == true)
{
ExcludingTax = false;
IncludingTax = true;
}
else
{
IncludingTax = false;
ExcludingTax = true;
}
}
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;
}
private void GetModelData(RefundFromSupplierForm pqf)
{
if (IsNew == false)
{
//this.ID = pqf.RefundFromSupplier.ID;
this.SelectedSupplierID = pqf.RefundFromSupplier.SupplierID;
this.SelectedAccountID = pqf.RefundFromSupplier.AccountId;
this.Date = pqf.RefundFromSupplier.Date;
this.AmountStr = pqf.RefundFromSupplier.AmountStr;
this.IsCheque = pqf.RefundFromSupplier.IsCheque;
if (IsCheque == true)
{
IsChequeTrue = true;
}
else
{
IsChequeFalse = true;
}
this.CashChequeNo = pqf.RefundFromSupplier.CashChequeNo;
this.Remarks = pqf.RefundFromSupplier.Remarks;
}
var result = pqf.RefundFromSupplierDetails.OrderByDescending(e => e.CreatedDate).GroupBy(e => e.PurchaseNo).Select(e => e.First()).ToList();
this.PQDetailsEntity = new ObservableCollection <CollectAmountDataGridViewModel>();
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.AmountDue = Math.Abs(decimal.Parse(Convert.ToString(item.AmountDue)));
pqEntity.AmountDueStr = Convert.ToString(Math.Abs(decimal.Parse(Convert.ToString(item.AmountDue))));
pqEntity.AmountAdjusted = item.AmountAdjusted;
pqEntity.AmountAdjustedStr = Convert.ToString(item.AmountAdjusted);
pqEntity.Discount = item.Discount;
pqEntity.DiscountStr = Convert.ToString(item.Discount);
PQDetailsEntity.Add(pqEntity);
OnPropertyChanged("PQDetailsEntity");
}
PQDetailsEntityLst = PQDetailsEntity;
}
public void GetDebitNote(object param)
{
if (param != null)
{
DebitNoteForm pqf = dnRepository.GetDebitNoteDetails(Convert.ToString(param));
this.ID = pqf.DebitNote.ID;
this.DebitNo = pqf.DebitNote.DebitNo;
this.DebitDate = pqf.DebitNote.DebitDate;
this.SupplierCreditNoteNo = pqf.DebitNote.SupplierCreditNoteNo;
this.SupplierCreditNoteDate = pqf.DebitNote.SupplierCreditNoteDate;
this.SupplierCreditNoteAmount = pqf.DebitNote.SupplierCreditNoteAmount;
this.SelectedSupplierID = pqf.DebitNote.SupplierID;
this.PurchaseInvoiceID = pqf.DebitNote.PurchaseInvoiceID;
this.PurchaseInvoiceNo = pqf.DebitNote.PurchaseInvoiceNo;
this.TermsAndConditions = pqf.DebitNote.TermsAndConditions;
this.TotalBeforeTax = pqf.DebitNote.TotalBeforeTax;
this.TotalTax = pqf.DebitNote.TotalTax;
this.TotalAfterTax = pqf.DebitNote.TotalAfterTax;
this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax);
this.TotalTaxStr = Convert.ToString(TotalTax);
this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax);
this.Status = pqf.DebitNote.Status;
this.PQDetailsEntity = new ObservableCollection <DataGridViewModel>();
foreach (var item in pqf.InvoiceDetails)
{
DataGridViewModel pqEntity = new DataGridViewModel(ProductList);
pqEntity.SelectedPSID = Convert.ToString(item.PINo);
pqEntity.PandSCode = item.PandSCode;
pqEntity.PandSName = item.PandSName;
pqEntity.GSTRate = Math.Round(Convert.ToDecimal(item.GSTRate), DecimalPlaces);
pqEntity.GSTRateStr = Convert.ToString(pqEntity.GSTRate) + "%";
pqEntity.PQQty = item.PIQty;
pqEntity.PQPrice = Convert.ToString(item.Price);
pqEntity.PQDiscount = Math.Round((decimal)item.PIDiscount, 2);
// PQDEntity.GSTRate = item.GSTRate;
pqEntity.PQAmount = item.PIAmount;
PQDetailsEntity.Add(pqEntity);
}
}
}
public void GetCreditNote(object param)
{
if (param != null)
{
CreditNoteForm pqf = dnRepository.GetCreditNoteDetails(Convert.ToString(param));
this.ID = pqf.CreditNote.ID;
this.CreditNo = pqf.CreditNote.CreditNo;
this.CreditDate = pqf.CreditNote.CreditDate;
this.CustomerDebitNoteNo = pqf.CreditNote.CustomerDebitNoteNo;
this.CustomerDebitNoteDate = pqf.CreditNote.CustomerDebitNoteDate;
this.CustomerDebitNoteAmount = pqf.CreditNote.CustomerDebitNoteAmount;
this.SelectedCustomerID = pqf.CreditNote.CustomerID;
this.SalesInvoiceID = pqf.CreditNote.SalesInvoiceID;
this.SalesInvoiceNo = pqf.CreditNote.SalesInvoiceNo;
this.TermsAndConditions = pqf.CreditNote.TermsAndConditions;
this.TotalBeforeTax = pqf.CreditNote.TotalBeforeTax;
this.TotalTax = pqf.CreditNote.TotalTax;
this.TotalAfterTax = pqf.CreditNote.TotalAfterTax;
this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax);
this.TotalTaxStr = Convert.ToString(TotalTax);
this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax);
this.Status = pqf.CreditNote.Status;
this.PQDetailsEntity = new ObservableCollection <DataGridViewModel>();
foreach (var item in pqf.InvoiceDetails)
{
DataGridViewModel pqEntity = new DataGridViewModel(ProductList);
pqEntity.SelectedPSID = Convert.ToString(item.SINo);
pqEntity.PandSCode = item.PandSCode;
pqEntity.PandSName = item.PandSName;
pqEntity.GSTRate = item.GSTRate;
pqEntity.SQQty = item.SIQty;
pqEntity.SQPrice = Convert.ToString(item.Price);
pqEntity.SQDiscount = item.SIDiscount;
// PQDEntity.GSTRate = item.GSTRate;
pqEntity.SQAmount = item.SIAmount;
PQDetailsEntity.Add(pqEntity);
}
}
}
void GetNewPS(object param)
{
IsNew = true;
// SelectedCustomerID = 0;
IsCustomerEnabled = true;
IsCreditNoEnabled = true;
PSErrors = string.Empty;
GetNewPS();
if (PQDetailsEntity != null)
{
if (PQDetailsEntity.Count > 0)
{
PQDetailsEntity.Clear();
var row = new CollectSalesAmountDataGridViewModel();
PQDetailsEntity.Add(row);
OnPropertyChanged("PQDetailsEntity");
}
}
}
public void GetPurchaseInvoice(string pqNo)
{
// Mouse.OverrideCursor = Cursors.Wait;
PurchaseInvoiceForm pqf = pqRepository.GetPurchaseInvoice(pqNo);
this.ID = pqf.Invoice.ID;
this.InvoiceNo = pqf.Invoice.InvoiceNo;
this.OurPONo = pqf.Invoice.OurPONo;
this.InvoiceDate = pqf.Invoice.InvoiceDate;
this.PaymentDueDate = pqf.Invoice.PaymentDueDate;
this.SelectedSupplierID = pqf.Invoice.SupplierID;
//if (this.SelectedSupplierID > 0)
//{
// GetSupplierDetails();
//}
this.TermsAndConditions = pqf.Invoice.TermsAndConditions;
this.TotalBeforeTax = pqf.Invoice.TotalBeforeTax;
this.TotalTax = pqf.Invoice.TotalTax;
this.TotalAfterTax = pqf.Invoice.TotalAfterTax;
this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax);
this.TotalTaxStr = Convert.ToString(TotalTax);
this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax);
if (pqf.Invoice.ExcIncGST == true)
{
ExcludingTax = false;
IncludingTax = true;
// PQDEntity.GSTRate = 0;
}
else
{
ExcludingTax = true;
IncludingTax = false;
// PQDEntity.GSTRate = TaxRate;
}
if (this.PIStatus == Convert.ToByte(PI_Status.Paid))
{
AllFieldsReadonly = true;
AllFieldsEnabled = false;
}
else
{
AllFieldsReadonly = false;
AllFieldsEnabled = true;
LstSuppliers = supplierRepository.GetAllSupplier().Where(s => s.IsInActive != "Y").ToList();
ProductAndServices = ProductAndServices.OrderBy(x => x.PSName).Where(x => x.IsInActive != "Y").ToObservable();
}
this.PIStatus = pqf.Invoice.PIStatus;
if (PIStatus == Convert.ToByte(PI_Status.Cancelled))
{
StatusString = "Cancelled";
VisibilityForImage = Visibility.Visible;
AllFieldsEnabled = false;
AllFieldsReadonly = true;
}
else if (PIStatus == Convert.ToByte(PI_Status.Paid))
{
StatusString = " Paid";
VisibilityForImage = Visibility.Visible;
AllFieldsEnabled = false;
AllFieldsReadonly = true;
}
else if (PIStatus == Convert.ToByte(PI_Status.Adjusted))
{
StatusString = "Adjusted";
VisibilityForImage = Visibility.Visible;
AllFieldsEnabled = false;
AllFieldsReadonly = true;
}
else
{
StatusString = "";
VisibilityForImage = Visibility.Collapsed;
AllFieldsEnabled = true;
AllFieldsReadonly = false;
}
SupplierEnabled = false;// added on 23 may 2017
this.PQDetailsEntity = new ObservableCollection <DataGridViewModel>();
foreach (var item in pqf.InvoiceDetails)
{
DataGridViewModel pqEntity = new DataGridViewModel(ProductList);
pqEntity.SelectedPSID = Convert.ToString(item.PINo);
pqEntity.PandSCode = item.PandSCode;
pqEntity.PandSName = item.PandSName;
pqEntity.GSTRate = Math.Round(Convert.ToDecimal(item.GSTRate), DecimalPlaces);
pqEntity.GSTRateStr = Convert.ToString(pqEntity.GSTRate) + "%";
pqEntity.PQQty = item.PIQty;
pqEntity.PQPrice = Convert.ToString(item.Price);
pqEntity.PQDiscount = item.PIDiscount;
// PQDEntity.GSTRate = item.GSTRate;
pqEntity.PQAmount = item.PIAmount;
PQDetailsEntity.Add(pqEntity);
}
}
public int ManageDuplicatePandS()
{
int rowFocusindex = -1;
lst = new ObservableCollection <DataGridViewModel>();
lst = PQDetailsEntity;
var query = lst.GroupBy(x => x.SelectedPSID)
.Where(g => g.Count() > 1)
.ToList();
if (query.Count > 0 && PQDetailsEntity.Count > 1)
{
var obj1 = query[0].ElementAt(0);
var obj2 = query[0].ElementAt(1);
int? qty = 1;
decimal?productPrice2 = 0;
decimal?discountP2 = 0;
qty = query[0].ElementAt(0).PQQty + query[0].ElementAt(1).PQQty;
productPrice2 = Convert.ToDecimal(query[0].ElementAt(1).PQPrice);
discountP2 = query[0].ElementAt(1).PQDiscount;
var index1 = lst.IndexOf(query[0].ElementAt(0));
var index2 = lst.IndexOf(query[0].ElementAt(1));
if (productPrice2 != null)
{
obj1.PQQty = qty;
obj1.PQPrice = Convert.ToString(productPrice2);
obj1.PQDiscount = discountP2;
PQDetailsEntity[index1] = obj1;
var row = new DataGridViewModel(ProductList);
//row.PQQty = 1;
//row.GSTRate = TaxRate;
//row.GSTRateStr = Convert.ToString(TaxRate) + "%";
PQDetailsEntity[index2] = row;
rowFocusindex = index2;
}
//for (int i = 0; i < 2; i++)
//{
// var p = PQDetailsEntity.Where(e => e.SelectedPSID == obj2.SelectedPSID ).FirstOrDefault();
// if (p.PQPrice == null)
// {
// PQDetailsEntity.Remove(p);
// }
//}
OnPropertyChanged("PQDetailsEntity");
}
else
{
int count = PQDetailsEntity.Count(x => x.SelectedPSID == null);
if (count == 0)
{
var row = new DataGridViewModel(ProductList);
//row.PQQty = 1;
//row.GSTRate = TaxRate;
//row.GSTRateStr = Convert.ToString(TaxRate) + "%";
PQDetailsEntity.Add(row);
OnPropertyChanged("PQDetailsEntity");
rowFocusindex = -1;
}
else
{
var emptyRow = lst.Where(y => y.SelectedPSID == null).FirstOrDefault();
rowFocusindex = PQDetailsEntity.IndexOf(emptyRow);
}
}
return(rowFocusindex);
}
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 void GetCreditNote(object param)
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
if (param != null)
{
CreditNoteForm pqf = dnRepository.GetCreditNoteDetails(Convert.ToString(param));
this.ID = pqf.CreditNote.ID;
this.CreditNo = pqf.CreditNote.CreditNo;
this.CreditDate = pqf.CreditNote.CreditDate;
this.CustomerDebitNoteNo = pqf.CreditNote.CustomerDebitNoteNo;
if (CustomerDebitNoteDate == null)
{
this.CustomerDebitNoteDate = pqf.CreditNote.CustomerDebitNoteDate;
}
else
{
DateTime DateinStr = (DateTime)pqf.CreditNote.CustomerDebitNoteDate;
this.CustomerDebitNoteDateStr = DateinStr.ToString(oData.DateFormat);
}
this.CustomerDebitNoteAmount = pqf.CreditNote.CustomerDebitNoteAmount;
this.SelectedCustomerID = pqf.CreditNote.CustomerID;
this.SalesInvoiceID = pqf.CreditNote.SalesInvoiceID;
this.SalesInvoiceNo = pqf.CreditNote.SalesInvoiceNo;
this.TermsAndConditions = pqf.CreditNote.TermsAndConditions;
this.TotalBeforeTax = Convert.ToDecimal(pqf.CreditNote.TotalBeforeTax);
this.TotalTax = Convert.ToDecimal(pqf.CreditNote.TotalTax);
this.TotalAfterTax = Convert.ToDecimal(pqf.CreditNote.TotalAfterTax);
this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax);
this.TotalTaxStr = Convert.ToString(TotalTax);
this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax);
this.Status = pqf.CreditNote.Status;
if (this.Status == 1)
{
RubberAdjusted = true;
}
this.PQDetailsEntity = new ObservableCollection <DataGridViewModel>();
foreach (var item in pqf.InvoiceDetails)
{
DataGridViewModel pqEntity = new DataGridViewModel(ProductList);
pqEntity.SelectedPSID = Convert.ToString(item.SINo);
pqEntity.PandSCode = item.PandSCode;
pqEntity.PandSName = item.PandSName;
pqEntity.GSTRate = item.GSTRate;
pqEntity.SQQty = item.SIQty;
pqEntity.SQPrice = Convert.ToString(item.Price);
pqEntity.SQDiscount = item.SIDiscount;
// PQDEntity.GSTRate = item.GSTRate;
pqEntity.SQAmount = item.SIAmount;
PQDetailsEntity.Add(pqEntity);
}
}
}
public void GetPurchaseQuotation(string pqNo)
{
// Mouse.OverrideCursor = Cursors.Wait;
PurchaseQuotationForm pqf = pqRepository.GetPurchaseQuotation(pqNo);
this.ID = pqf.Quotation.ID;
this.QuotationNo = pqf.Quotation.QuotationNo;
this.QuotationDate = pqf.Quotation.QuotationDate;
this.ValidForDays = pqf.Quotation.ValidForDays;
this.SelectedSupplierID = pqf.Quotation.SupplierID;
//if (this.SelectedSupplierID > 0)
//{
// GetSupplierDetails();
//}
this.TermsAndConditions = pqf.Quotation.TermsAndConditions;
this.TotalBeforeTax = pqf.Quotation.TotalBeforeTax;
this.TotalTax = pqf.Quotation.TotalTax;
this.TotalAfterTax = pqf.Quotation.TotalAfterTax;
this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax);
this.TotalTaxStr = Convert.ToString(TotalTax);
this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax);
if (pqf.Quotation.ExcIncGST == true)
{
ExcludingTax = false;
IncludingTax = true;
// PQDEntity.GSTRate = 0;
}
else
{
ExcludingTax = true;
IncludingTax = false;
// PQDEntity.GSTRate = TaxRate;
}
this.PQ_Conv_to_PO = pqf.Quotation.PQ_Conv_to_PO;
this.PQ_Conv_to_PI = pqf.Quotation.PQ_Conv_to_PI;
if (PQ_Conv_to_PO == true || PQ_Conv_to_PI == true)
{
AllFieldsReadonly = true;
AllFieldsEnabled = false;
}
else
{
AllFieldsReadonly = false;
AllFieldsEnabled = true;
LstSuppliers = supplierRepository.GetAllSupplier().Where(s => s.IsInActive != "Y").ToList();
ProductAndServices = ProductAndServices.OrderBy(x => x.PSName).Where(x => x.IsInActive != "Y").ToObservable();
}
SupplierEnabled = false;
this.PQDetailsEntity = new ObservableCollection <DataGridViewModel>();
foreach (var item in pqf.QuotationDetails)
{
DataGridViewModel pqEntity = new DataGridViewModel(ProductList);
pqEntity.SelectedPSID = Convert.ToString(item.PQNo);
pqEntity.PandSCode = item.PandSCode;
pqEntity.PandSName = item.PandSName;
pqEntity.GSTRate = Math.Round(Convert.ToDecimal(item.GSTRate), DecimalPlaces);
pqEntity.GSTRateStr = Convert.ToString(pqEntity.GSTRate) + "%";
pqEntity.PQQty = item.PQQty;
pqEntity.PQPrice = Convert.ToString(item.Price);
pqEntity.PQDiscount = item.PQDiscount;
// PQDEntity.GSTRate = item.GSTRate;
pqEntity.PQAmount = item.PQAmount;
PQDetailsEntity.Add(pqEntity);
}
}
