public void IsScheduleAvailable(string machineNumber, string schedule) { bool scheduleAassigned = false; SqlConnection connection = new SqlConnection(connectionString); string query = "spIsScheduleAvailable"; SqlCommand command = new SqlCommand(query, connection) { CommandType = CommandType.StoredProcedure }; command.Parameters.Add(new SqlParameter() { ParameterName = "@MachineNumber", Value = machineNumber }); command.Parameters.Add(new SqlParameter() { ParameterName = "@Schedule", Value = schedule }); connection.Open(); scheduleAassigned = Convert.ToBoolean(command.ExecuteScalar()); MachineOperator machineOperator = new MachineOperator(); machineOperator.MachineNumber = machineNumber; machineOperator.Schedule = schedule; machineOperator.ScheduleAssigned = scheduleAassigned; JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(machineOperator)); }
public void GetAllMachineOperators() { List <MachineOperator> listMachineOperators = new List <MachineOperator>(); SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM MachineOperator"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { MachineOperator machineOperator = new MachineOperator() { MachineOperatorId = Convert.ToInt32(reader["MachineOperatorId"]), EmployeeCode = reader["EmployeeCode"].ToString(), EmployeeName = reader["EmployeeName"].ToString(), EffectDate = Convert.ToDateTime(reader["EffectDate"]), Schedule = reader["Schedule"].ToString(), MachineNumber = reader["MachineNumber"].ToString() }; listMachineOperators.Add(machineOperator); } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(listMachineOperators)); }
public async Task <IActionResult> Edit(int id, [Bind("ID,MachineId,MOperatorId")] MachineOperator machineOperator) { if (id != machineOperator.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(machineOperator); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MachineOperatorExists(machineOperator.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["MachineId"] = new SelectList(_context.Machines, "MachineId", "MachineId", machineOperator.MachineId); ViewData["MOperatorId"] = new SelectList(_context.Operators, "MOperatorId", "MOperatorId", machineOperator.MOperatorId); return(View(machineOperator)); }
internal void SeedDemoData(IEnumerable <string> demoUserIds) { Console.WriteLine("Seeding Demo DB..."); // Demo data var machine1 = new Machine { Name = "M1", Location = "A-100", StartOperation = DateTime.Now }; var machine2 = new Machine { Name = "M2", Location = "M-101", StartOperation = DateTime.Now }; var device1 = new Device { Name = "BG A" }; var device2 = new Device { Name = "BG B" }; var device3 = new Device { Name = "MM 3" }; repMachine.InsertOrUpdate(new[] { machine1, machine2 }); var v1 = new DataValue { Value = 123.5, Unit = "V" }; var v2 = new DataValue { Value = 43, Unit = "V" }; var v3 = new DataValue { Value = 230, Unit = "V" }; var v4 = new DataValue { Value = 380, Unit = "V" }; var v5 = new DataValue { Value = 0.005, Unit = "A" }; device1.DataValues.Add(v1); device1.DataValues.Add(v2); device2.DataValues.Add(v3); device2.DataValues.Add(v4); device2.DataValues.Add(v5); repDevice.InsertOrUpdate(new[] { device1, device2, device3 }); var mo1 = new MachineOperator { UserId = demoUserIds.First() }; mo1.OperatedMachines.Add(machine1); mo1.OperatedMachines.Add(machine2); repOperators.InsertOrUpdate(mo1); }
public async Task <IActionResult> Create([Bind("ID,MachineId,MOperatorId")] MachineOperator machineOperator) { if (ModelState.IsValid) { _context.Add(machineOperator); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["MachineId"] = new SelectList(_context.Machines, "MachineId", "MachineId", machineOperator.MachineId); ViewData["MOperatorId"] = new SelectList(_context.Operators, "MOperatorId", "MOperatorId", machineOperator.MOperatorId); return(View(machineOperator)); }
public void SaveMachineOperator(MachineOperator machineOperator) { SqlConnection connection = new SqlConnection(connectionString); string query = "spInsertMachineOperator"; SqlCommand command = new SqlCommand(query, connection) { CommandType = CommandType.StoredProcedure }; command.Parameters.Add(new SqlParameter() { ParameterName = "@EmployeeCode", Value = machineOperator.EmployeeCode }); command.Parameters.Add(new SqlParameter() { ParameterName = "@EmployeeName", Value = machineOperator.EmployeeName }); command.Parameters.Add(new SqlParameter() { ParameterName = "@EffectDate", Value = machineOperator.EffectDate }); command.Parameters.Add(new SqlParameter() { ParameterName = "@Schedule", Value = machineOperator.Schedule }); command.Parameters.Add(new SqlParameter() { ParameterName = "@MachineNumber", Value = machineOperator.MachineNumber }); connection.Open(); command.ExecuteNonQuery(); }
private void OnGameEighthUpdate() { if (Game1.currentGameTime == null) { return; } if (Conf.CloseTreasureWhenAllLooted && Game1.activeClickableMenu is ItemGrabMenu menu) { InventoryAutomation.TryCloseItemGrabMenu(menu); } if (!Context.IsWorldReady || !Context.IsPlayerFree) { return; } Farmer player = Game1.player; GameLocation location = Game1.currentLocation; try { if (Conf.AutoReelRod) { AutoFisher.AutoReelRod(); } if (Game1.currentLocation is MineShaft shaft) { bool isFallingDownShaft = InstanceHolder.Reflection.GetField <bool>(shaft, "isFallingDownShaft").GetValue(); if (isFallingDownShaft) { return; } } if (!Context.CanPlayerMove) { return; } if (Conf.UnifyFlowerColors) { FlowerColorUnifier.UnifyFlowerColors(); } _ticks = (_ticks + 1) % 8; if (Conf.BalancedMode && _ticks != 0) { return; } FarmCleaner.OnEighthUpdate(); if (Conf.AutoEat) { FoodAutomation.TryToEatIfNeeded(player); } if (Conf.AutoPickUpTrash) { TrashCanScavenger.ScavengeTrashCan(); } if (Conf.AutoWaterNearbyCrops) { HarvestAutomation.WaterNearbyCrops(); } if (Conf.AutoPetNearbyAnimals) { AnimalAutomation.PetNearbyAnimals(); } if (Conf.AutoShearingAndMilking) { AnimalAutomation.ShearingAndMilking(player); } if (Conf.AutoPullMachineResult) { MachineOperator.PullMachineResult(); } if (Conf.AutoDepositIngredient) { MachineOperator.DepositIngredientsToMachines(); } if (Conf.AutoHarvest) { HarvestAutomation.HarvestNearbyCrops(player); } if (Conf.AutoDestroyDeadCrops) { HarvestAutomation.DestroyNearDeadCrops(player); } if (Conf.AutoRefillWateringCan) { WateringCanRefiller.RefillWateringCan(); } if (Conf.AutoCollectCollectibles) { CollectibleCollector.CollectNearbyCollectibles(location); } if (Conf.AutoDigArtifactSpot) { ArtifactSpotDigger.DigNearbyArtifactSpots(); } if (Conf.AutoShakeFruitedPlants) { HarvestAutomation.ShakeNearbyFruitedTree(); HarvestAutomation.ShakeNearbyFruitedBush(); } if (Conf.AutoAnimalDoor && !DayEnded && Game1.timeOfDay >= 1900) { DayEnded = true; EventHolder.Save.OnBeforeSave(null, null); } if (Conf.AutoPetNearbyPets) { AnimalAutomation.PetNearbyPets(); } } catch (Exception ex) { Logger.Error(ex.Source); Logger.Error(ex.ToString()); } }
public double CalcSalary(MachineOperator _operator) { _emp = new Employee(); _emp.BasicSalary = _operator.BasicSalary; return(base.CalcSalary(_emp)); }