public Probe(int position_X, int position_Y, char facingDirection, Highland highland) { Position_X = position_X; Position_Y = position_Y; FacingDirection = facingDirection; Highland = highland; }
public List <string> ValidateBeforeLaunch() { var probeLaunchJson = JObject.Parse(Json.ToString()); var highlander = probeLaunchJson["highland"].ToString().Split(' '); var probe = probeLaunchJson["probe"].ToObject <List <ProbeLaunchDTO> >(); Highland highland = new Highland(int.Parse(highlander[0]), int.Parse(highlander[1])); List <ProbeLaunchDTO> probeList = new List <ProbeLaunchDTO>(); foreach (var p in probe) { ProbeLaunchDTO pp = new ProbeLaunchDTO( p.Position_X, p.Position_Y, p.FacingDirection, highland, p.Moves ); probeList.Add(pp); } var launch = new Launch(probeList); return(launch.ProbeLaunch()); }
public ProbeLaunchDTO(int position_X, int position_Y, char facingDirection, Highland highland, string moves) : base(position_X, position_Y, facingDirection, highland) { Moves = moves; }
protected void Button1_Click(object sender, EventArgs e) { try { string confirmValue = Request.Form["confirm_value"]; if (confirmValue != "Yes") { return; } /* * <asp:ListItem Text ="Alleghany"></asp:ListItem> * <asp:ListItem Text ="Augusta"></asp:ListItem> * <asp:ListItem Text ="Bath"></asp:ListItem> * <asp:ListItem Text ="Botetourt"></asp:ListItem> * <asp:ListItem Text ="BuenaVista"></asp:ListItem> * <asp:ListItem Text ="Craig"></asp:ListItem> * <asp:ListItem Text ="Highland"></asp:ListItem> * <asp:ListItem Text ="LexingtonRockbridge"></asp:ListItem> * <asp:ListItem Text ="Staunton"></asp:ListItem> * <asp:ListItem Text ="Waynesboro"></asp:ListItem> * * <asp:ListItem Text ="General District"></asp:ListItem> * <asp:ListItem Text ="Juvenile and Domestic Relations"></asp:ListItem> * <asp:ListItem Text ="Circuit"></asp:ListItem> */ String[] CountyNames = new String[10] { "Alleghany", "Augusta", "Bath", "Botetourt", "BuenaVista", "Craig", "Highland", "LexingtonRockbridge", "Staunton", "Waynesboro" }; String[] CourtNames = new String[3] { "General District", "Juvenile and Domestic Relations", "Circuit" }; String[] DateNames = new String[4] { "Return", "CrossOver", "EPO", "None" }; DateTime now = DateTime.Now; System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection(); sc.ConnectionString = @"Server =Localhost;Database=TeamProject;Trusted_Connection=Yes;"; sc.Open(); System.Data.SqlClient.SqlCommand insert = new System.Data.SqlClient.SqlCommand(); insert.Connection = sc; insert.CommandText = "IF OBJECT_ID('dbo.InfractionGroup6', 'U') IS NOT NULL DROP TABLE dbo.InfractionGroup6;"; insert.ExecuteNonQuery(); insert.CommandText = "IF OBJECT_ID('dbo.Reminder', 'U') IS NOT NULL DROP TABLE dbo.Reminder;"; insert.ExecuteNonQuery(); insert.CommandText = "IF OBJECT_ID('dbo.Officer', 'U') IS NOT NULL DROP TABLE dbo.Officer;"; insert.ExecuteNonQuery(); insert.CommandText = "IF OBJECT_ID('dbo.BasisGroup6', 'U') IS NOT NULL DROP TABLE dbo.BasisGroup6;"; insert.ExecuteNonQuery(); insert.CommandText = "IF OBJECT_ID('dbo.DateException', 'U') IS NOT NULL DROP TABLE dbo.DateException;"; insert.ExecuteNonQuery(); insert.CommandText = "IF OBJECT_ID('dbo.MonthException', 'U') IS NOT NULL DROP TABLE dbo.MonthException;"; insert.ExecuteNonQuery(); /* * insert.CommandText = "IF OBJECT_ID('dbo.CrossOverDate', 'U') IS NOT NULL DROP TABLE dbo.CrossOverDate;"; * insert.ExecuteNonQuery(); * * * insert.CommandText = "IF OBJECT_ID('dbo.EPODate', 'U') IS NOT NULL DROP TABLE dbo.EPODate;"; * insert.ExecuteNonQuery(); */ insert.CommandText = "IF OBJECT_ID('dbo.Holiday', 'U') IS NOT NULL DROP TABLE dbo.Holiday;"; insert.ExecuteNonQuery(); //SpecialException insert.CommandText = "IF OBJECT_ID('dbo.SpecialException', 'U') IS NOT NULL DROP TABLE dbo.SpecialException;"; insert.ExecuteNonQuery(); insert.CommandText = "IF OBJECT_ID('dbo.Exception', 'U') IS NOT NULL DROP TABLE dbo.Exception;"; insert.ExecuteNonQuery(); insert.CommandText = "IF OBJECT_ID('dbo.Jurisdiction', 'U') IS NOT NULL DROP TABLE dbo.Jurisdiction;"; insert.ExecuteNonQuery(); // insert.CommandText = "IF OBJECT_ID('dbo.ExtraContacts', 'U') IS NOT NULL DROP TABLE dbo.ExtraContacts;"; // insert.ExecuteNonQuery(); insert.CommandText = "IF OBJECT_ID('dbo.Contacts', 'U') IS NOT NULL DROP TABLE dbo.Contacts;"; insert.ExecuteNonQuery(); insert.CommandText = "IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[Holiday_CRUD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[Holiday_CRUD]"; insert.ExecuteNonQuery(); insert.CommandText = "IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[Officer_CRUD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[Officer_CRUD]"; insert.ExecuteNonQuery(); insert.CommandText = "IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[InfractionGroup6_CRUD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[InfractionGroup6_CRUD]"; insert.ExecuteNonQuery(); insert.CommandText = "IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_CRUD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[Login_CRUD]"; insert.ExecuteNonQuery(); insert.CommandText = "IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[Reminder_CRUD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[Reminder_CRUD]"; insert.ExecuteNonQuery(); insert.CommandText = "IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[SpecialException_CRUD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[SpecialException_CRUD]"; insert.ExecuteNonQuery(); insert.CommandText = "IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[Contacts_CRUD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [dbo].[Contacts_CRUD]"; insert.ExecuteNonQuery(); insert.CommandText = "CREATE TABLE [dbo].[Jurisdiction] (JurisdictionID int IDENTITY(1,1),County varchar(50) NOT NULL, Court varchar(50) NOT NULL, DateType varchar(50) NOT NULL, PRIMARY KEY (JurisdictionID));"; insert.ExecuteNonQuery(); insert.CommandText = "CREATE TABLE [dbo].[Exception] (ExceptionID int IDENTITY(1,1), WeekOfMonth int, DayOfWeek int, Time time(0), Valid int, OldValid int, BusinessDayMin int, BusinessDayMax int, JurisdictionID int, PRIMARY KEY (ExceptionID), foreign key (JurisdictionID) references Jurisdiction (JurisdictionID));"; insert.ExecuteNonQuery(); insert.CommandText = "CREATE TABLE [dbo].[BasisGroup6] (ID int IDENTITY(1,1), " + "WeekOfMonth int, DayOfWeek int, Valid int, EffectiveDate Date, Time time(0), JurisdictionID int, PRIMARY KEY (ID), foreign key (JurisdictionID) references Jurisdiction (JurisdictionID));"; insert.ExecuteNonQuery(); insert.CommandText = "create table [InfractionGroup6](ID int IDENTITY(1,1), FirstName varchar(50), LastName varchar(50), InfractionDate DateTime, Description varchar(200), County varchar(50) NOT NULL, Court varchar(50) NOT NULL, HearingDate DateTime, PRIMARY KEY (ID));"; insert.ExecuteNonQuery(); insert.CommandText = "CREATE TABLE [dbo].[DateException] (ID int IDENTITY(1,1), ExceptionID int, ExceptionType int NOT NULL, DayCount int, Time time(0), Valid int, PRIMARY KEY (ID), foreign key (ExceptionID) references Exception (ExceptionID));"; insert.ExecuteNonQuery(); insert.CommandText = "CREATE TABLE [dbo].[MonthException] (MonthExceptionID int IDENTITY(1,1), Month int NOT NULL, MonthExceptionValid int, Time time(0), ExceptionID int, PRIMARY KEY (MonthExceptionID), foreign key (ExceptionID) references Exception (ExceptionID));"; insert.ExecuteNonQuery(); /* * insert.CommandText = "CREATE TABLE [dbo].[CrossOverDate] (ID int IDENTITY(1,1), ExceptionID int, ExceptionType int NOT NULL, Valid int, PRIMARY KEY (ID), foreign key (ExceptionID) references Exception (ExceptionID));"; * insert.ExecuteNonQuery(); * * insert.CommandText = "CREATE TABLE [dbo].[EPODate] (ID int IDENTITY(1,1), ExceptionID int, , ExceptionType int NOT NULL, Valid int, PRIMARY KEY (ID), foreign key (ExceptionID) references Exception (ExceptionID));"; * insert.ExecuteNonQuery(); */ insert.CommandText = "CREATE TABLE [dbo].[Holiday] (HolidayID int IDENTITY(1,1), HolidayName varchar(50) NOT NULL, HolidayDate datetime NOT NULL, JurisdictionID int, PRIMARY KEY (HolidayID), foreign key (JurisdictionID) references Jurisdiction (JurisdictionID));"; insert.ExecuteNonQuery(); insert.CommandText = "CREATE TABLE [dbo].[Officer] (OfficerID int IDENTITY(1,1), FirstName varchar(50) NOT NULL, LastName varchar(50) NOT NULL, OfficerType varchar(50) NOT NULL, OfficerDate datetime NOT NULL, JurisdictionID int, PRIMARY KEY (OfficerID), foreign key (JurisdictionID) references Jurisdiction (JurisdictionID));"; insert.ExecuteNonQuery(); insert.CommandText = "CREATE TABLE [dbo].[Reminder] (ReminderID int IDENTITY(1,1), Description nvarchar(MAX) NOT NULL, JurisdictionID int, PRIMARY KEY (ReminderID), foreign key (JurisdictionID) references Jurisdiction (JurisdictionID));"; insert.ExecuteNonQuery(); insert.CommandText = "CREATE TABLE [dbo].[SpecialException] (SpecialExceptionID int IDENTITY(1,1), SpecialExceptionName varchar(50) NOT NULL, SpecialExceptionDate datetime NOT NULL, JurisdictionID int, PRIMARY KEY (SpecialExceptionID), foreign key (JurisdictionID) references Jurisdiction (JurisdictionID));"; insert.ExecuteNonQuery(); insert.CommandText = "create table Contacts (ContactsID int IDENTITY(1,1), Department nvarchar(MAX), PersonName nvarchar(MAX), Location nvarchar(MAX), Address nvarchar(MAX), Phone varchar(50), Phone2 varchar(50), Fax varchar(50), Fax2 varchar(50), County varchar(50) NOT NULL, PRIMARY KEY (ContactsID));"; insert.ExecuteNonQuery(); // insert.CommandText = "CREATE TABLE [dbo].[ExtraContacts] (ExtraContactsID int IDENTITY(1,1), PersonName varchar(50), PolyCom varchar(200), IP varchar(50), ContactsID int, PRIMARY KEY (ExtraContactsID), foreign key (ContactsID) references Contacts (ContactsID));"; // insert.ExecuteNonQuery(); insert.CommandText = @"CREATE PROCEDURE [dbo].[Holiday_CRUD] @Action VARCHAR(10) ,@HolidayID INT = NULL ,@HolidayName VARCHAR(100) = NULL ,@HolidayDate datetime = NULL ,@County VARCHAR(100) = NULL ,@Court VARCHAR(100) = NULL ,@JurisdictionID INT = NULL AS BEGIN SET NOCOUNT ON; --SELECTALL IF @Action = 'SELECTALL' BEGIN SELECT hd.HolidayID, hd.HolidayName, hd.HolidayDate, ju.County, ju.Court from Holiday as hd, Jurisdiction as ju where ju.JurisdictionID = hd.JurisdictionID END --SELECT One IF @Action = 'SELECT' BEGIN SELECT hd.HolidayID, hd.HolidayName, hd.HolidayDate, ju.County, ju.Court from Holiday as hd, Jurisdiction as ju where ju.JurisdictionID = hd.JurisdictionID AND County = @County And Court = @Court; END --UPDATE IF @Action = 'UPDATE' BEGIN UPDATE Holiday SET HolidayName = @HolidayName, HolidayDate = @HolidayDate , JurisdictionID = @JurisdictionID WHERE HolidayID = @HolidayID END --DELETE IF @Action = 'DELETE' BEGIN DELETE FROM Holiday WHERE HolidayID = @HolidayID END END"; insert.ExecuteNonQuery(); insert.CommandText = @"CREATE PROCEDURE [dbo].[Officer_CRUD] @Action VARCHAR(10) ,@OfficerID INT = NULL ,@FirstName VARCHAR(100) = NULL ,@LastName VARCHAR(100) = NULL ,@OfficerType VARCHAR(100) = NULL ,@OfficerDate datetime = NULL ,@County VARCHAR(100) = NULL ,@Court VARCHAR(100) = NULL ,@JurisdictionID INT = NULL AS BEGIN SET NOCOUNT ON; --SELECTALL IF @Action = 'SELECTALL' BEGIN SELECT op.OfficerID, op.FirstName, op.LastName, op.OfficerType, op.OfficerDate, ju.County, ju.Court from Officer as op, Jurisdiction as ju where ju.JurisdictionID = op.JurisdictionID END --SELECT One IF @Action = 'SELECT' BEGIN SELECT op.OfficerID, op.FirstName, op.LastName, op.OfficerType, op.OfficerDate, ju.County, ju.Court from Officer as op, Jurisdiction as ju where ju.JurisdictionID = op.JurisdictionID AND County = @County And Court = @Court; END --UPDATE IF @Action = 'UPDATE' BEGIN UPDATE Officer SET FirstName = @FirstName, LastName = @LastName, OfficerType = @OfficerType , OfficerDate = @OfficerDate , JurisdictionID = @JurisdictionID WHERE OfficerID = @OfficerID END --DELETE IF @Action = 'DELETE' BEGIN DELETE FROM Officer WHERE OfficerID = @OfficerID END END"; insert.ExecuteNonQuery(); insert.CommandText = @"CREATE PROCEDURE [dbo].[InfractionGroup6_CRUD] @Action VARCHAR(10) ,@ID INT = NULL ,@FirstName VARCHAR(100) = NULL ,@LastName VARCHAR(100) = NULL ,@InfractionDate datetime = NULL ,@Description VARCHAR(100) = NULL ,@County VARCHAR(100) = NULL ,@Court VARCHAR(100) = NULL ,@HearingDate datetime = NULL ,@BasisID INT = NULL AS BEGIN SET NOCOUNT ON; --SELECTALL IF @Action = 'SELECTALL' BEGIN SELECT * FROM [InfractionGroup6]; END --SELECT One IF @Action = 'SELECT' BEGIN SELECT * FROM [InfractionGroup6] WHERE County = @County And Court = @Court; END --UPDATE IF @Action = 'UPDATE' BEGIN UPDATE InfractionGroup6 SET FirstName = @FirstName, LastName = @LastName, InfractionDate = @InfractionDate , Description = @Description , County = @County, Court = @Court , HearingDate = @HearingDate WHERE ID = @ID END --DELETE IF @Action = 'DELETE' BEGIN DELETE FROM InfractionGroup6 WHERE ID = @ID END END"; insert.ExecuteNonQuery(); insert.CommandText = @"CREATE PROCEDURE [dbo].[Login_CRUD] @Action VARCHAR(10) ,@UserNumber INT = NULL ,@ID VARCHAR(100) = NULL ,@Password VARCHAR(100) = NULL ,@TypeOfUser INT = NULL AS BEGIN SET NOCOUNT ON; --SELECTALL IF @Action = 'SELECTALL' BEGIN SELECT UserNumber, ID, Password, TypeOfUser from dbo.Login END --UPDATE IF @Action = 'UPDATE' BEGIN UPDATE dbo.Login SET ID = @ID, Password = @Password, TypeOfUser = @TypeOfUser WHERE UserNumber = @UserNumber END --DELETE IF @Action = 'DELETE' BEGIN DELETE FROM dbo.Login WHERE UserNumber = @UserNumber END END"; insert.ExecuteNonQuery(); insert.CommandText = @"CREATE PROCEDURE [dbo].[SpecialException_CRUD] @Action VARCHAR(10) ,@SpecialExceptionID INT = NULL ,@SpecialExceptionName VARCHAR(100) = NULL ,@SpecialExceptionDate datetime = NULL ,@County VARCHAR(100) = NULL ,@Court VARCHAR(100) = NULL ,@JurisdictionID INT = NULL AS BEGIN SET NOCOUNT ON; --SELECTALL IF @Action = 'SELECTALL' BEGIN SELECT hd.SpecialExceptionID, hd.SpecialExceptionName, hd.SpecialExceptionDate, ju.County, ju.Court from SpecialException as hd, Jurisdiction as ju where ju.JurisdictionID = hd.JurisdictionID END --SELECT One IF @Action = 'SELECT' BEGIN SELECT hd.SpecialExceptionID, hd.SpecialExceptionName, hd.SpecialExceptionDate, ju.County, ju.Court from SpecialException as hd, Jurisdiction as ju where ju.JurisdictionID = hd.JurisdictionID AND County = @County And Court = @Court; END --UPDATE IF @Action = 'UPDATE' BEGIN UPDATE SpecialException SET SpecialExceptionName = @SpecialExceptionName, SpecialExceptionDate = @SpecialExceptionDate , JurisdictionID = @JurisdictionID WHERE SpecialExceptionID = @SpecialExceptionID END --DELETE IF @Action = 'DELETE' BEGIN DELETE FROM SpecialException WHERE SpecialExceptionID = @SpecialExceptionID END END"; insert.ExecuteNonQuery(); insert.CommandText = @"CREATE PROCEDURE [dbo].[Reminder_CRUD] @Action VARCHAR(10) ,@ReminderID INT = NULL ,@Description nvarchar(MAX) = NULL ,@County VARCHAR(100) = NULL ,@Court VARCHAR(100) = NULL ,@DateType VARCHAR(100) = NULL ,@JurisdictionID INT = NULL AS BEGIN SET NOCOUNT ON; --SELECTALL IF @Action = 'SELECTALL' BEGIN SELECT hd.ReminderID, hd.Description, ju.County, ju.Court, ju.DateType from Reminder as hd, Jurisdiction as ju where ju.JurisdictionID = hd.JurisdictionID END --SELECT One IF @Action = 'SELECT' BEGIN SELECT hd.ReminderID, hd.Description, ju.County, ju.Court, ju.DateType from Reminder as hd, Jurisdiction as ju where ju.JurisdictionID = hd.JurisdictionID AND County = @County And Court = @Court AND DateType = @DateType; END --UPDATE IF @Action = 'UPDATE' BEGIN UPDATE Reminder SET Description = @Description, JurisdictionID = @JurisdictionID WHERE ReminderID = @ReminderID END --DELETE IF @Action = 'DELETE' BEGIN DELETE FROM Reminder WHERE ReminderID = @ReminderID END END"; insert.ExecuteNonQuery(); insert.CommandText = @"CREATE PROCEDURE [dbo].[Contacts_CRUD] @Action VARCHAR(10) ,@ContactsID INT = NULL ,@Department nvarchar(MAX) = NULL ,@PersonName nvarchar(MAX) = NULL ,@Location nvarchar(MAX) = NULL ,@Address nvarchar(MAX) = NULL ,@Phone varchar(50) = NULL ,@Phone2 varchar(50) = NULL ,@Fax varchar(50) = NULL ,@Fax2 varchar(50) = NULL ,@County varchar(50) = NULL AS BEGIN SET NOCOUNT ON; --SELECTALL IF @Action = 'SELECTALL' BEGIN SELECT * from Contacts END --SELECT One IF @Action = 'SELECT' BEGIN SELECT * from Contacts where County = @County; END --UPDATE IF @Action = 'UPDATE' BEGIN UPDATE Contacts SET Department = @Department, PersonName = @PersonName , Location = @Location, Address = @Address, Phone = @Phone , Phone2 = @Phone2, Fax = @Fax, Fax2 = @Fax2 , County = @County WHERE ContactsID = @ContactsID END --DELETE IF @Action = 'DELETE' BEGIN DELETE FROM Contacts WHERE ContactsID = @ContactsID END END"; insert.ExecuteNonQuery(); for (int countycount = 0; countycount < 10; countycount++) { for (int courtcount = 0; courtcount < 3; courtcount++) { for (int datecount = 0; datecount < 4; datecount++) { insert.CommandText = "insert into [dbo].[Jurisdiction] (County, Court, DateType) values ('" + CountyNames[countycount] + "', '" + CourtNames[courtcount] + "', '" + DateNames[datecount] + "')"; insert.ExecuteNonQuery(); } } } int LastIDNumber = LastID(); if (LastIDNumber == 0) { //error here Label1.Text = "Last id error"; return; } for (int k = 1; k < LastIDNumber + 1; k++) { for (int WoM = 1; WoM < 6; WoM++) { for (int doW = 0; doW < 7; doW++) { insert.CommandText = "insert into [dbo].[Exception] (WeekOfMonth, DayOfWeek, Time, Valid, OldValid, BusinessDayMin, BusinessDayMax, JurisdictionID) values (" + WoM + ", " + doW + ",'0:00', 0, 0, 0, 0, " + k + ")"; insert.ExecuteNonQuery(); DateTime defaultDate = new DateTime(2000, 1, 1); insert.CommandText = "insert into [dbo].[BasisGroup6] (WeekOfMonth, DayOfWeek, Valid, EffectiveDate, Time, JurisdictionID) values (" + WoM + "," + doW + ", 0 , '" + defaultDate + "', '0:00', " + k + ")"; insert.ExecuteNonQuery(); } } } sc.Close(); // foreach (var court in CourtNames) { Alleghany a1 = new Alleghany(); Augusta a2 = new Augusta(); Bath a3 = new Bath(); Botetourt a4 = new Botetourt(); BuenaVista a5 = new BuenaVista(); Craig a6 = new Craig(); Highland a7 = new Highland(); LexingtonRockbridge a8 = new LexingtonRockbridge(); Staunton a9 = new Staunton(); Waynesboro a10 = new Waynesboro(); Label1.Text += a1.test(); } // Label1.Text = "Reset Successssss"; } catch (Exception ex) { Label1.Text = " error : " + ex; // Log_Show("Setting Default Error : " + ex, 3, Label1); } }