private void btnew_Click(object sender, EventArgs e) { urbanmshare form1 = (urbanmshare)Application.OpenForms["urbanmshare"]; Panel panel1 = (Panel)form1.Controls["panel"]; panel1.Controls.Add(newaccount.Instance); newaccount.Instance.Dock = DockStyle.Fill; newaccount.Instance.BringToFront(); this.tbpassword.Text = string.Empty; this.tbusername.Text = string.Empty; }
private void btevaluate_Click(object sender, EventArgs e) { Program.idservice = Convert.ToInt32((sender as Button).Tag); urbanmshare form1 = (urbanmshare)Application.OpenForms["urbanmshare"]; Panel panel1 = (Panel)form1.Controls["panel"]; panel1.AutoScroll = false; panel1.Controls.Add(evaluation.Instance); evaluation.Instance.Dock = DockStyle.Fill; evaluation.Instance.BringToFront(); }
private void btrent_Click(object sender, EventArgs e) { if (lbcurrentstate.Text == "Não") { MessageBox.Show("Esta Viatura encontra-se indisponivel de momento.", "DriveMi - UrbanMShare"); return; } DialogResult rentconfirm = MessageBox.Show("Confirma o aluguer desta viatura?", "DriveMi - UrbanMShare", MessageBoxButtons.YesNo); if (rentconfirm == DialogResult.Yes) { sqlconn.Open(); SqlCommand qry2 = new SqlCommand(@"INSERT INTO [0502Service] ( [IDclient], [IDvehicle], [ReservDateStart], [ReservDateEnd],[PickUpPlace], [SimPrice],[CurrentState]) VALUES (@IDclient, @IDvehicle, @ReservDateStart, @ReservDateEnd, @PickUpPlace, @SimPrice, @CurrentState)", sqlconn); qry2.Parameters.Add("@IDclient", SqlDbType.VarChar).Value = Program.idclient; qry2.Parameters.Add("@IDvehicle", SqlDbType.VarChar).Value = Program.idrent; qry2.Parameters.Add("@ReservDateStart", SqlDbType.VarChar).Value = daterent.Value.ToString("yyyy-MM-dd HH:mm:ss");; qry2.Parameters.Add("@ReservDateEnd", SqlDbType.VarChar).Value = datedelivery.Value.ToString("yyyy-MM-dd HH:mm:ss");; qry2.Parameters.Add("@PickUpPlace", SqlDbType.VarChar).Value = idlocality; qry2.Parameters.Add("@SimPrice", SqlDbType.VarChar).Value = simprice; qry2.Parameters.Add("@CurrentState", SqlDbType.VarChar).Value = 1; qry2.ExecuteScalar(); SqlCommand qry3 = new SqlCommand(@"UPDATE [0501Vehicle] SET [0501Vehicle].CurrentState = 0 WHERE [0501Vehicle].IDvehicle = @IDvehicle;", sqlconn); qry3.Parameters.Add("@IDvehicle", SqlDbType.VarChar).Value = Program.idrent; qry3.ExecuteScalar(); sqlconn.Close(); urbanmshare form1 = (urbanmshare)Application.OpenForms["urbanmshare"]; Panel panel1 = (Panel)form1.Controls["panel"]; panel1.AutoScroll = false; panel1.Controls.Add(services.Instance); services.Instance.Dock = DockStyle.Fill; services.Instance.BringToFront(); services.Instance.cleanfilters(); services.Instance.createform(); MessageBox.Show("Viatura alugada com sucesso." + Environment.NewLine + "Pode proceder ao levantamnto da mesma.", "DriveMi - UrbanMShare"); } }
private void bcancel_Click(object sender, EventArgs e) { urbanmshare form1 = (urbanmshare)Application.OpenForms["urbanmshare"]; Panel panel1 = (Panel)form1.Controls["panel"]; panel1.Width = 950; panel1.Left = 0; foreach (Control c in this.Controls) { if (c.GetType() == typeof(TextBox)) { ((TextBox)(c)).Text = string.Empty; } if (c.GetType() == typeof(MaskedTextBox)) { ((MaskedTextBox)(c)).Text = string.Empty; } } panel1.Controls.Add(login.Instance); login.Instance.Dock = DockStyle.Fill; login.Instance.BringToFront(); }
private void ahpmethod() { double impF3F2; double impF2F3; double impF3F1; double impF1F3; double impF2F1; double impF1F2; double generalCIsum; double[,] general = new double[3, 5]; if (tb1.Value > 8) { impF2F3 = Math.Abs(tb1.Value - 7); impF3F2 = Convert.ToDouble(1.0 / Math.Abs(tb1.Value - 7)); } else { impF3F2 = Math.Abs(tb1.Value - 9); impF2F3 = Convert.ToDouble(1.0 / Math.Abs(tb1.Value - 9)); } if (tb2.Value > 8) { impF1F2 = Math.Abs(tb2.Value - 7); impF2F1 = Convert.ToDouble(1.0 / Math.Abs(tb2.Value - 7)); } else { impF2F1 = Math.Abs(tb2.Value - 9); impF1F2 = Convert.ToDouble(1.0 / Math.Abs(tb2.Value - 9)); } if (tb3.Value > 8) { impF1F3 = Math.Abs(tb3.Value - 7); impF3F1 = Convert.ToDouble(1.0 / Math.Abs(tb3.Value - 7)); } else { impF3F1 = Math.Abs(tb3.Value - 9); impF1F3 = Convert.ToDouble(1.0 / Math.Abs(tb3.Value - 9)); } general[0, 0] = 1.0; general[0, 1] = impF1F2; general[0, 2] = impF1F3; general[0, 3] = Math.Pow(general[0, 0] * general[0, 1] * general[0, 2], 1.0 / 3.0); general[1, 0] = impF2F1; general[1, 1] = 1.0; general[1, 2] = impF2F3; general[1, 3] = Math.Pow(general[1, 0] * general[1, 1] * general[1, 2], 1.0 / 3.0); general[2, 0] = impF3F1; general[2, 1] = impF3F2; general[2, 2] = 1.0; general[2, 3] = Math.Pow(general[2, 0] * general[2, 1] * general[2, 2], 1.0 / 3.0); generalCIsum = Convert.ToDouble(general[0, 3] + general[1, 3] + general[2, 3]); general[0, 4] = general[0, 3] / generalCIsum; general[1, 4] = general[1, 3] / generalCIsum; general[2, 4] = general[2, 3] / generalCIsum; sqlconn.Open(); SqlCommand qry1 = new SqlCommand(@"SELECT [IDvehicle], [EvTopic1], [EvTopic2], [EvTopic3] FROM [0601EvaluationAvg] ORDER BY [IDvehicle]", sqlconn); reader = qry1.ExecuteReader(); int n = 0; if (reader.HasRows) { while (reader.Read()) { n += 1; } } reader.Close(); double[,] evaluation = new double[n, 5]; double[,] factor_1 = new double[n, n + 2]; double[,] factor_2 = new double[n, n + 2]; double[,] factor_3 = new double[n, n + 2]; reader = qry1.ExecuteReader(); if (reader.HasRows) { int i = 0; while (reader.Read()) { evaluation[i, 0] = Convert.ToDouble(reader["IDvehicle"]); evaluation[i, 1] = Convert.ToDouble(reader["EvTopic1"]); evaluation[i, 2] = Convert.ToDouble(reader["EvTopic2"]); evaluation[i, 3] = Convert.ToDouble(reader["EvTopic3"]); i += 1; } } reader.Close(); sqlconn.Close(); for (int i = 0; i < n; i++) { for (int j = 0; j < n; j++) { factor_1[i, j] = Convert.ToDouble(evaluation[i, 1] / evaluation[j, 1]); factor_2[i, j] = Convert.ToDouble(evaluation[i, 2] / evaluation[j, 2]); factor_3[i, j] = Convert.ToDouble(evaluation[i, 3] / evaluation[j, 3]); } factor_1[i, n] = 1; factor_2[i, n] = 1; factor_3[i, n] = 1; } double factor1CIsum = 0, factor2CIsum = 0, factor3CIsum = 0; for (int i = 0; i < n; i++) { for (int j = 0; j < n; j++) { factor_1[i, n] *= factor_1[i, j]; factor_2[i, n] *= factor_2[i, j]; factor_3[i, n] *= factor_3[i, j]; } factor_1[i, n] = Math.Pow(factor_1[i, n], 1.0 / n); factor1CIsum += factor_1[i, n]; factor_2[i, n] = Math.Pow(factor_2[i, n], 1.0 / n); factor2CIsum += factor_2[i, n]; factor_3[i, n] = Math.Pow(factor_3[i, n], 1.0 / n); factor3CIsum += factor_3[i, n]; } for (int i = 0; i < n; i++) { factor_1[i, n + 1] = factor_1[i, n] / factor1CIsum; factor_2[i, n + 1] = factor_2[i, n] / factor2CIsum; factor_3[i, n + 1] = factor_3[i, n] / factor3CIsum; } for (int i = 0; i < n; i++) { evaluation[i, 4] = factor_1[i, n + 1] * general[0, 4] + factor_2[i, n + 1] * general[1, 4] + factor_3[i, n + 1] * general[2, 4]; } double[] scores = new double[n]; for (int i = 0; i < n; i++) { scores[i] = evaluation[i, 4]; } Array.Sort(scores); Array.Reverse(scores); Program.ahp_order = " ORDER BY CASE [0501Vehicle].IDvehicle "; for (int i = 0; i < n; i++) { for (int j = 0; j < n; j++) { if (evaluation[j, 4] == scores[i]) { Program.ahp_order += " WHEN " + evaluation[j, 0] + " THEN " + (i + 1); } } } Program.ahp_order += " End"; Program.qrystate = 1; urbanmshare form1 = (urbanmshare)Application.OpenForms["urbanmshare"]; Panel panel1 = (Panel)form1.Controls["panel"]; panel1.AutoScroll = true; services.Instance.BringToFront(); services.Instance.cleanfilters(); }
private void btsave_Click(object sender, EventArgs e) { Regex reg = new Regex(@"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$"); //formato de email int parsedValue; DateTime tmpDate, cartaValidadeDate, cPagValidadeDate, birthdayDate; if (DateTime.TryParse(tblicenceval.Text, out tmpDate)) { cartaValidadeDate = DateTime.ParseExact(tblicenceval.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture); } else { cartaValidadeDate = DateTime.ParseExact("01-01-1000", "dd-MM-yyyy", CultureInfo.InvariantCulture); } if (DateTime.TryParse(tbcardval.Text, out tmpDate)) { cPagValidadeDate = DateTime.ParseExact(tbcardval.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture); } else { cPagValidadeDate = DateTime.ParseExact("01-01-1000", "dd-MM-yyyy", CultureInfo.InvariantCulture); } if (DateTime.TryParse(tbbirthday.Text, out tmpDate)) { birthdayDate = DateTime.ParseExact(tbbirthday.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture); } else { birthdayDate = DateTime.ParseExact("01-01-1000", "dd-MM-yyyy", CultureInfo.InvariantCulture); } if (tbusername.Text == "" || tbusername.Text == null || int.TryParse(tbusername.Text, out parsedValue)) { MessageBox.Show("Campo nome de utilizador não preenchido devidamente.", "DriveMi - UrbanMShare"); } else if (tbpassword.Text == "" || tbpassword.Text == null) { MessageBox.Show("Campo nome de Senha não preenchido devidamente.", "DriveMi - UrbanMShare"); } else if (tbname.Text == "" || tbname.Text == null || int.TryParse(tbname.Text, out parsedValue)) { MessageBox.Show("Campo nome não preenchido devidamente.", "DriveMi - UrbanMShare"); } else if (tbaddress.Text == "" || tbaddress.Text == null || int.TryParse(tbaddress.Text, out parsedValue)) { MessageBox.Show("Campo morada não preenchido devidamente.", "DriveMi - UrbanMShare"); } else if (tbpostal1.Text == "" || tbpostal1.Text == null) { MessageBox.Show("Campo do código postal não preenchido.", "DriveMi - UrbanMShare"); } else if (tbpostal1.Text.Length != 4) { MessageBox.Show("Insira um código postal válido.", "DriveMi - UrbanMShare"); } else if (tbpostal2.Text == "" || tbpostal2.Text == null) { MessageBox.Show("Campo do código postal não preenchido.", "DriveMi - UrbanMShare"); } else if (tblocality.Text == "" || tblocality.Text == null || int.TryParse(tblocality.Text, out parsedValue)) { MessageBox.Show("Campo localidade não preenchid devidamente.", "DriveMi - UrbanMShare"); } else if (tbfiscal.Text == "" || tbfiscal.Text == null) { MessageBox.Show("Campo número fiscal não preenchido.", "DriveMi - UrbanMShare"); } else if (tbfiscal.Text.Length != 9) { MessageBox.Show("Insira um NIF válido.", "DriveMi - UrbanMShare"); } else if (tbbirthday.Text == "" || tbbirthday.Text == null || birthdayDate.ToString() == "01-01-1000 00:00:00") { MessageBox.Show("Campo da data de nascimento com data inválida.", "DriveMi - UrbanMShare"); } else if (tblicence.Text == "" || tblicence.Text == null) { MessageBox.Show("Campo do número da carta de condução não preenchido.", "DriveMi - UrbanMShare"); } else if (tblicenceval.Text == "" || tblicenceval.Text == null || cartaValidadeDate.ToString() == "01-01-1000 00:00:00") { MessageBox.Show("Campo da validade da carta de condução com data inválida.", "DriveMi - UrbanMShare"); } else if (cartaValidadeDate < DateTime.Now) { MessageBox.Show("A validade da carta de condução está expirada.", "DriveMi - UrbanMShare"); } else if (tbcard.Text == "" || tbcard.Text == null) { MessageBox.Show("Campo do cartão de pagamento não preenchido.", "DriveMi - UrbanMShare"); } else if (tbcard.Text.Length != 16) { MessageBox.Show("Insira um número de cartão de pagamento válido.", "DriveMi - UrbanMShare"); } else if (tbcardval.Text == "" || tbcardval.Text == null || cPagValidadeDate.ToString() == "01-01-1000 00:00:00") { MessageBox.Show("Campo da validade do cartão com data inválida", "DriveMi - UrbanMShare"); } else if (cPagValidadeDate < DateTime.Now) { MessageBox.Show("A validade do cartão de pagamento está expirada.", "DriveMi - UrbanMShare"); } else if (tbemail.Text == "" || tbemail.Text == null) { MessageBox.Show("Campo email não preenchido.", "DriveMi - UrbanMShare"); } else if (tbphone.Text == "" || tbphone.Text == null) { MessageBox.Show("Campo contacto não preenchido.", "DriveMi - UrbanMShare"); } else if (tbphone.Text.Length != 9) { MessageBox.Show("Insira um número de contacto válido.", "DriveMi - UrbanMShare"); } else if (!reg.IsMatch(tbemail.Text)) { MessageBox.Show("Introduza um email válido.", "DriveMi - UrbanMShare"); } else if (!int.TryParse(tbfiscal.Text, out parsedValue)) { MessageBox.Show("O NIF que inseriu não são numéricos.", "DriveMi - UrbanMShare"); } else { string fullName = tbname.Text; string[] names = fullName.Split(' '); DateTime cardval = DateTime.ParseExact(tbcardval.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture); DateTime licenceval = DateTime.ParseExact(tblicenceval.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture); DateTime birthday = DateTime.ParseExact(tbbirthday.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture); SqlConnection sqlconn = new SqlConnection(Program.strconn_str); sqlconn.Open(); SqlCommand qry = new SqlCommand("SELECT count([IDperson]) FROM [00Autentication] Where [Usrname]=@username;", sqlconn); qry.Parameters.Add("@username", SqlDbType.VarChar).Value = tbusername.Text; int usercount = Convert.ToInt32(qry.ExecuteScalar()); sqlconn.Close(); if (usercount > 1) { MessageBox.Show("O nome de utilizador escolhido já existe.", "DriveMi - UrbanMShare"); return; } sqlconn.Open(); SqlCommand qry2 = new SqlCommand(@"INSERT INTO [0401Client] ( [IDaddress], [IDlocality], [RegDate], [Name],[Address],[FiscalNr], [PayCardNr],[PayCardValidity],[LicenceNr],[LicenceNrValidity], [DateBirth],[SmallName]) output INSERTED.IDclient VALUES ( @IDaddress, @IDlocality, @RegDate, @Name, @Address, @FiscalNr, @PayCardNr, @PayCardValidity, @LicenceNr, @LicenceNrValidity, @DateBirth, @SmallName)" , sqlconn); qry2.Parameters.Add("@IDaddress", SqlDbType.VarChar).Value = tbpostal2.Text; qry2.Parameters.Add("@IDlocality", SqlDbType.VarChar).Value = tbpostal1.Text; qry2.Parameters.Add("@RegDate", SqlDbType.VarChar).Value = DateTime.Now.ToString("yyyy/MM/dd"); qry2.Parameters.Add("@Name", SqlDbType.VarChar).Value = tbname.Text; qry2.Parameters.Add("@Address", SqlDbType.VarChar).Value = tbaddress.Text; qry2.Parameters.Add("@FiscalNr", SqlDbType.VarChar).Value = tbfiscal.Text; qry2.Parameters.Add("@PayCardNr", SqlDbType.VarChar).Value = tbcard.Text; qry2.Parameters.Add("@PayCardValidity", SqlDbType.VarChar).Value = cardval.ToString("yyyy-MM-dd"); qry2.Parameters.Add("@LicenceNr", SqlDbType.VarChar).Value = tblicence.Text; qry2.Parameters.Add("@LicenceNrValidity", SqlDbType.VarChar).Value = licenceval.ToString("yyyy-MM-dd"); qry2.Parameters.Add("@DateBirth", SqlDbType.VarChar).Value = birthday.ToString("yyyy-MM-dd"); qry2.Parameters.Add("@SmallName", SqlDbType.VarChar).Value = names.First() + " " + names.Last(); int iduser = Convert.ToInt32(qry2.ExecuteScalar()); SqlCommand qry3 = new SqlCommand(@"INSERT INTO [00Autentication] ( [IDperson], [IDpersonType], [Usrname], [Usrpass],[CurrentState]) VALUES ( @IDperson, @IDpersontype, @Usrname, @Usrpass, @CurrentState)" , sqlconn); qry3.Parameters.Add("@IDperson", SqlDbType.VarChar).Value = iduser; qry3.Parameters.Add("@IDpersontype", SqlDbType.VarChar).Value = 24; qry3.Parameters.Add("@Usrname", SqlDbType.VarChar).Value = tbusername.Text; qry3.Parameters.Add("@Usrpass", SqlDbType.VarChar).Value = Program.GetMD5(tbpassword.Text); qry3.Parameters.Add("@CurrentState", SqlDbType.VarChar).Value = 1; qry3.ExecuteScalar(); SqlCommand qry4 = new SqlCommand(@"INSERT INTO [0403Contact] ( [IDperson], [IDcontactType], [IDpersonType], [Contact],[Obs]) VALUES (@IDperson, @IDcontactType, @IDpersonType, @Contact, @Obs)", sqlconn); qry4.Parameters.Add("@IDperson", SqlDbType.VarChar).Value = iduser; qry4.Parameters.Add("@IDcontactType", SqlDbType.VarChar).Value = 4; qry4.Parameters.Add("@IDpersonType", SqlDbType.VarChar).Value = 24; qry4.Parameters.Add("@Contact", SqlDbType.VarChar).Value = tbemail.Text; qry4.Parameters.Add("@Obs", SqlDbType.VarChar).Value = "Contacto de email guardado durante o registo."; qry4.ExecuteScalar(); SqlCommand qry5 = new SqlCommand(@"INSERT INTO [0403Contact] ( [IDperson], [IDcontactType], [IDpersonType], [Contact],[Obs]) VALUES (@IDperson, @IDcontactType, @IDpersonType, @Contact, @Obs)", sqlconn); qry5.Parameters.Add("@IDperson", SqlDbType.VarChar).Value = iduser; qry5.Parameters.Add("@IDcontactType", SqlDbType.VarChar).Value = 1; qry5.Parameters.Add("@IDpersonType", SqlDbType.VarChar).Value = 24; qry5.Parameters.Add("@Contact", SqlDbType.VarChar).Value = tbphone.Text; qry5.Parameters.Add("@Obs", SqlDbType.VarChar).Value = "Contacto telefónico guardado durante o registo."; qry5.ExecuteScalar(); sqlconn.Close(); urbanmshare form1 = (urbanmshare)Application.OpenForms["urbanmshare"]; Panel panel1 = (Panel)form1.Controls["panel"]; panel1.Controls.Add(login.Instance); login.Instance.Dock = DockStyle.Fill; login.Instance.BringToFront(); login.Instance.tbusername.Text = tbusername.Text; login.Instance.tbpassword.Text = tbpassword.Text; foreach (Control c in this.Controls) { if (c.GetType() == typeof(TextBox)) { ((TextBox)(c)).Text = string.Empty; } if (c.GetType() == typeof(MaskedTextBox)) { ((MaskedTextBox)(c)).Text = string.Empty; } } } }
private void services_Load(object sender, EventArgs e) { while (Controls.Count > 0) { Controls[0].Dispose(); } InitializeComponent(); createform(); sqlconn.Open(); SqlCommand qry3 = new SqlCommand("SELECT [Brand] FROM [0302CarBrand] ORDER BY [Brand] ;", sqlconn); reader = qry3.ExecuteReader(); cbbrand.Items.Add("Todas"); if (reader.HasRows) { while (reader.Read()) { cbbrand.Items.Add(reader["Brand"].ToString()); } } reader.Close(); SqlCommand qry4 = new SqlCommand("SELECT [DataValue] FROM [01BaseData] Where [DataType] = 2 Order by [DataValue] ;", sqlconn); reader = qry4.ExecuteReader(); cbcolour.Items.Add("Todas"); if (reader.HasRows) { while (reader.Read()) { cbcolour.Items.Add(reader["DataValue"].ToString()); } } reader.Close(); SqlCommand qry5 = new SqlCommand("SELECT [DataValue] FROM [01BaseData] Where [DataType] = 8 Order by [DataValue] ;", sqlconn); reader = qry5.ExecuteReader(); cbfueltype.Items.Add("Todas"); if (reader.HasRows) { while (reader.Read()) { cbfueltype.Items.Add(reader["DataValue"].ToString()); } } reader.Close(); SqlCommand qry6 = new SqlCommand("SELECT Distinct [Locality] FROM [0203Locality] ORDER BY [Locality];", sqlconn); reader = qry6.ExecuteReader(); cblocalization.Items.Add("Todas"); if (reader.HasRows) { while (reader.Read()) { cblocalization.Items.Add(reader["Locality"].ToString()); } } reader.Close(); sqlconn.Close(); cbbrand.Text = cbbrandtext; cbcolour.Text = cbcolourtext; cbfueltype.Text = cbfueltypetext; cblocalization.Text = cblocalizatontext; cbavailability.Text = cbavailabilitytext; cborder.Text = cbordertext; urbanmshare form1 = (urbanmshare)Application.OpenForms["urbanmshare"]; Panel panel1 = (Panel)form1.Controls["panel"]; panel1.AutoScroll = false; panel1.AutoScroll = true; }
private void btlogin_Click(object sender, EventArgs e) { try { SqlConnection sqlconn = new SqlConnection(Program.strconn_str); SqlCommand cmd = new SqlCommand(@"SELECT [0401Client].IDclient, [0401Client].SmallName, [00Autentication].Usrname, [00Autentication].Usrpass, [00Autentication].CurrentState, [0203Locality].Locality FROM ( [00Autentication] INNER JOIN [0401Client] ON [00Autentication].IDperson = [0401Client].IDclient) INNER JOIN [0203Locality] ON [0401Client].IDlocality = [0203Locality].IDlocality WHERE [00Autentication].Usrname = @user and [00Autentication].Usrpass = @password;", sqlconn); cmd.Parameters.Add("@user", SqlDbType.VarChar).Value = tbusername.Text; cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = Program.GetMD5(tbpassword.Text); sqlconn.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { if (Convert.ToInt32(reader["CurrentState"]) == 0) { MessageBox.Show("O utilizador encontra-se desativado", "DriveMi - UrbanMShare"); this.tbpassword.Text = string.Empty; this.tbusername.Text = string.Empty; return; } Program.smallname = reader["SmallName"].ToString(); Program.idclient = Convert.ToInt32(reader["IDclient"]); urbanmshare form1 = (urbanmshare)Application.OpenForms["urbanmshare"]; Panel panel1 = (Panel)form1.Controls["panel"]; panel1.AutoScroll = true; panel1.AutoScrollMargin = new System.Drawing.Size(20, 490); panel1.AutoScrollMinSize = new System.Drawing.Size(20, 490); panel1.Controls.Add(services.Instance); panel1.Width = 790; panel1.Left = 160; services.Instance.Dock = DockStyle.Fill; services.Instance.BringToFront(); this.tbpassword.Text = string.Empty; this.tbusername.Text = string.Empty; } } else { MessageBox.Show("Utilizador ou password incorretos.", "DriveMi - UrbanMShare"); this.tbpassword.Text = string.Empty; this.tbusername.Text = string.Empty; } reader.Close(); sqlconn.Close(); } catch (SqlException) { MessageBox.Show("Erro na ligação à base de dados", "DriveMi - UrbanMShare"); this.tbpassword.Text = string.Empty; this.tbusername.Text = string.Empty; } }
private void btevaluate_Click(object sender, EventArgs e) { if (factor1 == 0 || factor2 == 0 || factor3 == 0) { MessageBox.Show("Para submeter a sua avaliação todos os fatores deverão ser avaliados.", "DriveMi - UrbanMShare"); } else { sqlconn.Open(); SqlCommand qry1 = new SqlCommand(@"INSERT INTO [0602Evaluation] ( [IDservice], [EvTopic1], [EvTopic2], [EvTopic3]) VALUES ( @IDservice, @factor1, @factor2, @factor3)", sqlconn); qry1.Parameters.Add("@IDservice", SqlDbType.VarChar).Value = Program.idservice; qry1.Parameters.Add("@factor1", SqlDbType.VarChar).Value = factor1; qry1.Parameters.Add("@factor2", SqlDbType.VarChar).Value = factor2; qry1.Parameters.Add("@factor3", SqlDbType.VarChar).Value = factor3; qry1.ExecuteScalar(); SqlCommand qry2 = new SqlCommand(@"SELECT [0502Service].IDvehicle FROM [0602Evaluation] INNER JOIN [0502Service] ON [0602Evaluation].IDservice = [0502Service].IDservice WHERE [0602Evaluation].IDservice=@IDservice;", sqlconn); qry2.Parameters.Add("@IDservice", SqlDbType.VarChar).Value = Program.idservice; int IdVehicle = Convert.ToInt32(qry2.ExecuteScalar()); SqlCommand qry3 = new SqlCommand(@"UPDATE [0601EvaluationAvg] SET [0601EvaluationAvg].EvTopic1 = [updavg].EvTopic1, [0601EvaluationAvg].EvTopic2 = [updavg].EvTopic2, [0601EvaluationAvg].EvTopic3 = [updavg].EvTopic3 FROM [0601EvaluationAvg] INNER JOIN (SELECT [0502Service].IDvehicle, Avg([0602Evaluation].EvTopic1) AS EvTopic1, Avg([0602Evaluation].EvTopic2) AS EvTopic2, Avg([0602Evaluation].EvTopic3) AS EvTopic3 FROM ([0602Evaluation] INNER JOIN [0502Service] ON [0602Evaluation].IDservice = [0502Service].IDservice) INNER JOIN [0501Vehicle] ON [0502Service].IDvehicle = [0501Vehicle].IDvehicle GROUP BY [0502Service].IDvehicle) AS [updavg] ON [0601EvaluationAvg].IDvehicle = [updavg].IDvehicle WHERE [updavg].IDvehicle = @IDVehicle", sqlconn); qry3.Parameters.Add("@IDVehicle", SqlDbType.VarChar).Value = IdVehicle; qry3.ExecuteScalar(); MessageBox.Show("A UrbanMShare agradece a sua avaliação.", "DriveMi - UrbanMShare"); urbanmshare form1 = (urbanmshare)Application.OpenForms["urbanmshare"]; Panel panel1 = (Panel)form1.Controls["panel"]; panel1.AutoScroll = false; panel1.Controls.Add(historic.Instance); historic.Instance.Dock = DockStyle.Fill; historic.Instance.BringToFront(); historic.Instance.createform(); sqlconn.Close(); } }