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