private void GetListData()
{
IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();
var cashBankAcnts = rmRepository.GetAccountDetails().Where(t => t.AccountType == Convert.ToByte(Account_Type.Cash) ||
t.AccountType == Convert.ToByte(Account_Type.Bank) || t.AccountType == Convert.ToByte(Account_Type.CreditCard)).ToList();
if (cashBankAcnts != null)
{
TransferFromCashAndBankAccountsLst = cashBankAcnts.ToList();
TransferTocashAndBankAccountsLst = cashBankAcnts.ToList();
}
var taxes = purchaseRepository.GetDefaultTaxes().ToList();
if (taxes != null)
{
LstTaxes = taxes.ToList();
}
TaxModel objDefaultTax = new TaxModel();
objDefaultTax = purchaseRepository.GetDefaultTaxes().FirstOrDefault();
if (objDefaultTax != null)
{
TaxName = objDefaultTax.TaxName;
}
}
public void LoadSearchResult(string Suppliername)
{
IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();
this.ShowAllCount = purchaseRepository.GetAllPurOrder().Count();
this.PurchaseOrderList = purchaseRepository.GetAllPurOrder().Where(x => x.SupplierName == Suppliername).ToList();
}
private void RefreshData()
{
IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();
this.DateFormat = purchaseRepository.GetDateFormat();
this.ShowAllCount = purchaseRepository.GetAllPurOrder().Count();
GetOptionsandTaxValues();
this.JsonData = purchaseRepository.GetLastSelectionData(Convert.ToInt32(ScreenId.PurchaseOrderList));
this.PurchaseOrderList = purchaseRepository.GetAllPurOrderJson(this.JsonData, this.IncludingGSTTrue).OrderBy(e => e.SupplierName).ToList();
this.ShowSelectedCount = this.PurchaseOrderList.Count();
this.PurchaseOrderListcmb = purchaseRepository.GetAllPurOrder().OrderBy(e => e.SupplierName).ToList();
this.YearRange = purchaseRepository.GetYearRange().ToList();
//changedateformat(this.PurchaseOrderList);
changeNumberformat(this.PurchaseOrderList);
changeNumberformat(this.PurchaseOrderListcmb);
DefaultList = this.PurchaseOrderListcmb;
FullPQList = this.PurchaseOrderListcmb;
this.PurchaseOrderListcmbSup = this.PurchaseOrderList.GroupBy(x => x.SupplierName).Select(y => y.First()).OrderBy(x => x.SupplierName).Distinct().ToList();
this.PurchaseOrderListcmbONo = this.PurchaseOrderList.GroupBy(x => x.OrderNo).Select(y => y.First()).OrderBy(x => x.SortOrderNo).Distinct().ToList();
//this.ShowAllCount = this.PurchaseOrderListcmb.Count();
SetDefaultSearchSelection(this.JsonData);
var Updateddate = this.PurchaseOrderListcmb.Max(x => x.CreatedDateList);
string date = this.DateFormat as string;
this.LastUpdateDate = Convert.ToDateTime(Updateddate).ToString(date);
TotalAmount = Convert.ToString(PurchaseOrderList.Sum(e => e.OAmount));
DepositTotal = Convert.ToString(PurchaseOrderList.Sum(e => e.DAmount));
//this.GetData(this.SelectedSearchSupplier);
}
void GetOptionsandTaxValues()
{
OptionsEntity oData = new OptionsEntity();
IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
if (oData != null)
{
CurrencyName = oData.CurrencyCode;
DateFormat = oData.DateFormat;
}
TaxModel objDefaultTax = new TaxModel();
objDefaultTax = purchaseRepository.GetDefaultTaxes().FirstOrDefault();
}
void GetOptionsandTaxValues()
{
OptionsEntity oData = new OptionsEntity();
IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
if (oData != null)
{
CurrencyName = oData.CurrencyCode;
DateFormat = oData.DateFormat;
if (!string.IsNullOrWhiteSpace(oData.DefCashBankAcc))
{
this.SelectedCashBankAcntID = Convert.ToInt32(oData.DefCashBankAcc);
CheckAccountDetails(null);
}
}
}
void GetOptionsandTaxValues()
{
OptionsEntity oData = new OptionsEntity();
IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();
oData = purchaseRepository.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 = purchaseRepository.GetDefaultTaxes().FirstOrDefault();
}
void showexcGST(object param)
{
Mouse.OverrideCursor = Cursors.Wait;
int decimalpoints = Convert.ToInt32(this.DecimalPlaces);
IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();
this.PurchaseOrderList = purchaseRepository.GetAllPurOrderJson(this.JsonData, this.IncludingGSTTrue).ToList();
if (this.ShowAllTrue == false)
{
this.ShowSelectedCount = this.PurchaseOrderList.Count();
}
else
{
this.ShowSelectedCount = 0;
}
this.PurchaseOrderListcmb = this.PurchaseOrderList;
this.PurchaseOrderListcmbSup = this.PurchaseOrderList.GroupBy(x => x.SupplierName).Select(y => y.First()).OrderBy(x => x.SupplierName).Distinct().ToList();
this.PurchaseOrderListcmbONo = this.PurchaseOrderList.GroupBy(x => x.OrderNo).Select(y => y.First()).OrderBy(x => x.SortOrderNo).Distinct().ToList();
DefaultList = this.PurchaseOrderListcmb;
//changedateformat(this.PurchaseOrderList);
//changeNumberformat(this.PurchaseOrderList);
Mouse.OverrideCursor = null;
}
private void GetListData()
{
IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();
//var linkedAcnts = rmRepository.GetAccountDetails().Where(t => t.AccountType == Convert.ToByte(Account_Type.CurrentLiabilities) || t.AccountType == Convert.ToByte(Account_Type.LongTermLiabilities)).ToList();
var linkedAcnts = rmRepository.GetAccountDetails().Where(t => t.AccountType == Convert.ToByte(Account_TypeCode.UserCreatedLiabilities) ||
t.AccountType == Convert.ToByte(Account_TypeCode.NetGst)).ToList();
if (linkedAcnts != null)
{
foreach (var item in linkedAcnts)
{
if (item.AccountName == "Net GST/VAT")
{
item.IsLinked = false;
}
}
//LinkedAccountsLst = (from a in linkedAcnts
// select new AccountsEntity
// {
// AccountID=a.AccountID,
// AccountType=a.AccountType,
// AccountName= a.AccountType + " : " + a.AccountName,
// AccuntTypeCode=a.AccuntTypeCode,
// IsInactive=a.IsInactive,
// }).ToList();
LinkedAccountsLst = linkedAcnts.ToList();
}
var cashBankAcnts = rmRepository.GetAccountDetails().Where(t => t.AccountType == Convert.ToByte(Account_Type.Cash) ||
t.AccountType == Convert.ToByte(Account_Type.Bank) || t.AccountType == Convert.ToByte(Account_Type.CreditCard)).ToList();
if (cashBankAcnts != null)
{
CashAndBankAccountsLst = cashBankAcnts.ToList();
}
var taxes = purchaseRepository.GetDefaultTaxes().ToList();
if (taxes != null)
{
LstTaxes = taxes.ToList();
var tax = taxes.FirstOrDefault();
if (tax != null)
{
TaxName = tax.TaxName;
}
else
{
TaxName = "GST";
}
TaxModel objDefaultTax = new TaxModel();
objDefaultTax = taxes.Where(e => e.IsDefault == true).FirstOrDefault();
if (objDefaultTax != null)
{
SelectedTaxID = objDefaultTax.TaxID;
TaxRate = objDefaultTax.TaxRate;
}
else
{
SelectedTaxID = 0;
TaxRate = 0;
}
}
}
private void GetListData()
{
IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();
//var linkedAcnts = rmRepository.GetAccountDetails().Where(t => t.AccountType == Convert.ToByte(Account_Type.Income)
// || t.AccountType == Convert.ToByte(Account_Type.CurrentAssets) || t.AccountType == Convert.ToByte(Account_Type.FixedAssets)
// || t.AccountType == Convert.ToByte(Account_Type.CurrentLiabilities) || t.AccountType == Convert.ToByte(Account_Type.LongTermLiabilities)
// &&
// (t.AccountType != Convert.ToByte(Account_Type.Capital) || t.AccountType != Convert.ToByte(Account_Type.Costs) || t.AccountType != Convert.ToByte(Account_Type.Expenses)
// || t.AccountType != Convert.ToByte(Account_Type.Cash) || t.AccountType != Convert.ToByte(Account_Type.Bank))
// ).ToList();
var linkedAcnts = rmRepository.GetAccountDetails().Where(t => t.AccountType == Convert.ToByte(Account_TypeCode.NetGst) ||
t.AccountType == Convert.ToByte(Account_TypeCode.UserCreatedAsset) || t.AccountType == Convert.ToByte(Account_TypeCode.UserCreatedIncome)).ToList();
if (linkedAcnts != null)
{
foreach (var item in linkedAcnts)
{
if (item.AccountName == "Net GST/VAT")
{
item.IsLinked = false;
}
}
LinkedAccountsLst = linkedAcnts.ToList();
}
var cashBankAcnts = rmRepository.GetAccountDetails().Where(t => t.AccountType == Convert.ToByte(Account_Type.Cash) ||
t.AccountType == Convert.ToByte(Account_Type.Bank) || t.AccountType == Convert.ToByte(Account_Type.CreditCard)).ToList();
if (cashBankAcnts != null)
{
CashAndBankAccountsLst = cashBankAcnts.ToList();
}
var taxes = purchaseRepository.GetDefaultTaxes().ToList();
if (taxes != null)
{
LstTaxes = taxes.ToList();
var tax = taxes.FirstOrDefault();
if (tax != null)
{
TaxName = tax.TaxName;
}
else
{
TaxName = "GST";
}
TaxModel objDefaultTax = new TaxModel();
objDefaultTax = taxes.Where(e => e.IsDefault == true).FirstOrDefault();
if (objDefaultTax != null)
{
SelectedTaxID = objDefaultTax.TaxID;
TaxRate = objDefaultTax.TaxRate;
}
else
{
SelectedTaxID = 0;
TaxRate = 0;
}
}
}
void GetOptionsandTaxValues()
{
OptionsEntity oData = new OptionsEntity();
IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();
oData = purchaseRepository.GetOptionSettings();
if (oData != null)
{
this.CurrencyName = oData.CurrencyCode; //there is no currency name field in database
this.CurrencyCode = oData.CurrencyCode;
this.CurrencyFormat = oData.NumberFormat;
this.DateFormat = oData.DateFormat;
this.DecimalPlaces = oData.DecimalPlaces;
if (oData.ShowAmountIncGST == true)
{
this.IncludingGSTTrue = true;
this.IncludingGSTFalse = false;
//int decimalpoints = Convert.ToInt32(DecimalPlaces);
//foreach (var item in this.PurchaseOrderList)
//{
// item.OrderAmount = Math.Round(Convert.ToDouble(item.OrderAmount), decimalpoints).ToString();
//}
//this.PurchaseOrderList = this.PurchaseOrderList.Where(x => x.ExcIncGST == true).ToList();
}
else
{
this.IncludingGSTTrue = false;
this.IncludingGSTFalse = true;
int decimalpoints = Convert.ToInt32(DecimalPlaces);
//foreach (var item in this.PurchaseOrderList)
//{
// //item.OrderAmount = item.OrderAmountExcGST;
// //item.OrderAmount = Math.Round(Convert.ToDouble(item.OrderAmountExcGST), decimalpoints).ToString();
// item.OrderAmount = Math.Round(Convert.ToDouble(item.OrderAmount), decimalpoints).ToString();
//}
if (this.PurchaseOrderList != null)
{
this.PurchaseOrderList = this.PurchaseOrderList.Where(x => x.ExcIncGST == false).ToList();
}
}
}
else
{
this.CurrencyName = "USD";
this.CurrencyCode = "USD";
this.CurrencyFormat = "en-US";
this.DateFormat = "dd/MM/yyyy";
}
TaxModel objDefaultTax = new TaxModel();
objDefaultTax = purchaseRepository.GetDefaultTaxes().FirstOrDefault();
if (objDefaultTax != null)
{
this.TaxName = objDefaultTax.TaxName;
//this.TaxName = objDefaultTax.TaxRate;
}
else
{
this.TaxName = "GST Free";
//this.TaxRate = 0;
}
}
void Search(object param)
{
if (Count != 0)
{
SearchValues = new List <SearchEntity>();
//this.ShowSelectedTrue = true;
//this.ShowAllTrue = false;
if (this.SelectedSearchYear != null || this.SelectedSearchYear == string.Empty)
{
SearchEntity value = new SearchEntity();
value.FieldName = "Year";
value.FieldValue = this.SelectedSearchYear;
SearchValues.Add(value);
var year = Convert.ToInt32(this.SelectedSearchYear);
//DefaultList = FullPQList.Where(x => x.CreatedDate.Value.Year == year).ToList();
//if (this.IncludingGSTTrue == true)
// this.PurchaseOrderListInternal = DefaultList.Where(x => x.ExcIncGST == true).ToList();
//else
// this.PurchaseOrderListInternal = DefaultList.Where(x => x.ExcIncGST == false).ToList();
//this.PurchaseOrderListcmb = DefaultList;
}
if (this.SelectedSearchQuarter != null || this.SelectedSearchQuarter == string.Empty)
{
SearchEntity value = new SearchEntity();
value.FieldName = "Quarter";
value.FieldValue = this.SelectedSearchQuarter;
int month1;
int month2;
int month3;
if (Convert.ToInt32(this.SelectedSearchQuarter) == 1)
{
month1 = 1;
month2 = 2;
month3 = 3;
}
else if (Convert.ToInt32(this.SelectedSearchQuarter) == 2)
{
month1 = 4;
month2 = 5;
month3 = 6;
}
else if (Convert.ToInt32(this.SelectedSearchQuarter) == 3)
{
month1 = 7;
month2 = 8;
month3 = 9;
}
else
{
month1 = 10;
month2 = 11;
month3 = 12;
}
SearchValues.Add(value);
}
if (this.SelectedSearchMonth != null || this.SelectedSearchMonth == string.Empty)
{
SearchEntity value = new SearchEntity();
value.FieldName = "Month";
value.FieldValue = this.SelectedSearchMonth;
SearchValues.Add(value);
var month = Convert.ToInt32(this.SelectedSearchMonth);
}
if (this.SelectedSearchStartDate != null && this.SelectedSearchEndDate != null)
{
SearchEntity value = new SearchEntity();
value.FieldName = "StartDate";
//value.FieldValue = this.SelectedSearchStartDate.ToString();
value.FieldValue = string.Format("{0:MMM/dd/yyyy}", this.SelectedSearchStartDate);
SearchValues.Add(value);
//string[] value = new string[2];
SearchEntity value1 = new SearchEntity();
value1.FieldName = "EndDate";
//value1.FieldValue = this.SelectedSearchEndDate.ToString();
value1.FieldValue = string.Format("{0:MMM/dd/yyyy}", this.SelectedSearchEndDate);
SearchValues.Add(value);
SearchValues.Add(value1);
}
jsonSearch = JsonConvert.SerializeObject(SearchValues);
this.JsonData = jsonSearch;
IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();
var results = purchaseRepository.SaveSearchJson(jsonSearch, Convert.ToInt32(ScreenId.PurchaseOrderList), "Purhcase_Order_List");
if (Count != 0)
{
this.PurchaseOrderList = purchaseRepository.GetAllPurOrderJson(jsonSearch, this.IncludingGSTTrue);
//changedateformat(this.PurchaseOrderList);
changeNumberformat(this.PurchaseOrderList);
}
this.PurchaseOrderListcmb = this.PurchaseOrderList.OrderBy(e => e.SupplierName).ToList();
this.PurchaseOrderListcmbSup = this.PurchaseOrderList.GroupBy(x => x.SupplierName).Select(y => y.First()).OrderBy(x => x.SupplierName).Distinct().ToList();
this.PurchaseOrderListcmbONo = this.PurchaseOrderList.GroupBy(x => x.OrderNo).Select(y => y.First()).OrderBy(x => x.SortOrderNo).Distinct().ToList();
if (this.ShowAllTrue == true)
{
this.ShowSelectedCount = 0;
}
else
{
this.ShowSelectedCount = this.PurchaseOrderList.Count();
}
DefaultList = this.PurchaseOrderListcmb;
TotalAmount = Convert.ToString(PurchaseOrderList.Sum(e => e.OAmount));
DepositTotal = Convert.ToString(PurchaseOrderList.Sum(e => e.DAmount));
}
}
