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);
}
