public ActionResult updatePackageItem(packageItem p) { SqlConnection con = new SqlConnection(); //con.ConnectionString = "Data Source=souqzone.database.windows.net;Initial Catalog=souqzone;Integrated Security=False;User ID=souqzone_admin;Password=Az@00000;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; con.ConnectionString = @"Data Source=DESKTOP-J0TTRBH\SQLEXPRESS;Initial Catalog=test99;Integrated Security=True"; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.Connection = con;//بربط ال command على الداتابيز if (p.img != null) { cmd.CommandText = "update item set img='" + p.img + "',name='" + p.name + "',price=" + p.price + ",packageID=" + p.packageID + ",supplierID=" + p.supplierID + " where itemID=" + p.itemID; } else { cmd.CommandText = "update item set name='" + p.name + "',price=" + p.price + ",packageID=" + p.packageID + ",supplierID=" + p.supplierID + " where itemID=" + p.itemID; } int x = cmd.ExecuteNonQuery(); con.Close(); return(RedirectToAction("Index2")); }
public ActionResult insertPackageItem(packageItem p) { SqlConnection con = new SqlConnection(); //con.ConnectionString = "Data Source=souqzone.database.windows.net;Initial Catalog=souqzone;Integrated Security=False;User ID=souqzone_admin;Password=Az@00000;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; con.ConnectionString = @"Data Source=DESKTOP-J0TTRBH\SQLEXPRESS;Initial Catalog=test99;Integrated Security=True"; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.Connection = con;//بربط ال command على الداتابيز cmd.CommandText = "insert into item values('" + p.img + "','" + p.name + "'," + p.packageID + "," + p.supplierID + "," + p.price + ")"; int f = cmd.ExecuteNonQuery(); con.Close(); return(RedirectToAction("Index", new { idd = p.supplierID })); }
public ActionResult getPackageitem(int id) { SqlConnection con = new SqlConnection(); //con.ConnectionString = "Data Source=souqzone.database.windows.net;Initial Catalog=souqzone;Integrated Security=False;User ID=souqzone_admin;Password=Az@00000;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; con.ConnectionString = @"Data Source=DESKTOP-J0TTRBH\SQLEXPRESS;Initial Catalog=test99;Integrated Security=True"; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.Connection = con;//بربط ال command على الداتابيز cmd.CommandText = "select * from item where packageID=" + id; SqlDataReader r3 = cmd.ExecuteReader(); List <packageItem> lt3 = new List <packageItem>(); while (r3.Read()) { packageItem sp = new packageItem(); sp.img = r3["img"].ToString(); sp.name = r3["name"].ToString(); sp.price = float.Parse(r3["price"].ToString()); sp.supplierID = int.Parse(r3["supplierID"].ToString()); Session["supplierID"] = int.Parse(r3["supplierID"].ToString()); sp.packageID = int.Parse(r3["packageID"].ToString()); sp.itemID = int.Parse(r3["itemID"].ToString()); lt3.Add(sp); } Session["packageID"] = id; //Session["supplierID"] = sid; ViewBag.packageItems = lt3; r3.Close(); con.Close(); return(View("products")); //return View("jk"); }