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