internal bool shtoFature(FatureShitje fsh) { bool isSuccess = false; using (SqlConnection conn = Connection.GetConnection()) { string query = @"INSERT INTO [dbo].[fature_shitje] ( [Id], [Id_koke_fature], [Id_artikull], [Sasia], [Cmimi] VALUES ( @Id_koke_fature, @Id_artikull, @Sasia, @Cmimi )"; using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Id_koke_fature", fsh.kokeFature.id); cmd.Parameters.AddWithValue("@Id_artikull", fsh.a.id); cmd.Parameters.AddWithValue("@Sasia", fsh.sasiaShitjes); cmd.Parameters.AddWithValue("@Cmimi", fsh.a.cmimi); conn.Open(); isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false; conn.Close(); } } return(isSuccess); }
internal bool fshiFature(FatureShitje fature) { bool isSuccess = false; using (SqlConnection conn = Connection.GetConnection()) { string q = @"DELETE FROM [dbo].[fature_shitje] WHERE [Id] = @ID "; using (SqlCommand cmd = new SqlCommand(q, conn)) { cmd.Parameters.AddWithValue("@ID", fature.id); conn.Open(); isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false; conn.Close(); } } return(isSuccess); }
internal bool ndryshoFature(FatureShitje fsh) { bool isSuccess = false; using (SqlConnection conn = Connection.GetConnection()) { string query = @"UPDATE [dbo].[fature_shitje] SET [Id_koke_fature] = @Id_koke_fature, [Id_artikull] = @Id_artikull, [Sasia] = @Sasia WHERE Id = @Id"; using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Id_koke_fature", fsh.kokeFature.id); cmd.Parameters.AddWithValue("@Id_artikull", fsh.a.id); cmd.Parameters.AddWithValue("@Sasia", fsh.sasiaShitjes); conn.Open(); isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false; conn.Close(); } return(isSuccess); } }