private void button2_Click(object sender, EventArgs e)
{
this.Hide();
var newForm = new MrDelivery();
newForm.Show();
}
private void ApostoliButton_Click(object sender, EventArgs e)
{
currentmo = (ScorePoiothta + ScoreTaxitita) / 2;
if (ShopID == 1)
{
using (SqlConnection sqlCon = new SqlConnection(connectionString))
using (SqlCommand command = sqlCon.CreateCommand())
{
sqlCon.Open();
command.CommandText = "SELECT Rating FROM(SELECT Rating, ROW_NUMBER() OVER(ORDER BY ShopID) AS rownumber FROM tbl_Shop) AS foo WHERE foo.rownumber BETWEEN 1 and 1";
SqlDataReader reader = (null);
reader = command.ExecuteReader();
while (reader.Read())
{
convertMo = (reader["Rating"].ToString());
}
sqlCon.Close();
double.TryParse(convertMo, out oldMo);
mo = (currentmo + oldMo) / 2;
txtMo = mo.ToString();
sqlCon.Open();
command.CommandText = "UPDATE tbl_Shop SET Rating = '" + txtMo + "' WHERE ShopID = 1";
command.ExecuteNonQuery();
sqlCon.Close();
MessageBox.Show("Ευχαριστούμε για την αξιολόγηση!");
this.Hide();
var newForm = new MrDelivery();
newForm.Show();
}
}
if (ShopID == 2)
{
using (SqlConnection sqlCon = new SqlConnection(connectionString))
using (SqlCommand command = sqlCon.CreateCommand())
{
sqlCon.Open();
command.CommandText = "SELECT Rating FROM(SELECT Rating, ROW_NUMBER() OVER(ORDER BY ShopID) AS rownumber FROM tbl_Shop) AS foo WHERE foo.rownumber BETWEEN 2 and 2";
SqlDataReader reader = (null);
reader = command.ExecuteReader();
while (reader.Read())
{
convertMo = (reader["Rating"].ToString());
}
sqlCon.Close();
double.TryParse(convertMo, out oldMo);
mo = (currentmo + oldMo) / 2;
txtMo = mo.ToString();
sqlCon.Open();
command.CommandText = "UPDATE tbl_Shop SET Rating = '" + txtMo + "' WHERE ShopID = 2";
command.ExecuteNonQuery();
sqlCon.Close();
MessageBox.Show("Ευχαριστούμε για την αξιολόγηση!");
this.Hide();
var newForm = new MrDelivery();
newForm.Show();
}
}
if (ShopID == 3)
{
using (SqlConnection sqlCon = new SqlConnection(connectionString))
using (SqlCommand command = sqlCon.CreateCommand())
{
sqlCon.Open();
command.CommandText = "SELECT Rating FROM(SELECT Rating, ROW_NUMBER() OVER(ORDER BY ShopID) AS rownumber FROM tbl_Shop) AS foo WHERE foo.rownumber BETWEEN 3 and 3";
SqlDataReader reader = (null);
reader = command.ExecuteReader();
while (reader.Read())
{
convertMo = (reader["Rating"].ToString());
}
sqlCon.Close();
double.TryParse(convertMo, out oldMo);
mo = (currentmo + oldMo) / 2;
txtMo = mo.ToString();
sqlCon.Open();
command.CommandText = "UPDATE tbl_Shop SET Rating = '" + txtMo + "' WHERE ShopID = 3";
command.ExecuteNonQuery();
sqlCon.Close();
MessageBox.Show("Ευχαριστούμε για την αξιολόγηση!");
this.Hide();
var newForm = new MrDelivery();
newForm.Show();
}
}
if (ShopID == 4)
{
using (SqlConnection sqlCon = new SqlConnection(connectionString))
using (SqlCommand command = sqlCon.CreateCommand())
{
sqlCon.Open();
command.CommandText = "SELECT Rating FROM(SELECT Rating, ROW_NUMBER() OVER(ORDER BY ShopID) AS rownumber FROM tbl_Shop) AS foo WHERE foo.rownumber BETWEEN 4 and 4";
SqlDataReader reader = (null);
reader = command.ExecuteReader();
while (reader.Read())
{
convertMo = (reader["Rating"].ToString());
}
sqlCon.Close();
double.TryParse(convertMo, out oldMo);
mo = (currentmo + oldMo) / 2;
txtMo = mo.ToString();
sqlCon.Open();
command.CommandText = "UPDATE tbl_Shop SET Rating = '" + txtMo + "' WHERE ShopID = 4";
command.ExecuteNonQuery();
sqlCon.Close();
MessageBox.Show("Ευχαριστούμε για την αξιολόγηση!");
this.Hide();
var newForm = new MrDelivery();
newForm.Show();
}
}
}
