public object AddInventoryDetails(InventoryDetailsModel obj) { try { int result = 0; using (sqlcon = new SqlConnection(AppConfiguration.ConnectionString)) { sqlcon.Open(); SqlCommand cmd = new SqlCommand("Inventory_DM", sqlcon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", obj.Name); cmd.Parameters.AddWithValue("@Description", obj.Description); cmd.Parameters.AddWithValue("@Price", obj.Price); cmd.Parameters.AddWithValue("@TotalPrice", obj.TotalPrice); cmd.Parameters.AddWithValue("@Quantity", obj.Quantity); cmd.Parameters.AddWithValue("@Date", obj.Date); cmd.Parameters.AddWithValue("@InventoryID", obj.InventoryID); cmd.Parameters.AddWithValue("@Mode", 1); cmd.Parameters.Add("@Error", SqlDbType.Int); cmd.Parameters["@Error"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); return(result = Convert.ToInt32(cmd.Parameters["@Error"].Value)); } } finally { sqlcon.Close(); } }
public ActionResult AddInventoryDetails(InventoryDetailsModel objDetails) { if (Session["InventoryID"] != null) { objDetails.InventoryID = Convert.ToInt32(Session["InventoryID"].ToString()); } Session["InventoryID"] = null; return(Json(objDAL.AddInventoryDetails(objDetails))); }
public ActionResult EditInventory(int ID) { Session["InventoryID"] = Convert.ToString(ID); InventoryDetailsModel obj = new InventoryDetailsModel(); List <InventoryDetailsModel> typeList = new List <InventoryDetailsModel>(); typeList = objDAL.EditInventory(ID); obj = typeList[0]; return(Json(obj, JsonRequestBehavior.AllowGet)); }
public List <InventoryDetailsModel> EditInventory(int iD) { List <InventoryDetailsModel> desList = new List <InventoryDetailsModel>(); try { //sqlcon = new SqlConnection(SqlConn); sqlcon = new SqlConnection(AppConfiguration.ConnectionString); cmd = new SqlCommand("Inventory_DM", sqlcon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Mode", 4); cmd.Parameters.AddWithValue("@InventoryID", iD); sqlcon.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { InventoryDetailsModel obj = new InventoryDetailsModel(); obj.InventoryID = Convert.ToInt32(dr["InventoryID"]); obj.Name = Convert.ToString(dr["Name"]); obj.Description = Convert.ToString(dr["Description"]); obj.Date = Convert.ToString(dr["Date"]); obj.Price = Convert.ToDecimal(dr["Price"]); obj.TotalPrice = Convert.ToDecimal(dr["TotalPrice"]); obj.Quantity = Convert.ToInt32(dr["Quantity"]); desList.Add(obj); } } catch (Exception ex) { throw ex; } finally { sqlcon.Close(); } return(desList); }