public ActionResult EditMan(int id) //CaseID 修改的頁面 先讀取單筆
{
CaseManPower cg = new CaseManPower();
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.StatusID = q.StatusID;
cg.StatusName = db.CaseStatus.Find(q.StatusID).StatusName; //狀態
var g = db.ManPower.Where(m => m.CaseID == q.CaseID).First();
cg.MPID = g.MPID;
cg.MPName = g.MPName;
cg.MPNeedCount = g.MPNeedCount;
cg.MPActuralCount = g.MPActuralCount;
cg.MPTime = g.MPTime;
cg.MPDate = g.MPDate;
var sub = db.MPSubClass.Find(g.MPSubClassID);
cg.MPSubClass1 = sub.MPSubClass1; //小分類
cg.MPClass1 = db.MPClass.Find(sub.MPClassID).MPClass1; //大分類
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;
}
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);
ManPower mans = db.ManPower.Find(g.MPID);
MPSubClass subclass = db.MPSubClass.Find(g.MPSubClassID);
ViewBag.MPSubClassID = new SelectList(db.MPSubClass.Where(o => o.MPClassID == subclass.MPClassID), "MPSubClassID", "MPSubClass1", mans.MPSubClassID);
ViewBag.MPClassID = new SelectList(db.MPClass, "MPClassID", "MPClass1", subclass.MPClassID);
return(View(cg));
}
public ActionResult ManPowerCreate(IEnumerable <HttpPostedFileBase> files)
{
int mid = (int)Session["MEMBERID"];
#region
List <MPClass> gc = new List <MPClass>();
MPClass first = new MPClass();
first.MPClassID = 10000;
first.MPClass1 = "請選擇類別";
gc.Add(first);
var q = db.MPClass;
foreach (var a in q)
{
gc.Add(a);
}
List <MPSubClass> gsc = new List <MPSubClass>();
MPSubClass sbfirst = new MPSubClass();
sbfirst.MPSubClassID = 10000;
sbfirst.MPSubClass1 = "請先選擇大類別";
gsc.Add(sbfirst);
ViewBag.MPClassID = new SelectList(gc, "MPClassID", "MPClass1", first.MPClassID);
ViewBag.MPSubClassID = new SelectList(gsc, "MPSubClassID", "MPSubClass1", sbfirst.MPSubClassID);
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.ManPower.Add(new ManPower
{
CaseID = cid,
MPPoint = 0,
MPName = Request.Form["CaseContent"],
MPNeedCount = Convert.ToInt32(Request.Form["MPNeedCount"]),
MPSubClassID = Convert.ToInt32(Request.Form["MPSubClassID"]),
MPDate = Convert.ToDateTime(Request.Form["MPDate"]),
MPTime = Convert.ToDateTime(Request.Form["MPTime"]),
});
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("ManPowerAll"));
}
else
{
return(View());
}
}
