public Magazine GetMagazine(int id)
{
Magazine magazine = null;
SqlConnection connection = new SqlConnection(ConnectionString);
connection.Open();
SqlCommand command = new SqlCommand("select * from magazine", connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (id == Convert.ToInt32(reader["id"]))
{
MagazineType type = Magazine.getmagazine(reader["type"].ToString().Trim());
magazine = new Magazine(type, reader["issue"].ToString(), reader["name"].ToString(), Convert.ToInt32(reader["id"]), Convert.ToDouble(reader["price"]), reader["picture"].ToString());
magazine.Id = Convert.ToInt32(reader["id"]);
if (magazine.Id > Product.Idcount)
{
Product.Idcount = magazine.Id;
}
}
}
connection.Close();
return(magazine);
}
private void btnAddMagazine_Click(object sender, EventArgs e)
{
MagazineType type = Magazine.getmagazine(cmbMagazineTypes.SelectedItem.ToString());
adminUser.addNewMagazine(type, txtMagazineIssue.Text, txtMagazineName.Text, Product.Idcount, Convert.ToDouble(txtMagazinePrice.Text.Trim()), txtMagazineName.Text.Trim() + ".jpg");
DataTable dataTable = new DataTable();
DataTable = data.datagrid(dataTable, "magazine");
dtgMagazine.DataSource = DataTable;
}