public bool Delete(Categorybll u) { bool issuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { String sql = "DELETE FROM categories_tbl where id=@id"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@id", u.id); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { issuccess = true; } else { issuccess = false; } } catch (Exception e) { MessageBox.Show(e.Message); } finally { conn.Close(); } return(issuccess); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //string[] filePaths = Directory.GetFiles(Server.MapPath("~/Images/")); //List<ListItem> files = new List<ListItem>(); //foreach (string filePath in filePaths) //{ // string fileName = Path.GetFileName(filePath); // files.Add(new ListItem(fileName, "~/Images/" + fileName)); //} DataSet ds = new DataSet(); Productbll vBll = new Productbll(); Dealsbll oDel = new Dealsbll(); ds = oDel.GetDeals(); DataTable dt = ds.Tables[0]; dDeals.DataSource = dt; dDeals.DataTextField = "Description"; dDeals.DataValueField = "DealID"; dDeals.DataBind(); DataSet das; Supplierbll oSup = new Supplierbll(); das = oSup.GetSupplier(); DataTable dat = das.Tables[0]; dSupplier.DataSource = dat; dSupplier.DataTextField = "BusinessName"; dSupplier.DataValueField = "SupplierID"; dSupplier.DataBind(); DataSet dbs; Categorybll oCat = new Categorybll(); dbs = oCat.GetCategory(); DataTable dbt = dbs.Tables[0]; dCategory.DataSource = dbt; dCategory.DataTextField = "Description"; dCategory.DataValueField = "CategoryID"; dCategory.DataBind(); } }
public bool Update(Categorybll u) { bool issuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { String sql = "UPDATE categories_tbl SET Title=@Title,Description=@Description,added_date=@added_date,added_by=@added_by WHERE id=@id"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Title", u.Title); cmd.Parameters.AddWithValue("@Description", u.Description); cmd.Parameters.AddWithValue("@added_date", u.added_date); cmd.Parameters.AddWithValue("@added_by", u.added_by); cmd.Parameters.AddWithValue("@id", u.id); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { issuccess = true; } else { issuccess = false; } } catch (Exception e) { MessageBox.Show(e.Message); } finally { conn.Close(); } return(issuccess); }
public bool Insert(Categorybll u) { bool issuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { String sql = "INSERT INTO categories_tbl(Title,Description,added_date,added_by) VALUES (@Title,@Description,@added_date,@added_by)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Title", u.Title); cmd.Parameters.AddWithValue("@Description", u.Description); cmd.Parameters.AddWithValue("@added_date", u.added_date); cmd.Parameters.AddWithValue("@added_by", u.added_by); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { issuccess = true; } else { issuccess = false; } } catch (Exception e) { MessageBox.Show(e.Message); } finally { conn.Close(); } return(issuccess); }