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));
}
