public City(int CityID) { this.cityID = CityID; CityService cs = new CityService(); this.cityName = cs.GetCityByID(CityID); this.centerID = cs.GetCenterIDByCityID(CityID); }
protected void ButtonSubmit_Click(object sender, EventArgs e) { //השגת הנתונים לגבי המשתמש int clientID = Convert.ToInt32(Session["UserID"]); Client orderingClient = new Client(clientID); City collectingCity = new City(orderingClient.GetCityID()); string collectingCityName = collectingCity.GetCityName(); int collectingCityID = orderingClient.GetCityID(); string collectingAddress = orderingClient.GetAddress(); string date = DateTime.Now.ToShortDateString(); string item = this.TextBoxItemDescription.Text; string itemWeight = this.TextBoxItemWeight.Text; int destinationCityID = Convert.ToInt32(this.DropDownListDestinationCities.SelectedValue); string destinationCityName = this.DropDownListDestinationCities.SelectedItem.ToString(); string destinationAddress = this.TextBoxAddress.Text; string destinationDate = DateTime.Now.AddDays(30).ToShortDateString(); //חישוב המחיר CityService cs=new CityService(); int collectingCenterID = collectingCity.GetCenterID(); int destinationCenterID = cs.GetCenterIDByCityID(destinationCityID); int temp = destinationCenterID - collectingCenterID; if (temp < 0) temp *= -1; temp += 1; double price; price= 5 * Math.Log(double.Parse(itemWeight)) + 10 + (temp * 10); if (this.CheckBoxUrgent.Checked) { price += 10; } if (price < 20) price = 20; int roundedPrice = Convert.ToInt32(price); try { string sqlCommand = "INSERT INTO Orders (CollectingCityID,CollectingCityName,CollectingAddress,OrderingDate,DestinationCityID,DestinationCityName,DestinationAddress,DestinationDate,Item,ItemWeight,WorkerID,ClientID,Price,Status) VALUES (" + collectingCityID + ",'" + collectingCityName + "','" + collectingAddress + "','" + date + "'," + destinationCityID + ",'" + destinationCityName + "','" + destinationAddress + "','" + destinationDate + "','" + item + "'," + itemWeight + ",0," + clientID + "," + roundedPrice + ",'New');"; OleDbConnection myCon = new OleDbConnection(Connect.getConnectionString()); OleDbCommand cmd = new OleDbCommand(sqlCommand, myCon); myCon.Open(); cmd.ExecuteNonQuery(); myCon.Close(); Response.Redirect("HomePage.aspx"); } catch (Exception ex) { throw ex; } }
protected void ButtonSend_Click(object sender, EventArgs e) { if (this.CheckBoxAgreement.Checked) { string ID = this.TextBoxID.Text; string userName = this.TextBoxUserName.Text; string pass = this.TextBoxPass.Text; string passVerification = this.TextBoxPass2.Text; string email = this.TextBoxEmail.Text; string phone = this.DropDownList1.SelectedItem + this.TextBoxPhone.Text; string city = this.DropDownListCities.Text; string address = this.TextBoxAddress.Text; int cityID = Convert.ToInt32(this.DropDownListCities.SelectedValue); string fName = this.TextBoxFirstName.Text; string lName = this.TextBoxLastName.Text; City userCity = new City(); userCity.SetCityID(cityID); userCity.SetCityName(city); CityService cs = new CityService(); userCity.SetCenterID(cs.GetCenterIDByCityID(cityID)); OleDbConnection myCon = new OleDbConnection(Connect.getConnectionString()); OleDbCommand cmd = new OleDbCommand("SELECT * FROM Clients WHERE UserName='******';", myCon); myCon.Open(); if (cmd.ExecuteScalar() == null) { string sqlCommand = "INSERT INTO Clients (CityID,UserName,Pass,Phone,Email,Address,FirstName,LastName,ID,Activity) VALUES(" + cityID + ",'" + userName + "','" + pass + "','" + phone + "','" + email + "','" + address + "','" + fName + "','" + lName + "','"+ID+"','UnActive');"; cmd.CommandText = sqlCommand; cmd.ExecuteNonQuery(); } myCon.Close(); } else { Response.Write("<script type=\"text/javascript\">alert('אנא אשר את תנאי האתר')</script>"); } }
public int CalculatePrice(int num) { if (num == 1) { int clientID = Convert.ToInt32(Session["UserID"]); Client orderingClient = new Client(clientID); City collectingCity = new City(orderingClient.GetCityID()); string itemWeight = this.TextBoxItemWeight.Text; int destinationCityID = Convert.ToInt32(this.DropDownListDestinationCities.SelectedValue); //חישוב המחיר CityService cs = new CityService(); int collectingCenterID = collectingCity.GetCenterID(); int destinationCenterID = cs.GetCenterIDByCityID(destinationCityID); int temp = destinationCenterID - collectingCenterID; if (temp < 0) temp *= -1; temp += 1; double price; price = 5 * Math.Log(double.Parse(itemWeight)) + 10 + (temp * 10); if (this.CheckBoxUrgent.Checked) { price += 10; } if (price < 20) price = 20; int roundedPrice = Convert.ToInt32(price); return roundedPrice; } else if (num == 2) { int collectingCityID = Convert.ToInt32(this.DropDownListCollectingCities.SelectedValue); City collectingCity = new City(collectingCityID); string itemWeight = this.TextBoxItemWeight2.Text; int destinationCityID = Convert.ToInt32(this.DropDownListDestinationCities2.SelectedValue); //חישוב המחיר CityService cs = new CityService(); int collectingCenterID = collectingCity.GetCenterID(); int destinationCenterID = cs.GetCenterIDByCityID(destinationCityID); int temp = destinationCenterID - collectingCenterID; if (temp < 0) temp *= -1; temp += 1; double price; price = 5 * Math.Log(double.Parse(itemWeight)) + 10 + (temp * 10); if (this.CheckBoxUrgent2.Checked) { price += 10; } if (price < 20) price = 20; int roundedPrice = Convert.ToInt32(price); return roundedPrice; } else return 0; }