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