//下单
//更新订单状态
//PutTravelDiary 发布旅行日志
public static void saveOrder(order order)
{
using (var ctx = new hackthonEntities())
{
ctx.AddToorders(order);
ctx.SaveChanges();
}
}
//PutTravelDiary 删除旅行日志
public static void DeleteTraveDiary(int diaryID)
{
using (var ctx = new hackthonEntities())
{
var diary = from c in ctx.diaries where c.diaryID== diaryID select c ;
ctx.DeleteObject(diary);
ctx.SaveChanges();
}
}
//updateTravelDiary 更新旅行日志状态，已下单/已付款/已返积分/退款
public static void updateOrderStatusAs(int orderID,string orderStatus)
{
using (var ctx = new hackthonEntities())
{
order order = selectOrderInfoById(orderID);
ctx.orders.Attach(order);
order.status = orderStatus;
ctx.SaveChanges();
}
}
//用户注册 -- UserRegist
//todo: 同名的username可以添加
public static int saveUser(user u)
{
using (var ctx = new hackthonEntities())
{
if (u.credits == null) u.credits = 0; //虽然db中默认值为0，但是添加新行还是为空；
ctx.AddTousers(u);
ctx.SaveChanges();
return u.userID;
}
}
//PutTravelDiary 发布旅行日志
public static int saveDiary(diary diary)
{
using (var ctx = new hackthonEntities())
{
ctx.AddTodiaries(diary);
ctx.SaveChanges();
return diary.diaryID;
}
}
//付款成功添加100积分
//updateCredits(userID, price) ; 价格的1/10的积分，比如10000就给1000积分，相当于10块，（1/1000）
public static void updateCredits(int userID, decimal credits)
{
using (var ctx = new hackthonEntities())
{
user user = selectUserInfoById(userID);
ctx.users.Attach(user);
user.credits += credits;
ctx.SaveChanges();
}
}
//updateTravelDiary 更新旅行日志
public static void updateDiary(int diaryID, diary updateddiary)
{
using (var ctx = new hackthonEntities())
{
diary diary = getDiaryByDiaryID(diaryID);
ctx.diaries.Attach(diary);
if(diary.title !=updateddiary.title) diary.title =updateddiary.title;
//todo: 写其他的
ctx.SaveChanges();
}
}
