Exemplo n.º 1
0
        public ActionResult IssueToProduction(INVStoreTrans model)
        {
            if (model.TransactionID == 0)
            {
                var msg           = objBLL.Save(model, Convert.ToInt32(Session["UserID"]), "IssueToProduction/IssueToProduction");
                var TransactionID = objBLL.GetTransactionID();
                var TransactionNo = objDalIssue.GetTransactionNo(TransactionID);

                if (model.PageName == "Adjustment")
                {
                    var TransactionItemList = objDalIssue.GetTransactionItemListForStockAdjust(TransactionID, model.TransactionFrom);
                    return(Json(new { Msg = msg, TransactionID = TransactionID, TransactionNo = TransactionNo, TransactionItemList = TransactionItemList }, JsonRequestBehavior.AllowGet));
                }
                else
                {
                    var TransactionItemList = objDalIssue.GetTransactionItemList(TransactionID, model.TransactionFrom);
                    return(Json(new { Msg = msg, TransactionID = TransactionID, TransactionNo = TransactionNo, TransactionItemList = TransactionItemList }, JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                var msg = objBLL.Update(model, Convert.ToInt32(Session["UserID"]));

                if (model.PageName == "Adjustment")
                {
                    var TransactionItemList = objDalIssue.GetTransactionItemListForStockAdjust(model.TransactionID, model.TransactionFrom);
                    return(Json(new { Msg = msg, TransactionItemList = TransactionItemList }, JsonRequestBehavior.AllowGet));
                }
                else
                {
                    var TransactionItemList = objDalIssue.GetTransactionItemList(model.TransactionID, model.TransactionFrom);
                    return(Json(new { Msg = msg, TransactionItemList = TransactionItemList }, JsonRequestBehavior.AllowGet));
                }
            }
        }
Exemplo n.º 2
0
        public INVStoreTrans GetTransactionDetailsAfterSearch(long _TransactionID)
        {
            var model = new INVStoreTrans();


            using (_context)
            {
                var TransactionInfo = (from t in _context.INV_StoreTrans.AsEnumerable()
                                       where t.TransactionID == _TransactionID

                                       select new INVStoreTrans
                {
                    TransactionID = t.TransactionID,
                    TransactionNo = t.TransactionNo,
                    IssueFrom = t.TransactionFrom,
                    IssueTo = t.TransactionTo,
                    TransactionDate = (Convert.ToDateTime(t.TransactionDate)).ToString("dd'/'MM'/'yyyy"),
                    RecordStatus = t.RecordStatus,
                    Remark = t.Remarks
                }).FirstOrDefault();


                model.TransactionInfo = TransactionInfo;


                var TransactionItemList = GetTransactionItemList(_TransactionID, TransactionInfo.IssueFrom);

                model.TransactionItemList = TransactionItemList;

                return(model);
            }
        }
Exemplo n.º 3
0
        public ActionResult GetLoanRequestInfoList(string RequestID, byte?storeID)
        {
            INVStoreTrans model = new INVStoreTrans();

            model.InvStoreTransRequestList = Dalobject.GetLoanRequestInfoList(RequestID);
            if (model.InvStoreTransRequestList.Count() > 0)
            {
                model.InvStoreTransItemList = Dalobject.GetLoanRequestItemList(model.InvStoreTransRequestList[0].RequestID.ToString(), storeID);
            }
            return(Json(model, JsonRequestBehavior.AllowGet));
        }
Exemplo n.º 4
0
        public ActionResult GetAllGridList(string TransactionID, byte?storeID)
        {
            INVStoreTrans model = new INVStoreTrans();

            if (TransactionID != null)
            {
                model.InvStoreTransRequestList = Dalobject.GetPurcRecvPlList(TransactionID);
                model.InvStoreTransChallanList = Dalobject.GetChallanList(TransactionID);
                model.InvStoreTransItemList    = Dalobject.GetRecvItemListList(TransactionID, storeID);
            }
            return(Json(model, JsonRequestBehavior.AllowGet));
        }
Exemplo n.º 5
0
        public ValidationMsg Save(INVStoreTrans model, int userId, string pageUrl)
        {
            var transactionOption = new TransactionOptions {
                Timeout = new TimeSpan(0, 0, 99999)
            };
            var vMsg = new ValidationMsg();


            using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew, transactionOption))
            {
                try
                {
                    _dalStoreTransferIssue = new DalStoreTransferIssue();

                    TransactionID = _dalStoreTransferIssue.Save(model, userId, pageUrl);

                    //GetpurchaseID(purchaseID);

                    if (TransactionID > 0)
                    {
                        transactionScope.Complete();

                        vMsg.Type = Enums.MessageType.Success;
                        vMsg.Msg  = "Saved successfully.";
                        //vMsg.ReturnId = _dalChemicalForeignPurchaseOrder.GetOrderNo(OrderID);
                    }
                    else
                    {
                        vMsg.Type = Enums.MessageType.Error;
                        vMsg.Msg  = "Failed to save.";
                    }
                }

                catch (Exception e)
                {
                    vMsg.Type = Enums.MessageType.Error;
                    vMsg.Msg  = "Failed to save.";
                }
            }



            return(vMsg);
        }
Exemplo n.º 6
0
        public ActionResult StoreTransferReceive(INVStoreTrans model)
        {
            if (model.TransactionID == 0)
            {
                var msg           = objBllReceive.Save(model, Convert.ToInt32(Session["UserID"]), "StoreTransferIssue/StoreTransferIssue");
                var TransactionID = objBllReceive.GetTransactionID();
                var TransactionNo = objReceive.GetTransactionNo(TransactionID);

                var TransactionItemList = objReceive.GetTransactionItemList(TransactionID);
                return(Json(new { Msg = msg, TransactionID = TransactionID, TransactionNo = TransactionNo, TransactionItemList = TransactionItemList }, JsonRequestBehavior.AllowGet));
            }
            else
            {
                var msg = objBllReceive.Update(model, 1);
                var TransactionItemList = objReceive.GetTransactionItemList(model.TransactionID);

                return(Json(new { Msg = msg, TransactionItemList = TransactionItemList }, JsonRequestBehavior.AllowGet));
            }
        }
Exemplo n.º 7
0
        public ValidationMsg Update(INVStoreTrans model, int userId)
        {
            var transactionOption = new TransactionOptions {
                Timeout = new TimeSpan(0, 0, 9999)
            };
            var vMsg = new ValidationMsg();

            using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew, transactionOption))
            {
                try
                {
                    _dalStoreTransferIssue = new DalStoreTransferIssue();

                    var UpdateStatus = _dalStoreTransferIssue.Update(model, userId);

                    if (UpdateStatus > 0)
                    {
                        transactionScope.Complete();

                        vMsg.Type = Enums.MessageType.Update;
                        vMsg.Msg  = "Updated successfully.";
                    }
                    else
                    {
                        vMsg.Type = Enums.MessageType.Error;
                        vMsg.Msg  = "Failed to Update.";
                    }
                }

                catch (Exception)
                {
                    vMsg.Type = Enums.MessageType.Error;
                    vMsg.Msg  = "Failed to Update.";
                }
            }
            return(vMsg);
        }
