public Int32 insertStockTransferItem(Models.TrnStockTransferItem stockTransferItem)
        {
            try
            {
                Data.TrnStockTransferItem newStockTransferItem = new Data.TrnStockTransferItem();
                newStockTransferItem.STId = stockTransferItem.STId;
                newStockTransferItem.ItemId = stockTransferItem.ItemId;
                newStockTransferItem.ItemInventoryId = stockTransferItem.ItemInventoryId;
                newStockTransferItem.Particulars = stockTransferItem.Particulars;
                newStockTransferItem.UnitId = stockTransferItem.UnitId;
                newStockTransferItem.Quantity = stockTransferItem.Quantity;
                newStockTransferItem.Cost = stockTransferItem.Cost;
                newStockTransferItem.Amount = stockTransferItem.Amount;
                newStockTransferItem.BaseUnitId = stockTransferItem.BaseUnitId;

                var item = from d in db.MstArticles where d.Id == stockTransferItem.ItemId select d;
                newStockTransferItem.BaseUnitId = item.First().UnitId;

                var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == stockTransferItem.ItemId && d.UnitId == stockTransferItem.UnitId select d;
                if (conversionUnit.First().Multiplier > 0)
                {
                    newStockTransferItem.BaseQuantity = stockTransferItem.Quantity * (1 / conversionUnit.First().Multiplier);
                }
                else
                {
                    newStockTransferItem.BaseQuantity = stockTransferItem.Quantity * 1;
                }

                var baseQuantity = stockTransferItem.Quantity * (1 / conversionUnit.First().Multiplier);
                if (baseQuantity > 0)
                {
                    newStockTransferItem.BaseCost = stockTransferItem.Amount / baseQuantity;
                }
                else
                {
                    newStockTransferItem.BaseCost = stockTransferItem.Amount;
                }

                db.TrnStockTransferItems.InsertOnSubmit(newStockTransferItem);
                db.SubmitChanges();

                return newStockTransferItem.Id;
            }
            catch
            {
                return 0;
            }
        }
        public Int32 insertStockTransferItem(Models.TrnStockTransferItem stockTransferItem)
        {
            try
            {
                Data.TrnStockTransferItem newStockTransferItem = new Data.TrnStockTransferItem();
                newStockTransferItem.STId            = stockTransferItem.STId;
                newStockTransferItem.ItemId          = stockTransferItem.ItemId;
                newStockTransferItem.ItemInventoryId = stockTransferItem.ItemInventoryId;
                newStockTransferItem.Particulars     = stockTransferItem.Particulars;
                newStockTransferItem.UnitId          = stockTransferItem.UnitId;
                newStockTransferItem.Quantity        = stockTransferItem.Quantity;
                newStockTransferItem.Cost            = stockTransferItem.Cost;
                newStockTransferItem.Amount          = stockTransferItem.Amount;
                newStockTransferItem.BaseUnitId      = stockTransferItem.BaseUnitId;

                var item = from d in db.MstArticles where d.Id == stockTransferItem.ItemId select d;
                newStockTransferItem.BaseUnitId = item.First().UnitId;

                var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == stockTransferItem.ItemId && d.UnitId == stockTransferItem.UnitId select d;
                if (conversionUnit.First().Multiplier > 0)
                {
                    newStockTransferItem.BaseQuantity = stockTransferItem.Quantity * (1 / conversionUnit.First().Multiplier);
                }
                else
                {
                    newStockTransferItem.BaseQuantity = stockTransferItem.Quantity * 1;
                }

                var baseQuantity = stockTransferItem.Quantity * (1 / conversionUnit.First().Multiplier);
                if (baseQuantity > 0)
                {
                    newStockTransferItem.BaseCost = stockTransferItem.Amount / baseQuantity;
                }
                else
                {
                    newStockTransferItem.BaseCost = stockTransferItem.Amount;
                }

                db.TrnStockTransferItems.InsertOnSubmit(newStockTransferItem);
                db.SubmitChanges();

                return(newStockTransferItem.Id);
            }
            catch
            {
                return(0);
            }
        }
