public ActionResult GetUsersByJason()
{
UsersInfoDal dal = new UsersInfoDal();
List <UserInfo> objUSers = dal.usersInfo.ToList <UserInfo>();
return(Json(objUSers, JsonRequestBehavior.AllowGet));
}
public ActionResult SellingPets(User user, String id)
{
PetsDal dal = new PetsDal();
UsersInfoDal ufDal = new UsersInfoDal();
ShoppingCartDal scDal = new ShoppingCartDal();
ShoppingCart sc = new ShoppingCart();
if (user.UserName == null)
{
TempData["PetsError"] = "Sorry, You must login to buy pets!";
return(View("BuyPet", user));
}
if (id == "")
{
TempData["PetsError"] = "Sorry, You must enter value!";
return(View("BuyPet", user));
}
if (dal.pets.Find(id) != null)
{
if (dal.pets.Find(id).Availability == 1)
{
//Initializing the shopping cart object
sc.petType = dal.pets.Find(id).petType;
sc.petName = dal.pets.Find(id).petName;
sc.petID = dal.pets.Find(id).petID;
sc.customer = user.UserName;
//Add the object to the shopping cart sql table
scDal.shoppingCart.Add(sc);
scDal.SaveChanges();
dal.pets.Find(id).Availability = 0;
dal.pets.Remove(dal.pets.Find(id));
dal.SaveChanges();
ufDal.usersInfo.Find(user.UserName).PurchasedPet++;
ufDal.SaveChanges();
return(View("~/Views/Home/Index.cshtml", user));
}
else
{
TempData["PetsError"] = "Sorry, this Pets is not Availabile! Try else pets.";
return(View("BuyPet", user));
}
}
else
{
TempData["PetsError"] = "The entered ID is not exist!";
return(View("BuyPet", user));
}
}
public ActionResult Submit()
{
UserInfo uf = new UserInfo()
{
UserName = Request.Form["userInfo.UserName"].ToString(),
Password = Request.Form["userInfo.Password"].ToString(),
FirstName = Request.Form["userInfo.FirstName"].ToString(),
LastName = Request.Form["userInfo.LastName"].ToString(),
LovedPet = Request.Form["userInfo.LovedPet"].ToString()
};
//
User objUser = new User()
{
UserName = uf.UserName,
Password = uf.Password
};
UsersInfoDal UIDal = new UsersInfoDal();
UserDal dal = new UserDal();
if (ModelState.IsValid)
{
if (dal.Users.Find(objUser.UserName) != null)
{
TempData["Eror"] = "there is already user with this name";
return(View("Register", uf));
}
else
{
dal.Users.Add(objUser);
dal.SaveChanges();
UIDal.usersInfo.Add(uf);
UIDal.SaveChanges();
return(View("~/Views/Home/Index.cshtml", objUser));
}
}
else
{
TempData["Eror"] = "there value is not valid";
return(View("Register", uf));
}
}
/// <summary>
/// 查询用户信息和业务号
/// </summary>
/// <param name="context"></param>
public void QueryUserInfoAndYwh(HttpContext context)
{
var userInfoDal = new UsersInfoDal();
var groupid = context.Request.Params["groupid"];
//获取分页数据
var total = 0;
var page = int.Parse(context.Request["page"] ?? "1");
var rows = int.Parse(context.Request["rows"] ?? "10");
try
{
var data = userInfoDal.QueryUserInfoAndYwh2(groupid, page, rows, ref total);
var list = from da in data.AsEnumerable()
select new
{
wxid = da.Field<string>("wxid"),
nickname = da.Field<string>("nickname"),
sjh = da.Field<string>("phonenumber"),
// qy = da.Field<string>("qy"),
zw = da.Field<int?>("zw")
};
hashtable["rows"] = list.ToList();
hashtable["total"] = total;
var json = _jss.Serialize(hashtable);
context.Response.Write(json);
}
catch (Exception e)
{
Log.Debug("出错信息：" + e.Message);
}
}
