public IHttpActionResult Posttbl_Price(tbl_Price tbl_Price)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tbl_Price.Add(tbl_Price);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (tbl_PriceExists(tbl_Price.Price_ID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = tbl_Price.Price_ID }, tbl_Price));
}
public IHttpActionResult Puttbl_Price(string id, tbl_Price tbl_Price)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_Price.Price_ID)
{
return(BadRequest());
}
db.Entry(tbl_Price).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tbl_PriceExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Gettbl_Price(string id)
{
tbl_Price tbl_Price = db.tbl_Price.Find(id);
if (tbl_Price == null)
{
return(NotFound());
}
return(Ok(tbl_Price));
}
public ActionResult Edit([Bind(Include = "id,unitId,itemMasterId,price")] tbl_Price tbl_price)
{
if (ModelState.IsValid)
{
db.Entry(tbl_price).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.itemMasterId = new SelectList(db.tbl_ItemMaster, "id", "name", tbl_price.itemMasterId);
ViewBag.unitId = new SelectList(db.tbl_Unit, "id", "shortCode", tbl_price.unitId);
return(View(tbl_price));
}
// GET: /Price/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_Price tbl_price = db.tbl_Price.Find(id);
if (tbl_price == null)
{
return(HttpNotFound());
}
return(View(tbl_price));
}
public IHttpActionResult Deletetbl_Price(string id)
{
tbl_Price tbl_Price = db.tbl_Price.Find(id);
if (tbl_Price == null)
{
return(NotFound());
}
db.tbl_Price.Remove(tbl_Price);
db.SaveChanges();
return(Ok(tbl_Price));
}
// GET: /Price/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_Price tbl_price = db.tbl_Price.Find(id);
if (tbl_price == null)
{
return(HttpNotFound());
}
ViewBag.itemMasterId = new SelectList(db.tbl_ItemMaster, "id", "name", tbl_price.itemMasterId);
ViewBag.unitId = new SelectList(db.tbl_Unit, "id", "shortCode", tbl_price.unitId);
return(View(tbl_price));
}
public ActionResult Create([Bind(Include = "id,unitId,itemMasterId,price")] tbl_Price tbl_price)
{
if (ModelState.IsValid)
{
db.tbl_Price.Add(tbl_price);
ViewBag.message = "Price Inserted Succesfully";
db.SaveChanges();
//return View(tbl_price);
return(RedirectToAction("Index"));
}
ViewBag.itemMasterId = new SelectList(db.tbl_ItemMaster, "id", "name", tbl_price.itemMasterId);
ViewBag.unitId = new SelectList(db.tbl_Unit, "id", "shortCode", tbl_price.unitId);
return(View(tbl_price));
}
public JsonResult DeleteConfirmed(int id)
{
string success = string.Empty;
// return Json(success, JsonRequestBehavior.AllowGet);
tbl_Price tbl_price = db.tbl_Price.Find(id);
db.tbl_Price.Remove(tbl_price);
int result = db.SaveChanges();
if (result > 0)
{
success = "Data delete successfully";
}
// return Json(success, JsonRequestBehavior.AllowGet);
return(Json(new { result = success }));
}
