public void RefundMoneyToCustomer(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;
PQErrors = string.Empty;
CreditNoteForm PQForm = GetDataIntoModel();
if (PQForm != null)
{
dnRepository.UpdateCreditNote(PQForm);
}
if (param != null)
{
string obj = param.ToString();
SharedValues.NewClick = obj;
}
SharedValues.ScreenCheckName = "Refund To Customer";
SharedValues.ViewName = "Refund To Customer";
var accessitem = listitem.AddToList();
if (accessitem == true)
{
SharedValues.getValue = "RefundToCustomerTab";
SharedValues.CollectCommand = Convert.ToString(this.SelectedCustomerID);
var mainview = ServiceLocator.Current.GetInstance <RefundToCustomerView>();
var mainregion = this.regionManager.Regions[RegionNames.MainRegion];
mainregion.Add(mainview);
if (mainregion != null)
{
mainregion.Activate(mainview);
}
var tabview = ServiceLocator.Current.GetInstance <CashBankTabView>();
var tabregion = this.regionManager.Regions[RegionNames.MenuBarRegion];
tabregion.Add(tabview);
if (tabregion != null)
{
tabregion.Activate(tabview);
}
eventAggregator.GetEvent <TabVisibilityEvent>().Publish(true);
eventAggregator.GetEvent <TitleChangedEvent>().Publish("Refund To Customer Form");
}
else
{
MessageBox.Show("You do not have access to this screen. Please contact your Administrator.\n" + "@ Simple Accounting Software Pte Ltd");
}
Mouse.OverrideCursor = null;
}
}
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 CreditNoteForm GetPrintCreditNote(string pino)
{
CreditNoteForm pif = new CreditNoteForm();
try
{
using (SASEntitiesEDM entities = new SASEntitiesEDM())
{
var pi = (from pis in entities.SalesInvoices
join Cus in entities.Customers on pis.Cus_Id equals Cus.ID
join Sal in entities.CreditNotes on pis.ID equals Sal.SI_Id
where Sal.CN_No == pino && (pis.IsDeleted == false || pis.IsDeleted == null)
select new CreditNoteEntity
{
SalesInvoiceID = pis.ID,
SalesInvoiceNo = pis.SI_No,
ID = pis.ID,
CustomerID = pis.Cus_Id,
CustomerName = Cus.Cus_Name,
CustomerBillAddress1 = Cus.Cus_Bill_to_line1,
CustomerBillAddress2 = Cus.Cus_Bill_to_line2,
CustomerBillAddressCity = Cus.Cus_Bill_to_city,
CustomerBillAddressState = Cus.Cus_Bill_to_state,
CustomerBillAddressCountary = Cus.Cus_Bill_to_country,
CustomerBillPostCode = Cus.Cus_Bill_to_post_code,
CustomerTelephone = Cus.Cus_Telephone,
CreditNo = Sal.CN_No,
CreditDate = Sal.CN_Date,
CustomerDebitNoteNo = Sal.Cus_DN_No,
CustomerDebitNoteDate = Sal.Cus_DN_Date,
CustomerDebitNoteAmount = Sal.Cus_DN_Amount.ToString(),
TermsAndConditions = pis.SI_TandC,
TotalBeforeTax = pis.SI_Tot_bef_Tax,
TotalTax = pis.SI_GST_Amt,
TotalAfterTax = pis.SI_Tot_aft_Tax,
}).SingleOrDefault();
//var PaymentDueDate1 =pi.InvoiceDate.AddDays(Convert.ToInt32(pi.CreditDays));
if (pi != null)
{
pif.CreditNote = pi;
}
//for comapany details
var company = (from com in entities.CompanyDetails
where (com.IsDeleted == false || com.IsDeleted == null)
select new CreditNoteEntity
{
CompanyName = com.Comp_Name,
CompanyRegNumber = com.Comp_Reg_No,
CompanyLogo = com.Comp_Logo,
CompanyGstNumber = com.Comp_GST_Reg_No,
CompanyBillToAddressLine1 = com.Comp_Bill_to_line1,
CompanyBillToAddressLine2 = com.Comp_Bill_to_line2,
CompanyBillToCity = com.Comp_Bill_to_city,
CompanyBillToState = com.Comp_Bill_to_state,
CompanyBillToCountary = com.Comp_Bill_to_country,
CompanyBillToPostCode = com.Comp_Bill_to_post_code,
CompanyEmail = com.Comp_Email,
CompanyFax = com.Comp_Fax
}).SingleOrDefault();
pif.CreditNote.CompanyName = company.CompanyName;
pif.CreditNote.CompanyLogo = company.CompanyLogo;
pif.CreditNote.CompanyRegNumber = company.CompanyRegNumber;
pif.CreditNote.CompanyGstNumber = company.CompanyGstNumber;
pif.CreditNote.CompanyBillToAddressLine1 = company.CompanyBillToAddressLine1;
pif.CreditNote.CompanyBillToAddressLine2 = company.CompanyBillToAddressLine2;
pif.CreditNote.CompanyBillToCity = company.CompanyBillToCity;
pif.CreditNote.CompanyBillToState = company.CompanyBillToState;
pif.CreditNote.CompanyBillToCountary = company.CompanyBillToCountary;
pif.CreditNote.CompanyBillToPostCode = company.CompanyBillToPostCode;
pif.CreditNote.CompanyEmail = company.CompanyEmail;
pif.CreditNote.CompanyFax = company.CompanyFax;
//end for comapany details
//option details
var optiondata = (from option in entities.Options
select new CreditNoteEntity
{
CurrencyCode = option.Currency_Code
}).SingleOrDefault();
pif.CreditNote.CurrencyCode = optiondata.CurrencyCode;
//end options details
var pid = (from pids in entities.SalesInvoiceDetails
where pids.SI_ID == pi.SalesInvoiceID
select new SalesInvoiceDetailEntity
{
ID = pids.ID,
SIID = pids.SI_ID,
SINo = pids.SI_No,
PandSCode = pids.PandS_Code,
PandSName = pids.PandS_Name,
SIQty = pids.SI_Qty,
Price = pids.SI_Price,
SIDiscount = pids.SI_Discount,
SIAmount = pids.SI_Amount,
GSTRate = pids.GST_Rate
}).ToList <SalesInvoiceDetailEntity>();
if (pid != null)
{
pif.InvoiceDetails = pid;
}
return(pif);
}
}
catch (Exception ex)
{
throw ex;
}
}
