internal bool ndryshoKokeFature(KokeFature kf) { bool isSuccess = false; using (SqlConnection conn = Connection.GetConnection()) { string query = @"UPDATE [dbo].[koke_fature] SET [Id_tavolina] = @Id_tavolina, [Data] = @Data, [Id_kamarier] = @Id_kamarier, [Status] = @Status, [Nr_fature] = @Nr_fature WHERE Id = @Id"; using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Id_tavolina", kf.t.id); cmd.Parameters.AddWithValue("@Data", kf.data); cmd.Parameters.AddWithValue("@Nr_fature", kf.nrFature); cmd.Parameters.AddWithValue("@Status", kf.nrFature); cmd.Parameters.AddWithValue("@Id_kamarier", kf.kamarier.id); conn.Open(); isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false; conn.Close(); } return(isSuccess); } }
internal bool shtoKokeFature(KokeFature kf) { bool isSuccess = false; using (SqlConnection conn = Connection.GetConnection()) { string query = @"INSERT INTO [dbo].[koke_furnizimi] ( [Id], [Id_tavolina], [Data], [Id_kamarier], [Status], [Nr_fature], VALUES ( @Id_tavolina, @Data, @Id_kamarier, @Status, @Nr_fature )"; using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Id_tavolina", kf.t.id); cmd.Parameters.AddWithValue("@Data", kf.data); cmd.Parameters.AddWithValue("@Nr_fature", kf.nrFature); cmd.Parameters.AddWithValue("@Status", kf.nrFature); cmd.Parameters.AddWithValue("@Id_kamarier", kf.kamarier.id); conn.Open(); isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false; conn.Close(); } } return(isSuccess); }
public FatureShitje() { a = new Artikull(); kokeFature = new KokeFature(); }