public string GetUserName(string id)
{
TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities();
var query = from c in db.AspNetUsers
where c.Id == id
select new { c.UserName };
return(query.FirstOrDefault().UserName);
}
public ActionResult GetUserNote()
{
string id = HttpContext.User.Identity.GetUserId();
TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities();
var query = from c in db.note.AsEnumerable()
where c.mid == id
select new { c.n_id, c.p_name, c.p_id, c.create_time, c.n_title, c.n_grade, c.mid, videotime = ChangeTime(Convert.ToInt32(c.videotime)), c.n_content };
return(Json(new { data = query.ToList() }, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(OrderViewModel orderView)
{
if (ModelState.IsValid)
{
var userId = HttpContext.User.Identity.GetUserId();
var currentCart = Models.Cart.Operation.GetCurrentCart();
List <CartItem> items = currentCart.GetCartItems();
Decimal totalPrice;
totalPrice = currentCart.TotalAmount;
//0 現金
//1 信用卡
PaymentEntity pe = new PaymentEntity();
int payId;
payId = pe.Insert(orderView, userId, totalPrice, 1);
BuyItemDetailEntify be = new BuyItemDetailEntify();
Boolean isInserted;
isInserted = be.Insert(items, userId, payId);
TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities();
foreach (var item in items)
{
db.producttbl.Find(item.Id).state += 1;
}
db.SaveChanges();
//移除購物車Session資料
HttpContext.Session.Remove("Cart");
//轉至訂單完成頁面
return(RedirectToAction("FinishOrdered"));
//string msg;
//msg=PrintOrderViewContent(orderView);
//return Content(msg);
}
// todo error page
return(Content("Error!"));
//return View();
}
//[ValidateAntiForgeryToken]
public ActionResult SendMsg(string id)
{
string[] msg = id.Split('/');
discuss model = new discuss();
model.p_id = Convert.ToInt32(msg[0]);
model.d_content = msg[1];
var ID = HttpContext.User.Identity.GetUserId();
if (ID == null)
{
return(RedirectToAction("Login", "Account"));
}
int pid = Convert.ToInt32(model.p_id);
TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities();
model.Id = ID;
// model.d_crateDate =Convert.ToString( DateTime.Now.ToLocalTime());
model.d_crateDate = DateTime.Now.ToShortDateString();
db.discuss.Add(model);
db.SaveChanges();
//var query = from c in db.producttbl.AsEnumerable()
// where c.pid ==pid
// select new TabkeFiveWebApplication.Models.ViewModels.ProductViewModels
// {
// PId = c.pid,
// SelectedKinds =Convert.ToInt32( c.kind),
// SelectedCategories = Convert.ToInt32(c.category),
// MId = c.mid,
// Intro = c.intro,
// Price = Convert.ToInt32 (c.price),
// State = Convert.ToInt32(c.state),
// Score = Convert.ToInt32(c.score)
// };
//return RedirectToAction("View", "ShoppingCart", new { id = pid });
//var query = from c in db.discuss
// where c.p_id == model.p_id
// select c;
//return PartialView("_Discuss",query);
return(Content(msg[0]));
}
public ActionResult GetNoteByID(int nid)
{
TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities();
var query = from c in db.note
where c.n_id == nid
select c;
string userid = HttpContext.User.Identity.GetUserId();
if (query.Count() > 0)
{
ViewBag.edit = query.First().mid == userid ? true:false;
return(PartialView("_NoteBook", query));
}
else
{
return(HttpNotFound());
}
}
public IEnumerable <DiscussViewModel> Msg(int id)
{
TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities();
var query = from c in db.discuss
where c.p_id == id
orderby c.d_crateDate descending
select new DiscussViewModel
{
DId = c.d_id,
PId = c.p_id,
MId = c.Id,
DContent = c.d_content,
DCrateDate = c.d_crateDate,
DGreat = c.d_great,
DModifyDate = c.d_modifyDate
};
return(query);
}
public ActionResult Index(int id)
{
TFDBLibrary.TakeFiveDBEntities db = new TFDBLibrary.TakeFiveDBEntities();
var query = from c in db.discuss
where c.p_id == id
orderby c.d_id descending
select new DiscussViewModel {
DId = c.d_id, PId = c.p_id, MId = c.Id,
DContent = c.d_content, DCrateDate = c.d_crateDate,
DGreat = c.d_great, DModifyDate = c.d_modifyDate
};
if (query.Count() > 0)
{
return(PartialView("_Discuss", query));
}
else
{
DiscussViewModel non = new DiscussViewModel();
non.PId = id;
return(PartialView("_NonDiscuss", non));
}
}
