internal bool shtoTavoline(Tavolina t) { bool isSuccess = false; using (SqlConnection conn = Connection.GetConnection()) { string query = @"INSERT INTO [dbo].[tavolina] ( [Id_kamarier], [Status] VALUES ( @Id_kamarier, @Status )"; using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Id_kamarier", t.kamarier.id); cmd.Parameters.AddWithValue("@Status", t.status); conn.Open(); isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false; conn.Close(); } } return(isSuccess); }
internal bool ndrysho(Tavolina t) { bool isSuccess = false; using (SqlConnection conn = Connection.GetConnection()) { string query = @"UPDATE [dbo].[tavolina] SET [Id_kamarier] = @Id_kamarier, [Status] = @Status WHERE Id = @Id"; using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Id", t.id); cmd.Parameters.AddWithValue("@Id_kamarier", t.kamarier.id); cmd.Parameters.AddWithValue("@Status", t.status); conn.Open(); isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false; conn.Close(); } return(isSuccess); } }
public KokeFature() { t = new Tavolina(); kamarier = new Perdorues(); }