public async Task <ActionResult> DeleteConfirmed(int id)
{
inv_ItemHistory inv_ItemHistory = await db.inv_ItemHistory.FindAsync(id);
db.inv_ItemHistory.Remove(inv_ItemHistory);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> UpdateQuantity(inv_Items Item, inv_ItemHistory ItemHistory, decimal?NewQuantity)
{
int status = 0;
long ItemId;
if (Item.ItemID > 0)
{
//Edit
var v = db.inv_Items.Where(a => a.ItemID == Item.ItemID).FirstOrDefault();
if (v != null)
{
Session["OldQuantityTemp"] = v.ItemQuantity;
Session["NewQuantityTemp"] = NewQuantity;
v.ItemID = Item.ItemID;
ItemId = Item.ItemID;
v.ItemQuantity = int.Parse(Session["OldQuantityTemp"].ToString()) + int.Parse(Session["NewQuantityTemp"].ToString());
await db.SaveChangesAsync();
status = 1;
// Log ItemHistroy
string constr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("Insert_ItemHistory"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ItemID", Item.ItemID);
cmd.Parameters.AddWithValue("@ItemHistoryQuantity", long.Parse(Session["NewQuantityTemp"].ToString()));
cmd.Parameters.AddWithValue("@ItemHistoryProccessTypeID", 1);
cmd.Parameters.AddWithValue("@ItemHistoryDebitOrCredit", true);
cmd.Parameters.AddWithValue("@ItemHistoryDecription", "توريدة جديدة");
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
//Log ItemHistroy
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public async Task <ActionResult> Edit([Bind(Include = "ItemHistoryID,ItemID,ItemHistoryQuantity,QuantityMeasureUnit,ItemHistoryDebitOrCredit,ItemHistoryCuurentQuantity,ItemHistoryProccessTypeID,ItemHistoryProccessType,ItemHistoryDecription,ItemHistoryDate,UpLoaded,ItemHistoyPrice")] inv_ItemHistory inv_ItemHistory)
{
if (ModelState.IsValid)
{
db.Entry(inv_ItemHistory).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(inv_ItemHistory));
}
// GET: ItemHistory/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
inv_ItemHistory inv_ItemHistory = await db.inv_ItemHistory.FindAsync(id);
if (inv_ItemHistory == null)
{
return(HttpNotFound());
}
return(View(inv_ItemHistory));
}
