internal bool shtoArtikull(Artikull a) { bool isSuccess = false; using (SqlConnection conn = Connection.GetConnection()) { string query = @"INSERT INTO [dbo].[artikull] ( [Id], [Artikulli], [Sasia_mbetur], [Cmimi], [Id_kategori], [Id_njesia], [Status], VALUES ( @Artikulli, @Sasia_mbetur, @Cmimi, @Id_kategori, @Id_njesia, @Status )"; using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Artikulli", a.artikull); cmd.Parameters.AddWithValue("@Sasia_mbetur", a.sasia); cmd.Parameters.AddWithValue("@Cmimi", a.cmimi); cmd.Parameters.AddWithValue("@Id_kategori", a.kategori.id); cmd.Parameters.AddWithValue("@Id_njesia", a.njesi.id); cmd.Parameters.AddWithValue("@Status", a.status); conn.Open(); isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false; conn.Close(); } } return(isSuccess); }
internal bool ndryshoArtikull(Artikull a) { bool isSuccess = false; using (SqlConnection conn = Connection.GetConnection()) { string query = @"UPDATE [dbo].[artikull] SET [Cmimi] = @Cmimi, [Id_kategori] = @Id_kategori, [Status] = @Status WHERE Id = @Id"; using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@Cmimi", a.cmimi); cmd.Parameters.AddWithValue("@Id_kategori", a.kategori.id); cmd.Parameters.AddWithValue("@Status", a.status); conn.Open(); isSuccess = cmd.ExecuteNonQuery() > 0 ? true : false; conn.Close(); } return(isSuccess); } }
public FatureShitje() { a = new Artikull(); kokeFature = new KokeFature(); }
public Furnizimi() { kokeFurnizimi = new KokeFurnizimi(); a = new Artikull(); }