public string GetDateFormat()
        {
            ISupplierHistoryDAL purInvoice = new SupplierHistoryDAL();
            var result = purInvoice.GetDateFormat();

            return(result);
        }
        public bool SaveSearchJson(string jsonSearch, int ScreenId, string ScreenName)
        {
            ISupplierHistoryDAL purInvoice = new SupplierHistoryDAL();
            var result = purInvoice.SaveSearchJson(jsonSearch, ScreenId, ScreenName);

            return(result);
        }
        public string GetLastSelectionData(int ScreenId)
        {
            ISupplierHistoryDAL purInvoice = new SupplierHistoryDAL();
            var result = purInvoice.GetLastSelectionData(ScreenId);

            return(result);
        }
        public List <SupplierHistoryEntity> GetAllSalesInvoice()
        {
            ISupplierHistoryDAL purInvoice = new SupplierHistoryDAL();
            var Invoicelist = purInvoice.GetAllSalesInvoice();

            foreach (var item in Invoicelist)
            {
                if (item.InvoiceDateDateTime != null)
                {
                    item.InvoiceDate = item.InvoiceDateDateTime.ToString();
                }
                if (item.CashChequeNo != null && item.CashChequeNo != "")
                {
                    item.CreditCashNO = item.CashChequeNo;
                    if (item.CashChequeDateDate != null && item.CashChequeDateDate.Value.Year > 2000)
                    {
                        item.CreditCashDate = item.CashChequeDateDate.ToString();
                    }
                    else
                    {
                        item.CreditCashDate = null;
                    }
                    item.CreditCashAmount = item.CashChequeAmount.ToString();
                    item.TotalAmount      = item.CashChequeAmount;
                }

                else
                {
                    item.CreditCashNO = item.CreditNoteNo;
                    if (item.CreditNoteDateDate != null && item.CreditNoteDateDate.Value.Year > 2000)
                    {
                        item.CreditCashDate = item.CreditNoteDateDate.ToString();
                    }
                    else
                    {
                        item.CreditCashDate = null;
                    }
                    item.CreditCashAmount = item.CreditNoteAmount.ToString();
                    item.TotalAmount      = item.CreditNoteAmount;
                }
                switch (item.Status)
                {
                case 0:
                    item.StatusString = "All";
                    break;

                case 1:
                    item.StatusString = "Paid";
                    break;

                case 2:
                    item.StatusString = "UnPaid";
                    break;

                case 3:
                    item.StatusString = "Adjusted";
                    break;

                case 4:
                    item.StatusString = "Cancelled";
                    break;

                default:
                    item.StatusString = "All";
                    break;
                }


                if (item.CreditNoteNo != null && item.CreditNoteNo != "")
                {
                    item.CashCreditNo = item.CreditNoteNo;
                }
                else if (item.CashChequeNo != null && item.CashChequeNo != "")
                {
                    item.CashCreditNo = item.CashChequeNo;
                }
                else
                {
                    item.CashCreditNo = null;
                }
                item.InvoiceAmount = item.InvoiceAmountValue.ToString();
            }
            return(Invoicelist);
        }