public ActionResult Create() { int mid; if (Session["MEMBERID"] == null) { return(RedirectToAction("Login", "Member", new { area = "MyMember" })); } else { mid = (int)(Session["MEMBERID"]); } if (Request.Form.Count > 0) { //Session["MEMBERID"] = 3; mid = (int)Session["MEMBERID"]; Board _board = new Board(); _board.MemberID = mid; // (int)Session["MEMBERID"]; _board.CaseTitle = Request.Form["CaseTitle"]; _board.CaseContent = Request.Form["CaseContent"]; _board.StartDateTime = DateTime.Now; db.Board.Add(_board); db.SaveChanges(); return(RedirectToAction("Index", "Home", new { area = "" })); } return(View()); }
private void btnRemove_Click(object sender, EventArgs e) { this.flowLayoutPanel1.Controls.Clear(); var q = from p in dbContext.Pictures where p.CaseID == casid select p; foreach (var a in q) { dbContext.Pictures.Remove(a); } dbContext.SaveChanges(); qty = 0; }
public ActionResult HOME(IEnumerable <HttpPostedFileBase> files) { if (files != null) { foreach (var file in files) { if (file != null) { var imagesSize = file.ContentLength; byte[] imageByte = new byte[imagesSize]; file.InputStream.Read(imageByte, 0, imagesSize); db.Picture.Add(new Picture { CaseID = 1, Images = imageByte }); db.SaveChanges(); TempData["message"] = "上傳成功"; } else { TempData["message"] = "請先選檔案"; } } } return(RedirectToAction("HOME")); }
public ActionResult editedit(FormCollection collec) { var iii = collec["cart.CartID"].Split(','); var ii = collec["cart.Quantity"].Split(','); //int[] aa = { 2, 3 }; for (int i = 0; i < iii.Length; i++) { var c = Convert.ToInt32(iii[i]); var qu = Convert.ToInt32(ii[i]); var q = from p in db.Cart where p.CartID.Equals(c) select p; foreach (var a in q) { a.Quantity = qu; } } db.SaveChanges(); return(RedirectToAction("Cart")); }
public ActionResult Create(Member m, HttpPostedFileBase strPhoto) { string message = ""; if (ModelState.IsValid) { if (strPhoto != null) { //string strPath = Request.PhysicalApplicationPath + "Areas\\Members\\MemberImages"; //strPhoto.SaveAs(strPath + strPhoto.FileName); var imagesSize = strPhoto.ContentLength; byte[] imageByte = new byte[imagesSize]; strPhoto.InputStream.Read(imageByte, 0, imagesSize); m.Photo = imageByte; m.Stage = 1; m.EXP = 0; m.PointCount = 0; db.Member.Add(m); db.SaveChanges(); message = "註冊成功"; ViewBag.Message = message; //return RedirectToAction("Index", "Home", new { area = "" }); return(RedirectToAction("Login")); } else { message = "請選擇圖檔"; ViewBag.Message = message; return(View()); } } else { message = "註冊失敗"; ViewBag.Message = message; } return(RedirectToAction("Login")); }
public ActionResult Edit(FormCollection f /* Evaluation[] c*/) { var iiii = f["e.EvaID"].Split(','); var iii = f["e.Evaluation1"].Split(','); var ii = f["e.Evacontent"].Split(','); for (int i = 0; i < iii.Length; i++) { var ec = ii[i]; var elevel = Convert.ToInt32(iii[i]); var eid = Convert.ToInt32(iiii[i]); var q = from p in db.Evaluation where p.EvaID.Equals(eid) select p; foreach (var a in q) { a.Evaluation1 = elevel; a.Evacontent = ec; } } db.SaveChanges(); return(RedirectToAction("Evalist")); //foreach(var q in c) //{ // var ev = db.Evaluation.Find(q.EvaID); // ev.OrderID = q.OrderID; // ev.Evaluation1 = q.Evaluation1; // ev.Evacontent = q.Evacontent; //} //var ev = db.Evaluation.Find(c.EvaID); //ev.OrderID = c.OrderID; //ev.Evaluation1 = c.Evaluation1; //ev.Evacontent = c.Evacontent; //db.SaveChanges(); ////Repository //return View("Index"); } //不用
public ActionResult Edit(Cart c) { int aaa = Convert.ToInt32(Request.Form["ShoppingCartID"]); var sp = db.Cart.Where(a => a.ShoppingCartID == aaa).Select(a => a); //if(c.Recipient!=null&&c.RecipientPhone!=null&&c.RecipientAddress!=null) //{ foreach (Cart q in sp) { //q.Cases = null; q.Recipient = c.Recipient; q.RecipientPhone = c.RecipientPhone; q.RecipientAddress = c.RecipientAddress; db.Entry(q).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); return(RedirectToAction("OrderDetail")); //} //else //{ // return RedirectToAction("Edit"); //} }
發問 QQ = new 發問(); //不能一次開很多 事件會重複觸發 會存進多筆相同資料 private void Button1_Click(object sender, EventArgs e) //送出提問 { int cas = int.Parse(((Button)sender).Name); //CaseID if (QQ.textBox1.Text != "") { string messagecontent1 = QQ.textBox1.Text; dbContext.Contents.Add(new Content { CaseID = cas, MemberID = mem, MessageContent = messagecontent1, MessageDateTime = DateTime.Now }); dbContext.SaveChanges(); QQ.textBox1.Text = ""; functions(cas);//刷新 } }
public ActionResult MPMemberContent(int id, string Content) { //========存值 if (Content != null) { Content cont = new Content(); cont.CaseID = id; cont.MemberID = (int)Session["MEMBERID"]; cont.MessageContent = Content; cont.MessageDateTime = DateTime.Now; db.Content.Add(cont); db.SaveChanges(); } //========即刻讀值 var lastc = db.Content.Where(p => p.CaseID == id).OrderByDescending(p => p.MessageDateTime).First(); ContentViewModel cvm = new ContentViewModel(); cvm.CaseID = id; cvm.MemberID = lastc.MemberID; var m = db.Member.Find(lastc.MemberID); cvm.NickName = m.NickName; cvm.Photo = m.Photo; cvm.MessageContent = lastc.MessageContent; cvm.MessageDateTime = lastc.MessageDateTime; cvm.AuthorRepeat = lastc.AuthorRepeat; ViewBag.mem = lastc.MemberID; ViewBag.pho = m.Photo; ViewBag.data = cvm; return(Json(cvm, JsonRequestBehavior.AllowGet)); }
public ActionResult RemovePicture(int id)//CaseID 清除這案件的圖 { var q = db.Picture.Where(o => o.CaseID == id); foreach (var a in q) { db.Picture.Remove(a); } db.SaveChanges(); return(Json(db.Region.Where(c => c.CityID == id).Select(r => new { RegionID = r.RegionID, RegionName = r.RegionName }), JsonRequestBehavior.AllowGet)); }
private void button1_Click(object sender, EventArgs e) { //CASE優先 memberID1 = int.Parse(label13.Name); string CaseContent1 = textBox3.Text; string CaseTitle1 = textBox5.Text; string contact1 = textBox2.Text; string Location1 = textBox6.Text; //縣市要Load進來 區要在comboBox2屬性變化時讀取,條件等於 comboBox2.Text var q = from p in dbContext.Regions where p.RegionName == comboBox3.Text //用comboBox3.Text 來找到區的ID select new { p.RegionID }; foreach (var a in q) { regionID1 = a.RegionID; } DateTime dt = DateTime.Now; int statusID = 4; dbContext.Cases.Add(new Case { Contact = contact1, MemberID = memberID1, CaseContent = CaseContent1, CaseTitle = CaseTitle1 , StartDateTime = dt, Location = Location1, RegionID = regionID1, StatusID = statusID }); dbContext.SaveChanges(); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //GOODS string GdsName1 = textBox7.Text; int GdsCount1 = int.Parse(textBox8.Text); int GdsPoint1 = int.Parse(textBox4.Text);//價 var q1 = (from p in dbContext.Cases where p.MemberID == memberID1 orderby p.CaseID descending select new { p.CaseID }).Take(1); foreach (var a in q1) { CaseId1 = a.CaseID; }//先寫死 上面完成後讀取CASE 條件用會員ID與內容 找到CaseID var q2 = from p in dbContext.GdsSubClasses where p.GdsSubClass1 == comboBox4.Text select new { p.GdsSubClassID }; foreach (var a in q2) { GdssubClassID1 = a.GdsSubClassID; } //要先全部的項目load到這裡 然後用選到的取得分類ID dbContext.Goods.Add(new Good { GdsName = GdsName1, GdsCount = GdsCount1, GdsPoint = GdsPoint1, GdsDeadline = dateTimePicker1.Value , CaseID = CaseId1, GdsSubClassID = GdssubClassID1 }); dbContext.SaveChanges(); if (qty > 0) { for (int i = 1; i <= qty; i++) { string s; s = ((PictureBox)this.flowLayoutPanel1.Controls[i - 1]).ImageLocation; FileStream fs = new FileStream(s, FileMode.Open, FileAccess.Read); byte[] data = new byte[fs.Length]; fs.Read(data, 0, (int)fs.Length); dbContext.Pictures.Add(new Picture { CaseID = CaseId1, Images = data }); dbContext.SaveChanges(); } } //for (int i =0; i<= this.flowLayoutPanel1.Controls.Count-1; i++) //{ // ((PictureBox ) this.flowLayoutPanel1.Controls[i]).Tag //} MessageBox.Show("成功送出"); }
public void Create(T _entity) { Dbset.Add(_entity); db.SaveChanges(); }
public int buycheck(int id) { //=====把兩個表中的shoppingcartID取出來 var sc = (from s in db.Cart.AsEnumerable() where s.MemberID == id select s.ShoppingCartID).ToList(); var osc = (from s in db.Orders.AsEnumerable() where s.MemberID == id select s.ShoppingCartID).ToList(); //======存現有的shoppingcartID中最大的那個如果沒有現有的就直接給1 if (sc.Count == 0) { newshoppingID = 1; return(newshoppingID); } else { int lastshoppingID = (int)sc.Max(); //把兩個表中重複或是null的shoppingcartID去掉 var distinctsc = sc.Distinct().ToList(); var distinctosc = osc.Distinct().ToList(); distinctosc.RemoveAll(n => n == null); //灌值進去list內存 for (int i = 0; i < distinctsc.Count(); i++) { ShoppingcartIDinCart.Add((int)distinctsc[i]); } for (int i = 0; i < distinctosc.Count(); i++) { ShoppingcartIDinOrders.Add((int)distinctosc[i]); } //比較兩個list內的shoppingcartID var NoinOrdersShoppingcartid = ShoppingcartIDinCart.Except(ShoppingcartIDinOrders); int thisshoppingID; List <ShoppingCarts> carts = new List <ShoppingCarts>(); if (NoinOrdersShoppingcartid.Count() > 0) { thisshoppingID = NoinOrdersShoppingcartid.First(); //=============刪除上次購物車未加入訂單的資料=========== var tsc = (from s in db.Cart.AsEnumerable() where s.MemberID == id && s.ShoppingCartID == thisshoppingID select s).ToList(); foreach (var q in tsc) { db.Cart.Remove(q); db.SaveChanges(); } newshoppingID = lastshoppingID; } else { newshoppingID = lastshoppingID + 1; } return(newshoppingID); } }
public ActionResult GoodsCreate(IEnumerable <HttpPostedFileBase> files) { //int mid = Convert.ToInt32(Request.Cookies["MEMBERID"].Value); int mid = (int)Session["MEMBERID"]; #region List <GoodsClass> gc = new List <GoodsClass>(); GoodsClass first = new GoodsClass(); first.GdsClassID = 10000; first.GdsClass = "請選擇類別"; gc.Add(first); var q = db.GoodsClass; foreach (var a in q) { gc.Add(a); } List <GdsSubClass> gsc = new List <GdsSubClass>(); GdsSubClass sbfirst = new GdsSubClass(); sbfirst.GdsSubClassID = 10000; sbfirst.GdsSubClass1 = "請先選擇大類別"; gsc.Add(sbfirst); ViewBag.GdsClassID = new SelectList(gc, "GdsClassID", "GdsClass", first.GdsClassID); ViewBag.GdsSubClassID = new SelectList(gsc, "GdsSubClassID", "GdsSubClass1", sbfirst.GdsSubClassID); List <City> ct = new List <City>(); City ctfirst = new City(); ctfirst.CityID = 10000; ctfirst.CityName = "請選擇縣市"; ct.Add(ctfirst); var z = db.City; foreach (var a in z) { ct.Add(a); } List <Region> rg = new List <Region>(); Region rgfirst = new Region(); rgfirst.RegionID = 10000; rgfirst.RegionName = "請先選擇縣市"; rg.Add(rgfirst); ViewBag.CityID = new SelectList(ct, "CityID", "CityName", ctfirst.CityID); ViewBag.RegionID = new SelectList(rg, "RegionID", "RegionName", rgfirst.RegionID); #endregion if (Request.Form.Count > 0) { db.Cases.Add(new Cases { CaseTitle = Request.Form["CaseTitle"], CaseContent = Request.Form["CaseContent"], StartDateTime = DateTime.Now, MemberID = mid, Recommendation = 0, Location = Request.Form["Location"], RegionID = Convert.ToInt32(Request.Form["RegionID"]), Contact = Request.Form["Contact"], StatusID = Convert.ToInt32(Request.Form["StatusID"]), }); db.SaveChanges(); int cid = db.Cases.Where(c => c.MemberID == mid).OrderByDescending(c => c.CaseID).First().CaseID; db.Goods.Add(new Goods { CaseID = cid, GdsPoint = 0, GdsName = Request.Form["CaseContent"], GdsCount = Convert.ToInt32(Request.Form["GdsCount"]), GdsDeadline = Convert.ToDateTime(Request.Form["GdsDeadline"]), GdsSubClassID = Convert.ToInt32(Request.Form["GdsSubClassID"]), }); if (files != null) { foreach (var file in files) { if (file != null) { var imagesSize = file.ContentLength; byte[] imageByte = new byte[imagesSize]; file.InputStream.Read(imageByte, 0, imagesSize); db.Picture.Add(new Picture { CaseID = cid, Images = imageByte }); db.SaveChanges(); TempData["message"] = "上傳成功"; } else { TempData["message"] = "請先選檔案"; } } } db.SaveChanges(); return(RedirectToAction("BrowseGoodsAll")); } else { return(View()); } }