// GET: Categories
//public ActionResult Index()
//{
// return View();
//}
// GET: Categories/Details/5
//public ActionResult Details(int id)
//{
// return View();
//}
// GET: Categories/Create
public ActionResult Create()
{
CategorieBLL defCategorie = new CategorieBLL();
defCategorie.CategorieID = 0;
return(View(defCategorie));
}
public bool Delete(CategorieBLL c)
{
bool isSucces = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
string sql = "DELETE FROM CATEGORIE WHERE categorie_id=@categorie_id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@categorie_id", c.Id);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSucces = true;
}
else
{
isSucces = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSucces);
}
public bool Insert(CategorieBLL c)
{
bool isSucces = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
string sql = "INSERT INTO CATEGORIE (categorie_id, nume, descriere) VALUES (@categorie_id, @nume, @descriere)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@categorie_id", c.Id);
cmd.Parameters.AddWithValue("@nume", c.Nume);
cmd.Parameters.AddWithValue("@descriere", c.Descriere);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSucces = true;
}
else
{
isSucces = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSucces);
}
