public void StergereCategorie(IFake context, int categorieId)
{
Categorii categorie = context.Categorii.FirstOrDefault(a => a.Id == categorieId);
context.Categorii.Remove(categorie);
context.SaveChanges();
}
//Tema 3
public Carte(string sir)
{
string[] buff = sir.Split(',');
nume = buff[0];
autor = buff[1];
nr_exemplare = Convert.ToInt32(buff[2]);
gen = (Categorii)Convert.ToInt32(buff[3]);
}
public int AdaugareCategorie(IFake context, string categorie)
{
int ID_Categorie;
Categorii cat = new Categorii()
{
Nume = categorie
};
context.Categorii.Add(cat);
context.SaveChanges();
ID_Categorie = cat.Id;
return(ID_Categorie);
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Categorii = await _context.Categorii.FirstOrDefaultAsync(m => m.ID == id);
if (Categorii == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Categorii = await _context.Categorii.FindAsync(id);
if (Categorii != null)
{
_context.Categorii.Remove(Categorii);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public static List<Categorii> getCats()
{
using (SqlConnection con = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM Categories", con);
using (SqlDataReader reader = cmd.ExecuteReader())
{
List<Categorii> cats = new List<Categorii>();
while (reader.Read())
{
Categorii cat = new Categorii
{
cat_id = reader.GetInt32(0),
cat_name = reader.GetString(1)
};
cats.Add(cat);
}
return cats;
}
}
}
