Ejemplo n.º 1
0
        public string UpdateSubAssembly(SubAssembly model)
        {
            using (IDbConnection connection = OpenConnection(dataConnection))
            {
                IDbTransaction txn = connection.BeginTransaction();
                try
                {
                    Delete(model.StockCreationId, connection, txn);

                    Create(model, connection, txn);

                    InsertLoginHistory(dataConnection, model.CreatedBy, "Update", "Sub-assembly", model.StockCreationId.ToString(), model.OrganizationId.ToString());
                    txn.Commit();
                    return(model.StockCreationRefNo);
                }
                catch (SqlException sx)
                {
                    txn.Rollback();
                    throw sx;
                }
                catch (Exception ex)
                {
                    txn.Rollback();
                    throw ex;
                }
            }
        }
Ejemplo n.º 2
0
        public ActionResult Create(SubAssembly model)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    model.OrganizationId = OrganizationId;
                    model.CreatedDate    = System.DateTime.Now;
                    model.CreatedBy      = UserID.ToString();

                    string ref_no = new SubAssemblyRepository().CreateSubAssembly(model);
                    TempData["success"] = "Saved Successfully. Reference No. is " + ref_no;
                }
                else
                {
                    var allErrors = ModelState.Values.SelectMany(v => v.Errors);
                    FillDropdowns();
                    return(View(model));
                }
            }
            catch (Exception ex)
            {
                TempData["error"] = "Some error occured while saving. Please try again.|" + ex.Message;
                FillDropdowns();
                return(View(model));
            }
            return(RedirectToAction("Create"));
        }
Ejemplo n.º 3
0
 public MemoData(double V, SubAssembly S)
 {
     Value = V;
     sa    = S;
     //Parents = new List<MemoData>();
     //Children = new List<MemoData>();
 }
Ejemplo n.º 4
0
 public ActionResult Edit(SubAssembly model)
 {
     try
     {
         model.OrganizationId = OrganizationId;
         model.CreatedDate    = System.DateTime.Now;
         model.CreatedBy      = UserID.ToString();
         string ref_no = new SubAssemblyRepository().UpdateSubAssembly(model);
         TempData["success"] = "Updated Successfully - " + ref_no;
         return(RedirectToAction("Index"));
     }
     catch (SqlException sx)
     {
         if (sx.Errors[0].Number == 547)
         {
             TempData["error"] = "Cannot update, because the record is in use elsewhere";
         }
         else
         {
             TempData["error"] = "Some error occured while connecting to database|" + sx.Message;
         }
     }
     catch (Exception ex)
     {
         TempData["error"] = "Some error occured while saving. Please try again.|" + ex.Message;
     }
     FillDropdowns();
     return(View("Create", model));
 }
Ejemplo n.º 5
0
        public SubAssembly GetSubAssembly(int id, int organizationId)
        {
            using (IDbConnection connection = OpenConnection(dataConnection))
            {
                try
                {
                    #region Get data from [StockCreation] head
                    string      query = @"SELECT
	                                StockCreationId,
	                                StockCreationRefNo,
	                                StockCreationDate,
	                                isSubAssembly,
	                                EmployeeId,
	                                WorkingHours,
                                    ConsumedStockpointId,
                                    FinishedStockpointId
                                FROM StockCreation
                                WHERE StockCreationId = @id
                                AND OrganizationId = @organizationId
                                AND isSubAssembly = 1
                                AND isActive = 1";
                    SubAssembly model = connection.Query <SubAssembly>(query, new { id = id, OrganizationId = organizationId }).First();
                    #endregion

                    #region Get data from [StockCreationConsumedItems]
                    query = @"SELECT
	                            ConsumedItemsId,
	                            StockCreationId,
	                            ItemId,
	                            Quantity,
	                            Rate
                            FROM StockCreationConsumedItems
                            WHERE StockCreationId = @id
                            AND isActive = 1";
                    model.ConsumedItems = connection.Query <StockCreationConsumedItem>(query, new { id = id }).ToList();
                    #endregion

                    #region Get data from [StockCreationFinishedGoods]
                    query = @"SELECT
	                            FinishedGoodsId,
	                            StockCreationId,
	                            ItemId,
	                            Quantity,
	                            Rate
                            FROM StockCreationFinishedGoods
                            WHERE StockCreationId = @id
                            AND isActive = 1";
                    model.FinishedGoods = connection.Query <StockCreationFinishedGood>(query, new { id = id }).ToList();
                    #endregion

                    return(model);
                }
                catch (Exception)
                {
                    return(new SubAssembly());
                }
            }
        }
