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