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();
}
