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);
}
