private static Upravuje MapUpravToObj(SqlDataReader reader)
{
Upravuje upravuje = new Upravuje();
upravuje.IDzamestnance = reader.GetInt32(0);
upravuje.cisloRezervace = reader.GetInt32(1);
return(upravuje);
}
public int DeleteUprav(Upravuje upravuje)
{
SqlConnectionStringBuilder builder = DBConnector.GetBuilder();
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Clear();
sb.Append("DELETE FROM vis.upravuje where ID_zamestnance = @id");
string sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@id", upravuje.IDzamestnance);
}
}
return(0);
}
public int SaveUprav(Upravuje upravuje)
{
SqlConnectionStringBuilder builder = DBConnector.GetBuilder();
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Clear();
sb.Append("INSERT INTO vis.upravuje (ID_zamestnance,Cislo_Rezervace,)");
sb.Append("VALUES (@idZam, @cisloR);");
//sb.Append("SELECT CAST(scope_identity() AS int)");
string sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@idZam", upravuje.IDzamestnance);
command.Parameters.AddWithValue("@cisloR", upravuje.cisloRezervace);
}
}
return(0);
}
