public PurchaseInvoiceForm GetDataIntoModel()
{
try
{
OptionsEntity oData = new OptionsEntity();
oData = customerRepository.GetOptionSettings();
PurchaseInvoiceForm PQForm = new PurchaseInvoiceForm();
PQForm.BEInvoiceDetails = new List <PurchaseInvoiceBEDetailsEntity>();
PurchaseInvoiceEntity model = new PurchaseInvoiceEntity();
// model.InvoiceNo = this.InvoiceNo;
model.InvoiceDate = DateTime.ParseExact(this.InvoiceDateStr, oData.DateFormat, null);
model.TotalBeforeTax = this.TotalBeforeTax;
model.TotalTax = this.TotalTax;
model.TotalAfterTax = this.TotalAfterTax;
model.PaymentDueDate = DateTime.ParseExact(this.PaymentDueDateStr, oData.DateFormat, null);
model.OurPONo = this.OurPONo;
if (!string.IsNullOrEmpty(InvoiceNo))
{
model.InvoiceNo = this.InvoiceNo;
}
else
{
model.InvoiceNo = this.OurPONo;
this.InvoiceNo = this.OurPONo;
}
model.SupplierID = this.SelectedSupplierID;
model.TermsAndConditions = this.TermsAndConditions;
if (ExcludingTax == true)
{
model.ExcIncGST = false;
}
else
{
model.ExcIncGST = true;
}
PQForm.Invoice = model;
foreach (var item in BEDetailsEntity)
{
PurchaseInvoiceBEDetailsEntity pqEntity = new PurchaseInvoiceBEDetailsEntity();
pqEntity.SelectedAccountId = item.SelectedAccountId;
if (item.SelectedAccountId != null)
{
var acc = Accounts.Where(e => e.AccountID == item.SelectedAccountId).SingleOrDefault();
if (acc != null)
{
pqEntity.AccountName = acc.AccountName;
}
}
pqEntity.Description = item.Description;
pqEntity.SelectedTaxID = item.SelectedTaxID;
if (item.SelectedTaxID != null)
{
var tax = Taxes.Where(e => e.TaxID == item.SelectedTaxID).SingleOrDefault();
if (tax != null)
{
pqEntity.GSTCode = tax.TaxCode;
pqEntity.GSTRate = tax.TaxRate;
}
}
pqEntity.PQAmountStr = item.PQAmountStr;
pqEntity.PQAmount = Convert.ToDecimal(item.PQAmountStr);
//pqEntity.TaxList = item.TaxList;
pqEntity.PIType = "BE";
//pqEntity.Amount= item.PQAmountStr;
//pqEntity.AmountBeforeTax= Convert.ToDecimal(item.PQAmountStr);
//pqEntity.TaxAmount = Convert.ToDecimal(item.PQAmountStr) * pqEntity.GSTRate;
//pqEntity.AmountAfterTax = pqEntity.AmountBeforeTax + pqEntity.TaxAmount;
if (item.SelectedAccountId != null && Convert.ToInt32(item.SelectedAccountId) > 0)
{
PQForm.BEInvoiceDetails.Add(pqEntity);
}
}
return(PQForm);
}
catch (Exception ex)
{
throw ex;
}
}
public void GetPurchaseInvoice(string pqNo)
{
OptionsEntity oData = new OptionsEntity();
IPurchaseQuotationListRepository purchaseRepository = new PurchaseQuotationListRepository();
oData = purchaseRepository.GetOptionSettings();
// Mouse.OverrideCursor = Cursors.Wait;
PurchaseInvoiceForm pqf = pqRepository.GetPurchaseInvoice(pqNo);
if (pqf.Invoice != null)
{
this.ID = pqf.Invoice.ID;
this.InvoiceNo = pqf.Invoice.InvoiceNo;
this.OurPONo = pqf.Invoice.OurPONo;
this.InvoiceDateStr = pqf.Invoice.InvoiceDate.ToString(oData.DateFormat);
DateTime Dateinstr = (DateTime)pqf.Invoice.PaymentDueDate;
this.PaymentDueDateStr = Dateinstr.ToString(oData.DateFormat);
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;
}
this.PIStatus = pqf.Invoice.PIStatus;
if (this.PIStatus == Convert.ToByte(PI_Status.Paid))
{
AllFieldsReadonly = true;
AllFieldsEnabled = false;
}
else
{
AllFieldsReadonly = false;
AllFieldsEnabled = true;
}
this.BEDetailsEntity = new ObservableCollection <AccountDataGridViewModel>();
if (pqf.BEInvoiceDetails.Count() > 0)
{
foreach (var item in pqf.BEInvoiceDetails)
{
AccountDataGridViewModel pqEntity = new AccountDataGridViewModel(AccountsList);
pqEntity.SelectedAccountName = item.AccountName;
var acc = Accounts.Where(e => e.AccountName == item.AccountName).FirstOrDefault();
if (acc != null)
{
pqEntity.SelectedAccountId = acc.AccountID;
}
pqEntity.PQAmount = item.PQAmount;
pqEntity.PQAmountStr = Convert.ToString(item.PQAmount);
pqEntity.GSTRate = item.GSTRate;
pqEntity.Description = item.Description;
var tax = Taxes.Where(e => e.TaxRate == item.GSTRate).FirstOrDefault();
if (tax != null)
{
pqEntity.SelectedTaxID = tax.TaxID;
}
BEDetailsEntity.Add(pqEntity);
}
}
else
{
var row = new AccountDataGridViewModel(AccountsList);
BEDetailsEntity.Add(row);
OnPropertyChanged("BEDetailsEntity");
}
}
else
{
GetNewPQ();
}
}