Ejemplo n.º 3
0
        public HttpResponseMessage AddStockTransferItem(Entities.TrnStockTransferItem objStockTransferItem, String STId)
        {
            try
            {
                var currentUser = from d in db.MstUsers
                                  where d.UserId == User.Identity.GetUserId()
                                  select d;

                if (currentUser.Any())
                {
                    var currentUserId   = currentUser.FirstOrDefault().Id;
                    var currentBranchId = currentUser.FirstOrDefault().BranchId;

                    var userForms = from d in db.MstUserForms
                                    where d.UserId == currentUserId &&
                                    d.SysForm.FormName.Equals("StockTransferDetail")
                                    select d;

                    if (userForms.Any())
                    {
                        if (userForms.FirstOrDefault().CanAdd)
                        {
                            var stockTransfer = from d in db.TrnStockTransfers
                                                where d.Id == Convert.ToInt32(STId)
                                                select d;

                            if (stockTransfer.Any())
                            {
                                if (!stockTransfer.FirstOrDefault().IsLocked)
                                {
                                    var item = from d in db.MstArticles
                                               where d.Id == objStockTransferItem.ItemId &&
                                               d.IsInventory == true &&
                                               d.Kitting != 2 &&
                                               d.IsLocked == true
                                               select d;

                                    if (item.Any())
                                    {
                                        var conversionUnit = from d in db.MstArticleUnits
                                                             where d.ArticleId == objStockTransferItem.ItemId &&
                                                             d.UnitId == objStockTransferItem.UnitId &&
                                                             d.MstArticle.IsLocked == true
                                                             select d;

                                        if (conversionUnit.Any())
                                        {
                                            var itemInventories = from d in db.MstArticleInventories
                                                                  where d.ArticleId == objStockTransferItem.ItemId &&
                                                                  d.BranchId == currentBranchId &&
                                                                  d.Quantity > 0 &&
                                                                  d.MstArticle.IsInventory == true &&
                                                                  d.MstArticle.IsLocked == true
                                                                  select d;

                                            if (itemInventories.Any())
                                            {
                                                Decimal baseQuantity = objStockTransferItem.Quantity * 1;
                                                if (conversionUnit.FirstOrDefault().Multiplier > 0)
                                                {
                                                    baseQuantity = objStockTransferItem.Quantity * (1 / conversionUnit.FirstOrDefault().Multiplier);
                                                }

                                                Decimal baseCost = objStockTransferItem.Amount;
                                                if (baseQuantity > 0)
                                                {
                                                    baseCost = objStockTransferItem.Amount / baseQuantity;
                                                }

                                                Data.TrnStockTransferItem newStockTransferItem = new Data.TrnStockTransferItem
                                                {
                                                    STId            = Convert.ToInt32(STId),
                                                    ItemId          = objStockTransferItem.ItemId,
                                                    ItemInventoryId = objStockTransferItem.ItemInventoryId,
                                                    Particulars     = objStockTransferItem.Particulars,
                                                    UnitId          = objStockTransferItem.UnitId,
                                                    Quantity        = objStockTransferItem.Quantity,
                                                    Cost            = objStockTransferItem.Cost,
                                                    Amount          = objStockTransferItem.Amount,
                                                    BaseUnitId      = item.FirstOrDefault().UnitId,
                                                    BaseQuantity    = baseQuantity,
                                                    BaseCost        = baseCost,
                                                };

                                                db.TrnStockTransferItems.InsertOnSubmit(newStockTransferItem);
                                                db.SubmitChanges();

                                                return(Request.CreateResponse(HttpStatusCode.OK));
                                            }
                                            else
                                            {
                                                return(Request.CreateResponse(HttpStatusCode.BadRequest, "The selected item has no inventory code."));
                                            }
                                        }
                                        else
                                        {
                                            return(Request.CreateResponse(HttpStatusCode.BadRequest, "The selected item has no unit conversion."));
                                        }
                                    }
                                    else
                                    {
                                        return(Request.CreateResponse(HttpStatusCode.BadRequest, "The selected item was not found in the server."));
                                    }
                                }
                                else
                                {
                                    return(Request.CreateResponse(HttpStatusCode.BadRequest, "You cannot add new stock transfer item if the current stock transfer detail is locked."));
                                }
                            }
                            else
                            {
                                return(Request.CreateResponse(HttpStatusCode.NotFound, "These current stock transfer details are not found in the server. Please add new stock transfer first before proceeding."));
                            }
                        }
                        else
                        {
                            return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no rights to add new stock transfer item in this stock transfer detail page."));
                        }
                    }
                    else
                    {
                        return(Request.CreateResponse(HttpStatusCode.BadRequest, "Sorry. You have no access in this stock transfer detail page."));
                    }
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.BadRequest, "Theres no current user logged in."));
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
            }
        }
        public HttpResponseMessage AddFolderMonitoringStockTransfer(List <Entities.FolderMonitoringTrnStockTransfer> folderMonitoringTrnStockTransferObjects)
        {
            try
            {
                if (folderMonitoringTrnStockTransferObjects.Any())
                {
                    foreach (var folderMonitoringTrnStockTransferObject in folderMonitoringTrnStockTransferObjects)
                    {
                        Boolean isBranchExist    = false,
                                 isToBranchExist = false,
                                 isArticleExist  = false,
                                 isUserExist     = false,
                                 isItemExist     = false;

                        var branch = from d in db.MstBranches where d.BranchCode.Equals(folderMonitoringTrnStockTransferObject.BranchCode) select d;
                        if (branch.Any())
                        {
                            isBranchExist = true;
                        }

                        var toBranch = from d in db.MstBranches where d.BranchCode.Equals(folderMonitoringTrnStockTransferObject.ToBranchCode) select d;
                        if (toBranch.Any())
                        {
                            isToBranchExist = true;
                        }

                        var article = from d in db.MstArticles where d.ArticleTypeId == 6 && d.ManualArticleCode.Equals(folderMonitoringTrnStockTransferObject.ArticleCode) select d;
                        if (article.Any())
                        {
                            isArticleExist = true;
                        }

                        var user = from d in db.MstUsers where d.UserName.Equals(folderMonitoringTrnStockTransferObject.UserCode) select d;
                        if (user.Any())
                        {
                            isUserExist = true;
                        }

                        var item = from d in db.MstArticles where d.ArticleTypeId == 1 && d.ManualArticleCode.Equals(folderMonitoringTrnStockTransferObject.ItemCode) && d.IsInventory == true && d.IsLocked == true select d;
                        if (item.Any())
                        {
                            isItemExist = true;
                        }

                        if (isBranchExist && isToBranchExist && isUserExist && isArticleExist && isItemExist)
                        {
                            Int32 STId = 0;

                            var currentStockTransfer = from d in db.TrnStockTransfers where d.BranchId == branch.FirstOrDefault().Id&& d.ManualSTNumber.Equals(folderMonitoringTrnStockTransferObject.ManualSTNumber) && d.IsLocked == true select d;
                            if (currentStockTransfer.Any())
                            {
                                STId = currentStockTransfer.FirstOrDefault().Id;

                                var unlockStockTransfer = currentStockTransfer.FirstOrDefault();
                                unlockStockTransfer.IsLocked        = false;
                                unlockStockTransfer.UpdatedById     = user.FirstOrDefault().Id;
                                unlockStockTransfer.UpdatedDateTime = Convert.ToDateTime(folderMonitoringTrnStockTransferObject.CreatedDateTime);
                                db.SubmitChanges();

                                journal.DeleteStockTransferJournal(STId);
                                inventory.DeleteStockTransferInventory(STId);
                            }
                            else
                            {
                                var defaultSTNumber   = "0000000001";
                                var lastStockTransfer = from d in db.TrnStockTransfers.OrderByDescending(d => d.Id) where d.BranchId == branch.FirstOrDefault().Id select d;
                                if (lastStockTransfer.Any())
                                {
                                    var STNumber = Convert.ToInt32(lastStockTransfer.FirstOrDefault().STNumber) + 0000000001;
                                    defaultSTNumber = FillLeadingZeroes(STNumber, 10);
                                }

                                Data.TrnStockTransfer newStockTransfer = new Data.TrnStockTransfer
                                {
                                    BranchId        = branch.FirstOrDefault().Id,
                                    STNumber        = defaultSTNumber,
                                    STDate          = Convert.ToDateTime(folderMonitoringTrnStockTransferObject.STDate),
                                    ToBranchId      = toBranch.FirstOrDefault().Id,
                                    ArticleId       = article.FirstOrDefault().Id,
                                    Particulars     = folderMonitoringTrnStockTransferObject.Remarks,
                                    ManualSTNumber  = folderMonitoringTrnStockTransferObject.ManualSTNumber,
                                    PreparedById    = user.FirstOrDefault().Id,
                                    CheckedById     = user.FirstOrDefault().Id,
                                    ApprovedById    = user.FirstOrDefault().Id,
                                    Status          = null,
                                    IsPrinted       = false,
                                    IsLocked        = false,
                                    CreatedById     = user.FirstOrDefault().Id,
                                    CreatedDateTime = Convert.ToDateTime(folderMonitoringTrnStockTransferObject.CreatedDateTime),
                                    UpdatedById     = user.FirstOrDefault().Id,
                                    UpdatedDateTime = Convert.ToDateTime(folderMonitoringTrnStockTransferObject.CreatedDateTime)
                                };

                                db.TrnStockTransfers.InsertOnSubmit(newStockTransfer);
                                db.SubmitChanges();

                                STId = newStockTransfer.Id;
                            }

                            var unitConversion = from d in item.FirstOrDefault().MstArticleUnits where d.MstUnit.Unit.Equals(folderMonitoringTrnStockTransferObject.Unit) select d;
                            if (unitConversion.Any())
                            {
                                Decimal baseQuantity = folderMonitoringTrnStockTransferObject.Quantity * 1;
                                if (unitConversion.FirstOrDefault().Multiplier > 0)
                                {
                                    baseQuantity = folderMonitoringTrnStockTransferObject.Quantity * (1 / unitConversion.FirstOrDefault().Multiplier);
                                }

                                Decimal baseCost = folderMonitoringTrnStockTransferObject.Amount;
                                if (baseQuantity > 0)
                                {
                                    baseCost = folderMonitoringTrnStockTransferObject.Amount / baseQuantity;
                                }

                                Int32 itemInventoryId = 0;

                                var itemInventory = from d in db.MstArticleInventories where d.BranchId == branch.FirstOrDefault().Id&& d.ArticleId == item.FirstOrDefault().Id select d;
                                if (itemInventory.Any())
                                {
                                    itemInventoryId = itemInventory.FirstOrDefault().Id;
                                }

                                if (itemInventoryId > 0)
                                {
                                    Data.TrnStockTransferItem newStockTransferItem = new Data.TrnStockTransferItem
                                    {
                                        STId            = STId,
                                        ItemId          = item.FirstOrDefault().Id,
                                        ItemInventoryId = itemInventoryId,
                                        Particulars     = folderMonitoringTrnStockTransferObject.Particulars,
                                        UnitId          = unitConversion.FirstOrDefault().UnitId,
                                        Quantity        = folderMonitoringTrnStockTransferObject.Quantity,
                                        Cost            = folderMonitoringTrnStockTransferObject.Cost,
                                        Amount          = folderMonitoringTrnStockTransferObject.Amount,
                                        BaseUnitId      = item.FirstOrDefault().UnitId,
                                        BaseQuantity    = baseQuantity,
                                        BaseCost        = baseCost
                                    };

                                    db.TrnStockTransferItems.InsertOnSubmit(newStockTransferItem);
                                    db.SubmitChanges();
                                }

                                var stockTransfer = from d in db.TrnStockTransfers where d.Id == STId && d.IsLocked == false select d;
                                if (stockTransfer.Any())
                                {
                                    var lockStockTransfer = stockTransfer.FirstOrDefault();
                                    lockStockTransfer.IsLocked        = true;
                                    lockStockTransfer.UpdatedById     = user.FirstOrDefault().Id;
                                    lockStockTransfer.UpdatedDateTime = Convert.ToDateTime(folderMonitoringTrnStockTransferObject.CreatedDateTime);
                                    db.SubmitChanges();

                                    journal.InsertStockTransferJournal(STId);
                                    inventory.InsertStockTransferInventory(STId);
                                }
                            }
                        }
                    }

                    return(Request.CreateResponse(HttpStatusCode.OK));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.NotFound, "No data found."));
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's went wrong from the server."));
            }
        }