public string DeleteLicitatii(Licitatii licitatii) //Din perspectiva de Useri & Admini in DB
{
string mainconn = ConfigurationManager.ConnectionStrings["MySQLConnection"].ConnectionString;
MySqlConnection mysqlconn = new MySqlConnection(mainconn);
string sqlquery = "DELETE FROM `licitatii` WHERE Id='" + licitatii.Id + "'"; // se face delete doar dupa PK
MySqlCommand sqlcomm = new MySqlCommand(sqlquery, mysqlconn);
mysqlconn.Open();
MySqlDataAdapter mda = new MySqlDataAdapter(sqlcomm);
DataTable dt = new DataTable();
mda.Fill(dt); //ne aduce tabela din PHP in C# (mda -SQL adapter)
mysqlconn.Close(); // inchide tabela pt a o putea refolosii in alte servicii
return("Licitatia a fost stearsa");
}
public string InsertLicitatii(Licitatii licitatii, string username) //Din perspectiva de Useri & Admini in DB
{
string mainconn = ConfigurationManager.ConnectionStrings["MySQLConnection"].ConnectionString;
MySqlConnection mysqlconn = new MySqlConnection(mainconn);
string sqlquery = "INSERT INTO `licitatii`(`NumeProdus`, `Pret`, `User`) VALUES ('" + licitatii.NumeProdus + "', '" + licitatii.Pret + "', '" + username + "')";
MySqlCommand sqlcomm = new MySqlCommand(sqlquery, mysqlconn);
mysqlconn.Open();
MySqlDataAdapter mda = new MySqlDataAdapter(sqlcomm);
DataTable dt = new DataTable();
mda.Fill(dt); //ne aduce tabela din PHP in C# (mda -SQL adapter)
mysqlconn.Close(); // inchide tabela pt a o putea refolosii in alte servicii
return("Licitatia a fost adaugata");
}
public string EditLicitatii(Licitatii licitatii) //Din perspectiva de Useri & Admini in DB
{
string mainconn = ConfigurationManager.ConnectionStrings["MySQLConnection"].ConnectionString;
MySqlConnection mysqlconn = new MySqlConnection(mainconn);
string sqlquery = "UPDATE `licitatii` SET `NumeProdus`='" + licitatii.NumeProdus + "', `Pret`='" + licitatii.Pret + "' where `Id`='" + licitatii.Id + "'";
MySqlCommand sqlcomm = new MySqlCommand(sqlquery, mysqlconn);
mysqlconn.Open();
MySqlDataAdapter mda = new MySqlDataAdapter(sqlcomm);
DataTable dt = new DataTable();
mda.Fill(dt); //ne aduce tabela din PHP in C# (mda -SQL adapter)
mysqlconn.Close(); // inchide tabela pt a o putea refolosii in alte servicii
return("Licitatia a fost editata");
}
