public ActionResult Edit([Bind(Include = "id,code,name,categoryId,brandId,colorId,barCode")] tbl_ItemMaster tbl_itemmaster) { if (ModelState.IsValid) { db.Entry(tbl_itemmaster).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.brandId = new SelectList(db.tbl_Brand, "id", "name", tbl_itemmaster.brandId); ViewBag.categoryId = new SelectList(db.tbl_Category, "id", "name", tbl_itemmaster.categoryId); ViewBag.colorId = new SelectList(db.tbl_Color, "id", "name", tbl_itemmaster.colorId); return(View(tbl_itemmaster)); }
// GET: /ItemMaster/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_ItemMaster tbl_itemmaster = db.tbl_ItemMaster.Find(id); if (tbl_itemmaster == null) { return(HttpNotFound()); } return(View(tbl_itemmaster)); }
// GET: /ItemMaster/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_ItemMaster tbl_itemmaster = db.tbl_ItemMaster.Find(id); if (tbl_itemmaster == null) { return(HttpNotFound()); } ViewBag.brandId = new SelectList(db.tbl_Brand, "id", "name", tbl_itemmaster.brandId); ViewBag.categoryId = new SelectList(db.tbl_Category, "id", "name", tbl_itemmaster.categoryId); ViewBag.colorId = new SelectList(db.tbl_Color, "id", "name", tbl_itemmaster.colorId); return(View(tbl_itemmaster)); }
public JsonResult DeleteConfirmed(int id) { string success = string.Empty; // return Json(success, JsonRequestBehavior.AllowGet); tbl_ItemMaster tbl_itemmaster = db.tbl_ItemMaster.Find(id); db.tbl_ItemMaster.Remove(tbl_itemmaster); int result = db.SaveChanges(); if (result > 0) { success = "Data delete successfully"; } // return Json(success, JsonRequestBehavior.AllowGet); return(Json(new { result = success })); }
public ActionResult Create([Bind(Include = "id,code,name,categoryId,brandId,colorId,barCode")] tbl_ItemMaster tbl_itemmaster) { if (ModelState.IsValid) { db.tbl_ItemMaster.Add(tbl_itemmaster); ViewBag.message = "Item Inserted Succesfully"; db.SaveChanges(); //return View(tbl_itemmaster); return(RedirectToAction("Index")); } ViewBag.brandId = new SelectList(db.tbl_Brand, "id", "name", tbl_itemmaster.brandId); ViewBag.categoryId = new SelectList(db.tbl_Category, "id", "name", tbl_itemmaster.categoryId); ViewBag.colorId = new SelectList(db.tbl_Color, "id", "name", tbl_itemmaster.colorId); return(View(tbl_itemmaster)); }
private void btnCreate_Click(object sender, EventArgs e) { byte[] pic = null; try { if (CaptureBox.Image != null) { MemoryStream stream = new MemoryStream(); CaptureBox.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg); pic = stream.ToArray(); } if (txtWeight.Text == string.Empty && txtMelting.Text == string.Empty && txtQty.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtWeight, "Enter all details."); txtWeight.Focus(); panel3.Visible = true; lblError.Text = "Enter all details."; } else if (txtWeight.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtWeight, "Enter weight."); txtWeight.Focus(); panel3.Visible = true; lblError.Text = "Enter weight."; } else if (txtQty.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtQty, "Enter qty."); txtQty.Focus(); panel3.Visible = true; lblError.Text = "Enter qty."; } else if (txtMelting.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtMelting, "Enter melting."); txtMelting.Focus(); panel3.Visible = true; lblError.Text = "Enter melting."; } //else if (CaptureBox.Image == null) //{ // errorProvider1.Clear(); // errorProvider1.SetError(CaptureBox, "Select Image."); // CaptureBox.Focus(); // panel3.Visible = true; // lblError.Text = "Select Image."; //} else { if (btnCreate.Text == "Create") { //insert Code _entities = new MicroAccountsEntities1(); tbl_ItemMaster itemMaster = new tbl_ItemMaster(); //itemMaster.categoryId = Convert.ToInt32(cmbItemCategory.SelectedValue); itemMaster.categoryId = Convert.ToInt32(cmbItemCategory.SelectedValue); itemMaster.photo = pic; itemMaster.itemCode = lblItemCode.Text; itemMaster.createdDate = DateTime.Now; _entities.tbl_ItemMaster.Add(itemMaster); _entities.SaveChanges(); tbl_StockItemDetails stockDetail = new tbl_StockItemDetails(); stockDetail.weight = Convert.ToDecimal(txtWeight.Text); if (cmbKarat.SelectedIndex > 0) { stockDetail.carret = Convert.ToDecimal(cmbKarat.Text); } else { stockDetail.carret = 0; } stockDetail.qty = Convert.ToDecimal(txtQty.Text); stockDetail.unit = cmbUnit.Text.ToString(); stockDetail.melting = Convert.ToDecimal(txtMelting.Text); stockDetail.remarks = txtRemarks.Text.Trim().ToString(); stockDetail.itemId = _entities.tbl_ItemMaster.OrderByDescending(x => x.id).FirstOrDefault().id; stockDetail.createdDate = DateTime.Now; stockDetail.upadtedDate = DateTime.Now; _entities.tbl_StockItemDetails.Add(stockDetail); _entities.SaveChanges(); MessageBox.Show("Record Successfully Saved!"); } else { //Update Code _entities = new MicroAccountsEntities1(); var itemData = (from a in _entities.tbl_ItemMaster join b in _entities.tbl_StockItemDetails on a.id equals b.itemId where a.id == itemIDGlobal select new { a, b }).FirstOrDefault(); itemData.a.categoryId = Convert.ToInt32(cmbItemCategory.SelectedValue); itemData.a.photo = pic; itemData.a.itemCode = lblItemCode.Text; itemData.a.updateDate = DateTime.Now; itemData.b.weight = Convert.ToDecimal(txtWeight.Text); if (cmbKarat.SelectedIndex > 0) { itemData.b.carret = Convert.ToDecimal(cmbKarat.Text); } else { itemData.b.carret = 0; } itemData.b.qty = Convert.ToDecimal(txtQty.Text); itemData.b.unit = cmbUnit.Text.ToString(); itemData.b.melting = Convert.ToDecimal(txtMelting.Text); itemData.b.remarks = txtRemarks.Text.Trim().ToString(); itemData.b.upadtedDate = DateTime.Now; _entities.SaveChanges(); MessageBox.Show("Record Successfully Updated!"); } clear(); } } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }