public int UpdateCheckingScrap(SqlConnection connection, CheckingScrapViewModel user) { int result = 0; using (var command = new SqlCommand("ins_CheckingScrap_Update " + "@CheckingScrapId," + "@OutHourGuard," + "@OutGateId," + "@User5Id," + "@IsDone," + "@Step" , connection)) { AddSqlParameter(command, "@CheckingScrapId", user.CheckingScrapId, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@OutHourGuard", user.OutHourGuard, System.Data.SqlDbType.DateTime); AddSqlParameter(command, "@OutGateId", user.OutGateId, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@User5Id", user.User5Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@IsDone", user.IsDone, System.Data.SqlDbType.Bit); AddSqlParameter(command, "@Step", user.Step, System.Data.SqlDbType.Int); WriteLogExecutingCommand(command); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var info = new GateViewModel(); result = GetDbReaderValue <int>(reader["result"]); } } } return(result); }
public void FilterGates(object sender, ListChangedEventArgs e) { FilteredGates.Clear(); CategoryQueryBilder qb = new CategoryQueryBilder(); foreach (CheckedCategory cc in Categories) { if (cc.Checked) { qb.Categories.Add(cc.Category); } } SQLiteCommand com = new SQLiteCommand(SQLiteCon); com.CommandText = qb.Query; SQLiteDataReader r = com.ExecuteReader(); while (r.Read()) { string name = r.GetString(0); int inpNumber = r.GetInt32(1); string function = r.GetString(2); Gate g = new Gate(name, inpNumber, function); GateViewModel gvm = new GateViewModel(g); FilteredGates.Add(gvm); } }
public async Task <bool> StartJump(GateViewModel gateViewModel, MyPlayer player, MyCubeGrid grid) { MyVisualScriptLogicProvider.ShowNotification("Opening the gate...", (int)TimeSpan.FromSeconds(4).TotalMilliseconds, playerId: player.Identity.IdentityId); _effectsManager.NotifyJumpStatusChanged(JumpStatus.Started, gateViewModel, grid); await Task.Delay(TimeSpan.FromSeconds(12)); return(true); }
private void SelectGate(GateViewModel gvm) { Deselect(); foreach (GateViewModelWithCoordinates gvmwc in GateList) { if (gvmwc.gateViewModel == gvm) { SelectedGateViewModelWithCoordinates = gvmwc; break; } } }
private GateViewModel MapGateToViewModel(GateDto dto) { if (dto == null) { return(null); } var viewModel = new GateViewModel { GateId = dto.GateId, Name = dto.Name }; return(viewModel); }
public List <GateViewModel> GetGateList(SqlConnection connection) { var result = new List <GateViewModel>(); using (var command = new SqlCommand("exec Ins_GateModel_GetGateList", connection)) { using (var reader = command.ExecuteReader()) { while (reader.Read()) { var info = new GateViewModel(); info.GateId = GetDbReaderValue <string>(reader["GateCode"]); info.GateName = GetDbReaderValue <string>(reader["GateName"]); result.Add(info); } } return(result); } }
public int InsertCheckingScrap(SqlConnection connection, CheckingScrapViewModel user) { int result = 0; using (var command = new SqlCommand("EXEC Ins_CheckingScrap_Insert " + "@CheckingScrapId," + "@ScaleTicketId," + "@ScaleTicketMobileId," + "@RFID," + "@InHourGuard," + "@OutHourGuard," + "@GiaoNhan," + "@VehicleNumber," + "@DriverName," + "@DriverIdCard," + "@IsVehicleNew," + "@InGateId," + "@OutGateId," + "@ReceiveType," + "@User1Id," + "@Note1," + "@User2Id," + "@User3Id," + "@Note3," + "@CheckingTime," + "@User4Id," + "@VerifyTime," + "@User5Id," + "@Status," + "@Actived," + "@IsDone," + "@Step" , connection)) { AddSqlParameter(command, "@CheckingScrapId", user.CheckingScrapId, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@ScaleTicketId", user.ScaleTicketId, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@ScaleTicketMobileId", user.ScaleTicketMobileId, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@RFID", user.RFID, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@InHourGuard", user.InHourGuard, System.Data.SqlDbType.DateTime); AddSqlParameter(command, "@OutHourGuard", user.OutHourGuard, System.Data.SqlDbType.DateTime); AddSqlParameter(command, "@GiaoNhan", user.GiaoNhan, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@VehicleNumber", user.VehicleNumber, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@DriverName", user.DriverName, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@DriverIdCard", user.DriverIdCard, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@IsVehicleNew", user.IsVehicleNew, System.Data.SqlDbType.Bit); AddSqlParameter(command, "@InGateId", user.InGateId, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@OutGateId", user.OutGateId, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@ReceiveType", user.ReceiveType, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@User1Id", user.User1Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@Note1", user.Note1, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@User2Id", user.User2Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@User3Id", user.User3Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@Note3", user.Note3, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@CheckingTime", user.CheckingTime, System.Data.SqlDbType.DateTime); AddSqlParameter(command, "@User4Id", user.User4Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@VerifyTime", user.VerifyTime, System.Data.SqlDbType.DateTime); AddSqlParameter(command, "@User5Id", user.User5Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@Status", user.Status, System.Data.SqlDbType.Int); AddSqlParameter(command, "@Actived", user.Actived, System.Data.SqlDbType.Bit); AddSqlParameter(command, "@IsDone", user.IsDone, System.Data.SqlDbType.Bit); AddSqlParameter(command, "@Step", user.Step, System.Data.SqlDbType.Int); WriteLogExecutingCommand(command); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var info = new GateViewModel(); result = GetDbReaderValue <int> (reader["result"]); } } } return(result); }
public async Task Jump(GateViewModel gateViewModel, MyCubeGrid grid) { _effectsManager.NotifyJumpStatusChanged(JumpStatus.Ready, gateViewModel, grid); await Task.Delay(TimeSpan.FromSeconds(3)); }
public GateViewModelWithCoordinates(GateViewModel gvm, int x, int y) { gateViewModel = gvm; X = x; Y = y; }
public DestinationsEditor(GateViewModel gateViewModel) : this() { DataContext = gateViewModel; _viewModel = gateViewModel; }
private void Select(GateViewModel gvm) { SelectedGateViewModel = gvm; }