public bool bathNearby()
{
Bath nearbyBath = hen.findNearbyItem <Bath>();
if (nearbyBath != null && nearbyBath.filled && !nearbyBath.occupied)
{
return(true);
}
return(false);
}
public ActionResult CRTPRD(string category, Product p, bool Tank = false, instalation Instalation = instalation.Напольный, drain Drain = drain.Вертикальный, form Form = form.Ассиметричная, material Material = material.Акрил, int Length = 0, int Width = 0, int Pallet_height = 0)
{
MyContext db = new MyContext();
if (category == "Ванны")
{
Bath prod = new Bath();
prod.Form = Form;
prod.Material = Material;
prod.Length = Length;
prod.Width = Width;
prod.Name = p.Name;
prod.Description = p.Description;
prod.Price = p.Price;
prod.PathPicture = p.PathPicture;
prod.ManufacturerId = p.ManufacturerId;
db.Bathes.Add(prod);
db.SaveChanges();
}
else if (category == "Душевые кабинки")
{
ShowerCubicle prod = new ShowerCubicle();
prod.Form = Form;
prod.Material = Material;
prod.Length = Length;
prod.Width = Width;
prod.Pallet_height = Pallet_height;
prod.Name = p.Name;
prod.Description = p.Description;
prod.Price = p.Price;
prod.PathPicture = p.PathPicture;
prod.ManufacturerId = p.ManufacturerId;
db.ShowerCubicles.Add(prod);
db.SaveChanges();
}
else if (category == "Унитазы")
{
Toilet prod = new Toilet();
prod.Instalation = Instalation;
prod.Drain = Drain;
prod.Tank = Tank;
prod.Name = p.Name;
prod.Description = p.Description;
prod.Price = p.Price;
prod.PathPicture = p.PathPicture;
prod.ManufacturerId = p.ManufacturerId;
db.Toilets.Add(prod);
db.SaveChanges();
}
return(Redirect("/Home/ASDFGHJKL"));
}
protected void FSM_VejigaBaja()
{
switch (estado_vejiga)
{
case STATE_VejigaBaja.BUSCANDO:
ShowEmoticon("PiPi");
currentState = "[FSM Baño] Buscando baño";
bathObjective = BathInSight();
if (bathObjective == null)
{
CheckPee();
Pasear();
}
else
{
currentState = "[FSM Baño] Yendo al baño";
ShowEmoticon("PiPi");
bathObjective.AddUser(this);
estado_vejiga = STATE_VejigaBaja.ESPERANDO_BAÑO;
}
break;
case STATE_VejigaBaja.ESPERANDO_BAÑO:
currentState = "[FSM Baño] Esperando al baño";
CheckPee();
break;
case STATE_VejigaBaja.ORINANDO_BAÑO:
currentState = "[FSM Baño] Usando el baño";
break;
case STATE_VejigaBaja.ORINANDO_ENCIMA:
if (bathObjective != null)
{
bathObjective.Leave(this);
}
vejiga = 100;
estado_vejiga = STATE_VejigaBaja.BUSCANDO;
break;
}
}
override public void runOnce()
{
bath = input.hen.findNearbyItem <Bath>();
// if (target != null) {
// //this scripted movmement can hopefully be replaced by real animations later
// float bathSeekAcceleration = 0.02f; //TODO make this change depending on speed stat?
// input.hen.transform.LookAt(target.transform);
// //TODO keep rotation parallel to ground
// float yRot = input.hen.transform.rotation.eulerAngles.y;
// input.hen.transform.rotation = Quaternion.Euler(0, yRot, 0);
// input.hen.GetComponent<Rigidbody>().velocity += input.hen.transform.forward * bathSeekAcceleration;
// }
beforeBathingPos = input.hen.transform.position;
input.hen.transform.position = bath.gameObject.transform.position + new Vector3(0, 0.5f, 0);
input.hen.GetComponent <Rigidbody>().velocity = new Vector3(0, 0, 0);
input.hen.GetComponent <Animator>().SetTrigger("inWater");
Object.Instantiate(input.hen.bathingParticles, input.hen.transform.position, input.hen.bathingParticles.transform.rotation, bath.gameObject.transform);
}
public ActionResult SubmitBath()
{
Bath bath = new Bath();
string projectname = System.Web.HttpContext.Current.Request["projectname"] == null ? "" : System.Web.HttpContext.Current.Request["projectname"].ToString();
bath.BathName = projectname;
if (string.IsNullOrEmpty(projectname))
{
return(Content("Fail"));
}
else
{
if (BathService.Add(bath))
{
return(Content("Success"));
}
else
{
return(Content("Fail"));
}
}
}
public void finishBath(Bath bath)
{
StartCoroutine(featherQuality.increase(1 + .5f * InventoryPersist.getBathLevel()));
bath.unFill();
}
public void finishBath(Bath bath)
{
StartCoroutine(featherQuality.increase(1));
bath.unFill();
}
public static void Bath_OnCompletedStateTask_CleanUpCum(Bath __instance) => Tools.CleanUpSiru(__instance);
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);
}
}