Ejemplo n.º 6
0
        public JsonResult AddSubAssembly(SubAssembly SubAssembly)
        {
            var result = new { Success = "true", Message = "Success" };

            try
            {
                int siteId = this._SubAssemblyService.Add(SubAssembly);
            }
            catch (Exception ex)
            {
                result = new { Success = "false", Message = "Problem in adding SubAssembly.Please contact Admin." };
            }
            //return View("List");
            return(Json(result, JsonRequestBehavior.AllowGet));
        }
        /// <summary>
        /// Default constructor
        /// </summary>
        /// <param name="assemblyItem"></param>
        public FactorioAssembly(FactorioItem assemblyItem)
        {
            AssemblyItem = assemblyItem;

            Quantity = 1;

            if (assemblyItem.Recipe == null)
            {
                return;
            }

            foreach (var item in assemblyItem.Recipe)
            {
                SubAssembly.Add(new FactorioAssembly(item.Key, this, item.Value));
            }
        }
        public void GetSubAssemblyDetails_Should_Succeed()
        {
            var subAssembly = new SubAssembly()
            {
                Id         = "1",
                AssemblyId = "1",
                Name       = "subasdas",
                Quantity   = 2,
                Weight     = 3.50
            };

            this.Context.SubAssemblies.Add(subAssembly);
            this.Context.SaveChanges();

            var result = this.subAssemblyService.GetSubAssemblyDetails(subAssembly.Id);

            result.Should().NotBeNull()
            .And.BeOfType <SubAssemblyDetailsOutputModel>();
        }
Ejemplo n.º 9
0
        public void CreatePart_Should_Succeed()
        {
            var subAssembly = new SubAssembly()
            {
                Id       = "1",
                Name     = "aasdasd",
                Quantity = 1,
                Weight   = 1
            };

            var vendor = new Vendor()
            {
                Id   = "1",
                Name = "vendor"
            };

            this.Context.SubAssemblies.Add(subAssembly);
            this.Context.Vendors.Add(vendor);
            this.Context.SaveChanges();

            var partInputModel = new PartInputModel
            {
                Name          = "part1",
                Price         = 2.50m,
                Quantity      = 2,
                SubAssemblyId = subAssembly.Id,
                VendorName    = vendor.Name
            };

            var result = this.partService.Create(partInputModel).GetAwaiter().GetResult();

            var part = this.Context.Parts.First();

            result.Should().NotBeNull();
            part.Should().NotBeNull()
            .And.Subject.Should().BeEquivalentTo(new
            {
                Id       = result,
                ImageUrl = GlobalConstants.NoImageAvailableUrl,
                Name     = partInputModel.Name
            }, options => options.ExcludingMissingMembers());
        }
Ejemplo n.º 10
0
        public void GetById_Should_Succeed()
        {
            var subAssembly = new SubAssembly()
            {
                Id         = "1",
                AssemblyId = "1",
                Name       = "subasdas",
                Quantity   = 2,
                Weight     = 3.50
            };

            this.Context.SubAssemblies.Add(subAssembly);
            this.Context.SaveChanges();

            var result = this.subAssemblyService.GetById(subAssembly.Id);

            result.Should().NotBeNull()
            .And.Subject.As <SubAssembly>()
            .Name.Should().Be(subAssembly.Name);
        }
        /// <summary>
        /// Constructor for subassemblies
        /// </summary>
        /// <param name="assemblyItem"></param>
        /// <param name="topAssembly"></param>
        /// <param name="quantity"></param>
        public FactorioAssembly(FactorioItem assemblyItem, FactorioAssembly topAssembly, int quantity)
        {
            AssemblyItem = assemblyItem;

            ItemQuantity = quantity;

            m_topAssembly = topAssembly;

            Quantity = (quantity * ((topAssembly.Quantity * topAssembly.AssemblyItem.Productivity)) / (assemblyItem.Productivity * topAssembly.AssemblyItem.CraftingOutput));

            Quantity *= topAssembly.CraftingSpeed / CraftingSpeed;

            if (assemblyItem.Recipe != null)
            {
                foreach (var item in assemblyItem.Recipe)
                {
                    SubAssembly.Add(new FactorioAssembly(item.Key, this, item.Value));
                }
            }
        }