Exemplo n.º 8
0
 public ActionResult ConfirmChemicalPurchase(INVStoreTrans model)
 {
     _vmMsg = Dalobject.ConfirmChemicalPurchase(model, Convert.ToInt32(Session["UserID"]));
     return(Json(new { msg = _vmMsg }));
 }
Exemplo n.º 9
0
 public ActionResult LoanIssue(INVStoreTrans model)
 {
     _vmMsg = model.TransactionID == 0 ? Dalobject.Save(model, Convert.ToInt32(Session["UserID"]), "LoanIssue/LoanIssue") : Dalobject.Update(model, Convert.ToInt32(Session["UserID"]));
     return(Json(new { TransactionID = Dalobject.GetReceiveID(), TransactionNo = Dalobject.GetReceiveNo(), msg = _vmMsg }));
 }
Exemplo n.º 10
0
        public int Update(INVStoreTrans model, int userId)
        {
            try
            {
                using (TransactionScope transaction = new TransactionScope())
                {
                    using (_context)
                    {
                        #region Transaction_Informaiton_Update
                        var CurrentTransaction = (from p in _context.INV_StoreTrans
                                                  where p.TransactionID == model.TransactionID
                                                  select p).FirstOrDefault();


                        CurrentTransaction.TransactionDate = DalCommon.SetDate(model.TransactionDate);
                        CurrentTransaction.Remarks         = model.Remark;
                        CurrentTransaction.ModifiedBy      = userId;
                        CurrentTransaction.ModifiedOn      = DateTime.Now;
                        //_context.SaveChanges();

                        #endregion

                        #region Update Requisition ItemList
                        if (model.TransactionItemList != null)
                        {
                            foreach (var item in model.TransactionItemList)
                            {
                                var checkRequisitionItem = (from i in _context.INV_StoreTransItem
                                                            where i.TransItemID == item.TransItemID
                                                            select i).Any();

                                #region New_Item_Insertion
                                if (!checkRequisitionItem)
                                {
                                    INV_StoreTransItem objItem = new INV_StoreTransItem();

                                    objItem.TransactionID   = model.TransactionID;
                                    objItem.ItemID          = item.ItemID;
                                    objItem.SupplierID      = item.SupplierID;
                                    objItem.TransactionQty  = item.IssueQty;
                                    objItem.TransactionUnit = DalCommon.GetUnitCode(item.IssueUnitName);
                                    objItem.PackSize        = DalCommon.GetSizeCode(item.IssuePackSizeName);
                                    objItem.SizeUnit        = DalCommon.GetUnitCode(item.IssueSizeUnitName);
                                    objItem.PackQty         = item.IssuePackQty;
                                    objItem.SetOn           = DateTime.Now;
                                    objItem.SetBy           = userId;
                                    _context.INV_StoreTransItem.Add(objItem);
                                    //_context.SaveChanges();
                                }
                                #endregion

                                #region Existing_Item_Update
                                else
                                {
                                    var FoundItem = (from i in _context.INV_StoreTransItem
                                                     where i.TransItemID == item.TransItemID
                                                     select i).FirstOrDefault();
                                    FoundItem.ItemID          = item.ItemID;
                                    FoundItem.SupplierID      = item.SupplierID;
                                    FoundItem.TransactionQty  = item.IssueQty;
                                    FoundItem.TransactionUnit = DalCommon.GetUnitCode(item.IssueUnitName);
                                    FoundItem.PackSize        = DalCommon.GetSizeCode(item.IssuePackSizeName);
                                    FoundItem.SizeUnit        = DalCommon.GetUnitCode(item.IssueSizeUnitName);
                                    FoundItem.PackQty         = item.IssuePackQty;
                                    FoundItem.ModifiedOn      = DateTime.Now;
                                    FoundItem.ModifiedBy      = userId;
                                    //_context.SaveChanges();
                                }
                                #endregion
                            }
                        }

                        #endregion

                        _context.SaveChanges();
                    }

                    transaction.Complete();
                }
                return(1);
            }
            catch (Exception e)
            {
                return(0);
            }
        }
