public ActionResult EditGood(int id) //CaseID 修改的頁面 先讀取單筆
{
CaseGood cg = new CaseGood();
var q = db.Cases.Find(id);
cg.CaseID = q.CaseID;
Session["CaseID"] = q.CaseID;
cg.CaseTitle = q.CaseTitle;
cg.CaseContent = q.CaseContent;
cg.StartDateTime = q.StartDateTime;
cg.Location = q.Location; //地址還不完整!!!!!!!
cg.Contact = q.Contact;
cg.StatusName = db.CaseStatus.Find(q.StatusID).StatusName; //狀態
var g = db.Goods.Where(m => m.CaseID == q.CaseID).First();
cg.GdsID = g.GdsID;
cg.GdsName = g.GdsName;
cg.GdsCount = g.GdsCount;
cg.GdsPoint = g.GdsPoint;
var sub = db.GdsSubClass.Find(g.GdsSubClassID);
cg.GdsSubClass1 = sub.GdsSubClass1; //小分類
cg.GdsClass = db.GoodsClass.Find(sub.GdsClassID).GdsClass; //大分類
var re = db.Region.Find(q.RegionID);
cg.RegionName = re.RegionName; //區
cg.CityName = db.City.Find(re.CityID).CityName; //縣市
int count = db.Picture.Where(o => o.CaseID == id).Count();
if (count > 0)
{
var pimg = db.Picture.Where(m => m.CaseID == id).FirstOrDefault();
cg.ImageID = pimg.ImageID;
}
Goods goods = db.Goods.Find(g.GdsID);
GdsSubClass subclass = db.GdsSubClass.Find(g.GdsSubClassID);
ViewBag.GdsSubClassID = new SelectList(db.GdsSubClass.Where(o => o.GdsClassID == subclass.GdsClassID), "GdsSubClassID", "GdsSubClass1", goods.GdsSubClassID);
ViewBag.GdsClassID = new SelectList(db.GoodsClass, "GdsClassID", "GdsClass", subclass.GdsClassID);
Cases _case = db.Cases.Find(id);
Region region = db.Region.Find(q.RegionID);
ViewBag.RegionID = new SelectList(db.Region.Where(o => o.CityID == region.CityID), "RegionID", "RegionName", _case.RegionID);
ViewBag.CityID = new SelectList(db.City, "CityID", "CityName", region.CityID);
ViewBag.count = count;
return(View(cg));
}
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());
}
}
