Example #1
0
        public void UpdateInitialInventory(St_Header ObjUpdate)
        {
            var ObjToUpdate = _context.St_Headers.SingleOrDefault(m => m.CompanyID == ObjUpdate.CompanyID && m.TransactionKindNo == 517);

            if (ObjToUpdate != null)
            {
                ObjToUpdate.DueDate     = ObjUpdate.DueDate;
                ObjToUpdate.InsDateTime = ObjUpdate.InsDateTime;
                ObjToUpdate.InsUserID   = ObjUpdate.InsUserID;
            }
        }
Example #2
0
        public void DeleteHeader(St_Header ObjToDelete)
        {
            var ObjDelete = _context.St_Headers.FirstOrDefault(m => m.CompanyID == ObjToDelete.CompanyID &&
                                                               m.CompanyTransactionKindNo == ObjToDelete.CompanyTransactionKindNo && m.StockCode == ObjToDelete.StockCode &&
                                                               m.VoucherNumber == ObjToDelete.VoucherNumber && m.CompanyYear == ObjToDelete.CompanyYear);

            if (ObjDelete != null)
            {
                _context.St_Headers.Remove(ObjDelete);
            }
        }
Example #3
0
        private IHeader ReadHeader(BinaryReader br)
        {
            St_Header header = new St_Header();

            if (!header.Read(br))
            {
                string errorMessage = "Failed to read header of file {0}. Corrupt or invalid header?";
                MessageBox.Show(errorMessage, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                Environment.Exit(1);
            }
            return(header);
        }
Example #4
0
 public void UpdateToExportAndUnExport(St_Header ObjToUpdate)
 {
     if (ObjToUpdate.TransactionKindNo == 507)
     {
         var ObjUpdate = _context.St_Headers.FirstOrDefault(m => m.CompanyID == ObjToUpdate.CompanyID &&
                                                            m.CompanyTransactionKindNo == ObjToUpdate.CompanyTransactionKindNo && m.TransactionKindNo == ObjToUpdate.TransactionKindNo &&
                                                            m.VoucherNumber == ObjToUpdate.VoucherNumber && m.CompanyYear == ObjToUpdate.CompanyYear);
         if (ObjUpdate != null)
         {
             ObjUpdate.Exported = ObjToUpdate.Exported;
         }
     }
     else
     {
         var ObjUpdate = _context.St_Headers.FirstOrDefault(m => m.CompanyID == ObjToUpdate.CompanyID &&
                                                            m.CompanyTransactionKindNo == ObjToUpdate.CompanyTransactionKindNo && m.TransactionKindNo == ObjToUpdate.TransactionKindNo &&
                                                            m.VoucherNumber == ObjToUpdate.VoucherNumber && m.CompanyYear == ObjToUpdate.CompanyYear && m.StockCode == ObjToUpdate.StockCode);
         if (ObjUpdate != null)
         {
             ObjUpdate.Exported = ObjToUpdate.Exported;
         }
     }
 }
        public JsonResult SaveInitialInventory(St_ItemCardVM ObjSave)
        {
            MsgUnit Msg = new MsgUnit();

            try
            {
                var userId   = User.Identity.GetUserId();
                var UserInfo = _unitOfWork.User.GetMyInfo(userId);
                int year     = (DateTime.Now.Year) - 1;
                var CheckIfInitialInventoryExsitInHeader = _unitOfWork.St_Header.CheckIfInitialInventoryExsitInHeader(UserInfo.fCompanyId);
                if (CheckIfInitialInventoryExsitInHeader == null)
                {
                    var ObjSaveSt_Header = new St_Header();
                    ObjSaveSt_Header.CompanyID   = UserInfo.fCompanyId;
                    ObjSaveSt_Header.CompanyYear = UserInfo.CurrYear;
                    ObjSaveSt_Header.CompanyTransactionKindNo = 1;
                    ObjSaveSt_Header.TransactionKindNo        = 517;
                    ObjSaveSt_Header.StockCode     = "*";
                    ObjSaveSt_Header.VoucherNumber = "0";
                    ObjSaveSt_Header.VHI           = 0;
                    ObjSaveSt_Header.VoucherDate   = new DateTime(year, 12, 31);
                    ObjSaveSt_Header.AccountNumber = "";
                    ObjSaveSt_Header.SaleID        = 0;
                    ObjSaveSt_Header.NetTotalLocalBeforDiscount                       = 0;
                    ObjSaveSt_Header.NetTotalForeignBeforDiscount                     = 0;
                    ObjSaveSt_Header.NetTotalLineDiscountLocal                        = 0;
                    ObjSaveSt_Header.NetTotalLineDiscountForeign                      = 0;
                    ObjSaveSt_Header.NetTotalLocalAfterLineDiscount                   = 0;
                    ObjSaveSt_Header.NetTotalForeignAfterLineDiscount                 = 0;
                    ObjSaveSt_Header.NetTotalTaxAfterLineDiscountLocal                = 0;
                    ObjSaveSt_Header.NetTotalTaxAfterLineDiscounForeign               = 0;
                    ObjSaveSt_Header.NetTotalAfterLineDiscountBeforDiscountAllLocal   = 0;
                    ObjSaveSt_Header.NetTotalAfterLineDiscountBeforDiscountAllForeign = 0;
                    ObjSaveSt_Header.NetTotalDiscountLocal        = 0;
                    ObjSaveSt_Header.NetTotalDiscountForeign      = 0;
                    ObjSaveSt_Header.DiscountPercentage           = 0;
                    ObjSaveSt_Header.NetTotalLocalAfterDiscount   = 0;
                    ObjSaveSt_Header.NetTotalForeignAfterDiscount = 0;
                    ObjSaveSt_Header.TaxType            = 3;
                    ObjSaveSt_Header.NetTotalTaxLocal   = 0;
                    ObjSaveSt_Header.NetTotalTaxForeign = 0;
                    ObjSaveSt_Header.NetTotalLocal      = 0;
                    ObjSaveSt_Header.NetTotalForeign    = 0;
                    if (Resources.Resource.CurLang == "Arb")
                    {
                        ObjSaveSt_Header.Remark = "جرد اولي";
                        ObjSaveSt_Header.Hint   = "جرد اولي";
                    }
                    else
                    {
                        ObjSaveSt_Header.Remark = "Initial Inventory";
                        ObjSaveSt_Header.Hint   = "Initial Inventory";
                    }
                    ObjSaveSt_Header.Exported         = 0;
                    ObjSaveSt_Header.CurrencyID       = 1;
                    ObjSaveSt_Header.ConversionFactor = 1;
                    ObjSaveSt_Header.ConversionFactorAfterExpenses = 0;
                    ObjSaveSt_Header.VoucherCase                = 0;
                    ObjSaveSt_Header.CashLocal                  = 0;
                    ObjSaveSt_Header.CreditCardType1            = 0;
                    ObjSaveSt_Header.CreditCardLocal1           = 0;
                    ObjSaveSt_Header.CreditCardType2            = 0;
                    ObjSaveSt_Header.CreditCardLocal2           = 0;
                    ObjSaveSt_Header.ChequeLocal                = 0;
                    ObjSaveSt_Header.CreditLocal                = 0;
                    ObjSaveSt_Header.CashForeign                = 0;
                    ObjSaveSt_Header.CreditCardForeign1         = 0;
                    ObjSaveSt_Header.CreditCardForeign2         = 0;
                    ObjSaveSt_Header.ChequeForeign              = 0;
                    ObjSaveSt_Header.CreditForeign              = 0;
                    ObjSaveSt_Header.DueDate                    = DateTime.Now;
                    ObjSaveSt_Header.OfferNumber                = "";
                    ObjSaveSt_Header.OrderNumber                = "";
                    ObjSaveSt_Header.LocalCost                  = 0;
                    ObjSaveSt_Header.ForeignCost                = 0;
                    ObjSaveSt_Header.DriverID                   = 0;
                    ObjSaveSt_Header.OriginalVoucherNumber      = "0";
                    ObjSaveSt_Header.ShippingValueLocal         = 0;
                    ObjSaveSt_Header.ShippingValueForeign       = 0;
                    ObjSaveSt_Header.ShippingAccountNumber      = "";
                    ObjSaveSt_Header.ShippingCostCenter         = "";
                    ObjSaveSt_Header.OtherExpensesValueLocal    = 0;
                    ObjSaveSt_Header.OtherExpensesValueForeign  = 0;
                    ObjSaveSt_Header.OtherExpensesAccountNumber = "";
                    ObjSaveSt_Header.OtherExpensesCostCenter    = "";
                    ObjSaveSt_Header.NetTotalOfGoodsLocal       = 0;
                    ObjSaveSt_Header.NetTotalOfGoodsForeign     = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal1        = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal2        = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal3        = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal4        = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal5        = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal6        = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal7        = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal8        = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal9        = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal10       = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal11       = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal12       = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal13       = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal14       = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal15       = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal16       = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal17       = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal18       = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal19       = 0;
                    ObjSaveSt_Header.ExtraExpensesLocal20       = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign1      = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign2      = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign3      = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign4      = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign5      = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign6      = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign7      = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign8      = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign9      = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign10     = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign11     = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign12     = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign13     = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign14     = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign15     = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign16     = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign17     = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign18     = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign19     = 0;
                    ObjSaveSt_Header.ExtraExpensesForeign20     = 0;
                    ObjSaveSt_Header.InsDateTime                = DateTime.Now;
                    ObjSaveSt_Header.InsUserID                  = userId;
                    ObjSaveSt_Header.RowCount                   = _unitOfWork.St_Header.GetMaxRowNumberInitialInventory(UserInfo.fCompanyId);
                    var ObjSaveSt_Transaction = new St_Transaction();
                    ObjSaveSt_Transaction.CompanyID   = ObjSaveSt_Header.CompanyID;
                    ObjSaveSt_Transaction.CompanyYear = ObjSaveSt_Header.CompanyYear;
                    ObjSaveSt_Transaction.CompanyTransactionKindNo = ObjSaveSt_Header.CompanyTransactionKindNo;
                    ObjSaveSt_Transaction.TransactionKindNo        = ObjSaveSt_Header.TransactionKindNo;
                    ObjSaveSt_Transaction.StockCode                                     = ObjSave.StockCode;
                    ObjSaveSt_Transaction.VoucherNumber                                 = ObjSaveSt_Header.VoucherNumber;
                    ObjSaveSt_Transaction.RowNumber                                     = _unitOfWork.St_Header.GetMaxRowNumberInitialInventory(UserInfo.fCompanyId);
                    ObjSaveSt_Transaction.IsDeleted                                     = 0;
                    ObjSaveSt_Transaction.VHI                                           = ObjSaveSt_Header.VHI;
                    ObjSaveSt_Transaction.VoucherDate                                   = ObjSaveSt_Header.VoucherDate;
                    ObjSaveSt_Transaction.ItemCode                                      = ObjSave.UpdateItemCode;
                    ObjSaveSt_Transaction.SimilarItemCode                               = ObjSave.UpdateItemCode;
                    ObjSaveSt_Transaction.Quantity                                      = ObjSave.Quantity;
                    ObjSaveSt_Transaction.Bonus                                         = 0;
                    ObjSaveSt_Transaction.QuantityInputOutput                           = ObjSave.Quantity;
                    ObjSaveSt_Transaction.BonusInputOutput                              = 0;
                    ObjSaveSt_Transaction.TotalLocalBeforDiscount                       = (ObjSave.Quantity * ObjSave.CostRate);
                    ObjSaveSt_Transaction.TotalForeignBeforDiscount                     = 0;
                    ObjSaveSt_Transaction.TotalLineDiscountLocal                        = 0;
                    ObjSaveSt_Transaction.TotalLineDiscountForeign                      = 0;
                    ObjSaveSt_Transaction.TotalLocalAfterLineDiscount                   = 0;
                    ObjSaveSt_Transaction.TotalForeignAfterLineDiscount                 = 0;
                    ObjSaveSt_Transaction.LineDiscountPercentage                        = 0;
                    ObjSaveSt_Transaction.TotalTaxAfterLineDiscountLocal                = 0;
                    ObjSaveSt_Transaction.TotalTaxAfterLineDiscounForeign               = 0;
                    ObjSaveSt_Transaction.TotalAfterLineDiscountBeforDiscountAllLocal   = 0;
                    ObjSaveSt_Transaction.TotalAfterLineDiscountBeforDiscountAllForeign = 0;
                    ObjSaveSt_Transaction.TotalDiscountLocal                            = 0;
                    ObjSaveSt_Transaction.TotalDiscountForeign                          = 0;
                    ObjSaveSt_Transaction.DiscountPercentage                            = 0;
                    ObjSaveSt_Transaction.TotalLocalAfterDiscount                       = (ObjSave.Quantity * ObjSave.CostRate);
                    ObjSaveSt_Transaction.TotalForeignAfterDiscount                     = 0;
                    ObjSaveSt_Transaction.TaxRate                                       = 0;
                    ObjSaveSt_Transaction.TaxType                                       = 0;
                    ObjSaveSt_Transaction.TotalTaxLocal                                 = 0;
                    ObjSaveSt_Transaction.TotalTaxForeign                               = 0;
                    ObjSaveSt_Transaction.TotalLocal                                    = (ObjSave.Quantity * ObjSave.CostRate);
                    ObjSaveSt_Transaction.TotalForeign                                  = 0;
                    ObjSaveSt_Transaction.TotalCostLocal                                = (ObjSave.Quantity * ObjSave.CostRate);
                    ObjSaveSt_Transaction.TotalCostForeign                              = 0;
                    if (ObjSave.Quantity <= 0)
                    {
                        ObjSaveSt_Transaction.PricePieceLocalBeforDiscount = 0;
                    }
                    else
                    {
                        ObjSaveSt_Transaction.PricePieceLocalBeforDiscount = ObjSave.CostRate;
                    }
                    ObjSaveSt_Transaction.PricePieceForeignBeforDiscount                     = 0;
                    ObjSaveSt_Transaction.PricePieceLineDiscountLocal                        = 0;
                    ObjSaveSt_Transaction.PricePieceLineDiscountForeign                      = 0;
                    ObjSaveSt_Transaction.PricePieceLocalAfterLineDiscount                   = 0;
                    ObjSaveSt_Transaction.PricePieceForeignAfterLineDiscount                 = 0;
                    ObjSaveSt_Transaction.PricePieceTaxAfterLineDiscountLocal                = 0;
                    ObjSaveSt_Transaction.PricePieceTaxAfterLineDiscounForeign               = 0;
                    ObjSaveSt_Transaction.PricePieceAfterLineDiscountBeforDiscountAllLocal   = 0;
                    ObjSaveSt_Transaction.PricePieceAfterLineDiscountBeforDiscountAllForeign = 0;
                    ObjSaveSt_Transaction.PricePieceDiscountLocal   = 0;
                    ObjSaveSt_Transaction.PricePieceDiscountForeign = 0;
                    if (ObjSave.Quantity <= 0)
                    {
                        ObjSaveSt_Transaction.PricePieceLocalAfterDiscount = 0;
                    }
                    else
                    {
                        ObjSaveSt_Transaction.PricePieceLocalAfterDiscount = ObjSave.CostRate;
                    }
                    ObjSaveSt_Transaction.PricePieceForeignAfterDiscount = 0;
                    ObjSaveSt_Transaction.PricePieceTaxLocal             = 0;
                    ObjSaveSt_Transaction.PricePieceTaxForeign           = 0;
                    if (ObjSave.Quantity <= 0)
                    {
                        ObjSaveSt_Transaction.PricePieceTotalLocal = 0;
                    }
                    else
                    {
                        ObjSaveSt_Transaction.PricePieceTotalLocal = ObjSave.CostRate;
                    }
                    ObjSaveSt_Transaction.PricePieceTotalForeign = 0;
                    if (ObjSave.Quantity <= 0)
                    {
                        ObjSaveSt_Transaction.CostPieceLocal = 0;
                    }
                    else
                    {
                        ObjSaveSt_Transaction.CostPieceLocal = ObjSave.CostRate;
                    }
                    ObjSaveSt_Transaction.CostPieceForeign = 0;
                    if (Resources.Resource.CurLang == "Arb")
                    {
                        ObjSaveSt_Transaction.Remark = "جرد اولي";
                        ObjSaveSt_Transaction.Hint   = "جرد اولي";
                    }
                    else
                    {
                        ObjSaveSt_Transaction.Remark = "Initial Inventory";
                        ObjSaveSt_Transaction.Hint   = "Initial Inventory";
                    }
                    ObjSaveSt_Transaction.ExpierDate  = DateTime.Now;
                    ObjSaveSt_Transaction.BatchNumber = "";
                    ObjSaveSt_Transaction.InsDateTime = DateTime.Now;
                    ObjSaveSt_Transaction.InsUserID   = userId;

                    if (!ModelState.IsValid)
                    {
                        string Err    = " ";
                        var    errors = ModelState.Values.SelectMany(v => v.Errors);
                        foreach (ModelError error in errors)
                        {
                            Err = Err + error.ErrorMessage + " * ";
                        }

                        Msg.Msg  = Resources.Resource.SomthingWentWrong + " : " + Err;
                        Msg.Code = 0;
                        return(Json(Msg, JsonRequestBehavior.AllowGet));
                    }
                    _unitOfWork.St_Header.AddHeader(ObjSaveSt_Header);
                    _unitOfWork.St_Header.AddTransaction(ObjSaveSt_Transaction);
                    _unitOfWork.Complete();
                }
                else
                {
                    var CheckIfInitialInventoryExsitInTransaction = _unitOfWork.St_Header.CheckIfInitialInventoryExsitInTransaction(UserInfo.fCompanyId, ObjSave.UpdateItemCode, ObjSave.StockCode);
                    if (CheckIfInitialInventoryExsitInTransaction == null)
                    {
                        var ObjUpdateSt_Header = new St_Header();
                        ObjUpdateSt_Header.CompanyID   = UserInfo.fCompanyId;
                        ObjUpdateSt_Header.RowCount    = _unitOfWork.St_Header.GetMaxRowNumberInitialInventory(UserInfo.fCompanyId);
                        ObjUpdateSt_Header.DueDate     = DateTime.Now;
                        ObjUpdateSt_Header.InsDateTime = DateTime.Now;
                        ObjUpdateSt_Header.InsUserID   = userId;
                        var ObjSaveSt_Transaction = new St_Transaction();
                        ObjSaveSt_Transaction.CompanyID   = UserInfo.fCompanyId;
                        ObjSaveSt_Transaction.CompanyYear = UserInfo.CurrYear;
                        ObjSaveSt_Transaction.CompanyTransactionKindNo = 1;
                        ObjSaveSt_Transaction.TransactionKindNo        = 517;
                        ObjSaveSt_Transaction.StockCode                                     = ObjSave.StockCode;
                        ObjSaveSt_Transaction.RowNumber                                     = _unitOfWork.St_Header.GetMaxRowNumberInitialInventory(UserInfo.fCompanyId);
                        ObjSaveSt_Transaction.IsDeleted                                     = 0;
                        ObjSaveSt_Transaction.VoucherNumber                                 = "0";
                        ObjSaveSt_Transaction.VHI                                           = 0;
                        ObjSaveSt_Transaction.VoucherDate                                   = new DateTime(year, 12, 31);
                        ObjSaveSt_Transaction.ItemCode                                      = ObjSave.UpdateItemCode;
                        ObjSaveSt_Transaction.SimilarItemCode                               = ObjSave.UpdateItemCode;
                        ObjSaveSt_Transaction.Quantity                                      = ObjSave.Quantity;
                        ObjSaveSt_Transaction.Bonus                                         = 0;
                        ObjSaveSt_Transaction.QuantityInputOutput                           = ObjSave.Quantity;
                        ObjSaveSt_Transaction.BonusInputOutput                              = 0;
                        ObjSaveSt_Transaction.TotalLocalBeforDiscount                       = (ObjSave.Quantity * ObjSave.CostRate);
                        ObjSaveSt_Transaction.TotalForeignBeforDiscount                     = 0;
                        ObjSaveSt_Transaction.TotalLineDiscountLocal                        = 0;
                        ObjSaveSt_Transaction.TotalLineDiscountForeign                      = 0;
                        ObjSaveSt_Transaction.TotalLocalAfterLineDiscount                   = 0;
                        ObjSaveSt_Transaction.TotalForeignAfterLineDiscount                 = 0;
                        ObjSaveSt_Transaction.LineDiscountPercentage                        = 0;
                        ObjSaveSt_Transaction.TotalTaxAfterLineDiscountLocal                = 0;
                        ObjSaveSt_Transaction.TotalTaxAfterLineDiscounForeign               = 0;
                        ObjSaveSt_Transaction.TotalAfterLineDiscountBeforDiscountAllLocal   = 0;
                        ObjSaveSt_Transaction.TotalAfterLineDiscountBeforDiscountAllForeign = 0;
                        ObjSaveSt_Transaction.TotalDiscountLocal                            = 0;
                        ObjSaveSt_Transaction.TotalDiscountForeign                          = 0;
                        ObjSaveSt_Transaction.DiscountPercentage                            = 0;
                        ObjSaveSt_Transaction.TotalLocalAfterDiscount                       = (ObjSave.Quantity * ObjSave.CostRate);
                        ObjSaveSt_Transaction.TotalForeignAfterDiscount                     = 0;
                        ObjSaveSt_Transaction.TaxRate                                       = 0;
                        ObjSaveSt_Transaction.TaxType                                       = 0;
                        ObjSaveSt_Transaction.TotalTaxLocal                                 = 0;
                        ObjSaveSt_Transaction.TotalTaxForeign                               = 0;
                        ObjSaveSt_Transaction.TotalLocal                                    = (ObjSave.Quantity * ObjSave.CostRate);
                        ObjSaveSt_Transaction.TotalForeign                                  = 0;
                        ObjSaveSt_Transaction.TotalCostLocal                                = (ObjSave.Quantity * ObjSave.CostRate);
                        ObjSaveSt_Transaction.TotalCostForeign                              = 0;
                        if (ObjSave.Quantity <= 0)
                        {
                            ObjSaveSt_Transaction.PricePieceLocalBeforDiscount = 0;
                        }
                        else
                        {
                            ObjSaveSt_Transaction.PricePieceLocalBeforDiscount = ObjSave.CostRate;
                        }
                        ObjSaveSt_Transaction.PricePieceForeignBeforDiscount                     = 0;
                        ObjSaveSt_Transaction.PricePieceLineDiscountLocal                        = 0;
                        ObjSaveSt_Transaction.PricePieceLineDiscountForeign                      = 0;
                        ObjSaveSt_Transaction.PricePieceLocalAfterLineDiscount                   = 0;
                        ObjSaveSt_Transaction.PricePieceForeignAfterLineDiscount                 = 0;
                        ObjSaveSt_Transaction.PricePieceTaxAfterLineDiscountLocal                = 0;
                        ObjSaveSt_Transaction.PricePieceTaxAfterLineDiscounForeign               = 0;
                        ObjSaveSt_Transaction.PricePieceAfterLineDiscountBeforDiscountAllLocal   = 0;
                        ObjSaveSt_Transaction.PricePieceAfterLineDiscountBeforDiscountAllForeign = 0;
                        ObjSaveSt_Transaction.PricePieceDiscountLocal   = 0;
                        ObjSaveSt_Transaction.PricePieceDiscountForeign = 0;
                        if (ObjSave.Quantity <= 0)
                        {
                            ObjSaveSt_Transaction.PricePieceLocalAfterDiscount = 0;
                        }
                        else
                        {
                            ObjSaveSt_Transaction.PricePieceLocalAfterDiscount = ObjSave.CostRate;
                        }
                        ObjSaveSt_Transaction.PricePieceForeignAfterDiscount = 0;
                        ObjSaveSt_Transaction.PricePieceTaxLocal             = 0;
                        ObjSaveSt_Transaction.PricePieceTaxForeign           = 0;
                        if (ObjSave.Quantity <= 0)
                        {
                            ObjSaveSt_Transaction.PricePieceTotalLocal = 0;
                        }
                        else
                        {
                            ObjSaveSt_Transaction.PricePieceTotalLocal = ObjSave.CostRate;
                        }
                        ObjSaveSt_Transaction.PricePieceTotalForeign = 0;
                        if (ObjSave.Quantity <= 0)
                        {
                            ObjSaveSt_Transaction.CostPieceLocal = 0;
                        }
                        else
                        {
                            ObjSaveSt_Transaction.CostPieceLocal = ObjSave.CostRate;
                        }
                        ObjSaveSt_Transaction.CostPieceForeign = 0;
                        if (Resources.Resource.CurLang == "Arb")
                        {
                            ObjSaveSt_Transaction.Remark = "جرد اولي";
                            ObjSaveSt_Transaction.Hint   = "جرد اولي";
                        }
                        else
                        {
                            ObjSaveSt_Transaction.Remark = "Initial Inventory";
                            ObjSaveSt_Transaction.Hint   = "Initial Inventory";
                        }
                        ObjSaveSt_Transaction.ExpierDate  = DateTime.Now;
                        ObjSaveSt_Transaction.BatchNumber = "";
                        ObjSaveSt_Transaction.InsDateTime = DateTime.Now;
                        ObjSaveSt_Transaction.InsUserID   = userId;

                        if (!ModelState.IsValid)
                        {
                            string Err    = " ";
                            var    errors = ModelState.Values.SelectMany(v => v.Errors);
                            foreach (ModelError error in errors)
                            {
                                Err = Err + error.ErrorMessage + " * ";
                            }

                            Msg.Msg  = Resources.Resource.SomthingWentWrong + " : " + Err;
                            Msg.Code = 0;
                            return(Json(Msg, JsonRequestBehavior.AllowGet));
                        }
                        _unitOfWork.St_Header.UpdateRowCountInitialInventory(ObjUpdateSt_Header);
                        _unitOfWork.St_Header.AddTransaction(ObjSaveSt_Transaction);
                        _unitOfWork.Complete();
                    }
                    else
                    {
                        var ObjUpdateSt_Header = new St_Header();
                        ObjUpdateSt_Header.CompanyID   = UserInfo.fCompanyId;
                        ObjUpdateSt_Header.DueDate     = DateTime.Now;
                        ObjUpdateSt_Header.InsDateTime = DateTime.Now;
                        ObjUpdateSt_Header.InsUserID   = userId;
                        var ObjUpdateSt_Transaction = new St_Transaction();
                        ObjUpdateSt_Transaction.CompanyID               = UserInfo.fCompanyId;
                        ObjUpdateSt_Transaction.StockCode               = ObjSave.StockCode;
                        ObjUpdateSt_Transaction.ItemCode                = ObjSave.UpdateItemCode;
                        ObjUpdateSt_Transaction.Quantity                = ObjSave.Quantity;
                        ObjUpdateSt_Transaction.QuantityInputOutput     = ObjSave.Quantity;
                        ObjUpdateSt_Transaction.TotalLocalBeforDiscount = (ObjSave.Quantity * ObjSave.CostRate);
                        ObjUpdateSt_Transaction.TotalLocalAfterDiscount = (ObjSave.Quantity * ObjSave.CostRate);
                        ObjUpdateSt_Transaction.TotalLocal              = (ObjSave.Quantity * ObjSave.CostRate);
                        ObjUpdateSt_Transaction.TotalCostLocal          = (ObjSave.Quantity * ObjSave.CostRate);
                        if (ObjSave.Quantity <= 0)
                        {
                            ObjUpdateSt_Transaction.PricePieceLocalBeforDiscount = 0;
                            ObjUpdateSt_Transaction.PricePieceLocalAfterDiscount = 0;
                            ObjUpdateSt_Transaction.PricePieceTotalLocal         = 0;
                            ObjUpdateSt_Transaction.CostPieceLocal = 0;
                        }
                        else
                        {
                            ObjUpdateSt_Transaction.PricePieceLocalBeforDiscount = ObjSave.CostRate;
                            ObjUpdateSt_Transaction.PricePieceLocalAfterDiscount = ObjSave.CostRate;
                            ObjUpdateSt_Transaction.PricePieceTotalLocal         = ObjSave.CostRate;
                            ObjUpdateSt_Transaction.CostPieceLocal = ObjSave.CostRate;
                        }
                        ObjUpdateSt_Transaction.InsDateTime = DateTime.Now;
                        ObjUpdateSt_Transaction.InsUserID   = userId;
                        if (!ModelState.IsValid)
                        {
                            string Err    = " ";
                            var    errors = ModelState.Values.SelectMany(v => v.Errors);
                            foreach (ModelError error in errors)
                            {
                                Err = Err + error.ErrorMessage + " * ";
                            }

                            Msg.Msg  = Resources.Resource.SomthingWentWrong + " : " + Err;
                            Msg.Code = 0;
                            return(Json(Msg, JsonRequestBehavior.AllowGet));
                        }

                        _unitOfWork.St_Header.UpdateInitialInventory(ObjUpdateSt_Header);
                        _unitOfWork.St_Header.UpdateInitialInventoryInTransaction(ObjUpdateSt_Transaction);
                        _unitOfWork.Complete();
                    }
                }
                Msg.Code = 1;
                Msg.Msg  = Resources.Resource.AddedSuccessfully;
                return(Json(Msg, JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                Msg.Msg  = Resources.Resource.SomthingWentWrong + " : " + ex.Message.ToString();
                Msg.Code = 0;
                return(Json(Msg, JsonRequestBehavior.AllowGet));
            }
        }
Example #6
0
 public void AddHeader(St_Header ObjSave)
 {
     _context.St_Headers.Add(ObjSave);
 }
Example #7
0
 public JumpTableInterface()
 {
     header           = new St_Header();
     footer           = new St_Footer();
     jumpTableEntries = new List <JumpTableEntry>();
 }