Exemplo n.º 11
0
        public long Save(INVStoreTrans model, int userId, string pageUrl)
        {
            long CurrentTransactionID = 0;

            try
            {
                using (TransactionScope transaction = new TransactionScope())
                {
                    using (_context)
                    {
                        var GetTransactionNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);

                        if (GetTransactionNo != null)
                        {
                            #region New_Transaction_Insert

                            INV_StoreTrans objIssue = new INV_StoreTrans();

                            objIssue.TransactionNo       = GetTransactionNo;
                            objIssue.TransactionDate     = DalCommon.SetDate(model.TransactionDate);
                            objIssue.TransactionCategory = "ISU";
                            objIssue.TransactionType     = "STI";
                            objIssue.TransactionFrom     = model.IssueFrom;
                            objIssue.TransactionTo       = model.IssueTo;

                            objIssue.TransactionStatus = "TRI";


                            objIssue.RecordStatus = "NCF";
                            objIssue.SetBy        = userId;
                            objIssue.SetOn        = DateTime.Now;

                            _context.INV_StoreTrans.Add(objIssue);
                            _context.SaveChanges();
                            CurrentTransactionID = objIssue.TransactionID;
                            #endregion

                            #region Item Insert
                            if (model.TransactionItemList != null)
                            {
                                foreach (var item in model.TransactionItemList)
                                {
                                    INV_StoreTransItem objItem = new INV_StoreTransItem();

                                    objItem.TransactionID = CurrentTransactionID;

                                    objItem.ItemID     = item.ItemID;
                                    objItem.SupplierID = item.SupplierID;

                                    objItem.TransactionQty = item.IssueQty;

                                    objItem.TransactionUnit = DalCommon.GetUnitCode(item.IssueUnitName);


                                    objItem.PackSize = DalCommon.GetSizeCode(item.IssuePackSizeName);
                                    objItem.SizeUnit = DalCommon.GetUnitCode(item.IssueSizeUnitName);


                                    objItem.PackQty = item.IssuePackQty;
                                    //objItem.ItemSource = DalCommon.ReturnItemSource(item.ItemSource);
                                    objItem.SetOn = DateTime.Now;
                                    objItem.SetBy = userId;

                                    _context.INV_StoreTransItem.Add(objItem);
                                    //_context.SaveChanges();
                                }
                            }
                            #endregion
                        }
                        _context.SaveChanges();
                    }
                    transaction.Complete();
                }
                return(CurrentTransactionID);
            }
            catch (Exception e)
            {
                return(0);
            }
        }
