public ActionResult Create(tMessageCode mescode, tForumTitle title, tForumMessage message)
{
if (Request.Cookies["account"] == null)
{
return(RedirectToAction("Index", "ForumHome"));
}
string epid = Request.Cookies["account"].Value;
var EP_ID = db.tEmployee.Where(p => p.fEp_Code == epid).Single().fEp_ID;
db.tMessageCode.Add(mescode);
db.SaveChanges();
title.fMC_ID = db.tMessageCode.AsEnumerable().Last().fMC_ID;
title.fEp_ID = EP_ID;
title.fFT_Date = DateTime.Now;
message.fEp_ID = EP_ID;
message.fFM_Date = DateTime.Now;
message.fMC_ID = db.tMessageCode.AsEnumerable().Last().fMC_ID;
db.tForumTitle.Add(title);
db.tForumMessage.Add(message);
db.SaveChanges();
return(RedirectToAction("Index", "ForumHome"));
}
//刪除文章
public ActionResult Delete(int?id)
{
var FTid = db.tForumTitle.Where(p => p.fMC_ID == id).Single().fFT_ID;
var FMid = db.tForumMessage.Where(p => p.fMC_ID == id).Single().fFM_ID;
tMessageCode deleCode = db.tMessageCode.Find(id);
tForumTitle deleTitle = db.tForumTitle.Find(FTid);
tForumMessage deleMessage = db.tForumMessage.Find(FMid);
db.tMessageCode.Remove(deleCode);
db.tForumTitle.Remove(deleTitle);
db.tForumMessage.Remove(deleMessage);
db.SaveChanges();
return(RedirectToAction("Index", "ForumMyself"));
}
public ActionResult CreateDetail(tTravelDetail _TravelDetail, HttpPostedFileBase fImage, string fTD_site)
{
if (ModelState.IsValid)
{
if (fImage != null && fImage.ContentLength > 0)
{
tMessageCode _MCode = new tMessageCode();
db.tMessageCode.Add(_MCode);
db.SaveChanges();
//將上傳的圖轉成二進位
var imgSize = fImage.ContentLength;
byte[] imgByte = new byte[imgSize];
fImage.InputStream.Read(imgByte, 0, imgSize);
_TravelDetail.fTD_Image = imgByte;
//將tTD_side地址轉座標
var requestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}", Uri.EscapeDataString(fTD_site));
var request = WebRequest.Create(requestUri);
var response = request.GetResponse();
var xdoc = XDocument.Load(response.GetResponseStream());
var result = xdoc.Element("GeocodeResponse").Element("result");
var locationElement = result.Element("geometry").Element("location");
var lat = locationElement.Element("lat");
var lng = locationElement.Element("lng");
double latitude = Double.Parse(lat.Value);
double lngitude = Double.Parse(lng.Value);
_TravelDetail.fTD_site = String.Format("{0},{1}", Convert.ToString(latitude), Convert.ToString(lngitude));
_TravelDetail.fMC_ID = db.tMessageCode.AsEnumerable().Last().fMC_ID;
db.tTravelDetail.Add(_TravelDetail);
db.SaveChanges();
return(RedirectToAction("Index", "TravelMapHome"));
}
else
{
ViewBag.message = "請選擇圖檔!!";
}
}
return(View());
}
public ActionResult tPhotoCreate([Bind(Include = "fPh_ID,fPh_PicFile,fAl_ID,fPh_Date,fPh_Notes,fMC_ID")] tPhoto tPhoto, HttpPostedFileBase[] photoImage)
{
try {
if (ModelState.IsValid)
{
if (photoImage != null && photoImage.Count() > 0)
{
foreach (var uploadFile in photoImage)
{
if (uploadFile.ContentLength > 0)
{
var imgSize = uploadFile.ContentLength;
byte[] imgByte = new byte[imgSize];
uploadFile.InputStream.Read(imgByte, 0, imgSize);
tMessageCode tMessageCode = new tMessageCode();
db.tMessageCode.Add(tMessageCode);
db.SaveChanges();
tPhoto.fPh_Notes = "";
tPhoto.fPh_PicFile = imgByte;
tPhoto.fPh_Date = DateTime.Now;
tPhoto.fMC_ID = db.tMessageCode.AsEnumerable().Last().fMC_ID;
db.tPhoto.Add(tPhoto);
db.SaveChanges();
}
}
return(RedirectToAction("Photo", "Albums", new { area = "Albums", id = tPhoto.fAl_ID }));
}
}
ViewBag.fAl_ID = new SelectList(db.tAlbum, "fAl_ID", "fAl_ID", tPhoto.fAl_ID);
ViewBag.fMC_ID = new SelectList(db.tMessageCode, "fMC_ID", "fMC_ID", tPhoto.fMC_ID);
return(View(tPhoto));
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Albums", new { area = "Albums" }));
}
}
public ActionResult AddRestaurant(tRestaurant restaurant, HttpPostedFileBase RestaurantImg, List <string> chkfoodclass, string rd1, int fEp_ID = 2)
{
if (ModelState.IsValid)
{
if (RestaurantImg != null && RestaurantImg.ContentLength > 0)
{
//先在messageCode建立一個流水號
tMessageCode newCode = new tMessageCode();
db.tMessageCode.Add(newCode);
db.SaveChanges();
restaurant.fMC_ID = db.tMessageCode.ToList().Last().fMC_ID;
//將上傳的圖轉成二進位
var imgSize = RestaurantImg.ContentLength;
byte[] imgByte = new byte[imgSize];
RestaurantImg.InputStream.Read(imgByte, 0, imgSize);
restaurant.fRe_Image = imgByte;
//將tRe_site地址轉座標
var requestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}", Uri.EscapeDataString(restaurant.fRe_Addr));
var request = WebRequest.Create(requestUri);
var response = request.GetResponse();
var xdoc = XDocument.Load(response.GetResponseStream());
var result = xdoc.Element("GeocodeResponse").Element("result");
var locationElement = result.Element("geometry").Element("location");
var lat = locationElement.Element("lat");
var lng = locationElement.Element("lng");
double latitude = Double.Parse(lat.Value);
double lngitude = Double.Parse(lng.Value);
restaurant.fRe_site = String.Format("{0},{1}", Convert.ToString(latitude), Convert.ToString(lngitude));
//後來要看使用者是誰 先給EPID預設值2
restaurant.fEp_ID = fEp_ID;
if (rd1 == "Yes")
{
restaurant.fRe_Delivery = true;
}
else
{
restaurant.fRe_Delivery = false;
}
db.tRestaurant.Add(restaurant);
db.SaveChanges();
//meal篩選
tMealClass newMealC = new tMealClass();
int RestaurantLastID = db.tRestaurant.AsEnumerable().Last().fRe_ID;
foreach (string mealidnum in chkfoodclass)
{
newMealC.fML_ID = Convert.ToInt32(mealidnum);
newMealC.fRe_ID = RestaurantLastID;
db.tMealClass.Add(newMealC);
db.SaveChanges();
}
return(RedirectToAction("Index", "FoodHome"));
}
else
{
ViewBag.message = "請選擇圖檔!!";
}
}
ViewBag.datas = db.tRestaurant.ToList();
return(RedirectToAction("Index", "FoodHome"));
}