Ejemplo n.º 12
0
        public string CreateSubAssembly(SubAssembly model)
        {
            using (IDbConnection connection = OpenConnection(dataConnection))
            {
                IDbTransaction txn = connection.BeginTransaction();
                try
                {
                    model.StockCreationRefNo = DatabaseCommonRepository.GetNewDocNo(connection, model.OrganizationId, 26, true, txn);

                    int id = Create(model, connection, txn);

                    InsertLoginHistory(dataConnection, model.CreatedBy, "Create", "Sub-assembly", id.ToString(), model.OrganizationId.ToString());
                    txn.Commit();
                    return(model.StockCreationRefNo);
                }
                catch (Exception)
                {
                    txn.Rollback();
                    throw;
                }
            }
        }
Ejemplo n.º 13
0
        public void AddOrUpdate(List <ProductDto> productDTOList)
        {
            var productList = ctx.Product.Include(s => s.SubAssembly).Where(o => o.JobID == productDTOList[1].JobID).ToList();

            //remove deleted products -
            productList
            .Where(d => !productDTOList.Any(dto => dto.ProductID == d.ProductID)).ToList()
            .ForEach(deleted => ctx.Product.Remove(deleted));

            productDTOList.ToList().ForEach(ad =>
            {
                var product = ctx.Product.Include(s => s.SubAssembly).FirstOrDefault(r => r.ProductID == ad.ProductID);
                if (product == null)
                {
                    product = new Product();
                    ctx.Product.Add(product);
                }

                product.JobID           = ad.JobID;
                product.ArchDescription = ad.ArchDescription;
                product.UnitID          = ad.UnitID;
                product.UnitName        = ad.UnitName;
                product.RoomName        = ad.RoomName;
                product.ProductionDate  = ad.ProductionDate;
                product.W             = ad.W.GetValueOrDefault();
                product.H             = ad.H.GetValueOrDefault();
                product.D             = ad.D.GetValueOrDefault();
                product.Delivered     = ad.Delivered.GetValueOrDefault();
                product.DeliveredDate = ad.DeliveryDate;
                product.Make          = ad.Make;
                product.NIC           = ad.NIC;

                //remove deleted subassemblies -
                product.SubAssembly
                .Where(d => !ad.SubAssemblies.Any(SubAssemblyDTO => SubAssemblyDTO.SubAssemblyID == d.SubAssemblyID)).ToList()
                .ForEach(deleted => ctx.SubAssembly.Remove(deleted));

                //update or add SubAssembly --
                ad.SubAssemblies.ToList().ForEach(od =>
                {
                    var subassembly = product.SubAssembly.FirstOrDefault(r => r.SubAssemblyID == od.SubAssemblyID);
                    if (subassembly == null)
                    {
                        subassembly = new SubAssembly();
                        product.SubAssembly.Add(subassembly);
                    }
                    subassembly.ProductID       = od.ProductID;
                    subassembly.SubAssemblyName = od.SubAssemblyName;
                    subassembly.MakeFile        = od.MakeFile;
                    subassembly.W           = od.W;
                    subassembly.H           = od.H;
                    subassembly.D           = od.D;
                    subassembly.GlassPartID = od.GlassPartID;
                    subassembly.CPD_id      = od.CPD_ID;
                });
            });



            ctx.SaveChanges();
        }
