public ActionResult BackEditTheRoomDetail(CImage r) { Room room = dbSA.Room.Where(t => t.ID == r.roomID).FirstOrDefault(); if (room != null) { int index = r.mypic.FileName.IndexOf("."); string extention = r.mypic.FileName.Substring(index, r.mypic.FileName.Length - index); string photoName = Guid.NewGuid().ToString() + extention; r.entity_room = room; r.entity_room.Picture.FirstOrDefault().RoomStylePicture = "/Content/" + photoName; r.mypic.SaveAs(Server.MapPath("/Content/") + photoName); room.RoomName = r.roomname; room.RoomType = r.roomtype; //room.BuildCase.BuildCaseName = r.BuildCase.BuildCaseName; room.Description = r.description; room.SquareFootage = r.squarefootage; room.Rent = r.rent; Picture picture = new Picture(); picture.RoomStylePicture = r.entity_room.Picture.FirstOrDefault().RoomStylePicture; picture.RoomID = r.roomID; dbSA.SaveChanges(); } return(RedirectToAction("BackRoomManage")); }
public ActionResult Edit(Information p_info) { try { SingleApartmentEntities db = new SingleApartmentEntities(); Information info = db.Information.FirstOrDefault(p => p.InformationID == p_info.InformationID); if (info != null) { //挑選了 "請選擇"項目 if (p_info.MemberCategoryID == 999) { info.MemberCategoryID = null; } else { info.MemberCategoryID = p_info.MemberCategoryID; } //優先等級 info.Priority = p_info.Priority; db.SaveChanges(); } return(RedirectToAction("List")); } catch { return(RedirectToAction("List")); } }
public ActionResult CategoryEdit(MemberInformationCategory p_info) { //TODO: FormCollection collection==>不要用 try { //todo: //int memberID = 1; //todo: CMember member = Session[CDictionary.welcome] as CMember; int memberID = member.fMemberId; //(int)Session["MemberID"]; SingleApartmentEntities db = new SingleApartmentEntities(); MemberInformationCategory info = db.MemberInformationCategory.FirstOrDefault(p => p.MemberCategoryID == p_info.MemberCategoryID && p.MemberID == memberID); if (info != null) { info.MemberCategoryName = p_info.MemberCategoryName; db.SaveChanges(); } return(RedirectToAction("UserCategoryList")); } catch { //return View(); return(RedirectToAction("UserCategoryList")); } }
public ActionResult Register(CMember input)//此處更新 { if (ModelState.IsValid == false) { return(View()); } var member = db.tMember.Where(p => p.fMemberId == input.fMemberId).FirstOrDefault(); if (member == null) { int index = input.myImage.FileName.IndexOf("."); string extention = input.myImage.FileName.Substring(index, input.myImage.FileName.Length - index); string photoName = Guid.NewGuid().ToString() + extention; input.fImage = "../Content/" + photoName; input.myImage.SaveAs(Server.MapPath("../Content/") + photoName); //此處新增--------------------------- tMember t = new tMember(); t.fMemberId = input.fMemberId; t.fMemberName = input.fMemberName; t.fAccount = input.fAccount; t.fPassword = input.fPassword; t.fEmail = input.fEmail; t.fRoomId = input.fRoomId; t.fPhone = input.fPhone; t.fAge = input.fAge; t.fSex = input.fSex; t.fBirthDate = input.fBirthDate; t.fSalary = input.fSalary; t.fCareer = input.fCareer; t.fImage = input.fImage; t.fLeave = input.fLeave; t.fRole = input.fRole; //---------------------------------- db.tMember.Add(t); db.SaveChanges(); return(RedirectToAction("LogIn")); } ViewBag.Message = "此帳號已有人使用,請輸入新的帳號"; return(View()); }
public void update_read_yn(int id) { SingleApartmentEntities db = new SingleApartmentEntities(); Information information = db.Information.FirstOrDefault(p => p.InformationID == id); if (information != null) { information.Read_YN = "Y"; db.SaveChanges(); } }
public ActionResult DeleteRoomFavorite(int id) { var user = Session[CDictionary.welcome] as CMember; if (user == null) { return(RedirectToAction("Login", "Member")); } int memberID = user.fMemberId; RoomFavorite roomfa = dbSA.RoomFavorite.FirstOrDefault(r => r.RoomID == id); if (roomfa != null) { dbSA.RoomFavorite.Remove(roomfa); dbSA.SaveChanges(); } return(RedirectToAction("RoomFavoritelist")); }
public ActionResult CreatAllProduct(HttpPostedFileBase imgPhoto, Product p, string SUBNAME) { /*新增照片*/ SingleApartmentEntities db = new SingleApartmentEntities(); //====================================================== imgPhoto.SaveAs("c:\\temp\\111.jpg"); FileStream fs = new FileStream("c:\\temp\\111.jpg", FileMode.Open, FileAccess.Read); int length = (int)fs.Length; byte[] image = new byte[length]; fs.Read(image, 0, length); fs.Close(); //===================================================== //下拉式選單抓id int SUBID = (from S in db.ProductSubCategory where S.ProductSubCategoryName == SUBNAME select S.ProductSubCategoryID).FirstOrDefault(); var PROID = (from P in db.Product where P.ProductSubCategoryID == SUBID select P.ProductSubCategoryID).FirstOrDefault(); p.Discontinued = "N"; p.ProductSubCategoryID = PROID; db.Product.Add(p); //----------------------- ProductPictures prodpic = new ProductPictures(); prodpic.ProductID = p.ProductID; //prodpic.ProductPictureID = 2; prodpic.ProductPicture = image; db.ProductPictures.Add(prodpic); db.SaveChanges(); //====================================================== return(RedirectToAction("Home", "Product")); }
//產生訂單 public ActionResult MakeOrderIntoDB(int RtnCode, string RtnMsg, string CustomField1, string CustomField2) { SingleApartmentEntities db = new SingleApartmentEntities(); string cusID = CustomField1; string OrderID = CustomField2; db.Order.Where(r => r.OrderID.ToString() == OrderID).FirstOrDefault().PayStatus = "付款完成"; db.Order.Where(r => r.OrderID.ToString() == OrderID).FirstOrDefault().SendingStatus = "出貨中"; db.Order.Where(r => r.OrderID.ToString() == OrderID).FirstOrDefault().ArrivedDate = DateTime.Now.AddDays(7); db.SaveChanges(); return(RedirectToAction("OrderList")); }
// GET: Delete public ActionResult Deleteacdb(int id) { SingleApartmentEntities db = new SingleApartmentEntities(); Activity table = db.Activity.FirstOrDefault(p => p.ActivityID == id); if (table != null) { db.Activity.Remove(table); db.SaveChanges(); } return(RedirectToAction("List")); }
public ActionResult DeleteFavorite(string MemberID, string ProductID) { SingleApartmentEntities db = new SingleApartmentEntities(); var fa = db.FavoriteList.Where(r => r.MemberID.ToString() == MemberID && r.ProductID.ToString() == ProductID).FirstOrDefault(); if (fa != null) { db.FavoriteList.Remove(fa); db.SaveChanges(); } return(RedirectToAction("Favoritelist", new { MemberID = int.Parse(MemberID) })); }
public void update_status(int id) { SingleApartmentEntities db = new SingleApartmentEntities(); Information information = db.Information.FirstOrDefault(p => p.InformationID == id); if (information != null) { information.Status = "User_Deleted"; db.SaveChanges(); } //return RedirectToAction("List"); }
//===================================================================== ////刪除 public ActionResult Delete(int id) { SingleApartmentEntities db = new SingleApartmentEntities(); Product prod = db.Product.FirstOrDefault(p => p.ProductID == id); if (prod != null) { db.Product.Remove(prod); db.SaveChanges(); } return(RedirectToAction("ProductList")); }
public ActionResult ShowProductInCart(int MemberID)//第四步 { int totalPrice = 0; SingleApartmentEntities DB = new SingleApartmentEntities(); List <COrderDetailsViewModel> list = Session[CDictionary.PRODUCTS_IN_CART] as List <COrderDetailsViewModel>; Order od = new Order(); //抓出多筆資料 foreach (var item in list) { OrderDetails ODD = new OrderDetails(); ODD.ProductName = DB.Product.Where(p => p.ProductID == item.ProductID).FirstOrDefault().ProductName; ODD.Quantity = item.Quantity; ODD.ProductID = item.ProductID; ODD.UnitPrice = DB.Product.Where(p => p.ProductID == item.ProductID).FirstOrDefault().UnitPrice; totalPrice += item.Quantity * (DB.Product.Where(p => p.ProductID == item.ProductID).FirstOrDefault().UnitPrice); od.OrderDetails.Add(ODD); } //訂單日期 od.OrderDate = DateTime.Now; //到貨日期 od.ArrivedDate = DateTime.Now.AddDays(7); //總金額 od.TotalAmount = totalPrice; od.OrderStatusID = 1; od.SendingStatus = "配送中"; od.PayStatus = "尚未付款"; od.MemberID = MemberID;//到時候要改成使用者的memberID DB.Order.Add(od); DB.SaveChanges(); return(RedirectToAction("Home")); }
public string GoLogin(string returnUrl) { google ms = JsonConvert.DeserializeObject <google>(returnUrl); var member = db.tMember.Where(x => x.fEmail == ms.du).FirstOrDefault(); if (member == null) { tMember t = new tMember(); t.fEmail = ms.du; t.fMemberName = ms.Ad; t.fAccount = ms.du; t.fPassword = ms.OT; db.tMember.Add(t); db.SaveChanges(); member = db.tMember.Where(x => x.fEmail == ms.du).FirstOrDefault(); } CMember c = new CMember(); c.fMemberId = member.fMemberId; c.fMemberName = member.fMemberName; c.fAccount = member.fAccount; c.fPassword = member.fPassword; c.fEmail = member.fEmail; c.fRoomId = member.fRoomId; c.fPhone = member.fPhone; c.fAge = member.fAge; c.fSex = member.fSex; c.fBirthDate = member.fBirthDate; c.fSalary = member.fSalary; c.fCareer = member.fCareer; c.fImage = member.fImage; c.fLeave = member.fLeave; c.fRole = member.fRole; Session[CDictionary.welcome] = c; return("驗證成功"); }
public ActionResult InfoCategoryCreate(InformationCategory p_info) { try { SingleApartmentEntities db = new SingleApartmentEntities(); db.InformationCategory.Add(p_info); db.SaveChanges(); return(RedirectToAction("InfoCategoryList")); } catch { return(RedirectToAction("InfoCategoryList")); } }
public ActionResult JobCreate(JobService p_job) { try { SingleApartmentEntities db = new SingleApartmentEntities(); db.JobService.Add(p_job); db.SaveChanges(); return(RedirectToAction("JobList")); } catch { return(RedirectToAction("JobList")); } }
public ActionResult Edit(HttpPostedFileBase imgPhoto, Product p) { SingleApartmentEntities db = new SingleApartmentEntities(); //====================================================== imgPhoto.SaveAs("c:\\temp\\111.jpg"); FileStream fs = new FileStream("c:\\temp\\111.jpg", FileMode.Open, FileAccess.Read); int length = (int)fs.Length; byte[] image = new byte[length]; fs.Read(image, 0, length); fs.Close(); //===================================================== Product prod = db.Product.FirstOrDefault(q => q.ProductID == p.ProductID); if (prod != null) { prod.ProductName = p.ProductName; prod.UnitPrice = p.UnitPrice; prod.Stock = p.Stock; prod.Sales = p.Sales; prod.ProductID = p.ProductID; prod.ProductSubCategoryID = p.ProductSubCategoryID; prod.Discontinued = p.Discontinued; prod.ProductPictures.FirstOrDefault().ProductPicture = image; db.SaveChanges(); } //----------------------- return(RedirectToAction("ProductList")); }
//return RedirectToAction("List"); public void update_status(int id) { try { SingleApartmentEntities db = new SingleApartmentEntities(); Information information = db.Information.FirstOrDefault(p => p.InformationID == id); if (information != null) { information.Status = "User_Deleted"; db.SaveChanges(); } } catch { } }
// GET public ActionResult InfoCategoryDelete(int id) { try { SingleApartmentEntities db = new SingleApartmentEntities(); InformationCategory info = db.InformationCategory.FirstOrDefault(p => p.InformationCategoryID == id); if (info != null) { db.InformationCategory.Remove(info); db.SaveChanges(); } return(RedirectToAction("InfoCategoryList")); } catch { return(RedirectToAction("InfoCategoryList")); } }
// GET public ActionResult JobDelete(int id) { try { SingleApartmentEntities db = new SingleApartmentEntities(); JobService info = db.JobService.FirstOrDefault(p => p.JobID == id); if (info != null) { db.JobService.Remove(info); db.SaveChanges(); } return(RedirectToAction("JobList")); } catch { return(RedirectToAction("JobList")); } }
public ActionResult Edit(Activity tb) { SingleApartmentEntities db = new SingleApartmentEntities(); Activity table = db.Activity.FirstOrDefault(p => p.ActivityID == tb.ActivityID); if (table != null) { table.ActivityName = tb.ActivityName; table.StartTime = tb.StartTime; table.EndTime = tb.EndTime; table.MeetingPoint = tb.MeetingPoint; table.PeopleCount = tb.PeopleCount; table.Note = tb.Note; db.SaveChanges(); } return(RedirectToAction("List")); }
// GET public ActionResult CategoryDelete(int member_id, int category_id) { try { SingleApartmentEntities db = new SingleApartmentEntities(); MemberInformationCategory info = db.MemberInformationCategory.FirstOrDefault(p => p.MemberCategoryID == category_id && p.MemberID == member_id); if (info != null) { db.MemberInformationCategory.Remove(info); db.SaveChanges(); } return(RedirectToAction("UserCategoryList")); } catch { return(RedirectToAction("UserCategoryList")); } }
//將session資料加進DB 12/4 public ActionResult AddToDB(int id) { SingleApartmentEntities db = new SingleApartmentEntities(); CMember member = Session[CDictionary.welcome] as CMember; if (member == null) { return(RedirectToAction("Login", "Member")); } int memberID = member.fMemberId; //CActivityCart t = new CActivityCart(); //tActivityCart cart = new tActivityCart(); //if (list != null) //{ Participant p = new Participant(); p.ActivityID = id; p.MemberID = memberID; db.Participant.Add(p); db.SaveChanges(); List <CActivityCart> list = Session[CDictionary.Cart_Key] as List <CActivityCart>; foreach (var a in list) { if (a.fJoinedId == id) { list.Remove(a); break; } } //list = new List<CActivityCart>(); Session[CDictionary.Cart_Key] = list; //} //list.Remove(list); return(RedirectToAction("CartView")); }
public ActionResult InfoCategoryEdit(InformationCategory p_info) { //TODO: FormCollection collection==>不要用 try { SingleApartmentEntities db = new SingleApartmentEntities(); InformationCategory info = db.InformationCategory.FirstOrDefault(p => p.InformationCategoryID == p_info.InformationCategoryID); if (info != null) { //info.InformationSource = p_info.InformationSource; info.InformationCategoryName = p_info.InformationCategoryName; db.SaveChanges(); } return(RedirectToAction("InfoCategoryList")); } catch { //return View(); return(RedirectToAction("InfoCategoryList")); } }
public ActionResult Create(Activity ac, string subName) { SingleApartmentEntities entity = new SingleApartmentEntities(); int sub = 0; var subID = from SUBID in entity.ActivitySubCategory where SUBID.ActivitySubCategoryName == subName select SUBID.ActivitySubCategoryID; foreach (var g in subID) { sub = g; } if (subName != null) { ac.SubCategoryDetailID = sub; } entity.Activity.Add(ac); entity.SaveChanges(); return(RedirectToAction("List")); }
public JsonResult AddToFavorite(string MemberID, string ProductID) { SingleApartmentEntities db = new SingleApartmentEntities(); var fa = db.FavoriteList.Where(r => r.MemberID.ToString() == MemberID && r.ProductID.ToString() == ProductID); if (fa.Count() == 0) { FavoriteList fv = new FavoriteList() { MemberID = int.Parse(MemberID), ProductID = int.Parse(ProductID) }; db.FavoriteList.Add(fv); db.SaveChanges(); var json = JsonConvert.SerializeObject(new { ans = "已成功加入我的最愛" }); return(Json(json)); } else { return(Json(JsonConvert.SerializeObject(new { ans = "我的最愛裡已有此件商品" }))); } }
public JsonResult ActivityMessageCreate(Message p_ms) { try { SingleApartmentEntities db = new SingleApartmentEntities(); p_ms.MessageDate = DateTime.Now; db.Message.Add(p_ms); db.SaveChanges(); return(new JsonResult { Data = new { status = true } }); } catch { return(new JsonResult { Data = new { status = false } }); } }
public ActionResult subActivity(int id) { SingleApartmentEntities entity = new SingleApartmentEntities(); CMember member = Session[CDictionary.welcome] as CMember; if (member == null) { return(RedirectToAction("Login", "Member")); } int memberID = member.fMemberId; SubActivity subActivity = new SubActivity(); subActivity.ActivityID = id; subActivity.MemberID = memberID; entity.SubActivity.Add(subActivity); entity.SaveChanges(); return(RedirectToAction("List")); }
public ActionResult CategoryCreate(MemberInformationCategory p_info) { try { SingleApartmentEntities db = new SingleApartmentEntities(); //int memberID = 1; //todo: CMember member = Session[CDictionary.welcome] as CMember; int memberID = member.fMemberId; //(int)Session["MemberID"]; p_info.MemberID = memberID; db.MemberInformationCategory.Add(p_info); db.SaveChanges(); return(RedirectToAction("UserCategoryList")); } catch { return(RedirectToAction("UserCategoryList")); } }
//no use public void CategoryEdit_JS(int category_id, string category_name) //MemberInformationCategory p_info { //TODO: FormCollection collection==>不要用 try { //todo: //int memberID = 1; //todo: CMember member = Session[CDictionary.welcome] as CMember; int memberID = member.fMemberId; //(int)Session["MemberID"]; SingleApartmentEntities db = new SingleApartmentEntities(); MemberInformationCategory info = db.MemberInformationCategory.FirstOrDefault(p => p.MemberCategoryID == category_id && p.MemberID == memberID); if (info != null) { info.MemberCategoryName = category_name; //p_info.MemberCategoryName; db.SaveChanges(); } } catch { //return View(); } }