protected void btnNew_Click(object sender, EventArgs e) { if (btnNew.Text.Equals("Save New")) { try { string theID = txtID.Text; string newName = txtName.Text; double newPrice = double.Parse(txtPrice.Text.Replace("$", "")); string newDesc = txtDescription.Text; SQLDataClass.InsertProduct(theID, newName, newPrice, newDesc); txtMessage.Text = "Record updated."; SQLDataClass.getAllProducts(); } catch (Exception ex) { txtMessage.Text = "Product Not Inserted: " + ex.Message; } } else if (btnNew.Text.Equals("New")) { txtDescription.Text = ""; txtID.Text = ""; txtName.Text = ""; txtPrice.Text = ""; btnUpdate.Enabled = false; btnFirst.Enabled = false; btnLast.Enabled = false; btnNext.Enabled = false; btnPrevious.Enabled = false; } }
protected void Page_Load(object sender, EventArgs e) { SQLDataClass.getAllProducts(); TextArea1.InnerText = ""; if (!IsPostBack) { DisplayRow((int)Session["Prog3_Index"]); } }
protected void Page_Load(object sender, EventArgs e) { SQLDataClass.getAllLogin(); Label5.Visible = false; if (CheckBox1.Checked) { Response.Redirect("Default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { SQLDataClass.DeleteShopping(); } catch (Exception ex) { //Response.Write(ex.Message); } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { string theID = txtID.Text; string newName = txtName.Text; double newPrice = double.Parse(txtPrice.Text.Replace("$", "")); string newDesc = txtDescription.Text; SQLDataClass.UpdateProduct(theID, newName, newPrice, newDesc); txtMessage.Text = "Record updated."; SQLDataClass.getAllProducts(); } catch (Exception ex) { txtMessage.Text = "Product Not Updated: " + ex.Message; } }
protected void Button3_Click(object sender, EventArgs e) { try { for (int i = 0; i < SQLDataClass.tblCart.Rows.Count; i++) { if (SQLDataClass.tblCart.Rows[i][0].ToString().Equals(TextBox1.Text.ToString())) { try { string theID = TextBox1.Text; string newName = TextBox2.Text; double newPrice = double.Parse(TextBox3.Text.Replace("$", "")); int newQty = int.Parse(TextBox4.Text); double newTotal = double.Parse(TextBox7.Text.Replace("$", "")); SQLDataClass.UpdateCart(theID, newName, newQty, newPrice, newTotal); SQLDataClass.getAllCart(); } catch (Exception ex) { TextArea1.InnerText = "Product Not Updated:" + ex.Message; } } } Guid newGuid = Guid.NewGuid(); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["UWPCS3870ConnectionString"].ConnectionString); conn.Open(); String insertQuery = "Insert into Cart(CartProdID, CartProdName, CartProdQty, CartProdUnitPrice, CartProdCost) values(@CID, @CName, @CQty, @CUnitPrice, @CTotal)"; SqlCommand comm = new SqlCommand(insertQuery, conn); comm.Parameters.AddWithValue("@CID", TextBox1.Text); comm.Parameters.AddWithValue("@CName", TextBox2.Text); comm.Parameters.AddWithValue("@CQty", TextBox4.Text); comm.Parameters.AddWithValue("@CUnitPrice", TextBox3.Text); comm.Parameters.AddWithValue("@CTotal", TextBox7.Text); comm.ExecuteNonQuery(); conn.Close(); Response.Redirect("Login.aspx"); } catch (Exception ex) { Response.Write("Error:" + ex.ToString()); } }
protected void Button5_Click(object sender, EventArgs e) { try { string theID = TextBox1.Text; string newName = TextBox2.Text; double newPrice = double.Parse(TextBox3.Text.Replace("$", "")); string newDesc = TextBox4.Text; SQLDataClass.UpdateProduct(theID, newName, newPrice, newDesc); TextArea1.InnerText = "Record Updated"; SQLDataClass.getAllProducts(); } catch (Exception ex) { TextArea1.InnerText = "Product Not Updated:" + ex.Message; } }
protected void txtChange(object sender, EventArgs e) { if (SQLDataClass.checkID(txtID.Text)) { for (int i = 0; i < SQLDataClass.tblProduct.Rows.Count; i++) { System.Data.DataRow row = SQLDataClass.tblProduct.Rows[i]; String temp1 = row[0].ToString(); String temp2 = row[1].ToString(); String temp3 = row[2].ToString(); if (txtID.Text.Trim().Equals(row[0].ToString().Trim())) { txtID.Text = row[0].ToString(); txtName.Text = row[1].ToString(); txtPrice.Text = row[2].ToString(); } } } }
protected void Button6_Click(object sender, EventArgs e) { if (Button6.Text.Equals("Cancel")) { ResetButtons(); TextArea1.InnerText = "Insertion was canceled"; } else { try { string theID = TextBox1.Text; SQLDataClass.DeleteProdcut(theID); TextArea1.InnerText = "Record Deleted"; } catch (Exception ex) { TextArea1.InnerText = "Product Not Deleted" + ex.Message; } } }
protected void Button7_Click(object sender, EventArgs e) { if (Button7.Text.Equals("Save New")) { try { string theID = TextBox1.Text; string newName = TextBox2.Text; double newPrice = double.Parse(TextBox3.Text.Replace("$", "")); string newDesc = TextBox4.Text; SQLDataClass.AddProduct(theID, newName, newPrice, newDesc); TextArea1.InnerText = "Record Added"; SQLDataClass.getAllProducts(); ResetButtons(); } catch (Exception ex) { TextArea1.InnerText = "Product Not added:" + ex.Message; } } else { TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; Button1.Enabled = false; Button2.Enabled = false; Button3.Enabled = false; Button4.Enabled = false; Button5.Enabled = false; Button6.Text = "Cancel"; Button7.Text = "Save New"; } }
protected void Application_Start(object sender, EventArgs e) { SQLDataClass.setupProdAdapter(); }
protected void Page_Load(object sender, EventArgs e) { SQLDataClass.getAllProducts(); //dtlProduct.DataSource = SQLDataClass.tblProduct; //dtlProduct.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SQLDataClass.getAllProducts(); DisableText(); }
public JsonStringResult Get(double lon, double lat, double Scale, string CalcType, string Adminpwd, string ReportToken, string ProjectName, string CustomerName, string Recipients, bool DelCalcTables = true) { //this function received the WS parameters //and extract the osm data according to it // let's avoid low scale calculation and quit the calculation with an alert message if (Scale > 0.5) { return(new JsonStringResult(ExtractOSMMapProdProd.Properties.Resources.BigScale)); } coor = new Coordinates() { lon = lon, lat = lat, zoomLevel = Scale }; string strContent = string.Empty; try { initLogger(); // let's extract the osm data and insert it to the PGSQL DB as tables ExtractOSMMap OSMData = new ExtractOSMMap(); tblprefix = OSMData.OsmFileDownload(lon, lat, Scale); // let's get set background rank according to the coordinates geocoding (coordinates in a city, suburb, village and etc) GeoCodingServices service = new GeoCodingServices(); int Rank = service.GetCityRank(coor.lon, coor.lat); switch (Rank) { case 1: m_BackgroundInterference = 36; break; case 2: m_BackgroundInterference = 20; break; case 3: m_BackgroundInterference = 15; break; case 4: m_BackgroundInterference = 8; break; case 5: m_BackgroundInterference = 4; break; default: m_BackgroundInterference = 0; break; } // convert string to enum Types type = ((Types)Enum.Parse(typeof(Types), CalcType, true)); // let's calculate the attributes Indcies according to the coordinates location and other parameters dataClass = new SQLDataClass(Connectionstr); List <Results> lstResults = dataClass.CalculateIndcies(tblprefix, coor, m_BackgroundInterference, ProjectName + StringDot + CustomerName, true, type); strContent += ParseData(lstResults); // let's get the address of teh location as a string and add it to the result JSON string Address = GetAddress(coor); strContent += StringSeparator + "Address:" + Address; // the report is disabled, later on will be added back to the results string reportName = StringSeparator + "Report:N.A."; strContent += reportName; if (DelCalcTables) { dataClass.DeleteTables(tblprefix); } // let's calc the total index value and add it to the list Results result = new Results { type = Types.All, category = 6, indexvalue = lstResults.Average(x => x.indexvalue) }; lstResults.Add(result); // let's send the shorty report email and update the email send status strContent += StringSeparator + "Email:" + GenerateShortReport(coor, Address, CustomerName, Recipients, lstResults); // ** report code - disabled at this stage ** //if (!string.IsNullOrEmpty(ReportToken) && ReportToken == "Report56562") //{ //GenerateReport generateReport = new GenerateReport(); //GenerateReport.Coordinates coordinates = new GenerateReport.Coordinates { lon = Convert.ToSingle(lon), lat = Convert.ToSingle(lat), zoomlevel = 17 }; //GenerateReport.Marks marks = new GenerateReport.Marks { AirQuality = AirQualityVal, Ecology = EcologyVal, NoiseInterference = noiseVal, RadiationEG = radiationVal, SoilPollution = soilVal, FinalMark = ((noiseVal + soilVal + radiationVal + AirQualityVal + EcologyVal) / 5) }; //GenerateReport.ReportExtraInfo ReportExtraInfo = new GenerateReport.ReportExtraInfo { CustomerName = CustomerName, ProjName = ProjectName }; //string reportName = generateReport.GenerateReportPdf(marks, coordinates, ReportExtraInfo);"; //strContent += reportName; //} //else //{ // strContent += "N.A."; //} } catch (Exception ex) { strContent = ex.Message; } return(new JsonStringResult(strContent)); }