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