Ejemplo n.º 14
0
        public void DeleteRobot_Should_Succeed_With_All_Of_The_Nested_Classes()
        {
            var admin = new User()
            {
                Id       = "123",
                Name     = "Papuncho Kunchev",
                UserName = "******"
            };
            var user = new User()
            {
                Id       = "321",
                Name     = "Kuncho Papunchev",
                UserName = "******"
            };

            var robot = new Robot()
            {
                Id           = "1",
                UserId       = user.Id,
                Axes         = 2,
                Name         = "myRobot",
                SerialNumber = "2323"
            };

            var assembly = new Assembly()
            {
                Id      = "1",
                RobotId = robot.Id
            };

            var subAssembly = new SubAssembly()
            {
                AssemblyId = assembly.Id,
                Id         = "1",
                Quantity   = 1,
                Weight     = 1,
                Name       = "Motherboard"
            };

            var vendor = new Vendor()
            {
                Id   = "1",
                Name = "IBM"
            };

            var part = new Part()
            {
                Id            = "1",
                Price         = 2.50m,
                Quantity      = 2,
                SubAssemblyId = subAssembly.Id,
                VendorId      = vendor.Id
            };

            userManager.CreateAsync(admin).GetAwaiter();
            userManager.CreateAsync(user).GetAwaiter();

            var role = new IdentityRole {
                Name = "admin"
            };

            roleManager.CreateAsync(role).GetAwaiter();
            userManager.AddToRoleAsync(admin, role.Name).GetAwaiter();

            this.Context.Robots.Add(robot);
            this.Context.Assemblies.Add(assembly);
            this.Context.SubAssemblies.Add(subAssembly);
            this.Context.Parts.Add(part);
            this.Context.Vendors.Add(vendor);
            this.Context.SaveChanges();

            robotService.DeleteRobot(robot.Id, admin.UserName);

            var result = this.Context.Robots.FirstOrDefault();

            result.Should().BeNull();
        }
Ejemplo n.º 15
0
 public SubAssemblyView(SubAssembly subA)
 {
     this.subA = subA;
     subAssemController();
 }
        public static void GetTimeAndSD(SubAssembly sub, double[] testpoints, string actionname, out double time,
                                        out double SD)
        {
            time = 0;
            SD   = 0;
            var inputdictionary = new Dictionary <List <double[]>, List <double[, ]> >();

            double[,] subinputs;
            double[] userx;
            double   usery, subtime, subsd;
            var      userfeedbacks = new List <double[]>();

            if (actionname.StartsWith("S") || actionname.StartsWith("s"))
            {
                userfeedbacks   = usersecuredata;
                inputdictionary = SecureDictionary;
                Gethistoricaldata(testpoints, userfeedbacks, out usery);
                //   usery = -1; // disable userfeedback
                if (usery != -1)
                {
                    time = usery;
                    SD   = 0;
                }
                else
                {
                    foreach (var otherf in sub.Secure.Fasteners)
                    {
                        if (otherf.SecureModelInputs != null)
                        {
                            if (EvaluationForBinaryTree.IsSameImputs(testpoints, otherf.SecureModelInputs) && otherf.Time > 0.001)
                            //if time is included in subassembly
                            {
                                time = otherf.Time;
                                SD   = 0;
                                break;
                            }
                            else
                            {
                                TimeAndSD(testpoints, inputdictionary, userfeedbacks, out time, out SD);
                                break;
                            }
                        }
                    }
                }
            }
            else
            {
                if (actionname.StartsWith("m") || actionname.StartsWith("M"))
                {
                    userfeedbacks   = usermovedata;
                    inputdictionary = MoveDictionary;
                    subinputs       = sub.MoveRoateModelInputs;
                    subtime         = sub.MoveRoate.Time;
                    subsd           = sub.MoveRoate.TimeSD;
                }
                else if (actionname.StartsWith("i") || actionname.StartsWith("I"))
                {
                    userfeedbacks   = userinstalldata;
                    inputdictionary = InstallDictionary;
                    subinputs       = sub.InstallModelInputs;
                    subtime         = sub.Install.Time;
                    subsd           = sub.Install.TimeSD;
                }
                else
                {
                    userfeedbacks   = userrotatedata;
                    inputdictionary = RotateDictionary;
                    subinputs       = sub.RotateModelInputs;
                    subtime         = sub.Rotate.Time;
                    subsd           = sub.Rotate.TimeSD;
                }
                Gethistoricaldata(testpoints, userfeedbacks, out usery);
                //  usery = -1; // disable userfeedback
                if (usery != -1)
                {
                    time = usery;
                    SD   = 0;
                    if (actionname.StartsWith("i") && time > 2.9 && time < 3.01)
                    {
                        var sss = 1;
                    }
                }
                else
                {
                    if (EvaluationForBinaryTree.IsSameImputs(testpoints, subinputs) && subtime != 0)
                    //if time is included in subassembly
                    {
                        time = subtime;
                        SD   = subsd;
                        if (actionname.StartsWith("i") && time > 2.9 && time < 3.01)
                        {
                            var sss = 1;
                        }
                    }
                    else
                    {
                        TimeAndSD(testpoints, inputdictionary, userfeedbacks, out time, out SD);
                        if (actionname.StartsWith("i") && time > 2.9 && time < 3.01)
                        {
                            var sss = 1;
                        }
                    }
                }
            }
        }