Exemplo n.º 12
0
        public INVStoreTrans GetTransactionDetailsAfterSearch(long _TransactionID)
        {
            var model = new INVStoreTrans();


            using (_context)
            {
                var RequisitionID = (from r in _context.INV_StoreTransRequest
                                     where r.TransactionID == _TransactionID
                                     select r.RequisitionID
                                     ).FirstOrDefault();

                if (RequisitionID != null)
                {
                    var TransactionInfo = (from t in _context.INV_StoreTrans.AsEnumerable()
                                           where t.TransactionID == _TransactionID

                                           join req in _context.INV_StoreTransRequest on t.TransactionID equals req.TransactionID into Requests
                                           from req in Requests.DefaultIfEmpty()

                                           //from req in _context.INV_StoreTransRequest.Where(x => x.TransactionID == _TransactionID).DefaultIfEmpty()

                                           join r in _context.PRD_ChemProdReq on RequisitionID equals r.RequisitionID into Requisitions
                                           from r in Requisitions.DefaultIfEmpty()

                                           //from r in _context.PRD_ChemProdReq.Where(x => x.RequisitionID == RequisitionID).DefaultIfEmpty()

                                           join u in _context.Users on(r == null ? null : r.ReqRaisedBy) equals u.UserID into UserInfo
                                           from u in UserInfo.DefaultIfEmpty()

                                           //from u in _context.Users.Where(x => x.UserID == r.ReqRaisedBy).DefaultIfEmpty()
                                           select new INVStoreTrans
                    {
                        TransactionID = t.TransactionID,
                        TransactionNo = t.TransactionNo,
                        IssueFrom = t.TransactionFrom,
                        IssueTo = t.TransactionTo,
                        TransactionDate = (Convert.ToDateTime(t.TransactionDate)).ToString("dd'/'MM'/'yyyy"),
                        RecordStatus = t.RecordStatus,
                        RequisitionID = (r == null ? 0 : r.RequisitionID),
                        RequisitionNo = (r == null ? null : r.RequisitionNo),
                        RequisitionCategory = (r == null ? null : DalCommon.ReturnRequisitionCategory(r.RequisitionCategory)),
                        RequisitionType = (r == null ? null : DalCommon.ReturnOrderType(r.RequisitionType)),
                        RequiredByTime = (r == null ? null : (r.RequiredByTime).ToString()),
                        ReqRaisedOn = (r == null ? null : (Convert.ToDateTime(r.ReqRaisedOn)).ToString("dd'/'MM'/'yyyy")),
                        ReqRaisedByName = (u == null ? null : (u.FirstName + " " + u.MiddleName + " " + u.LastName)),
                        JobOrderNo = (r == null ? null : r.JobOrderNo),
                        Remark = (req == null ? null : req.Remark),
                        TransactionType = t.TransactionType
                    }).FirstOrDefault();


                    model.TransactionInfo = TransactionInfo;

                    var TransactionItemList = GetTransactionItemList(_TransactionID, TransactionInfo.IssueFrom);

                    model.TransactionItemList = TransactionItemList;

                    return(model);
                }

                else
                {
                    var TransactionInfo = (from t in _context.INV_StoreTrans.AsEnumerable()
                                           where t.TransactionID == _TransactionID

                                           join req in _context.INV_StoreTransRequest on t.TransactionID equals req.TransactionID into Requests
                                           from req in Requests.DefaultIfEmpty()

                                           //from req in _context.INV_StoreTransRequest.Where(x => x.TransactionID == _TransactionID).DefaultIfEmpty()

                                           select new INVStoreTrans
                    {
                        TransactionID = t.TransactionID,
                        TransactionNo = t.TransactionNo,
                        IssueFrom = t.TransactionFrom,
                        IssueTo = t.TransactionTo,
                        TransactionDate = (Convert.ToDateTime(t.TransactionDate)).ToString("dd'/'MM'/'yyyy"),
                        RecordStatus = t.RecordStatus,
                        Remark = (req == null ? null : req.Remark),
                        ReqToDate = (Convert.ToDateTime(req.ReqToDate)).ToString("dd'/'MM'/'yyyy"),
                        ReqFromDate = (Convert.ToDateTime(req.ReqFromDate)).ToString("dd'/'MM'/'yyyy"),
                        TransactionType = t.TransactionType
                    }).FirstOrDefault();


                    model.TransactionInfo = TransactionInfo;

                    if (TransactionInfo.TransactionType == "ADI")
                    {
                        var TransactionItemList = GetTransactionItemListForStockAdjust(_TransactionID, TransactionInfo.IssueFrom);
                        model.TransactionItemList = TransactionItemList;
                    }
                    else
                    {
                        var TransactionItemList = GetTransactionItemList(_TransactionID, TransactionInfo.IssueFrom);
                        model.TransactionItemList = TransactionItemList;
                    }



                    return(model);
                }
            }
        }
