private BootProduct CreateProduct()
{
BootProduct product = new BootProduct();
product.ShoeName = Nametxt.Text;
product.Price = Convert.ToInt32(Pricetxt.Text);
product.ShoeType = Convert.ToInt32(TypeDropDown.SelectedValue);
product.Description = Desctxt.Text;
product.Image = ImageDropDown.SelectedValue;
return(product);
}
public BootProduct GetProducts(int id)
{
try
{
using (db_1525596_co5027Entities db = new db_1525596_co5027Entities())
{
BootProduct product = db.BootProducts.Find(id);
return(product);
}
}
catch (Exception)
{
return(null);
}
}
public string InsertProduct(BootProduct product)
{
try
{
db_1525596_co5027Entities db = new db_1525596_co5027Entities();
db.BootProducts.Add(product);
db.SaveChanges();
return(product.ShoeName + " Inserted Successfull");
}
catch (Exception e)
{
return("Error:" + e);
}
}
private void Fillpage(int id)
{
//get selected details from database
ShoeModel shoeModel = new ShoeModel();
BootProduct product = shoeModel.GetProducts(id);
//Fill the text
Desctxt.Text = product.Description;
Nametxt.Text = product.ShoeName;
Pricetxt.Text = product.Price.ToString();
//set the value of dropdown
ImageDropDown.SelectedValue = product.Image;
TypeDropDown.SelectedValue = product.ShoeType.ToString();
}
public string DeleteProduct(int id)
{
try
{
db_1525596_co5027Entities db = new db_1525596_co5027Entities();
BootProduct product = db.BootProducts.Find(id);
db.BootProducts.Attach(product);
db.BootProducts.Remove(product);
db.SaveChanges();
return(product.ShoeName + "Deleted Successfull");
}
catch (Exception e)
{
return("Error:" + e);
}
}
protected void Submitbtn_Click(object sender, EventArgs e)
{
ShoeModel bootProduct = new ShoeModel();
BootProduct product = CreateProduct();
//checck if there is an id on the websitename
if (!string.IsNullOrWhiteSpace(Request.QueryString["id"]))
{
//there is an id
int id = Convert.ToInt32(Request.QueryString["id"]);
ResultLabel.Text = bootProduct.UpdateProduct(id, product);
}
else
{
//no id
ResultLabel.Text = bootProduct.InsertProduct(product);
}
}
public string UpdateProduct(int id, BootProduct product)
{
try
{
db_1525596_co5027Entities db = new db_1525596_co5027Entities();
//get the info from the db
BootProduct p = db.BootProducts.Find(id);
p.ShoeName = product.ShoeName;
p.Price = product.Price;
p.ShoeType = product.ShoeType;
p.Description = product.Description;
p.Image = product.Image;
db.SaveChanges();
return(product.ShoeName + " Updated Successfull");
}
catch (Exception e)
{
return("Error:" + e);
}
}