private watchProduct CreatewatchProduct()
{
watchProduct watchproduct = new watchProduct();
watchproduct.watchName = txtNameP.Text;
watchproduct.watchPrice = Convert.ToInt32(txtPriceP.Text);
watchproduct.watchProID = Convert.ToInt32(ddlTypeP.SelectedValue);
watchproduct.watchDescription = txtDescP.Text;
watchproduct.watchImage = ddlPicP.SelectedValue;
return(watchproduct);
}
public string InsertwatchProd(watchProduct watchproduct)
{
try
{
db_1525591_co5027_aziimEntities db = new db_1525591_co5027_aziimEntities();
db.watchProducts.Add(watchproduct);
db.SaveChanges();
return(watchproduct.watchName + "was just added to your cart");
}
catch (Exception e)
{
return("Error:" + e);
}
}
public watchProduct GetwatchProduct(int id)
{
try
{
using (db_1525591_co5027_aziimEntities db = new db_1525591_co5027_aziimEntities())
{
watchProduct watchproduct = db.watchProducts.Find(id);
return(watchproduct);
}
}
catch (Exception)
{
return(null);
}
}
private void FillPage(int id)
{
//retrieve product which are selected from database
PwModel pwmodel = new PwModel();
watchProduct watchproduct = pwmodel.GetwatchProduct(id);
//Fill in textboxes
txtDescP.Text = watchproduct.watchDescription;
txtNameP.Text = watchproduct.watchName;
txtPriceP.Text = watchproduct.watchPrice.ToString();
//set ddl values
ddlPicP.SelectedValue = watchproduct.watchImage;
ddlTypeP.SelectedValue = watchproduct.watchProID.ToString();
}
public string DeletewatchProd(int id)
{
try
{
db_1525591_co5027_aziimEntities db = new db_1525591_co5027_aziimEntities();
watchProduct watchproduct = db.watchProducts.Find(id);
db.watchProducts.Attach(watchproduct);
db.watchProducts.Remove(watchproduct);
db.SaveChanges();
return(watchproduct.watchName + "was just removed");
}
catch (Exception e)
{
return("Error:" + e);
}
}
protected void btnSubmitP_Click(object sender, EventArgs e)
{
PwModel pwmodel = new PwModel();
watchProduct watchproduct = CreatewatchProduct();
//checking if the url contains id parameter
if (!String.IsNullOrWhiteSpace(Request.QueryString["id"]))
{
//id is exist thus update current row
int id = Convert.ToInt32(Request.QueryString["id"]);
lblResultP.Text = pwmodel.UpdatewatchProd(id, watchproduct);
}
else
{
//id is not exist thus create new row
lblResultP.Text = pwmodel.InsertwatchProd(watchproduct);
}
}
public string UpdatewatchProd(int id, watchProduct watchproduct)
{
try
{
db_1525591_co5027_aziimEntities db = new db_1525591_co5027_aziimEntities();
//take object from database
watchProduct prod = db.watchProducts.Find(id);
prod.watchName = watchproduct.watchName;
prod.watchPrice = watchproduct.watchPrice;
prod.watchProID = watchproduct.watchProID;
prod.watchDescription = watchproduct.watchDescription;
prod.watchImage = watchproduct.watchImage;
db.SaveChanges();
return(watchproduct.watchName + "was just updated");
}
catch (Exception e)
{
return("Error:" + e);
}
}