Exemplo n.º 13
0
        public int Update(INVStoreTrans model, int userId)
        {
            try
            {
                using (TransactionScope transaction = new TransactionScope())
                {
                    using (_context)
                    {
                        #region Transaction_Informaiton_Update
                        var CurrentTransaction = (from p in _context.INV_StoreTrans
                                                  where p.TransactionID == model.TransactionID
                                                  select p).FirstOrDefault();

                        if (model.AdjustmentType == "Addition")
                        {
                            CurrentTransaction.TransactionCategory = "RCV";
                        }
                        else
                        {
                            CurrentTransaction.TransactionCategory = "ISU";
                        }
                        if (model.PageName == "Adjustment")
                        {
                            CurrentTransaction.TransactionType = "ADI";
                        }
                        else if (model.PageName == "InventoryAdjustment" & model.AdjustmentType == "Addition")
                        {
                            CurrentTransaction.TransactionType = "ADR";
                        }
                        else if (model.PageName == "InventoryAdjustment" & model.AdjustmentType == "Subtraction")
                        {
                            CurrentTransaction.TransactionType = "ADI";
                        }
                        else
                        {
                            CurrentTransaction.TransactionType = "ITP";
                            CurrentTransaction.TransactionTo   = model.TransactionTo;
                        }

                        CurrentTransaction.Remarks = model.Remark;



                        CurrentTransaction.TransactionDate = DalCommon.SetDate(model.TransactionDate);
                        CurrentTransaction.ModifiedBy      = userId;
                        CurrentTransaction.ModifiedOn      = DateTime.Now;
                        //_context.SaveChanges();

                        #endregion

                        #region Request Infromation Update

                        if (model.PageName != "InventoryAdjustment")
                        {
                            if (model.PageName == "Adjustment")
                            {
                                var CurrentRequest = (from r in _context.INV_StoreTransRequest
                                                      where r.TransactionID == model.TransactionID
                                                      select r).FirstOrDefault();

                                CurrentRequest.ReqFromDate = DalCommon.SetDate(model.ReqFromDate);
                                CurrentRequest.ReqToDate   = DalCommon.SetDate(model.ReqToDate);
                                CurrentRequest.ModifiedBy  = userId;
                                CurrentRequest.ModifiedOn  = DateTime.Now;
                                CurrentRequest.Remark      = model.Remark;
                            }
                            else
                            {
                                var CurrentRequest = (from r in _context.INV_StoreTransRequest
                                                      where r.TransactionID == model.TransactionID &&
                                                      r.RequisitionID == model.RefTransactionID
                                                      select r).FirstOrDefault();
                                CurrentRequest.Remark     = model.Remark;
                                CurrentRequest.ModifiedBy = userId;
                                CurrentRequest.ModifiedOn = DateTime.Now;
                            }
                        }



                        #endregion

                        #region Update Requisition ItemList

                        if (model.InvStoreTransItemList != null)
                        {
                            foreach (var item in model.InvStoreTransItemList)
                            {
                                var checkRequisitionItem = (from i in _context.INV_StoreTransItem
                                                            where i.TransItemID == item.TransItemID
                                                            select i).Any();

                                #region New_Item_Insertion
                                if (!checkRequisitionItem)
                                {
                                    INV_StoreTransItem objItem = new INV_StoreTransItem();

                                    objItem.TransactionID = model.TransactionID;
                                    objItem.ItemID        = item.ItemID;
                                    if (item.SupplierID == 0)
                                    {
                                        objItem.SupplierID = null;
                                    }
                                    else
                                    {
                                        objItem.SupplierID = item.SupplierID;
                                    }
                                    objItem.TransactionQty = item.TransactionQty;

                                    objItem.TransactionUnit = DalCommon.GetUnitCode(item.TransactionUnitName);


                                    if (item.PackSizeName != null)
                                    {
                                        objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
                                    }

                                    if (item.SizeUnitName != null)
                                    {
                                        objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
                                    }


                                    objItem.PackQty    = item.PackQty;
                                    objItem.ItemSource = DalCommon.ReturnItemSource(item.ItemSource);

                                    objItem.SetOn = DateTime.Now;
                                    objItem.SetBy = userId;

                                    _context.INV_StoreTransItem.Add(objItem);
                                    //_context.SaveChanges();
                                }
                                #endregion

                                #region Existing_Item_Update
                                else
                                {
                                    var FoundItem = (from i in _context.INV_StoreTransItem
                                                     where i.TransItemID == item.TransItemID
                                                     select i).FirstOrDefault();

                                    FoundItem.ItemID = item.ItemID;
                                    if (item.SupplierID == 0)
                                    {
                                        FoundItem.SupplierID = null;
                                    }
                                    else
                                    {
                                        FoundItem.SupplierID = item.SupplierID;
                                    }
                                    FoundItem.TransactionQty = item.TransactionQty;

                                    FoundItem.TransactionUnit = DalCommon.GetUnitCode(item.TransactionUnitName);


                                    if (item.PackSizeName != null)
                                    {
                                        FoundItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
                                    }

                                    if (item.SizeUnitName != null)
                                    {
                                        FoundItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
                                    }


                                    FoundItem.PackQty    = item.PackQty;
                                    FoundItem.ModifiedBy = userId;
                                    FoundItem.ModifiedOn = DateTime.Now;

                                    //_context.SaveChanges();
                                }
                                #endregion
                            }
                        }

                        #endregion

                        _context.SaveChanges();
                    }

                    transaction.Complete();
                }
                return(1);
            }
            catch (Exception e)
            {
                return(0);
            }
        }
