protected override async System.Threading.Tasks.Task OnInitializedAsync()
{
dataHelper = new DataBaseManagement.DataManagement();
interestList = new List <infoForTheGrid>();
string ServerName = Environment.MachineName;
string database = "CurieratVladProiect";
string ConnectionString = String.Format(@"Server={0}\SQLEXPRESS;Initial Catalog={1};
Integrated Security = SSPI", ServerName, database);
//comanda sql folosita
//select a.nume, a.prenume from soferi a where a.id_dispecer = (select c.id_dispecer from dispeceri c inner join comenzi d on c.id_dispecer = d.id_dispecer where d.awb = '123111' )
string sqlCommand = "select a.nume_dispecer from dispeceri a where " +
" a.id_dispecer = (select c.id_dispecer from dispeceri c inner join comenzi d on c.id_dispecer = d.id_dispecer where d.awb= '" + awb + "' and d.id_client = (select id_client from clienti e where d.id_client = e.id_client ) ) ";
//alocare
List <string> nume_dispecer = new List <string>();
//obtinerea datelor din baza de date
nume_dispecer = await dataHelper.LoadData <string, dynamic>(sqlCommand, new { }, ConnectionString);
sqlCommand = "select a.valoare_comanda, a.awb,a.data_livrare from comenzi a where a.awb = '" + awb + "'";
interestList = await dataHelper.LoadData <infoForTheGrid, dynamic>(sqlCommand, new { }, ConnectionString);
if (interestList.Count == 0)
{
// notificare
NotificationService.Notify(NotificationSeverity.Error, $"Error", $"We do not have an order with this awb");
//return la pagina
UriHelper.NavigateTo("/user");
}
else
{
interestList.ElementAt(0).nume_dispecer = nume_dispecer.ElementAt(0);
}
}
protected override async System.Threading.Tasks.Task OnInitializedAsync()
{
dataHelper = new DataBaseManagement.DataManagement();
interestList = new List <infoForTheGrid>();
list2 = new List <forGrid2>();
list3 = new List <forGrid3>();
string ServerName = Environment.MachineName;
string database = "CurieratVladProiect";
string ConnectionString = String.Format(@"Server={0}\SQLEXPRESS;Initial Catalog={1};
Integrated Security = SSPI", ServerName, database);
string sqlCommand = "select a.nume_dispecer, b.nume, b.prenume from dispeceri a " +
"inner join soferi b on a.id_dispecer = b.id_dispecer";
interestList = await dataHelper.LoadData <infoForTheGrid, dynamic>(sqlCommand, new { }, ConnectionString);
sqlCommand = "select a.nume_dispecer, b.id_comanda from dispeceri a inner join comenzi b on a.id_dispecer = b.id_dispecer";
list2 = await dataHelper.LoadData <forGrid2, dynamic>(sqlCommand, new { }, ConnectionString);
sqlCommand = "select a.nume_dispecer,count(id_comanda) as id_co " +
"from dispeceri a inner join comenzi c on a.id_dispecer = c.id_dispecer group by a.nume_dispecer having count(id_comanda) >=5";
list3 = await dataHelper.LoadData <forGrid3, dynamic>(sqlCommand, new { }, ConnectionString);
list4 = new List <forGrid4>();
sqlCommand = "select a.nume, a.prenume, b.awb from clienti a inner join comenzi b on a.id_client = b.id_client";
list4 = await dataHelper.LoadData <forGrid4, dynamic>(sqlCommand, new { }, ConnectionString);
list5 = new List <forGrid5>();
sqlCommand = "select a.marca, a.an, b.nume, b.prenume from masini a left join soferi b on a.id_masina = b.id_masina group by a.marca, a.an, b.nume, b.prenume having a.an <= 2020";
list5 = await dataHelper.LoadData <forGrid5, dynamic>(sqlCommand, new { }, ConnectionString);
}
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);
}
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 override async System.Threading.Tasks.Task OnInitializedAsync()
{
dataHelper = new DataBaseManagement.DataManagement();
// SqlConnection scn = new SqlConnection();
string ConnectionString = @"Data Source=DESKTOP-I3NIEPL\SQLEXPRESS;Initial Catalog=login_database;database=CurieratVladProiect;integrated security=SSPI";
drivers = new List <FirmaCurierat.Models.FirmaCurierat.Soferi>();
string sqlCommand = "select * from soferi";
// scn.Open();
drivers = await dataHelper.LoadData <FirmaCurierat.Models.FirmaCurierat.Soferi, dynamic>(sqlCommand, new { }, ConnectionString);
}
protected override async System.Threading.Tasks.Task OnInitializedAsync()
{
dataHelper = new DataBaseManagement.DataManagement();
comenzi = new List <Models.FirmaCurierat.Comenzi>();
string ServerName = Environment.MachineName;
string database = "CurieratVladProiect";
string ConnectionString = String.Format(@"Server={0}\SQLEXPRESS;Initial Catalog={1};
Integrated Security = SSPI", ServerName, database);
string sqlCommand = "select * from comenzi";
comenzi = await dataHelper.LoadData <Models.FirmaCurierat.Comenzi, dynamic>(sqlCommand, new { }, ConnectionString);
}
protected override async System.Threading.Tasks.Task OnInitializedAsync()
{ //initializare datahelper pt a putea accesa functia generica de get a unei liste din baaz de date
dataHelper = new DataBaseManagement.DataManagement();
// 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);
interest = new List <interestList>();
string sqlCommand = "select a.nume, a.prenume, b.awb from soferi a inner join dispeceri d on d.id_dispecer = (select c.id_dispecer from dispeceri c where a.id_dispecer = c.id_dispecer ) inner join comenzi b on(d.id_dispecer = b.id_dispecer) where b.id_sofer is not null and a.id_sofer = b.id_sofer";
interest = await dataHelper.LoadData <interestList, dynamic>(sqlCommand, new { }, ConnectionString);
}
protected async Task loadLists()
{
dataHelper = new DataBaseManagement.DataManagement();
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;
coordsList = new List <Models.FirmaCurierat.Dispeceri>();
string sqlCommand = "select * from dispeceri";
SqlCommand scmd = new SqlCommand("select * from dispeceri", scn);
scmd.Parameters.Clear();
scn.Open();
var dr = scmd.ExecuteReader();
while (dr.Read())
{
Models.FirmaCurierat.Dispeceri temp = new Models.FirmaCurierat.Dispeceri();
temp.id_dispecer = (int)dr["id_dispecer"];
temp.nume_dispecer = (string)dr["nume_dispecer"];
coordsList.Add(temp);
}
sqlCommand = "select * from tip_comenzi";
tip = new List <Models.FirmaCurierat.TipComenzi>();
scmd = new SqlCommand("select * from tip_comenzi", scn);
dr.Close();
scmd.Parameters.Clear();
dr = scmd.ExecuteReader();
while (dr.Read())
{
Models.FirmaCurierat.TipComenzi temp = new Models.FirmaCurierat.TipComenzi();
temp.id_tip = (int)dr["id_tip"];
temp.specificatii = (string)dr["specificatii"];
temp.tip = (string)dr["tip"];
}
}
protected override async System.Threading.Tasks.Task OnInitializedAsync()
{
interestList = new List <infoForTheGrid>();
interestList2 = new List <infoForTheGrid2>();
dataHelper = new DataBaseManagement.DataManagement();
string ServerName = Environment.MachineName;
//interogari complexe
string database = "CurieratVladProiect";
string ConnectionString = String.Format(@"Server={0}\SQLEXPRESS;Initial Catalog={1};
Integrated Security = SSPI", ServerName, database);
string sqlCommand = "select a.nume, b.awb, b.valoare_comanda from clienti a " +
"inner join comenzi b on a.id_client = b.id_client where b.valoare_comanda >= ( select avg(valoare_comanda) from comenzi) order by " +
"b.valoare_comanda asc";
interestList = await dataHelper.LoadData <infoForTheGrid, dynamic>(sqlCommand, new { }, ConnectionString);
sqlCommand = "select a.marca,b.valoare_comanda from masini a inner join soferi c on a.id_masina = c.id_masina inner join comenzi b on b.valoare_comanda >= (select max(valoare_comanda) from comenzi) ";
interestList2 = await dataHelper.LoadData <infoForTheGrid2, dynamic>(sqlCommand, new { }, ConnectionString);
}
protected override async System.Threading.Tasks.Task OnInitializedAsync()
{ //initializare liste
driver = new Models.FirmaCurierat.Soferi();
cars = new Models.FirmaCurierat.Masini();
carsList = new List <Models.FirmaCurierat.Masini>();
coordsList = new List <Models.FirmaCurierat.Dispeceri>();
// SqlConnection scn = new SqlConnection();
string ServerName = Environment.MachineName;
//connection string general
string database = "CurieratVladProiect";
string ConnectionString = String.Format(@"Server={0}\SQLEXPRESS;Initial Catalog={1};
Integrated Security = SSPI", ServerName, database);
//initializare liste
coordsList = new List <Models.FirmaCurierat.Dispeceri>();
carsList = new List <Models.FirmaCurierat.Masini>();
//comanda
string sqlCommand = "select * from dispeceri";
dataHelper = new DataBaseManagement.DataManagement();
// scn.Open();
List <Models.FirmaCurierat.Masini> tempList = new List <Models.FirmaCurierat.Masini>();
//apelare functie generala pentru obtinerea unei liste de elemente din baza de date
coordsList = await dataHelper.LoadData <Models.FirmaCurierat.Dispeceri, dynamic>(sqlCommand, new { }, ConnectionString);
sqlCommand = "select * from masini";
//tot apelare functie generala
tempList = await dataHelper.LoadData <Models.FirmaCurierat.Masini, dynamic>(sqlCommand, new { }, ConnectionString);
sqlCommand = "select id_masina from soferi";
List <int> forSorting = new List <int>();
forSorting = await dataHelper.LoadData <int, dynamic>(sqlCommand, new { }, ConnectionString);
//aleg doar masinile care nu au asociate un sofer, relatia fiind de 1->1
carsList = tempList.Where(i => forSorting.Contains(i.id_masina) == false).ToList();
}
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);
}
