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