public List <StocShowroom> GetListaStocShowroomRepo()
{
List <StocShowroom> listaDepozit = new List <StocShowroom>();
using (MySqlConnection conn = new MySqlConnection(Ada.Properties.Settings.Default.connString))
{
if (conn == null)
{
throw new Exception("Connection String is Null. Set the value of Connection String in Ada->Properties-?Settings.settings");
}
MySqlCommand query = new MySqlCommand("SELECT * from stoc_show", conn);
conn.Open();
MySqlDataAdapter sqlDataAdapter = new MySqlDataAdapter(query);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
StocShowroom stocShowroom = new StocShowroom();
stocShowroom.Codmat = row["CODMAT"].ToString();
stocShowroom.Sf = row["SF"].ToString();
stocShowroom.Denmat = row["DENMAT"].ToString();
stocShowroom.CodBare = row["COD_BARE"].ToString();
stocShowroom.PretCumparare = row["PRET_CUMP"].ToString();
stocShowroom.PretTV_Aman = row["PRETV_AMAN"].ToString();
stocShowroom.Clasa = row["CLASA"].ToString();
listaDepozit.Add(stocShowroom);
}
return(listaDepozit);
}
}
/*
* Function: Add new record to the Database
* with the help of stored procedure
*/
public void AddNewRecord(StocShowroom stocShowroom)
{
using (MySqlConnection conn = new MySqlConnection(Ada.Properties.Settings.Default.connString))
{
if (conn == null)
{
throw new Exception("Connection String is Null. Set the value of Connection String in MovieCatalog->Properties-?Settings.settings");
}
else if (stocShowroom == null)
{
throw new Exception("The passed argument 'movieRecord' is null");
}
conn.Open();
using (MySqlCommand command = new MySqlCommand("INSERT INTO borderou (factura, website ) VALUES ("
+ stocShowroom.CodBare + ",'" + stocShowroom.Sf + "')", conn))
{
command.ExecuteNonQuery();
}
conn.Close();
}
}
