public A3()
{
var a = new AInt();
a.fld3 = "a";
fld2 = a;
fld5 = a;
}
/// <summary>
/// Initializes a new instance of the <see cref="A3" /> class.
/// </summary>
public A3()
{
var a = new AInt {
Fld3 = "a"
};
Fld2 = a;
Fld5 = a;
}
public A3()
{
var a = new AInt();
a.fld3 = "a";
fld2 = a;
fld5 = a;
}
public void OnPost()
{
AMessage = "posted";
whichEntity = Request.Form["entityType"];
database.connect();
dbCommand = "SELECT * FROM " + whichEntity;
SqlCommand cmd = new SqlCommand();
cmd.Connection = database.Connection;
cmd.CommandText = dbCommand;
reader = cmd.ExecuteReader();
AInt = reader.FieldCount;
Debug.WriteLine(AInt.ToString());
string output = "";
for (int i = 0; i < AInt; i++)
{
ColumnNames.Add(reader.GetName(i));
output += reader.GetName(i);
}
Debug.WriteLine(output);
output = "";
int j = 0;
while (reader.Read())
{
//Debug.WriteLine(String.Format("{0}, {1}", reader[0], reader[1]));
Results.Add(new List <string>());
for (int i = 0; i < AInt; i++)
{
output += reader[i] + ", ";
Results[j].Add(reader[i].ToString());
}
j++;
output += '\n';
}
Debug.WriteLine("Results count: " + Results.Count());
Debug.WriteLine(output);
cmd.Dispose();
database.disconnect();
bool success = false;
if (whichEntity == "ANIMAL")
{
AMessage = "controller recognized ANIMAL";
database.connect();
string insertID = Request.Form["ID"];
if (string.IsNullOrEmpty(insertID) == true)
{
// throw error
}
string insertName = Request.Form["Name"];
if (string.IsNullOrEmpty(insertName) == true)
{
// throw error
}
string insertSpecies = Request.Form["Species"];
if (string.IsNullOrEmpty(insertSpecies) == true)
{
// throw error
}
string insertTaxology = Request.Form["Taxology"];
if (string.IsNullOrEmpty(insertTaxology) == true)
{
// throw error
}
string insertBirthLocation = Request.Form["Birth Location"];
if (string.IsNullOrEmpty(insertBirthLocation) == true)
{
// NULL allowed
//insertBirthLocation = "NULL";
}
string insertBirthDate = Request.Form["insertBirthDate"];
if (string.IsNullOrEmpty(insertBirthDate) == true)
{
// NULL allowed
//insertBirthDate = "NULL";
}
string insertState = Request.Form["Status"];
if (string.IsNullOrEmpty(insertState) == true)
{
// throw error
}
string insertStatus_date = Request.Form["Status_date"];
if (string.IsNullOrEmpty(insertStatus_date) == true)
{
// throw error
}
string insertGender = Request.Form["Gender"];
if (string.IsNullOrEmpty(insertGender) == true)
{
// throw error
}
string insertHeight = Request.Form["Height"];
if (string.IsNullOrEmpty(insertHeight) == true)
{
// NULL allowed
insertHeight = "NULL";
}
string insertWeight = Request.Form["Weight"];
if (string.IsNullOrEmpty(insertWeight) == true)
{
// NULL allowed
insertWeight = "NULL";
}
string insertHealth = Request.Form["Health"];
if (string.IsNullOrEmpty(insertHealth) == true)
{
// NULL allowed
//insertHealth = "NULL";
}
string insertHealth_date = Request.Form["Health_date"];
if (string.IsNullOrEmpty(insertHealth_date) == true)
{
// NULL allowed
//insertHealth_date = "NULL";
}
string insertAttraction = Request.Form["Attraction"];
if (string.IsNullOrEmpty(insertAttraction) == true)
{
// throw error
}
//SqlCommand cmd = new SqlCommand();
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(ID, [Name], Species, Taxology, " +
"[Birth Location], [Birth Date], Status, Status_date, Gender, Weight, Height, " +
"Health, Health_date, Attraction) " +
"VALUES(" + insertID + ", '" + insertName + "', '" + insertSpecies +
"', '" + insertTaxology + "', '" + insertBirthLocation + "', '" +
insertBirthDate + "', '" + insertState + "', '" + insertStatus_date +
"', " + insertGender + ", " + insertWeight + ", " + insertHeight +
", '" + insertHealth + "', '" + insertHealth_date + "', " + insertAttraction +
");";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
if (e.Number == 50000)
{
AMessage = "TRIGGERED: Animal inserted or updated into a closed attraction!";
}
else
{
EMessage = "Failed to execute insert: " + e.ToString();
}
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "ATTRACTION")
{
AMessage = "controller recogznied ATTRACTION";
database.connect();
string insertID = Request.Form["ID"];
if (string.IsNullOrEmpty(insertID) == true)
{
// throw error
}
string insertType = Request.Form["Name"];
if (string.IsNullOrEmpty(insertType) == true)
{
// throw error
}
string insertOpen = Request.Form["Open_closed"];
if (string.IsNullOrEmpty(insertOpen) == true)
{
// throw error
}
string insertOpenDate = Request.Form["Open_closed_date"];
if (string.IsNullOrEmpty(insertOpenDate) == true)
{
// throw error
}
string insertManager = Request.Form["Manager"];
if (string.IsNullOrEmpty(insertManager) == true)
{
// throw error
}
string insertManagerDate = Request.Form["Manager_date"];
if (string.IsNullOrEmpty(insertManagerDate) == true)
{
// throw error
}
string insertDescription = Request.Form["Description"];
if (string.IsNullOrEmpty(insertDescription) == true)
{
// NULL allowed
//insertDescription = "NULL";
}
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(ID, Name, Open_closed, " +
"Open_closed_date, Manager, Manager_date, Description) " +
"VALUES(" + insertID + ", '" + insertType + "', " + insertOpen +
", '" + insertOpenDate + "', " + insertManager + ", '" +
insertManagerDate + "', '" + insertDescription + "');";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "CUSTOMER")
{
AMessage = "controller recognized CUSTOMER";
database.connect();
string insertID = Request.Form["ID"];
string insertFname = Request.Form["Fname"];
string insertMname = Request.Form["Mname"];
string insertLname = Request.Form["Lname"];
string insertStreetAddress = Request.Form["StreetAddress"];
string insertCityAddress = Request.Form["CityAddress"];
string insertZipAddress = Request.Form["ZipAddress"];
string insertStateAddress = Request.Form["StateAddress"];
string insertPhone = Request.Form["Phone"];
string insertEmail = Request.Form["Email"];
string insertMembershipType = Request.Form["MembershipType"];
string insertExpirationDate = Request.Form["ExpirationDate"];
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(ID, Fname, Mname," +
" Lname, StreetAddress, CityAddress, ZipAddress, StateAddress, " +
" Phone, Email, MembershipType, ExpirationDate) " +
"VALUES(" + insertID + ", '" + insertFname + "', '" + insertMname +
"', '" + insertLname + "', '" + insertStreetAddress + "', '" +
insertCityAddress + "', " + insertZipAddress + ", '" + insertStateAddress +
"', " + insertPhone + ", '" + insertEmail + "', " + insertMembershipType +
", '" + insertExpirationDate + "');";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "EMPLOYEE")
{
AMessage = "controller recogznied EMPLOYEE";
database.connect();
string insertID = Request.Form["ID"];
string insertFname = Request.Form["Fname"];
string insertMname = Request.Form["Mname"];
string insertLname = Request.Form["Lname"];
string insertTitle = Request.Form["Title"];
string insertHire_Date = Request.Form["Hire_Date"];
string insertStreet = Request.Form["Street"];
string insertCity = Request.Form["City"];
string insertZip = Request.Form["Zip"];
string insertState = Request.Form["State"];
string insertEmail = Request.Form["Email"];
string insertPhone = Request.Form["Phone"];
string insertGender = Request.Form["Gender"];
string insertStore = Request.Form["Store"];
if (string.IsNullOrEmpty(insertStore) == true)
{
insertStore = "NULL";
}
string insertAttraction = Request.Form["Attraction"];
if (string.IsNullOrEmpty(insertAttraction) == true)
{
insertAttraction = "NULL";
}
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(ID, Fname, Mname, Lname, [Title]," +
" Hire_Date, Street, City, Zip, [State], Email, Phone#, Gender, Store, Attraction) " +
"VALUES(" + insertID + ", '" + insertFname + "', '" + insertMname +
"', '" + insertLname + "', " + insertTitle + ", '" + insertHire_Date +
"', '" + insertStreet + "', '" + insertCity + "', '" + insertZip + "', '" +
insertState + "', '" + insertEmail + "', " + insertPhone + ", " + insertGender +
", " + insertStore + ", " + insertAttraction + ");";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "GENDER_TYPE")
{
AMessage = "controller recognized GENDER_TYPE";
database.connect();
string insertID = Request.Form["ID"];
string insertGender = Request.Form["Name"];
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(ID, Name) " +
"VALUES(" + insertID + ", '" + insertGender + "');";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "MEMBERSHIP_TYPE")
{
AMessage = "controller recognized MEMBERSHIP_TYPE";
database.connect();
string insertID = Request.Form["ID"];
string insertType = Request.Form["Name"];
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(ID, Name) " +
"VALUES(" + insertID + ", '" + insertType + "');";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "PAY_TYPE")
{
AMessage = "controller recognized PAY_TYPE";
database.connect();
string insertID = Request.Form["ID"];
string insertType = Request.Form["Name"];
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(ID, Name) " +
"VALUES(" + insertID + ", '" + insertType + "');";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "PRODUCT")
{
AMessage = "controller recogznied PRODUCT";
database.connect();
string insertID = Request.Form["ID"];
string insertType = Request.Form["Name"];
string insertPrice = Request.Form["Price"];
string insertDescription = Request.Form["Description"];
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(ID, Name, Price, Description) " +
"VALUES(" + insertID + ", '" + insertType + "', " + insertPrice +
", '" + insertDescription + "');";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "PURCHASE")
{
AMessage = "controller recognized PURCHASE";
database.connect();
string insertReceipt = Request.Form["Receipt"];
Debug.WriteLine("Receipt: " + insertReceipt);
string insertTime = Request.Form["Time"];
string insertAmount = Request.Form["insertAmount"];
string insertPay_option = Request.Form["Pay_option"];
string insertDate = Request.Form["Date"];
string insertStore = Request.Form["Store"];
string insertCustomer = Request.Form["Customer"];
string insertEmployee = Request.Form["Employee"];
if (string.IsNullOrEmpty(insertCustomer) == true)
{
insertCustomer = "NULL";
}
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(Receipt, Time, " +
"Pay_option, Date, Store, Customer, Employee) " +
"VALUES(" + insertReceipt + ", '" + insertTime + "', " +
insertPay_option + ", '" + insertDate +
"', " + insertStore + ", " + insertCustomer + ", " + insertEmployee + ");";
Debug.Write(dbCommand);
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
if (e.Number == 50000)
{
AMessage = "TRIGGERED: Purchase time was not during zoo operating hours!";
}
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "PURCHASE_INFO")
{
AMessage = "controller recognized PURCHASE_INFO";
database.connect();
string insertReceipt = Request.Form["Receipt"];
string insertProduct = Request.Form["Product"];
string insertPrice = Request.Form["Price"];
string insertQuantity = Request.Form["insertQuantity"];
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(Receipt, Product, Price, " +
"Quantity) " +
"VALUES(" + insertReceipt + ", " + insertProduct + ", " +
insertPrice + ", " + insertQuantity + ");";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "STORE")
{
AMessage = "controller recognized STORE";
database.connect();
string insertID = Request.Form["ID"];
string insertName = Request.Form["Name"];
string insertType = Request.Form["Type"];
string insertManager = Request.Form["insertManager"];
string insertManager_date = Request.Form["insertManager_date"];
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(ID, Name, Type, " +
"Manager, Manager_date) " +
"VALUES(" + insertID + ", '" + insertName + "', " +
insertType + ", " + insertManager + ", '" + insertManager_date + "');";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "STORE_TYPE")
{
AMessage = "controller recognized STORE_TYPE";
database.connect();
string insertID = Request.Form["ID"];
string insertName = Request.Form["Name"];
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(ID, Name) " +
"VALUES(" + insertID + ", '" + insertName + "');";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
}
cmd.Dispose();
database.disconnect();
}
else if (whichEntity == "TITLE_TYPE")
{
AMessage = "controller recognized TITLE_TYPE";
database.connect();
string insertID = Request.Form["ID"];
string insertType = Request.Form["Title"];
cmd = new SqlCommand();
cmd.Connection = database.Connection;
dbCommand = "INSERT INTO " + whichEntity + "(ID, Title) " +
"VALUES(" + insertID + ", '" + insertType + "');";
cmd.CommandText = dbCommand;
try
{
cmd.ExecuteNonQuery();
EMessage = "Insert successful";
success = true;
}
catch (SqlException e)
{
EMessage = "Failed to execute insert: " + e.ToString();
}
cmd.Dispose();
database.disconnect();
}
else
{
EMessage = "Could not find entity type.";
}
if (success)
{
Response.Redirect("./Search?we=" + whichEntity);
}
}