Exemplo n.º 14
0
        public long Save(INVStoreTrans model, int userId, string pageUrl)
        {
            long CurrentTransactionID = 0;
            long CurrentRequestID     = 0;

            using (TransactionScope transaction = new TransactionScope())
            {
                try
                {
                    using (_context)
                    {
                        string GetTransactionNo;
                        if (model.PageName == "Adjustment")
                        {
                            GetTransactionNo = DalCommon.GetPreDefineNextCodeByUrl("ChemicalStockAdjustment/ChemicalStockAdjustment");
                        }
                        else if (model.PageName == "InventoryAdjustment")
                        {
                            //Need Attention
                            GetTransactionNo = DalCommon.GetPreDefineNextCodeByUrl("ChemicalStockAdjustment/ChemicalStockAdjustment");
                        }
                        else
                        {
                            GetTransactionNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
                        }


                        if (GetTransactionNo != null)
                        {
                            #region New_Transaction_Insert

                            INV_StoreTrans objIssue = new INV_StoreTrans();

                            objIssue.TransactionNo   = GetTransactionNo;
                            objIssue.TransactionDate = DalCommon.SetDate(model.TransactionDate);
                            if (model.AdjustmentType == "Addition")
                            {
                                objIssue.TransactionCategory = "RCV";
                            }
                            else
                            {
                                objIssue.TransactionCategory = "ISU";
                            }


                            objIssue.TransactionFrom = model.TransactionFrom;


                            if (model.PageName == "Adjustment")
                            {
                                objIssue.TransactionType = "ADI";
                            }
                            else if (model.PageName == "InventoryAdjustment" & model.AdjustmentType == "Addition")
                            {
                                objIssue.TransactionType = "ADR";
                            }
                            else if (model.PageName == "InventoryAdjustment" & model.AdjustmentType == "Subtraction")
                            {
                                objIssue.TransactionType = "ADI";
                            }
                            else
                            {
                                objIssue.TransactionType = "ITP";
                                objIssue.TransactionTo   = model.TransactionTo;
                            }


                            objIssue.RecordStatus      = "NCF";
                            objIssue.TransactionState  = "RNG";
                            objIssue.TransactionStatus = "TRI";
                            objIssue.SetBy             = userId;
                            objIssue.SetOn             = DateTime.Now;

                            _context.INV_StoreTrans.Add(objIssue);
                            _context.SaveChanges();
                            CurrentTransactionID = objIssue.TransactionID;

                            #endregion

                            #region New Transaction Request Insert
                            if (model.PageName != "InventoryAdjustment")
                            {
                                var objRequest = new INV_StoreTransRequest();

                                objRequest.TransRequestNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
                                objRequest.TransactionID  = CurrentTransactionID;

                                if (model.PageName == "Adjustment")
                                {
                                    objRequest.ReqFromDate = DalCommon.SetDate(model.ReqFromDate);
                                    objRequest.ReqToDate   = DalCommon.SetDate(model.ReqToDate);
                                }
                                else
                                {
                                    objRequest.RequisitionID = Convert.ToInt32(model.RefTransactionID);
                                    objRequest.RequestNo     = model.RefTransactionNo;
                                }
                                objRequest.Remark = model.Remark;
                                objRequest.SetBy  = userId;
                                objRequest.SetOn  = DateTime.Now;

                                _context.INV_StoreTransRequest.Add(objRequest);
                                _context.SaveChanges();
                                CurrentRequestID = objRequest.TransRequestID;
                            }

                            #endregion

                            #region Item Insert
                            if (model.InvStoreTransItemList != null)
                            {
                                foreach (var item in model.InvStoreTransItemList)
                                {
                                    INV_StoreTransItem objItem = new INV_StoreTransItem();

                                    objItem.TransactionID = CurrentTransactionID;

                                    if (model.PageName != "InventoryAdjustment")
                                    {
                                        objItem.TransRequestID = CurrentRequestID;
                                    }

                                    objItem.ItemID = item.ItemID;
                                    if (item.SupplierID == 0)
                                    {
                                        objItem.SupplierID = null;
                                    }
                                    else
                                    {
                                        objItem.SupplierID = item.SupplierID;
                                    }
                                    objItem.TransactionQty = item.TransactionQty;

                                    objItem.TransactionUnit = DalCommon.GetUnitCode(item.TransactionUnitName);


                                    if (item.PackSizeName != null)
                                    {
                                        objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
                                    }

                                    if (item.SizeUnitName != null)
                                    {
                                        objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
                                    }
                                    objItem.PackQty = item.PackQty;

                                    objItem.SetOn = DateTime.Now;
                                    objItem.SetBy = userId;

                                    _context.INV_StoreTransItem.Add(objItem);
                                    //_context.SaveChanges();
                                }
                            }
                            #endregion
                        }
                        _context.SaveChanges();
                    }
                    transaction.Complete();
                }
                catch (Exception e)
                {
                    CurrentTransactionID = 0;
                    return(CurrentTransactionID);
                }
            }
            return(CurrentTransactionID);
        }