protected override async System.Threading.Tasks.Task OnInitializedAsync() { soferi = new List <Models.FirmaCurierat.Soferi>(); client = new Models.FirmaCurierat.Clienti(); comanda = new Models.FirmaCurierat.Comenzi(); tip = new List <Models.FirmaCurierat.TipComenzi>(); coordsList = new List <Models.FirmaCurierat.Dispeceri>(); tip_selected = new Models.FirmaCurierat.TipComenzi(); // SqlConnection scn = new SqlConnection(); string ServerName = Environment.MachineName; string database = "CurieratVladProiect"; string ConnectionString = String.Format(@"Server={0}\SQLEXPRESS;Initial Catalog={1}; Integrated Security = SSPI", ServerName, database); //lista de dispeceri pentur a putea atribuii comenzii coordsList = new List <Models.FirmaCurierat.Dispeceri>(); string sqlCommand = "select * from dispeceri"; dataHelper = new DataBaseManagement.DataManagement(); coordsList = await dataHelper.LoadData <Models.FirmaCurierat.Dispeceri, dynamic>(sqlCommand, new { }, ConnectionString); //ce tipuri de comenzi am sqlCommand = "select * from tip_comenzi"; tip = await dataHelper.LoadData <Models.FirmaCurierat.TipComenzi, dynamic>(sqlCommand, new { }, ConnectionString); //soferii sqlCommand = "select * from soferi"; soferi = await dataHelper.LoadData <Models.FirmaCurierat.Soferi, dynamic>(sqlCommand, new { }, ConnectionString); }
//functie pentru accesarea paginii de editare a comenzii protected async System.Threading.Tasks.Task updateOrder(MouseEventArgs args, object data) { FirmaCurierat.Models.FirmaCurierat.Clienti data2 = new Models.FirmaCurierat.Clienti(); // drivers2.RemoveAll(d => d.id_sofer == data2.id_sofer); data2 = (Models.FirmaCurierat.Clienti)data; UriHelper.NavigateTo($"edit-order/{data2.id_client}"); //var dialogResult = await DialogService.OpenAsync<EditClientandOrder>("Edit Order", new Dictionary<string, object>() { { "client_id", data2.id_client} }); await InvokeAsync(() => { StateHasChanged(); }); }
protected async Task loadClientsandOrders() { comenzi = new List <Models.FirmaCurierat.Comenzi>(); dataHelper = new DataBaseManagement.DataManagement(); clients = new List <Models.FirmaCurierat.Clienti>(); client = new Models.FirmaCurierat.Clienti(); SqlConnection scn = new SqlConnection(); string ServerName = Environment.MachineName; string database = "CurieratVladProiect"; string ConnectionString = String.Format(@"Server={0}\SQLEXPRESS;Initial Catalog={1}; Integrated Security = SSPI", ServerName, database); scn.ConnectionString = ConnectionString; SqlCommand scmd = new SqlCommand("select * from clienti where id_client = @id", scn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@id", client_id); scn.Open(); // var inserted_Client = (Models.FirmaCurierat.Clienti)scmd.ExecuteScalar(); using (SqlDataReader reader = scmd.ExecuteReader()) { if (reader.Read()) { client.id_client = (int)reader["id_client"]; client.mail = (string)reader["mail"]; client.nume = (string)reader["nume"]; client.prenume = (string)reader["prenume"]; client.adresa = (string)reader["adresa"]; } } // SqlConnection scn = new SqlConnection(); // scn.ConnectionString = @"Data Source=DESKTOP-I3NIEPL\SQLEXPRESS;Initial Catalog=login_database;database=CurieratVladProiect;integrated security=SSPI"; // string ConnectionString = @"Data Source=DESKTOP-I3NIEPL\SQLEXPRESS;Initial Catalog=login_database;database=CurieratVladProiect;integrated security=SSPI"; comanda = new Models.FirmaCurierat.Comenzi(); scmd = new SqlCommand("select * from comenzi where id_client = @id", scn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@id", client_id); using (SqlDataReader reader = scmd.ExecuteReader()) { if (reader.Read()) { comanda.awb = (string)reader["awb"]; comanda.data_livrare = (string)reader["data_livrare"]; comanda.id_client = (int)reader["id_client"]; comanda.id_comanda = (int)reader["id_comanda"]; comanda.id_dispecer = (int)reader["id_dispecer"]; } } comanda = comenzi.Where(i => i.id_client == Convert.ToInt32(client_id)).FirstOrDefault(); }
protected async System.Threading.Tasks.Task GridDeleteButtonClick(MouseEventArgs args, object data) { try { if (await DialogService.Confirm("Do you want to delete this record?") == true) { //functie delete client and order FirmaCurierat.Models.FirmaCurierat.Clienti data2 = new Models.FirmaCurierat.Clienti(); // drivers2.RemoveAll(d => d.id_sofer == data2.id_sofer); data2 = (Models.FirmaCurierat.Clienti)data; SqlConnection scn = new SqlConnection(); string ServerName = Environment.MachineName; string database = "CurieratVladProiect"; string ConnectionString = String.Format(@"Server={0}\SQLEXPRESS;Initial Catalog={1}; Integrated Security = SSPI", ServerName, database); scn.ConnectionString = ConnectionString; //selectez comanda care urmeaza sa fie stearsa SqlCommand scmd = new SqlCommand("select id_comanda from comenzi where id_client = @id", scn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@id", data2.id_client); scn.Open(); int deletType = Convert.ToInt32(scmd.ExecuteScalar()); //sterg din tipul comenzii conform relatiei scmd = new SqlCommand("delete from tipul_comenzii where id_comanda = @id", scn); scmd.Parameters.AddWithValue("@id", deletType); scmd.ExecuteNonQuery(); //sterg din comenzi scmd = new SqlCommand("delete from comenzi where id_comanda = @id", scn); scmd.Parameters.AddWithValue("@id", deletType); scmd.ExecuteNonQuery(); scmd = new SqlCommand("delete from clienti where id_client = @id", scn); scmd.Parameters.AddWithValue("@id", data2.id_client); scmd.ExecuteNonQuery(); this.StateHasChanged(); clients = new List <FirmaCurierat.Models.FirmaCurierat.Clienti>(); string sqlCommand = "select * from clienti"; clients = await dataHelper.LoadData <FirmaCurierat.Models.FirmaCurierat.Clienti, dynamic>(sqlCommand, new { }, ConnectionString); grid.Refresh(); NotificationService.Notify(NotificationSeverity.Success, $"Order deleted"); } } catch (System.Exception rlvMailerDeleteMailException) { NotificationService.Notify(NotificationSeverity.Error, $"Error", $"Unable to delete order and client"); } }
protected async Task loadClientsandOrders() { //initializare liste tip = new List <Models.FirmaCurierat.TipComenzi>(); tip_selected = new Models.FirmaCurierat.TipComenzi(); comenzi = new List <Models.FirmaCurierat.Comenzi>(); dataHelper = new DataBaseManagement.DataManagement(); clients = new List <Models.FirmaCurierat.Clienti>(); client = new Models.FirmaCurierat.Clienti(); SqlConnection scn = new SqlConnection(); string ServerName = Environment.MachineName; string database = "CurieratVladProiect"; string ConnectionString = String.Format(@"Server={0}\SQLEXPRESS;Initial Catalog={1}; Integrated Security = SSPI", ServerName, database); scn.ConnectionString = ConnectionString; scn.Open(); // string ConnectionString = @"Data Source=DESKTOP-I3NIEPL\SQLEXPRESS;Initial Catalog=login_database;database=CurieratVladProiect;integrated security=SSPI"; comanda = new Models.FirmaCurierat.Comenzi(); //selecteaza comenzile clientului cu id-ul cliend_id SqlCommand scmd = new SqlCommand("select * from comenzi where id_client = @id", scn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@id", client_id); using (SqlDataReader reader = scmd.ExecuteReader()) { //ia informatiile despre comanda if (reader.Read()) { comanda.awb = (string)reader["awb"]; comanda.data_livrare = (string)reader["data_livrare"]; comanda.id_client = (int)reader["id_client"]; comanda.id_comanda = (int)reader["id_comanda"]; comanda.id_dispecer = (int)reader["id_dispecer"]; } } //selectam id-ul tipului comenzii scmd = new SqlCommand("select id_tip from tipul_comenzii where id_comanda = @id;;SELECT SCOPE_IDENTITY()", scn); scmd.Parameters.AddWithValue("@id", comanda.id_comanda); int tip_id = Convert.ToInt32(scmd.ExecuteScalar()); //selectam tipul comenzii scmd = new SqlCommand("select * from tip_comenzi where id_tip = @id", scn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@id", tip_id); using (SqlDataReader reader = scmd.ExecuteReader()) { //luam datele despre tip si specificatiile if (reader.Read()) { tip_selected.id_tip = (int)reader["id_tip"]; tip_selected.specificatii = (string)reader["specificatii"]; tip_selected.tip = (string)reader["tip"]; } } string sqlCommand = "select * from tip_comenzi"; tip = await dataHelper.LoadData <Models.FirmaCurierat.TipComenzi, dynamic>(sqlCommand, new { }, ConnectionString); }
protected override async System.Threading.Tasks.Task OnInitializedAsync() { client = new Models.FirmaCurierat.Clienti(); }