public JournalForm GetDataIntoModel()
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
JournalForm JForm = new JournalForm();
JForm.JournalaDataDetails= new List<JournalFormEntity>();
JournalFormEntity model = new JournalFormEntity();
model.JournalNo = this.JournalNo;
model.JournalDate = DateTime.ParseExact(this.JournalDateStr, oData.DateFormat, null);
JForm.JournalData = model;
foreach (var item in JournalDetailsEntity)
{
if (item.ID != null)
{
JournalFormEntity jEntity = new JournalFormEntity();
jEntity.ID = item.ID;
jEntity.JournalDateStr = item.JournalDateStr;
jEntity.Credit = item.Credit;
jEntity.Debit = item.Debit;
if (item.ID != 0 && Convert.ToInt32(item.ID) > 0)
{
JForm.JournalaDataDetails.Add(jEntity);
}
}
}
return JForm;
}
public void GetJournalDetails(string JNo)
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
string obj = JNo.ToString();
JournalForm JObj = journalRepository.GetJournalDetails(obj);
this.JournalNo = JObj.JournalData.JournalNo;
DateTime Dateinstr = (DateTime)JObj.JournalData.JournalDate;
this.JournalDateStr = Dateinstr.ToString(oData.DateFormat);
this.JournalDetailsEntity = new ObservableCollection<JGridViewModel>();
this.sumCredit =Convert.ToString(JObj.JournalaDataDetails.Sum(x => x.Credit));
this.sumDebit = Convert.ToString(JObj.JournalaDataDetails.Sum(x => x.Debit));
foreach (var item in JObj.JournalaDataDetails)
{
JGridViewModel pqEntity = new JGridViewModel(JournalList);
pqEntity.ID = item.ID;
pqEntity.JournalDateStr = item.JournalDateStr;
pqEntity.Credit = item.Credit;
pqEntity.Debit = item.Debit;
JournalDetailsEntity.Add(pqEntity);
}
}
public TransferMoneyEntity GetDataIntoModel()
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
TransferMoneyEntity model = new TransferMoneyEntity();
model.SelectedtransferFromCashAndBankAcntID = this.SelectedtransferFromCashAndBankAcntID;
model.SelectedtransferToCashBankAcntID = this.SelectedtransferToCashBankAcntID;
model.CashChequeDate = DateTime.ParseExact(this.CashChequeDateStr, oData.DateFormat, null);
model.CashChequeNo = this.CashChequeNo;
model.AmountStr = AmountStr;
model.Amount = Convert.ToDecimal(AmountStr);
model.TransferFromBeforeBalanceStr = this.TransferFromBeforeBalanceStr;
model.TransferFromBeforeBalance = Convert.ToDecimal(TransferFromBeforeBalance);
model.TransferFromAfterBalanceStr = this.TransferFromAfterBalanceStr;
model.TransferFromAfterBalance = Convert.ToDecimal(TransferFromAfterBalance);
model.TransferToBeforeBalanceStr = this.TransferToBeforeBalanceStr;
model.TransferToBeforeBalance = Convert.ToDecimal(TransferToBeforeBalance);
model.TransferToAfterBalanceStr = this.TransferToAfterBalanceStr;
model.TransferToAfterBalance = Convert.ToDecimal(TransferToAfterBalance);
model.TaxRate = this.TaxRate;
model.Remarks = this.Remarks;
model.IsCheque = this.IsCheque;
return(model);
}
public PaymentFromCustomerForm GetDataIntoModel()
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
PaymentFromCustomerForm PQForm = new PaymentFromCustomerForm();
PQForm.PaymentFromCustomerDetails = new List <PaymentFromCustomerDetailsEntity>();
PaymentFromCustomerEntity model = new PaymentFromCustomerEntity();
// this.ID = pqf.PaymentFromCustomer.ID;
model.CustomerID = this.SelectedCustomerID;
model.AccountId = this.SelectedAccountID;
//model.DateStr = this.DateStr;
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.PaymentFromCustomer = model;
foreach (var item in PQDetailsEntity.Where(e => Convert.ToDecimal(e.AmountAdjustedStr) != 0))
{
PaymentFromCustomerDetailsEntity pqEntity = new PaymentFromCustomerDetailsEntity();
pqEntity.SalesNo = item.SalesNo;
pqEntity.SalesDate = item.SalesDate;
pqEntity.SalesAmount = Convert.ToDecimal(item.SalesAmountStr);
//item.SalesAmount=pqEntity.SalesAmount;
if (item.PaymentDueDateStr != string.Empty)
{
// pqEntity.PaymentDueDate = Convert.ToDateTime(item.PaymentDueDateStr);
pqEntity.PaymentDueDate = Utility.SimpleDateTime(item.PaymentDueDateStr); //Sunil Sharma
}
else
{
pqEntity.PaymentDueDate = null;
}
//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.PaymentFromCustomerDetails.Add(pqEntity);
}
return(PQForm);
}
private void AdjustCreditNotes(string AdjustedNo)
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
IsNew = false;
AdjustCreditNoteForm pqf = psRepository.AdjustCreditNoteDetails(AdjustedNo);
pqf.AdjustCreditNote.Amount = Math.Abs(decimal.Parse(pqf.AdjustCreditNote.Amount.ToString()));
pqf.AdjustCreditNote.AmountStr = Math.Abs(decimal.Parse(pqf.AdjustCreditNote.AmountStr)).ToString();
pqf.AdjustCreditNote.MustCompare = true;
if (pqf.AdjustCreditNote.AdjustCreditNoteDate == null)
{
this.AdjustCreditNoteDateStr = "";
}
else
{
DateTime Dateinstr = (DateTime)pqf.AdjustCreditNote.AdjustCreditNoteDate;
this.AdjustCreditNoteDateStr = Dateinstr.ToString(oData.DateFormat);
}
GetModelData(pqf);
}
public PayMoneyEntity GetDataIntoModel()
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
PayMoneyEntity model = new PayMoneyEntity();
model.SelectedLinkedAcntID = this.SelectedLinkedAcntID;
model.SelectedCashBankAcntID = this.SelectedCashBankAcntID;
model.CashChequeDate = DateTime.ParseExact(this.CashChequeDateStr, oData.DateFormat, null);
model.CashChequeNo = this.CashChequeNo;
model.TotalBeforeTaxStr = TotalBeforeTaxStr;
model.TotalBeforeTax = Convert.ToDecimal(TotalBeforeTaxStr);
model.TotalTaxStr = this.TotalTaxStr;
model.TotalTax = Convert.ToDecimal(TotalTaxStr);
model.TotalAfterTaxStr = this.TotalAfterTaxStr;
model.TotalAfterTax = Convert.ToDecimal(TotalAfterTaxStr);
model.SelectedTaxID = this.SelectedTaxID;
model.TaxRate = this.TaxRate;
model.Remarks = this.Remarks;
model.IsCheque = this.IsCheque;
return(model);
}
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 void GetCountAndAdjustStock(string scNo)
{
// Mouse.OverrideCursor = Cursors.Wait;
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
CountAndAdjustStockForm pqf = casRepository.GetCountAndAdjustStock(scNo);
this.StockCountNo = pqf.CountAndAdjustStock.StockCountNo;
DateTime Dateinstr = (DateTime)pqf.CountAndAdjustStock.StockDate;
this.StockDateStr = Dateinstr.ToString(oData.DateFormat);
if (pqf.CountAndAdjustStock.Type == Convert.ToInt16(Stock_Type.IncreaseDecreaseStock))
{
IsIncreaseDecreaseStock = true;
IsStockDamaged = false;
IsStockTake = false;
SharedValues.StockType = Convert.ToInt16(Stock_Type.IncreaseDecreaseStock);
}
else if (pqf.CountAndAdjustStock.Type == Convert.ToInt16(Stock_Type.StockDamaged))
{
IsIncreaseDecreaseStock = false;
IsStockDamaged = true;
IsStockTake = false;
SharedValues.StockType = Convert.ToInt16(Stock_Type.StockDamaged);
}
else if (pqf.CountAndAdjustStock.Type == Convert.ToInt16(Stock_Type.StockTake))
{
IsIncreaseDecreaseStock = false;
IsStockDamaged = false;
IsStockTake = true;
SharedValues.StockType = Convert.ToInt16(Stock_Type.StockTake);
}
this.PSDetailsEntity = new ObservableCollection <DataGridViewModel>();
foreach (var item in pqf.CountAndAdjustStockDetails)
{
DataGridViewModel pqEntity = new DataGridViewModel(ProductList);
pqEntity.SelectedPSID = item.PSID;
pqEntity.PandSCode = item.PandSCode;
pqEntity.PandSName = item.PandSName;
pqEntity.SystemQty = item.SystemQty;
pqEntity.CountQty = item.CountQty;
pqEntity.Difference = item.Difference;
pqEntity.AvgCost = Convert.ToString(item.AverageCost);
pqEntity.Amount = item.Amount;
pqEntity.AmountStr = item.AmountStr;
PSDetailsEntity.Add(pqEntity);
}
}
public void CanCreateSalesOrder()
{
using (var context = new SPEmulationContext(Settings.Default.IsolationLevel, Settings.Default.Url))
{
var salesOrderList = context.GetOrCreateList(
SalesOrderListRepository.SalesOrderListName,
SPListTemplateType.GenericList,
"OrderDate", "Customer", "Status");
var orderLinesList = context.GetOrCreateList(
SalesOrderListRepository.OrderLinesListName,
SPListTemplateType.GenericList,
"SalesOrder", "Price", "Quantity");
var repository = new SalesOrderListRepository();
var customer = new Customer
{
CustomerId = 2,
Name = "Customer 2"
};
var order = new SalesOrder
{
SalesOrderId = 0,
Customer = customer,
OrderDate = DateTime.Today,
Status = OrderStatus.New
};
order.Lines.Add(new OrderLine
{
Product = "Product 1",
Quantity = 5,
Price = 5.5
});
order.Lines.Add(new OrderLine
{
Product = "Product 2",
Quantity = 2,
Price = 106.5
});
int salesOrderCount = salesOrderList.ItemCount;
int orderLineCount = orderLinesList.ItemCount;
repository.Add(order);
Assert.AreEqual <int>(salesOrderCount + 1, salesOrderList.Items.Count);
Assert.AreEqual <int>(orderLineCount + 2, orderLinesList.Items.Count);
}
}
public CountAndAdjustStockForm GetDataIntoModel()
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
CountAndAdjustStockForm CSForm = new CountAndAdjustStockForm();
CSForm.CountAndAdjustStockDetails = new List <CountAndAdjustStockDetailsEntity>();
CountAndAdjustStockEntity model = new CountAndAdjustStockEntity();
model.StockCountNo = this.StockCountNo;
model.StockDate = DateTime.ParseExact(this.StockDateStr, oData.DateFormat, null);
if (IsIncreaseDecreaseStock == true)
{
model.StockType = Convert.ToByte(Stock_Type.IncreaseDecreaseStock);
}
if (IsStockDamaged == true)
{
model.StockType = Convert.ToByte(Stock_Type.StockDamaged);
}
if (IsStockTake == true)
{
model.StockType = Convert.ToByte(Stock_Type.StockTake);
}
CSForm.CountAndAdjustStock = model;
foreach (var item in PSDetailsEntity.Where(e => e.CountQty != 0))
{
if (item.SelectedPSID != 0)
{
CountAndAdjustStockDetailsEntity pqEntity = new CountAndAdjustStockDetailsEntity();
pqEntity.PSID = item.SelectedPSID;
pqEntity.PandSCode = item.PandSCode;
pqEntity.PandSName = item.PandSName;
pqEntity.SystemQty = item.SystemQty;
pqEntity.CountQty = item.CountQty;
pqEntity.Difference = item.Difference;
pqEntity.AvgCost = item.AvgCost;
pqEntity.Amount = item.Amount;
pqEntity.AdjustedAmount = Convert.ToDecimal(AdjustedAmountStr);
pqEntity.AdjustedAmountStr = AdjustedAmountStr;
if (item.SelectedPSID != 0 && Convert.ToInt32(item.SelectedPSID) > 0)
{
CSForm.CountAndAdjustStockDetails.Add(pqEntity);
}
}
}
return(CSForm);
}
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);
}
public RefundFromSupplierForm GetDataIntoModel()
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
RefundFromSupplierForm PQForm = new RefundFromSupplierForm();
PQForm.RefundFromSupplierDetails = new List <RefundFromSupplierDetailsEntity>();
RefundFromSupplierEntity model = new RefundFromSupplierEntity();
// this.ID = pqf.RefundFromSupplier.ID;
model.SupplierID = this.SelectedSupplierID;
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.RefundFromSupplier = model;
foreach (var item in PQDetailsEntity.Where(e => Convert.ToDecimal(e.AmountAdjustedStr) != 0))
{
RefundFromSupplierDetailsEntity pqEntity = new RefundFromSupplierDetailsEntity();
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.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.RefundFromSupplierDetails.Add(pqEntity);
}
return(PQForm);
}
private void GetPaymentToSupplierDetails(string cashChequeNo)
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
this.ListSuppliers = supplierRepository.GetAllSupplier().ToList();
IsNew = false;
PaymentToSupplierForm pqf = psRepository.GetPaymentToSupplierDetails(cashChequeNo);
DateTime Dateinstr = (DateTime)pqf.PaymentToSupplier.Date;
this.DateStr = Dateinstr.ToString(oData.DateFormat);
GetModelData(pqf);
}
public void CanGetSalesOrderByCustomer()
{
using (var context = new SPEmulationContext(Settings.Default.IsolationLevel, Settings.Default.Url))
{
var solutionRelativePath = @"..\..\..\SalesOrderPortalSolution\Lists\";
var salesOrderList = context.GetOrCreateList(solutionRelativePath + "SalesOrders\\Elements.xml", solutionRelativePath + "SalesOrders\\schema.xml");
var orderLinesList = context.GetOrCreateList(solutionRelativePath + "OrderLines\\Elements.xml", solutionRelativePath + "OrderLines\\schema.xml");
var repository = new SalesOrderListRepository();
// CAML not yet supported. Fake queries.
if (context.IsolationLevel == IsolationLevel.Fake)
{
new ShimSPList(salesOrderList)
{
GetItemsSPQuery = (q) =>
{
var shim = new ShimSPListItemCollection();
shim.Bind(salesOrderList.Items.Cast <SPListItem>().Where(i => (int)i["Customer"] == 1));
return(shim.Instance);
}
};
new ShimSPList(orderLinesList)
{
GetItemsSPQuery = (q) =>
{
var shim = new ShimSPListItemCollection();
var match = Regex.Match(q.Query, "<FieldRef Name='SalesOrder' LookupId='TRUE' /><Value Type='Lookup' >.*?</Value>");
var lookupId = int.Parse(match.Value.Replace("<FieldRef Name='SalesOrder' LookupId='TRUE' /><Value Type='Lookup' >", "").Replace("</Value>", ""));
shim.Bind(orderLinesList.Items.Cast <SPListItem>().Where(i => (int)i["SalesOrder"] == 1));
return(shim.Instance);
}
};
}
var customer1 = new Customer
{
CustomerId = 1,
Name = "Customer 1"
};
var salesOrdersOfCustomer1 = repository.GetByCustomer(customer1);
Assert.AreEqual <int>(2, salesOrdersOfCustomer1.Count());
Assert.AreEqual <int>(2, salesOrdersOfCustomer1.First().Lines.Count);
}
}
private void GetPayMoneyDetails(string cashChequeNo)
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
IsNew = false;
IsTextBoxReadOnly = true;
IsCashChequeEnabled = false;
PayMoneyEntity pqf = rmRepository.GetPayMoneyDetails(cashChequeNo);
DateTime Dateinstr = (DateTime)pqf.CashChequeDate;
this.CashChequeDateStr = Dateinstr.ToString(oData.DateFormat);
GetModelData(pqf);
}
void GetOptionsandTaxValues()
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
if (oData != null)
{
CurrencyName = oData.CurrencyCode;
DateFormat = oData.DateFormat;
}
TaxModel objDefaultTax = new TaxModel();
objDefaultTax = purchaseRepository.GetDefaultTaxes();
}
public DebitNoteForm GetDataIntoModel()
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
DebitNoteForm PQForm = new DebitNoteForm();
PQForm.InvoiceDetails = new List <PurchaseInvoiceDetailEntity>();
DebitNoteEntity model = new DebitNoteEntity();
model.DebitNo = this.DebitNo;
model.DebitDate = this.DebitDate;
model.TotalBeforeTax = this.TotalBeforeTax;
model.TotalTax = this.TotalTax;
model.TotalAfterTax = this.TotalAfterTax;
model.SupplierCreditNoteNo = this.SupplierCreditNoteNo;
model.SupplierCreditNoteDate = DateTime.ParseExact(this.SupplierCreditNoteDateStr, oData.DateFormat, null);
model.SupplierCreditNoteAmount = this.SupplierCreditNoteAmount;
model.SupplierID = this.SelectedSupplierID;
model.TermsAndConditions = this.TermsAndConditions;
PQForm.DebitNote = model;
foreach (var item in PQDetailsEntity)
{
PurchaseInvoiceDetailEntity pqEntity = new PurchaseInvoiceDetailEntity();
pqEntity.PINo = Convert.ToString(item.SelectedPSID);
pqEntity.PandSCode = item.PandSCode;
pqEntity.PandSName = item.PandSName;
pqEntity.PIQty = item.PQQty;
pqEntity.PIPrice = item.PQPrice;
pqEntity.PIDiscount = item.PQDiscount;
pqEntity.GSTRate = item.GSTRate;
pqEntity.GSTRateStr = Convert.ToString(item.GSTRate) + "%";
pqEntity.PIAmount = item.PQAmount;
if (item.SelectedPSID != null && Convert.ToInt32(item.SelectedPSID) > 0)
{
PQForm.InvoiceDetails.Add(pqEntity);
}
}
return(PQForm);
}
void GetOptionsandTaxValues()
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository SalesRepository = new SalesOrderListRepository();
oData = SalesRepository.GetOptionSettings();
if (oData != null)
{
CurrencyName = oData.CurrencyCode;
DateFormat = oData.DateFormat;
if (!string.IsNullOrWhiteSpace(oData.DefCashBankAcc))
{
this.SelectedAccountID = Convert.ToInt32(oData.DefCashBankAcc);
}
}
TaxModel objDefaultTax = new TaxModel();
objDefaultTax = SalesRepository.GetDefaultTaxes();
}
private void GetPaymentFromCustomerDetails(string cashChequeNo)
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
this.ListCustomers = CustomerRepository.GetCustomerList().ToList();
IsNew = false;
PaymentFromCustomerForm pqf = psRepository.GetPaymentFromCustomerDetails(cashChequeNo);
if (pqf.PaymentFromCustomer != null)
{
DateTime Dateinstr = (DateTime)pqf.PaymentFromCustomer.Date;
this.DateStr = Dateinstr.ToString(oData.DateFormat);
GetModelData(pqf);
}
else
{
}
}
//void NavigateToSupplier(object param)
//{
// string obj = param.ToString();
// SharedValues.getValue = obj;
// var mainview = ServiceLocator.Current.GetInstance<SupplierDetailView>();
// var mainregion = this.regionManager.Regions[RegionNames.MainRegion];
// mainregion.Add(mainview);
// if (mainregion != null)
// {
// mainregion.Activate(mainview);
// }
// var tabview = ServiceLocator.Current.GetInstance<SupplierTabView>();
// var tabregion = this.regionManager.Regions[RegionNames.MenuBarRegion];
// tabregion.Add(tabview);
// if (tabregion != null)
// {
// tabregion.Activate(tabview);
// }
// eventAggregator.GetEvent<TabVisibilityEvent>().Publish(true);
// eventAggregator.GetEvent<SubTabVisibilityEvent>().Publish(false);
// eventAggregator.GetEvent<TitleChangedEvent>().Publish("Suppliers Details Form");
//}
void ShowSales(object param)
{
this.ShowDetailTrue = true;
this.ShowSummaryTrue = false;
ITodoUnpaidDetailRepository paymentRepository = new TodoUnpaidDetailRepository();
//GetOptionsandTaxValues();
this.ListDueDays = paymentRepository.GetAllData(1);
this.UnpaidPurchaseTrue = false;
this.UnpaidPurSalesTrue = false;
this.UnpaidSalesTrue = true;
this.UnpaidSummaryTrue = false;
DefaultList = this.ListDueDays;
this.ListDueDayscmbSup = this.ListDueDays.GroupBy(x => x.Name).Select(y => y.First()).OrderBy(x => x.Name).ToList();
this.ListDueDayscmbInv = this.ListDueDays.GroupBy(x => x.InvoiceNo).Select(y => y.First()).OrderBy(x => x.InvoiceNo).ToList();
this.ShowSelectedCount = this.ListDueDays.Count();
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
this.DateformatStr = oData.DateFormat.ToString();
}
private void GetAdjustDebitNoteDetails(string DebitNoteNo)
{
OptionsEntity oData = new OptionsEntity();
ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
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();
pqf.AdjustDebitNote.AdjustDebitNoteNumber = "AD-" + psRepository.GetLatestInvoiceNo();
if (pqf.AdjustDebitNote.AdjustDebitNoteDate == null)
{
this.AdjustDebitNoteDateStr = "";
}
else
{
DateTime Dateinstr = (DateTime)pqf.AdjustDebitNote.AdjustDebitNoteDate;
this.AdjustDebitNoteDateStr = Dateinstr.ToString(oData.DateFormat);
}
GetModelData(pqf);
}
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);
}
}
}
