public UndeliveredPurchaseOrdersDepositsModel GetDataIntoModel()
        {
            UndeliveredPurchaseOrdersDepositsModel JForm = new UndeliveredPurchaseOrdersDepositsModel();

            JForm.UndeliveredPurchaseOrdersDepositsDetailsData = new List <UndeliveredPurchaseOrdersDepositsEntity>();
            //UnpaidSalesInvoiceEntity model = new UnpaidSalesInvoiceEntity();

            //JForm.UnpaidSalesInvoiceData = model;

            foreach (var item in UndeliveredPurchaseOrdersDepositsDetailsEntity)
            {
                if (item.ID != null)
                {
                    UndeliveredPurchaseOrdersDepositsEntity jEntity = new UndeliveredPurchaseOrdersDepositsEntity();
                    jEntity.ID                = item.ID;
                    jEntity.SupplierName      = item.SupplierName;
                    jEntity.OrderNo           = "OPO-" + item.OrderNo;
                    jEntity.UndeliveredAmount = item.UndeliveredAmount;
                    jEntity.DepositAmount     = item.DepositAmount;
                    jEntity.OrderDate         = item.OrderDate;
                    jEntity.OrderDateTime     = DateTime.ParseExact(item.OrderDate, DateFormat, null);
                    if (item.ID != 0 && Convert.ToInt32(item.ID) > 0)
                    {
                        JForm.UndeliveredPurchaseOrdersDepositsDetailsData.Add(jEntity);
                    }
                }
            }

            return(JForm);
        }
コード例 #2
0
        public int SaveUndeliveredPurchaseOrdersDepositsData(UndeliveredPurchaseOrdersDepositsModel JForm)
        {
            //int autoId = 0;
            // UnpaidSalesInvoice obj = new UnpaidSalesInvoice();
            try
            {
                using (SASEntitiesEDM entities = new SASEntitiesEDM())
                {
                    UndeliveredPurchaseOrdersWithDeposit obj1;
                    if (JForm.UndeliveredPurchaseOrdersDepositsDetailsData != null)
                    {
                        foreach (UndeliveredPurchaseOrdersDepositsEntity JEntity in JForm.UndeliveredPurchaseOrdersDepositsDetailsData)
                        {
                            //save entity value
                            obj1      = new UndeliveredPurchaseOrdersWithDeposit();
                            obj1.S_ID = JEntity.ID;
                            obj1.UPurchaseOrder_No            = JEntity.OrderNo;
                            obj1.UPurchaseOrder_Date          = JEntity.OrderDateTime;
                            obj1.UPurchaseOrder_Amount        = JEntity.UndeliveredAmount;
                            obj1.UPurchaseOrderDeposit_Amount = JEntity.DepositAmount;
                            obj1.CreatedDate = DateTime.Now;
                            obj1.IsDeleted   = false;
                            if (obj1 != null)
                            {
                                entities.UndeliveredPurchaseOrdersWithDeposits.Add(obj1);
                                entities.SaveChanges();
                            }
                            //if (entities.UndeliveredPurchaseOrdersWithDeposits.AsNoTracking().FirstOrDefault(x => x.ID == JEntity.ID) == null)
                            //{
                            //    entities.UndeliveredPurchaseOrdersWithDeposits.Add(obj1);
                            //    entities.SaveChanges();

                            //}
                            //else
                            //{
                            //    entities.Entry(obj1).State = EntityState.Modified;
                            //    entities.SaveChanges();
                            //}
                        }
                    }

                    else
                    {
                    }
                }
                return(1);
            }
            catch (Exception e)
            {
                return(0);

                throw e;
            }
        }
        public string ValidateJournal()
        {
            string msg = string.Empty;
            UndeliveredPurchaseOrdersDepositsModel JForm = GetDataIntoModel();
            //var tempInvoiceNumber = UndeliveredPurchaseRepository.IsChequeNoPresent();
            //string result = JForm.UndeliveredPurchaseOrdersDepositsDetailsData.Where(x => x.OrderNo == tempInvoiceNumber).Select(x => x.OrderNo).FirstOrDefault();
            //if (result != null)
            //{
            //    msg = "Entry against Cheque No is already done";
            //}


            //return msg;
            List <string> ListInvoiceNumber = UndeliveredPurchaseRepository.IsChequeNoPresent();
            List <string> InsideList        = JForm.UndeliveredPurchaseOrdersDepositsDetailsData.Select(x => x.OrderNo).ToList();
            List <string> PINumberList      = InsideList.Distinct().ToList();

            foreach (var item in JForm.UndeliveredPurchaseOrdersDepositsDetailsData)
            {
                if (InsideList.Count != PINumberList.Count)
                {
                    msg = "Two Invoice Number Should Not Be Same";
                    //this.CASErrors =msg;
                    break;
                }
                if (ListInvoiceNumber == null)
                {
                    msg = "No Entry is done till Now";
                    //this.CASErrors=msg;
                    break;
                }
                if (ListInvoiceNumber.Contains(item.OrderNo))
                {
                    msg = "Entry against Cheque No is already done ";
                    // this.CASErrors = msg;
                    break;
                }
            }

            return(msg);
        }
        public void SaveUndeliveredPurchase(object param)
        {
            MessageBoxResult result = System.Windows.MessageBox.Show("Do you want to save changes?", "Save Confirmation", MessageBoxButton.YesNo);

            if (result == MessageBoxResult.Yes)
            {
                Mouse.OverrideCursor = System.Windows.Input.Cursors.Wait;


                string msg = ValidateJournal();
                if (msg != string.Empty && msg != "No Entry is done till Now")
                {
                    CASErrors            = msg;
                    Mouse.OverrideCursor = null;
                    return;
                }

                CASErrors = string.Empty;
                UndeliveredPurchaseOrdersDepositsModel JForm = GetDataIntoModel();
                UndeliveredPurchaseRepository.SaveUndeliveredPurchaseOrdersDepositsData(JForm);
                Mouse.OverrideCursor = null;
            }
        }
        public int SaveUndeliveredPurchaseOrdersDepositsData(UndeliveredPurchaseOrdersDepositsModel JForm)
        {
            IUndeliveredPurchaseOrdersDepositsBL obj = new UndeliveredPurchaseOrdersDepositsBL();

            return(obj.SaveUndeliveredPurchaseOrdersDepositsData(JForm));
        }