//点赞、取消赞
//userid为点赞人/取消赞人的ID号
public JsonpResult OptIn(int tid, int userid, int point)
{
try
{
var territory = db.Territories.Find(tid);
//territory.PraiseTimes += point;
if (point == 1)
{
db.Praises.Add(new Praise()
{
TId = tid,
UserId = userid
});
db.SaveChanges();
}
else if (point == -1)
{
var praise = db.Praises.Single(x => x.TId == tid && x.UserId == userid);
db.Praises.Attach(praise);
db.Praises.Remove(praise);
db.SaveChanges();
}
territory.PraiseTimes = db.Praises.Where(x => x.TId == tid).ToList().Count;
db.SaveChanges();
return(this.Jsonp(this.WrapNoKey("OK")));
}
catch
{
return(this.Jsonp(this.WrapNoKey("Error")));
}
}
//用户添加自己要卖的二手商品信息，发布
public JsonpResult AddProduct(int userid, string pdtitle, int pdtype, string pdprice, string pdmsg)
{
try
{
db.Products.Add(new Product()
{
PdTitle = pdtitle,
PdType = (GoodsType)pdtype,
PdPrice = decimal.Parse(pdprice),
PdMsg = pdmsg,
LaunchTime = DateTime.Now.ToString(),
IsOnShelves = true
});
db.SaveChanges();
//找到最后一个product的id号，填入关联表/
var pdid = db.Products.AsEnumerable().Last().Id;
db.UserProducts.Add(new UserProduct()
{
UserId = userid,
PdId = pdid
});
db.SaveChanges();
return(this.Jsonp(this.WrapNoKey(pdid)));
}
catch
{
return(this.Jsonp(this.WrapNoKey("add product failed")));
}
}
public ActionResult Create([Bind(Include = "Id,StudentId,StudentClass,StudentName")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public JsonpResult Register(string username, string pswd, string userno, string tel, string sign, string usericon)
{
var judge = db.Students.Where(x => x.StudentId == userno && x.StudentName == username);
var isUReg = db.Users.Where(x => x.UserNo == userno);
////判断学生表中是否有相应学生：必须保证姓名和学号信息与学生表中信息一致
//if (judge == null || judge.Count() < 1)
//{
// return this.Jsonp(this.WrapNoKey("Invalid userno or username"));
//}
//判断当前注册用学号是否已被注册
if (isUReg != null && isUReg.Count() >= 1)
{
return(this.Jsonp(this.WrapNoKey("Registered")));
}
else
{
db.Users.Add(new User()
{
UserName = username,
Pswd = pswd,
UserNo = userno,
Tel = tel,
Sign = sign,
UserIcon = usericon,
Sex = (Gender)1
});
db.SaveChanges();
var user = _userService.GetUserByUserNo(userno);
return(this.Jsonp(this.WrapNoKey(user.Id)));
}
}
//收藏商品
public JsonpResult CollectProduct(int userid, int pdid)
{
var judge = db.ProductWishlists.Where(x => x.UserId == userid && x.PdId == pdid);
if (judge == null || judge.Count() < 1)
{
db.ProductWishlists.Add(new ProductWishlist()
{
UserId = userid,
PdId = pdid
});
db.SaveChanges();
return(this.Jsonp(this.WrapNoKey("OK")));//要不要返回id之类的信息？
}
else
{
return(this.Jsonp(this.WrapNoKey("Collected")));
}
}
//添加地盘里的新纪录
public JsonpResult AddTerritory(int userid, string site, string remark)
{
try
{
db.Territories.Add(new Territory()
{
UserId = userid,
Site = site,
Remark = remark,
Time = DateTime.Now.ToString("yyyy/MM/dd")
});
db.SaveChanges();
var tid = db.Territories.AsEnumerable().Last().Id;
return(this.Jsonp(this.WrapNoKey(tid)));
}
catch
{
return(this.Jsonp(this.WrapNoKey("add territory fail")));
}
}
public void Test(string base64)
{
int id = 9;
byte[] bytes = Convert.FromBase64String(base64);
MemoryStream memStream = new MemoryStream(bytes);
Bitmap bmp = new Bitmap(memStream);
string date = DateTime.Now.ToString("yyyyMMdd");
string uppath = Server.MapPath("~/Image/") + date + "\\";
//如果不存在，就新建文件夹
if (Directory.Exists(uppath) == false)
{
Directory.CreateDirectory(uppath);
}
//普通二手商品
var product = db.Products.Find(id);
//图片命名
string image = DateTime.Now.ToString("yyyyMMddhhmmss") + "_" + id + product.PdType + ".jpg";
//图片存储路径
string path = uppath + image;
bmp.Save(path, System.Drawing.Imaging.ImageFormat.Jpeg);
string ipv4 = "";
System.Net.IPAddress[] addressList = Dns.GetHostEntry(Dns.GetHostName()).AddressList;
foreach (IPAddress ip in addressList)
{
if (ip.AddressFamily == AddressFamily.InterNetwork)
{
ipv4 = ip.ToString();
}
}
//URL获取图片时用的绝对路径，存储在数据库中
string savepath = ipv4 + "/Image/" + date + "/" + image;
product.PdImage = savepath;
db.SaveChanges();
memStream.Close();
}
//duration:持续时间(单位：天)
public JsonpResult AddAuction(int userid, string auctitle, int auctype,
int isnew, decimal startingprice, decimal range, string aucmsg, int duration)
{
bool NewOrOld;
if (isnew == 0)
{
NewOrOld = false; //非新
}
else
{
NewOrOld = true; //全新
}
try
{
db.Auctions.Add(new Auction()
{
AucTitle = auctitle,
AucType = (GoodsType)auctype,
IsNew = NewOrOld,
StartingPrice = startingprice,
PriceIncreaseRange = range,
AucMsg = aucmsg,
StartTime = DateTime.Now,
EndTime = DateTime.Now.AddDays(duration).ToString("yyyy/MM/dd HH:mm:ss"),
NewPrice = startingprice,
IsOnShelves = true
});
db.SaveChanges();
var aucid = db.Auctions.AsEnumerable().Last().Id;
db.UserAuctions.Add(new UserAuction()
{
UserId = userid,
AucId = aucid
});
db.SaveChanges();
return(this.Jsonp(this.WrapNoKey(aucid)));
}
catch
{
return(this.Jsonp(this.WrapNoKey("add auction failed")));
}
}
//买家加价
//拍卖品表中最新价格、买家id更新
//拍卖品被自动添加到买家收藏夹中
public JsonpResult AddPrice(int buyerid, int aucid, decimal newprice)
{
var sailerid = db.UserAuctions.Single(x => x.AucId == aucid).UserId;
if (buyerid == sailerid)
{
return(this.Jsonp(this.WrapNoKey("cannot buy own auction")));
}
var auction = db.Auctions.Find(aucid);
//判断买家加的价格是否大于拍卖品表中的newprice，若低于，说明有信息延时，提示买家重新加价
if (newprice < auction.NewPrice)
{
return(this.Jsonp(this.WrapNoKey("newprice is lower")));
}
else
{
auction.NewPrice = newprice;
auction.Buyerid = buyerid;
db.SaveChanges();
}
var isAuctionExist = db.AuctionWishlists.Where(x => x.UserId == buyerid && x.AucId == aucid);
if (isAuctionExist == null || isAuctionExist.Count() < 1)
{
db.AuctionWishlists.Add(new AuctionWishlist()
{
UserId = buyerid,
AucId = aucid,
NewAucPrice = newprice
});
db.SaveChanges();
}
else
{
db.AuctionWishlists.Single(x => x.UserId == buyerid && x.AucId == aucid).NewAucPrice = newprice;
db.SaveChanges();
}
return(this.Jsonp(this.WrapNoKey("OK")));
}