Ejemplo n.º 17
0
        private int Create(SubAssembly model, IDbConnection connection, IDbTransaction txn)
        {
            try
            {
                #region Inserting into [StockCreation] head
                string query = @"INSERT INTO StockCreation
                                    (
	                                    StockCreationRefNo,
	                                    StockCreationDate,
                                        isSubAssembly,
                                        EmployeeId,
                                        WorkingHours,
                                        CreatedBy,
                                        CreatedDate,
                                        OrganizationId,
                                        ConsumedStockpointId,
                                        FinishedStockpointId
                                    )
                                    VALUES
                                    (
                                        @StockCreationRefNo,
	                                    @StockCreationDate,
	                                    1,
                                        @EmployeeId,
                                        @WorkingHours,
                                        @CreatedBy,
                                        @CreatedDate,
                                        @OrganizationId,
                                        @ConsumedStockpointId,
                                        @FinishedStockpointId
                                    );
                                    SELECT CAST(SCOPE_IDENTITY() AS INT)";

                int id = connection.Query <int>(query, model, txn).First();
                #endregion

                #region Inserting Finished Goods + Stock Updation
                foreach (var item in model.FinishedGoods)
                {
                    item.StockCreationId = id;
                    var i = new StockCreationFinishedGoodsRepository().InsertFinishedGoods(item, connection, txn);
                    new StockUpdateRepository().InsertStockUpdate(new StockUpdate
                    {
                        OrganizationId = model.OrganizationId,
                        CreatedBy      = model.CreatedBy,
                        CreatedDate    = model.CreatedDate,
                        StockPointId   = model.FinishedStockpointId,
                        StockType      = typeof(SubAssembly).Name,
                        StockInOut     = "IN",
                        stocktrnDate   = System.DateTime.Today,
                        ItemId         = item.ItemId,
                        Quantity       = item.Quantity,
                        StocktrnId     = id,
                        StockUserId    = model.StockCreationRefNo
                    }, connection, txn);
                }
                #endregion

                #region Inserting Consumed Items + Stock Updation
                foreach (var item in model.ConsumedItems)
                {
                    item.StockCreationId = id;
                    var i = new StockCreationConsumedItemsRepository().InsertConsumedItems(item, connection, txn);
                    new StockUpdateRepository().InsertStockUpdate(new StockUpdate
                    {
                        OrganizationId = model.OrganizationId,
                        CreatedBy      = model.CreatedBy,
                        CreatedDate    = model.CreatedDate,
                        StockPointId   = model.ConsumedStockpointId,
                        StockType      = typeof(SubAssembly).Name,
                        StockInOut     = "OUT",
                        stocktrnDate   = System.DateTime.Today,
                        ItemId         = item.ItemId,
                        Quantity       = item.Quantity * (-1),
                        StocktrnId     = id,
                        StockUserId    = model.StockCreationRefNo
                    }, connection, txn);
                }
                #endregion

                return(id);
            }
            catch (Exception)
            {
                throw;
            }
        }