public ActionResult CreateAd(tbl_product pvm, HttpPostedFileBase imgfile)
{
List <tbl_category> li = db.tbl_category.ToList();
ViewBag.categorylist = new SelectList(li, "cat_id", "cat_name");
string path = uploadimgfile(imgfile);
if (path.Equals("-1"))
{
ViewBag.error = "Image could not be uploaded....";
}
else
{
tbl_product p = new tbl_product();
p.pro_name = pvm.pro_name;
p.pro_price = pvm.pro_price;
p.pro_image = path;
p.pro_fk_cat = pvm.pro_fk_cat;
p.pro_des = pvm.pro_des;
p.pro_fk_us = Convert.ToInt32(Session["u_id"].ToString());
db.tbl_product.Add(p);
db.SaveChanges();
Response.Redirect("index");
}
return(View());
}
// GET: product/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_product tbl_product = db.tbl_product.Find(id);
if (tbl_product == null)
{
return(HttpNotFound());
}
var category = db.tbl_category.ToList();
List <SelectListItem> li = new List <SelectListItem>();
li.Add(new SelectListItem {
Text = "[Select a category]", Value = "0"
});
foreach (var c in category)
{
li.Add(new SelectListItem {
Text = c.category, Value = c.catID.ToString()
});
ViewBag.category = li;
}
//ViewBag.categoryID = new SelectList(db.tbl_category, "catID", "category", tbl_product.categoryID);
ViewBag.colourID = new SelectList(db.tbl_colour, "colID", "colour", tbl_product.colourID);
//ViewBag.modelID = new SelectList(db.tbl_model, "modID", "model", tbl_product.modelID);
ViewBag.sizeID = new SelectList(db.tbl_size, "sizID", "size", tbl_product.sizeID);
//ViewBag.subCategoryID = new SelectList(db.tbl_sub_category, "subID", "subcategory", tbl_product.subCategoryID);
return(View(tbl_product));
}
public bool InsertIns(mProduct pPrd)
{
try
{
tbl_product vPrd = new tbl_product();
var query = from b in Db.tbl_product
orderby b.product_id descending
select b;
vPrd = query.FirstOrDefault();
tbl_product p = new tbl_product();
Random rnd = new Random();
p.product_img1 = pPrd.product_img1;
p.product_img2 = pPrd.product_img2;
p.product_img_alt = pPrd.product_img_alt;
p.product_price = pPrd.product_price;
p.product_summery = pPrd.product_summery;
p.product_title1 = pPrd.product_title1;
p.product_title2 = pPrd.product_title2;
p.product_cat = pPrd.product_cat;
p.product_parent = pPrd.product_parent;
p.product_exist = pPrd.product_exist;
p.product_exp = pPrd.product_exp;
p.product_save = pPrd.product_save;
p.product_visit = 200;
p.product_id = vPrd.product_id + 1;
Db.tbl_product.Add(p);
return(Convert.ToBoolean(Db.SaveChanges()));
}
catch (Exception)
{
return(false);
}
}
// 单个删除
protected void lbtnDelCa_Click(object sender, EventArgs e)
{
// 当前点击的按钮
LinkButton lb = (LinkButton)sender;
int caId = int.Parse(lb.CommandArgument);
tbl_sinkia_attribute bll = new tbl_sinkia_attribute();
bll.GetModel(caId);
string attribute_name = bll.attribute_name;
tbl_product bllpp = new tbl_product();
bllpp.pro_level = caId;
if (!bllpp.Existsshuxing())//查找是否存在下级商品
{
bll.Delete(caId);
mym.JscriptMsg(this.Page, " 成功删除属性：" + attribute_name + "", Utils.CombUrlTxt("pro_attribute_list.aspx", "keywords={0}&page={1}", this.keywords, this.page.ToString()), "Success");
}
else
{
mym.JscriptMsg(this.Page, "有商品属于该商品属性，不能删除！", "", "Error");
return;
}
}
private void ShowInfo(int _id)
{
tbl_product model1 = new tbl_product();
model1.GetModel(_id);
this.ddlproduct_category_id.SelectedValue = model1.pro_pid.ToString();
this.txtdw.Text = model1.pro_danwei;
this.txtImgUrl.Text = model1.pro_imgs;
this.txtImgUrl1.Text = model1.pro_imgs1;
this.txtImgUrl2.Text = model1.pro_imgs2;
this.txtproduct_name.Text = model1.pro_name;
this.txtgo_price.Text = MyConvert(model1.go_price.ToString());
this.txtsalse_price.Text = MyConvert(model1.salse_price.ToString());
//this.pv.Text = MyConvert(model1.pro_PV.ToString());
this.txtContent.Value = model1.pro_memo.ToString();
this.attribute.SelectedValue = model1.pro_level.ToString();//属性绑定
this.txtproduct_num.Text = model1.pro_num.ToString();
//if (model1.pro_type == 0)
//{
// this.cbIsLock.Checked = true;
//}
//if (model1.flag == 0)
//{
// this.shengji.Checked = true;
//}
if (model1.pro_isok == 1)
{
this.pro_isok.Checked = true;
}
else
{
this.pro_isok.Checked = false;
}
if (model1.pro_home_show == 1)
{
this.pro_home_show.Checked = true;
}
else
{
this.pro_home_show.Checked = false;
}
if (model1.pro_Hot == 1)
{
this.pro_Hot.Checked = true;
}
else
{
this.pro_Hot.Checked = false;
}
this.ddlprov.SelectedValue = model1.province_id.ToString();
this.ddlcity.SelectedValue = model1.city_id.ToString();
this.ddlarea.SelectedValue = model1.dictrict_id.ToString();
//this.shop.Text = MyConvert(model1.shop_fen.ToString());
//this.yun.Text = MyConvert(model1.cloud_fen.ToString());
//this.chongxiao.Text = MyConvert(model1.futou_fen.ToString());
}
public ActionResult CreateAd(tbl_product pvm, HttpPostedFileBase imgfile)
{
List <tbl_category> li = db.tbl_category.ToList();
ViewBag.categorylist = new SelectList(li, "category_id", "category_name");
string path = uploadimgfile(imgfile);
if (path.Equals("-1"))
{
ViewBag.error = "Görsel Yüklenemedi....";
}
else
{
tbl_product p = new tbl_product();
p.product_name = pvm.product_name;
p.product_price = pvm.product_price;
p.product_image = path;
p.product_fk_category = pvm.product_fk_category;
p.product_description = pvm.product_description;
p.product_fk_user = Convert.ToInt32(Session["userid"].ToString());
db.tbl_product.Add(p);
db.SaveChanges();
Response.Redirect("index");
}
return(View());
}
public ActionResult addprod(product pr, HttpPostedFileBase file1)
{
ViewBag.cat = new SelectList(dc.tbl_category, "cid", "cname");
tbl_product tr = new tbl_product();
tr.pname = pr.pname;
tr.pcategory = pr.catid;
tr.pprice = pr.pprice;
tr.pdetails = pr.pdetails;
if (file1 != null)
{
filename = file1.FileName;
path = Server.MapPath("~/image/~");
fullpath = path + "\\" + filename;
file1.SaveAs(fullpath);
temp = "~/image/" + filename;
}
else
{
temp = "";
}
tr.pimg = temp;
dc.tbl_product.Add(tr);
dc.SaveChanges();
return(View());
}
public ActionResult Adtocart(tbl_product pi, string qty, int Id)
{
tbl_product p = db.tbl_product.Where(x => x.product_id == Id).SingleOrDefault();
Cart c = new Cart();
c.product_id = p.product_id;
c.price = (float)p.product_price;
c.qty = Convert.ToInt32(qty);
c.bill = c.price * c.qty;
c.product_name = p.product_name;
if (TempData["Cart"] == null)
{
li.Add(c);
TempData["Cart"] = li;
}
else
{
List <Cart> li2 = TempData["Cart"] as List <Cart>;
li2.Add(c);
TempData["Cart"] = li2;
}
TempData.Keep();
return(RedirectToAction("Index"));
}
// 单个删除
protected void lbtnDelCa_Click(object sender, EventArgs e)
{
// 当前点击的按钮
LinkButton lb = (LinkButton)sender;
int caId = int.Parse(lb.CommandArgument);
tbl_sinkia_class bll = new tbl_sinkia_class();
bll.GetModel(caId);
string pro_class = bll.pro_class;
tbl_product bllpp = new tbl_product();
bllpp.pro_pid = caId;
if (!bllpp.ExistsBM())//查找是否存在下级商品
{
bll.Delete(caId);
mym.JscriptMsg(this.Page, " 成功删除商品类别：" + pro_class + "", Utils.CombUrlTxt("pro_class_list.aspx", "keywords={0}&page={1}", this.keywords, this.page.ToString()), "Success");
}
else
{
mym.JscriptMsg(this.Page, "有商品属于该商品类别，不能删除！", "", "Error");
return;
}
}
public ActionResult addproduct(pclass f, HttpPostedFileBase file1)
{
ViewBag.cat = new SelectList(dc.tbl_category, "catid", "catname");
tbl_product pr = new tbl_product();
pr.pname = f.pname;
pr.pcategory = f.catid;
pr.pprice = f.pprice;
pr.pdetail = f.pdetail;
if (file1 != null)
{
filename = file1.FileName;
path = Server.MapPath("~/img/");
fulpath = path + filename;
file1.SaveAs(fulpath);
temp = "~/img/" + filename;
}
else
{
temp = "";
}
pr.pimage = temp;
dc.tbl_product.Add(pr);
dc.SaveChanges();
return(View());
}
public ActionResult CreateAd(tbl_product tblProduct, HttpPostedFileBase imgFile)
{
string path = UploadImageFile(imgFile);
if (path.Equals("-1"))
{
ViewBag.ErrorMessage = "File could not be uploaded......";
}
else
{
tbl_product p = new tbl_product();
p.pro_name = tblProduct.pro_name;
p.pro_image = path;
p.pro_description = tblProduct.pro_description;
p.pro_price = tblProduct.pro_price;
p.pro_fk_cat = tblProduct.pro_fk_cat;
p.pro_fk_user = Convert.ToInt32(Session["u_id"].ToString());
db.tbl_product.Add(p);
db.SaveChanges();
Response.Redirect("Index");
}
return(View());
}
public async Task <ActionResult> Edit(Product model)
{
if (!GetTokenValidation(ApplicationSession.Session.Token))
{
return(RedirectToAction("Index", "Login"));
}
ViewBag.ProductType = await ProductTyp();
try
{
tbl_product dbmodel = db.tbl_product.Where(x => x.Id == model.Id).FirstOrDefault();
dbmodel.Id = model.Id;
dbmodel.Name = model.Name;
dbmodel.ProductTypeId = model.ProductTypeId;
dbmodel.Code = model.Code;
db.SaveChanges();
SetNotification("info", "Record save update");
return(RedirectToAction("Index"));
}
catch
{
SetNotification("error", "Error Record not update");
return(View());
}
}
/// <summary>
/// 获得购物车列表
/// </summary>
public static IList <cart_items> GetList()
{
IDictionary <string, int> dic = GetCart();
if (dic != null)
{
IList <cart_items> iList = new List <cart_items>();
foreach (var item in dic)
{
tbl_product model = new tbl_product();
model.GetModel(Convert.ToInt32(item.Key.Split('|')[0]));
cart_items modelt = new cart_items();
modelt.id = model.pro_id;
modelt.title = model.pro_name;
modelt.goprice = Utils.StrToDecimal(model.go_price.ToString(), 0);
modelt.img_url = model.pro_imgs;
modelt.product_category_id = Convert.ToInt32(model.pro_pid);
modelt.dw = model.pro_danwei;
modelt.price = Utils.StrToDecimal(model.salse_price.ToString(), 0);
modelt.quantity = item.Value;
modelt.shuxing = item.Key.Split('|')[1];
modelt.key_shuxing = item.Key;
iList.Add(modelt);
}
return(iList);
}
return(null);
}
public ActionResult Create(tbl_product tbl_product, HttpPostedFileBase file)
{
if (ModelState.IsValid)
{
if (file != null && file.ContentLength > 0)
{
try
{
string PathToFolder = Server.MapPath("~/Images");
string fileName = Path.GetFileName(file.FileName);
string path = Path.Combine(PathToFolder, fileName);
file.SaveAs(path);
tbl_product.Image = file.FileName;
}
catch (Exception ex)
{
ViewBag.Message = "ERROR:" + ex.Message.ToString();
}
}
db.tbl_product.Add(tbl_product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.tbl_category, "CategoryId", "Name", tbl_product.CategoryId);
return(View(tbl_product));
}
public ActionResult CreateShortUrl(int id)
{
tbl_product t = (from product in db.tbl_product
where product.product_id == id
select product).Single();
string webUrl = "";
webUrl = Config.ConfigManager.getConfig("get-short-url");
byte[] dataArray = Encoding.UTF8.GetBytes(t.content_url);
WebRequest webRequest = WebRequest.Create(webUrl);
HttpWebRequest request = webRequest as HttpWebRequest;
request.Method = "POST";
request.ContentLength = dataArray.Length;
Stream dataStream = request.GetRequestStream();
dataStream.Write(dataArray, 0, dataArray.Length);
dataStream.Close();
WebResponse response = request.GetResponse();
String shortUrl = new StreamReader(response.GetResponseStream(), Encoding.UTF8).ReadToEnd();
t.short_url = shortUrl;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public DataTable GetProduct(tbl_product p, tbl_stock s)
{
DataTable programs = new DataTable();
try
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@company_id ", p.company_id);
parameters.Add("@branch_id", p.branch_id);
DataTable dt = helper.GetDataTableFromStoredProc(SP.productwithquantity, parameters);
foreach (DataRow dr in dt.Rows)
{
p.product_id = Convert.ToInt32(dr["product_id"].ToString());
p.product_name = (dr["product_name"].ToString());
p.product_code = (dr["product_code"].ToString());
p.purchas_price = Convert.ToDecimal(dr["purchas_price"].ToString());
p.sales_price = Convert.ToDecimal(dr["sales_price"].ToString());
s.qty = Convert.ToInt32(dr["qty"].ToString());
p.reorder_level = Convert.ToInt32(dr["reorder_level"].ToString());
}
programs = dt;
}
catch (Exception ex)
{
ErrorLog.saveerror(ex);
}
return(programs);
}
public ActionResult Deleteconfirmed(int id)
{
tbl_product tbl_pro = db.tbl_product.Find(id);
db.tbl_product.Remove(tbl_pro);
db.SaveChanges();
return(RedirectToAction("ViewCategory"));
}
//
// GET: /Product/Edit/5
public ActionResult Edit(int id)
{
tbl_product tbl_product = db.tbl_product.Single(t => t.product_id == id);
ViewBag.types = new SelectList(db.tbl_product_type.ToList(), "id", "name");
ViewBag.push_levels = new SelectList(PushLevelModel.GetPushLevelList(), "level", "name");
return(View(tbl_product));
}
public ActionResult Delete(int?id)
{
tbl_product p = db.tbl_product.Where(x => x.pro_id == id).SingleOrDefault();
db.tbl_product.Remove(p);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
tbl_product tbl_product = db.tbl_product.Find(id);
db.tbl_product.Remove(tbl_product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
tbl_product temp = db.tbl_product.Single(m => m.product_id == id);
temp.product_status = false;
temp.push_level = 0;
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Product/Details/5
public ActionResult Details(int id = 0)
{
tbl_product tbl_product = db.tbl_product.Find(id);
if (tbl_product == null)
{
return(HttpNotFound());
}
return(View(tbl_product));
}
public ActionResult Edit([Bind(Include = "Id,anbarId,category,codeKala,name,date1,date2,serialNumber,barcode,temperetureMin,temperetureMax,minOrder,maxOrder,active")] tbl_product tbl_product)
{
if (ModelState.IsValid)
{
db.Entry(tbl_product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_product));
}
public List <tbl_product> GetPriceOutlist(tbl_product model, string connString)
{
SqlParameter[] param =
{
new SqlParameter("@product_ID", 680)
};
return(SqlHelper.ExtecuteProcedureReturnData <List <tbl_product> >(connString,
"GetProductByID", r => r.TranslateAsOutputTest(), param));
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
if (filefrontimage.HasFile)
{
string serverpath = Server.MapPath("..") + "\\img\\" + filefrontimage.FileName;
filefrontimage.SaveAs(serverpath);
string urlfront = filefrontimage.FileName;
tbl_product proObj = new tbl_product();
proObj.prodname = txtprodname.Text;
proObj.fkcomid = int.Parse(ddlselectcompany.SelectedValue.ToString());
proObj.fksid = int.Parse(ddlsubcat.SelectedValue.ToString());
proObj.mandate = txtmanudate.Text;
proObj.warryear = txtwarryear.Text;
proObj.warrmonth = txtwarrmonth.Text;
proObj.warrday = txtwarrday.Text;
proObj.stock = txtstock.Text;
proObj.prize = txtprize.Text;
proObj.frontimage = urlfront;
proObj.port = txtport.Text;
proObj.modalid = txtmodelid.Text;
proObj.modalname = txtmodelname.Text;
proObj.color = txtcolor.Text;
proObj.lifestyle = txtlifestyle.Text;
proObj.batterycell = txtbattterycell.Text;
proObj.hardwareinterface = txthardwareinterface.Text;
proObj.systemarchitutecture = txtsysarchite.Text;
proObj.processer = txtprocessername.Text;
proObj.harddisk = txtharddisk.Text;
proObj.harddisk = txtharddisk.Text;
proObj.frontcamera = txtwebcamera.Text;
proObj.speaker = txtspeakers.Text;
proObj.batterycell = txtbattterycell.Text;
proObj.lockport = txtlockport.Text;
proObj.os = txtos.Text;
proObj.ram = txtram.Text;
proObj.weight = txtweight.Text;
proObj.graphicprocess = txtgraphicprocesser.Text;
proObj.maxresoulution = txtmaxresolution.Text;
proObj.bluethooth = ddlbluethooth.SelectedValue.ToString();
proObj.wifi = ddlwifi.SelectedValue.ToString();
db.tbl_products.InsertOnSubmit(proObj);
db.SubmitChanges();
lblmsg.Text = "Data Successfully Insert";
}
}
catch (Exception ee)
{
lblmsg.Text = ee.Message;
}
}
public ActionResult Edit(tbl_product tbl_product)
{
if (ModelState.IsValid)
{
db.tbl_product.Attach(tbl_product);
db.ObjectStateManager.ChangeObjectState(tbl_product, EntityState.Modified);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_product));
}
public async Task <int> Delete(Tbl_productRequest tbl_productRequest)
{
var tbl_product = new tbl_product()
{
id = tbl_productRequest.id
};
_context.tbl_products.Remove(tbl_product);
return(await _context.SaveChangesAsync());
}
public ActionResult Edit(tbl_product tbl_product)
{
if (ModelState.IsValid)
{
db.Entry(tbl_product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.tbl_category, "CategoryId", "Name", tbl_product.CategoryId);
return(View(tbl_product));
}
//
// GET: /Product/Edit/5
public ActionResult Edit(int id = 0)
{
tbl_product tbl_product = db.tbl_product.Find(id);
if (tbl_product == null)
{
return(HttpNotFound());
}
ViewBag.CategoryId = new SelectList(db.tbl_category, "CategoryId", "Name", tbl_product.CategoryId);
return(View(tbl_product));
}
public ActionResult Edit([Bind(Include = "pid,pname,pprice,pdetails,cid")] tbl_product tbl_product)
{
if (ModelState.IsValid)
{
db.Entry(tbl_product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.cid = new SelectList(db.tbl_category, "cid", "cname", tbl_product.cid);
return(View(tbl_product));
}
public ActionResult AddProduct(tbl_product pd)
{
EFDALLib dal = new EFDALLib();
dal.AddProducts(pd);
var catid = dal.GetAllCategoryById().ToList();
ViewData.Add("cid", catid);
ViewData.Add("Message", "Product Added Successfully");
return(View());
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
if (filefrontimage.HasFile && filebackimage.HasFile)
{
string serverpath = Server.MapPath("..") + "\\img\\" + filefrontimage.FileName;
filefrontimage.SaveAs(serverpath);
string urlfront = filefrontimage.FileName;
string serverpath1 = Server.MapPath("..") + "\\img\\" + filebackimage.FileName;
filebackimage.SaveAs(serverpath);
string urlback = filebackimage.FileName;
tbl_product proObj = new tbl_product();
proObj.prodname = txtprodname.Text;
proObj.fkcomid = int.Parse(ddlselectcompany.SelectedValue.ToString());
proObj.fksid = int.Parse(ddlsubcat.SelectedValue.ToString());
proObj.mandate = txtmanudate.Text;
proObj.warryear = txtwarryear.Text;
proObj.warrmonth = txtwarrmonth.Text;
proObj.warrday = txtwarrday.Text;
proObj.stock = txtstock.Text;
proObj.prize = txtprize.Text;
proObj.frontimage = urlfront;
proObj.backimage = urlback;
proObj.modalid = txtmodelid.Text;
proObj.modalname = txtmodelname.Text;
proObj.color = txtcolor.Text;
proObj.weight = txtweight.Text;
proObj.internalmemory = txtinternalmemory.Text;
proObj.externalmemory = txtextrnalmemory.Text;
proObj.batterytype = txtbattry.Text;
proObj.batterycell = txtbattrycell.Text;
proObj.frontcamera = txtfrontcamera.Text;
proObj.displaysize = txtdsize.Text;
db.tbl_products.InsertOnSubmit(proObj);
db.SubmitChanges();
lblmsg.Text = "Data Successfully Insert";
}
}
catch (Exception ee)
{
lblmsg.Text = ee.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (filefrontimage.HasFile)
{
string serverpath = Server.MapPath("..") + "\\img\\" + filefrontimage.FileName;
filefrontimage.SaveAs(serverpath);
string urlfront = filefrontimage.FileName;
tbl_product proObj = new tbl_product();
proObj.prodname = txtprodname.Text;
proObj.fkcomid = int.Parse(ddlselectcompany.SelectedValue.ToString());
proObj.fksid = int.Parse(ddlsubcat.SelectedValue.ToString());
proObj.mandate = txtmanudate.Text;
proObj.warryear = txtwarryear.Text;
proObj.warrmonth = txtwarrmonth.Text;
proObj.warrday = txtwarrday.Text;
proObj.stock = txtstock.Text;
proObj.prize = txtprize.Text;
proObj.frontimage = urlfront;
proObj.modalid = txtmodelid.Text;
proObj.modalname = txtmodelname.Text;
proObj.color = txtcolor.Text;
proObj.processer = txtprocessername.Text;
proObj.harddisk = txthadrdiskcap.Text;
proObj.os = txtos.Text;
proObj.ram = txtram.Text;
proObj.java = txtram.Text;
proObj.opticaldrive = txtopticaldrive.Text;
proObj.weight = txtweight.Text;
proObj.graphicprocess = txtgraphicsprocesser.Text;
proObj.keybord = txtkeybord.Text;
proObj.maxresoulution = txtmaximunresol.Text;
db.tbl_products.InsertOnSubmit(proObj);
db.SubmitChanges();
lblmsg.Text = "Data Successfully Insert";
}
}
catch (Exception ee)
{
lblmsg.Text = ee.Message;
}
}
protected void btnUpdateAccess_Click(object sender, EventArgs e)
{
TextBox ProductName = (TextBox)DetailsView4.FindControl("txtprodname");
DropDownList fkcomid = (DropDownList)DetailsView4.FindControl("ddlselectcompany");
TextBox stock = (TextBox)DetailsView4.FindControl("txtstock");
DropDownList fksid = (DropDownList)DetailsView4.FindControl("ddlsubcata");
TextBox prize = (TextBox)DetailsView4.FindControl("txtprize");
FileUpload filefrontimage = (FileUpload)DetailsView4.FindControl("filefrontimage");
FileUpload filebackimage = (FileUpload)DetailsView4.FindControl("filebackimage");
TextBox modelid = (TextBox)DetailsView4.FindControl("txtmodelid");
TextBox modelname = (TextBox)DetailsView4.FindControl("txtmodelname");
TextBox color = (TextBox)DetailsView4.FindControl("txtcolor");
TextBox frontcamera = (TextBox)DetailsView4.FindControl("txtfrontcamera");
TextBox backcamera = (TextBox)DetailsView4.FindControl("txtbackcamera");
TextBox internalmemory = (TextBox)DetailsView4.FindControl("txtinternalmemory");
TextBox externalmemory = (TextBox)DetailsView4.FindControl("txtextrnalmemory");
TextBox weight = (TextBox)DetailsView4.FindControl("txtweight");
TextBox batterytype = (TextBox)DetailsView4.FindControl("txtbattry");
TextBox batterycell = (TextBox)DetailsView4.FindControl("txtbattrycell");
if (filefrontimage.HasFile && filebackimage.HasFile)
{
string serverpath = Server.MapPath("..") + "\\img\\" + filefrontimage.FileName;
filefrontimage.SaveAs(serverpath);
string urlfront = filefrontimage.FileName;
string serverpath1 = Server.MapPath("..") + "\\img\\" + filebackimage.FileName;
filebackimage.SaveAs(serverpath);
string urlback = filebackimage.FileName;
tbl_product proObj = new tbl_product();
proObj = db.tbl_products.Single(data => data.pkprodid == int.Parse(DetailsView4.DataKey[0].ToString()));
proObj.prodname = ProductName.Text;
proObj.fkcomid = int.Parse(fkcomid.SelectedValue.ToString());
proObj.fksid = int.Parse(fksid.SelectedValue.ToString());
proObj.stock = stock.Text;
proObj.prize = prize.Text;
proObj.frontimage = urlfront;
proObj.backimage = urlback;
proObj.modalid = modelid.Text;
proObj.modalname = modelname.Text;
proObj.color = color.Text;
proObj.weight = weight.Text;
proObj.internalmemory = internalmemory.Text;
proObj.externalmemory = externalmemory.Text;
proObj.batterytype = batterytype.Text;
proObj.batterycell = batterycell.Text;
proObj.frontcamera = frontcamera.Text;
proObj.backcamera = backcamera.Text;
db.SubmitChanges();
Response.Redirect("ViewAccessoriesProduct.aspx");
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
TextBox ProductName = (TextBox)DetailsView1.FindControl("txtprodname");
DropDownList fkcomid = (DropDownList)DetailsView1.FindControl("ddlselectcompany");
TextBox stock = (TextBox)DetailsView1.FindControl("txtstock");
DropDownList fksid = (DropDownList)DetailsView1.FindControl("ddlsubcat");
TextBox prize = (TextBox)DetailsView1.FindControl("txtprize");
FileUpload filefrontimage = (FileUpload)DetailsView1.FindControl("filefrontimage");
FileUpload filebackimage = (FileUpload)DetailsView1.FindControl("filebackimage");
TextBox modelid = (TextBox)DetailsView1.FindControl("txtmodelid");
TextBox modelname = (TextBox)DetailsView1.FindControl("txtmodelname");
TextBox color = (TextBox)DetailsView1.FindControl("txtcolor");
DropDownList touch = (DropDownList)DetailsView1.FindControl("ddltouch");
TextBox simtype = (TextBox)DetailsView1.FindControl("txtsim");
TextBox callfeature = (TextBox)DetailsView1.FindControl("txtcallfeat");
TextBox cpu = (TextBox)DetailsView1.FindControl("txtcpu");
TextBox os = (TextBox)DetailsView1.FindControl("txtos");
TextBox ram = (TextBox)DetailsView1.FindControl("txtram");
DropDownList java = (DropDownList)DetailsView1.FindControl("ddljava");
TextBox processer = (TextBox)DetailsView1.FindControl("txtprocesser");
TextBox size = (TextBox)DetailsView1.FindControl("txtdsize");
TextBox frontcamera = (TextBox)DetailsView1.FindControl("txtfrontcamera");
DropDownList bluethooth = (DropDownList)DetailsView1.FindControl("ddlbluethooth");
DropDownList wifi = (DropDownList)DetailsView1.FindControl("ddlwifi");
DropDownList _2g = (DropDownList)DetailsView1.FindControl("ddl2g");
DropDownList _3g = (DropDownList)DetailsView1.FindControl("ddl3g");
DropDownList gprs = (DropDownList)DetailsView1.FindControl("ddlgprs");
TextBox backcamera = (TextBox)DetailsView1.FindControl("txtbackcamera");
TextBox internalmemory = (TextBox)DetailsView1.FindControl("txtinternalmemory");
TextBox externalmemory = (TextBox)DetailsView1.FindControl("txtextrnalmemory");
TextBox weight = (TextBox)DetailsView1.FindControl("txtweight");
TextBox batterytype = (TextBox)DetailsView1.FindControl("txtbattry");
if (filefrontimage.HasFile && filebackimage.HasFile)
{
tbl_product proObj = new tbl_product();
string serverpath = Server.MapPath("..") + "\\img\\" + filefrontimage.FileName;
filefrontimage.SaveAs(serverpath);
string urlfront = filefrontimage.FileName;
string serverpath1 = Server.MapPath("..") + "\\img\\" + filebackimage.FileName;
filebackimage.SaveAs(serverpath);
string urlback = filebackimage.FileName;
proObj = db.tbl_products.Single(data => data.pkprodid == int.Parse(DetailsView1.DataKey[0].ToString()));
proObj.prodname = ProductName.Text;
proObj.fkcomid = int.Parse(fkcomid.SelectedValue.ToString());
proObj.fksid = int.Parse(fksid.SelectedValue.ToString());
proObj.stock = stock.Text;
proObj.prize = prize.Text;
proObj.frontimage = urlfront;
proObj.backimage = urlback;
proObj.modalid = modelid.Text;
proObj.modalname = modelname.Text;
proObj.color = color.Text;
proObj.touch = touch.SelectedValue.ToString();
proObj.simtype = simtype.Text;
proObj.callfeature = callfeature.Text;
proObj.cpu = cpu.Text;
proObj.os = os.Text;
proObj.ram = ram.Text;
proObj.java = java.Text;
proObj.processer = processer.Text;
proObj.displaysize = size.Text;
proObj.frontcamera = frontcamera.Text;
proObj.backcamera = backcamera.Text;
proObj.bluethooth = bluethooth.SelectedValue.ToString();
proObj.wifi = wifi.SelectedValue.ToString();
proObj._2g = _2g.SelectedValue.ToString();
proObj._3g = _3g.SelectedValue.ToString();
proObj.gprs = gprs.SelectedValue.ToString();
proObj.internalmemory = internalmemory.Text;
proObj.externalmemory = externalmemory.Text;
proObj.weight = weight.Text;
proObj.batterytype = batterytype.Text;
db.SubmitChanges();
Response.Redirect("ViewMobilProduct.aspx");
}
}
protected void btnUpdateLeptop_Click(object sender, EventArgs e)
{
TextBox ProductName = (TextBox)DetailsView3.FindControl("txtprodname");
DropDownList fkcomid = (DropDownList)DetailsView3.FindControl("ddlselectcompany");
DropDownList fksid = (DropDownList)DetailsView3.FindControl("ddlsubcatl");
TextBox stock = (TextBox)DetailsView3.FindControl("txtstock");
TextBox prize = (TextBox)DetailsView3.FindControl("txtprize");
FileUpload filefrontimage = (FileUpload)DetailsView3.FindControl("filefrontimage");
TextBox modelid = (TextBox)DetailsView3.FindControl("txtmodelid");
TextBox modelname = (TextBox)DetailsView3.FindControl("txtmodelname");
TextBox color = (TextBox)DetailsView3.FindControl("txtcolor");
TextBox processername = (TextBox)DetailsView3.FindControl("txtprocessername");
TextBox harddisk = (TextBox)DetailsView3.FindControl("txtharddisk");
TextBox os = (TextBox)DetailsView3.FindControl("txtos");
TextBox ram = (TextBox)DetailsView3.FindControl("txtram");
TextBox weight = (TextBox)DetailsView3.FindControl("txtweight");
TextBox graphicsprocesser = (TextBox)DetailsView3.FindControl("txtgraphicprocesser");
TextBox batterycell = (TextBox)DetailsView3.FindControl("txtbattterycell");
TextBox speaker = (TextBox)DetailsView3.FindControl("txtspeakers");
DropDownList bluethooth = (DropDownList)DetailsView3.FindControl("ddlblueth");
DropDownList wifi = (DropDownList)DetailsView3.FindControl("ddlwifi");
if (filefrontimage.HasFile)
{
string serverpath = Server.MapPath("..") + "\\img\\" + filefrontimage.FileName;
filefrontimage.SaveAs(serverpath);
string urlfront = filefrontimage.FileName;
tbl_product proObj = new tbl_product();
proObj = db.tbl_products.Single(data => data.pkprodid == int.Parse(DetailsView3.DataKey[0].ToString()));
proObj.prodname = ProductName.Text;
proObj.fkcomid = int.Parse(fkcomid.SelectedValue.ToString());
proObj.fksid = int.Parse(fksid.SelectedValue.ToString());
proObj.stock = stock.Text;
proObj.prize = prize.Text;
proObj.frontimage = urlfront;
proObj.modalid = modelid.Text;
proObj.modalname = modelname.Text;
proObj.color = color.Text;
proObj.processer = processername.Text;
proObj.harddisk = harddisk.Text;
proObj.os = os.Text;
proObj.ram = ram.Text;
proObj.weight = weight.Text;
proObj.graphicprocess = graphicsprocesser.Text;
proObj.batterycell = batterycell.Text;
proObj.speaker = speaker.Text;
proObj.bluethooth = bluethooth.SelectedValue.ToString();
proObj.wifi = wifi.SelectedValue.ToString();
db.SubmitChanges();
Response.Redirect("ViewLeptopProduct.aspx");
}
}
protected void btnsave_Click1(object sender, EventArgs e)
{
TextBox ProductName = (TextBox)DetailsView2.FindControl("txtprodname");
DropDownList fkcomid = (DropDownList)DetailsView2.FindControl("ddlselectcompany");
TextBox stock = (TextBox)DetailsView2.FindControl("txtstock");
DropDownList fksid = (DropDownList)DetailsView2.FindControl("ddlsubcats");
TextBox prize = (TextBox)DetailsView2.FindControl("txtprize");
FileUpload filefrontimage = (FileUpload)DetailsView2.FindControl("filefrontimage");
TextBox modelid = (TextBox)DetailsView2.FindControl("txtmodelid");
TextBox modelname = (TextBox)DetailsView2.FindControl("txtmodelname");
TextBox color = (TextBox)DetailsView2.FindControl("txtcolor");
TextBox processername = (TextBox)DetailsView2.FindControl("txtprocessername");
TextBox os = (TextBox)DetailsView2.FindControl("txtos");
TextBox ram = (TextBox)DetailsView2.FindControl("txtram");
DropDownList java = (DropDownList)DetailsView2.FindControl("ddljava");
TextBox processer = (TextBox)DetailsView2.FindControl("txtprocesser");
TextBox harddisk = (TextBox)DetailsView2.FindControl("txthadrdiskcap");
TextBox opticaldrive = (TextBox)DetailsView2.FindControl("txtopticaldrive");
TextBox weight = (TextBox)DetailsView2.FindControl("txtweight");
TextBox graphicsprocesser = (TextBox)DetailsView2.FindControl("txtgraphicsprocesser");
TextBox keybord = (TextBox)DetailsView2.FindControl("txtkeybord");
if (filefrontimage.HasFile)
{
tbl_product proObj = new tbl_product();
string serverpath1 = Server.MapPath("..") + "\\img\\" + filefrontimage.FileName;
filefrontimage.SaveAs(serverpath1);
string urlfront1 = filefrontimage.FileName;
proObj = db.tbl_products.Single(data => data.pkprodid == int.Parse(DetailsView2.DataKey[0].ToString()));
proObj.prodname = ProductName.Text;
proObj.fkcomid = int.Parse(fkcomid.SelectedValue.ToString());
proObj.fksid = int.Parse(fksid.SelectedValue.ToString());
proObj.stock = stock.Text;
proObj.prize = prize.Text;
proObj.frontimage = urlfront1;
proObj.modalid = modelid.Text;
proObj.modalname = modelname.Text;
proObj.color = color.Text;
proObj.processer = processername.Text;
proObj.harddisk = harddisk.Text;
proObj.os = os.Text;
proObj.ram = ram.Text;
proObj.java = ram.Text;
proObj.opticaldrive = opticaldrive.Text;
proObj.weight = weight.Text;
proObj.graphicprocess = graphicsprocesser.Text;
proObj.keybord = keybord.Text;
db.SubmitChanges();
Response.Redirect("ViewComputerProduct.aspx");
}
}
