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