Beispiel #1
0
        // --

        public bool CancelConfirmItem(StockInEquipment o, Boolean isSaveDraff, params System.Linq.Expressions.Expression <Func <StockInEquipment, object> >[] properties)
        {
            using (TransactionScope transaction = new TransactionScope())
            {
                try
                {
                    StockInEquipment item = db.StockInEquipments.Where(i => i.ID == o.ID || i.OrderCode == o.OrderCode).SingleOrDefault();
                    if (o.StockInEquipmentDetails != null)
                    {
                        ITInventoryManager itInManager = new ITInventoryManager();
                        foreach (StockInEquipmentDetail i in o.StockInEquipmentDetails)
                        {
                            itInManager.AddItemToWarehouse(i.ItemDetailID, i.UnitID, i.Quantity.Value, this.db);
                        }
                    }
                    item.Status = (int)OrderStatus.DRAFT;
                    db.SaveChanges();
                    transaction.Complete();
                    return(true);
                }
                catch
                {
                    transaction.Dispose();
                    return(false);
                }
            }
        }
Beispiel #2
0
        /// <summary>
        /// Insert Item:
        /// DeviceRegistration
        /// if OrderStatus was Save end Send then Insert WFMain to DB
        /// </summary>
        /// <param name="o"></param>
        /// <returns></returns>
        public string InsertItem(StockInEquipment o, bool isSaveDraff)
        {
            using (TransactionScope transaction = new TransactionScope())
            {
                try
                {
                    o.ID = Guid.NewGuid().ToString();
                    if (o.StockInEquipmentDetails != null)
                    {
                        ITInventoryManager itInManager = new ITInventoryManager();
                        foreach (StockInEquipmentDetail i in o.StockInEquipmentDetails)
                        {
                            i.ID = Guid.NewGuid().ToString();
                            i.StockInEquipmentID = o.ID;

                            // Add Number in stock
                            if (!isSaveDraff)
                            {
                                itInManager.AddItemToWarehouse(i.ItemDetailID, i.UnitID, i.Quantity.Value, this.db);
                            }
                        }
                    }

                    if (isSaveDraff)
                    {
                        o.Status = (int)OrderStatus.DRAFT;
                    }
                    else
                    {
                        o.Status = (int)OrderStatus.FINSHED;
                    }

                    db.StockInEquipments.Add(o);

                    db.SaveChanges();
                    transaction.Complete();
                    return(o.ID);
                }
                catch (Exception)
                {
                    transaction.Dispose();
                }
            }
            return("");
        }
Beispiel #3
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sItemID"></param>
        /// <returns></returns>
        public bool DeleteItem(string sItemID, int iUserID)
        {
            StockInEquipment item = db.StockInEquipments.Where(i => i.ID == sItemID).SingleOrDefault();

            if (item != null)
            {
                if (iUserID != item.CreatorID.Value)
                {
                    return(false);
                }
                if (item.Status == (int)OrderStatus.FINSHED)
                {
                    return(false);
                }

                item.Status = (int)OrderStatus.DELETED;
                db.SaveChanges();
                return(true);
            }
            return(false);
        }
Beispiel #4
0
        /// <summary>
        /// Update Item
        /// </summary>
        /// <param name="o">DeviceRegistration to Update</param>
        /// <param name="status">OrderStatus</param>
        /// <param name="w">WFMainDetail</param>
        /// <param name="properties"></param>
        /// <returns></returns>
        public bool UpdateItem(StockInEquipment o, Boolean isSaveDraff, params System.Linq.Expressions.Expression <Func <StockInEquipment, object> >[] properties)
        {
            using (TransactionScope transaction = new TransactionScope())
            {
                try
                {
                    StockInEquipment item = db.StockInEquipments.Where(i => i.ID == o.ID || i.OrderCode == o.OrderCode).SingleOrDefault();
                    if (item != null)
                    {
                        foreach (var propertie in properties)
                        {
                            var lambda = (LambdaExpression)propertie;
                            MemberExpression memberExpression;
                            if (lambda.Body is UnaryExpression)
                            {
                                memberExpression = (MemberExpression)((UnaryExpression)lambda.Body).Operand;
                            }
                            else
                            {
                                memberExpression = (MemberExpression)lambda.Body;
                            }

                            string propertyName = memberExpression.Member.Name;
                            item.GetType().GetProperty(propertyName).SetValue(item, o.GetType().GetProperty(propertyName).GetValue(o));
                        }
                    }

                    // Xóa  Detail
                    List <StockInEquipmentDetail> lstDeviceDetail = db.StockInEquipmentDetails.Where(i => i.StockInEquipmentID == item.ID).ToList();
                    if (lstDeviceDetail.Count > 0)
                    {
                        foreach (StockInEquipmentDetail i in lstDeviceDetail)
                        {
                            db.StockInEquipmentDetails.Remove(i);
                        }
                    }
                    //Add detail
                    if (o.StockInEquipmentDetails != null)
                    {
                        ITInventoryManager itInManager = new ITInventoryManager();
                        foreach (StockInEquipmentDetail i in o.StockInEquipmentDetails)
                        {
                            i.ID = Guid.NewGuid().ToString();
                            i.StockInEquipmentID = o.ID;
                            db.StockInEquipmentDetails.Add(i);

                            // Add Number in stock
                            if (!isSaveDraff)
                            {
                                itInManager.AddItemToWarehouse(i.ItemDetailID, i.UnitID, i.Quantity.Value, this.db);
                            }
                        }
                    }

                    if (isSaveDraff)
                    {
                        item.Status = (int)OrderStatus.DRAFT;
                    }
                    else
                    {
                        item.Status = (int)OrderStatus.FINSHED;
                        item.Temp1  = DateTime.Now;
                    }

                    db.SaveChanges();
                    transaction.Complete();

                    return(true);
                }
                catch
                {
                    transaction.Dispose();
                    return(false);
                }
            }
        }