public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
// поиск пользователя в бд
TBuyer user = null;
using (ToyStoreAccessContext db = new ToyStoreAccessContext())
{
user = db.TBuyers.FirstOrDefault(u => u.Firstname == model.Name && u.Password == model.Password);
if (user != null)
{
HttpContext.Response.Cookies["idBuyer"].Value = user.idBuyer.ToString();
}
HttpContext.Response.Cookies["idBuyer"].Expires = DateTime.Now.AddYears(1);
}
if (user != null)
{
FormsAuthentication.SetAuthCookie(model.Name, true);
return(Redirect("/Home/index"));
}
else
{
ModelState.AddModelError("", "Пользователя с таким логином и паролем нет");
}
}
return(View(model));
}
/// <summary>
/// 载入道具返回
/// </summary>
/// <param name="dbi"></param>
private void loadBack(DbAccessItem dbi)
{
if (dbi.Result.ErrCode != 0)
{
SvLogger.Error("DB Access Fail : Op=Load Buyer, ErrMsg={0}, Data={1}.", dbi.Result.ErrMsg, dbi.SpName);
}
else
{
DataTable dt = dbi.OutDs.Tables[0];
foreach (DataRow dr in dt.Rows)
{
TBuyer t = new TBuyer();
t.id = HTBaseFunc.NullToLong(dr["ID"]);
t.name = HTBaseFunc.NullToStr(dr["Name"]);
t.desc = HTBaseFunc.NullToStr(dr["Desc"]);
t.country = HTBaseFunc.NullToStr(dr["Country"]);
t.address = HTBaseFunc.NullToStr(dr["Addres"]);
t.tel = HTBaseFunc.NullToStr(dr["Tel"]);
t.linkMans = LinkmanStringToList(HTBaseFunc.NullToStr(dr["linkman"]));
Buyer b = new Buyer(t);
m_buyerDic[b.m_Data.id] = b;
}
DataLoadManager.Instance.AddLoadSuccTableCount();
}
OnLoadDataFromDBFinish(dbi.Result.ErrCode == 0);
}
public ActionResult DeleteConfirmed(int id)
{
TBuyer tBuyer = db.TBuyers.Find(id);
db.TBuyers.Remove(tBuyer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "idBuyer,Firstname,Email,Password,C_TRole")] TBuyer tBuyer)
{
if (ModelState.IsValid)
{
db.Entry(tBuyer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.C_TRole = new SelectList(db.TRoles, "IdRole", "Name", tBuyer.C_TRole);
return(View(tBuyer));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TBuyer tBuyer = db.TBuyers.Find(id);
if (tBuyer == null)
{
return(HttpNotFound());
}
return(View(tBuyer));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TBuyer tBuyer = db.TBuyers.Find(id);
if (tBuyer == null)
{
return(HttpNotFound());
}
ViewBag.C_TRole = new SelectList(db.TRoles, "IdRole", "Name", tBuyer.C_TRole);
return(View(tBuyer));
}
public override string[] GetRolesForUser(string username)
{
string[] role = new string[] { };
using (ToyStoreAccessContext db = new ToyStoreAccessContext())
{
// Получаем пользователя
TBuyer user = db.TBuyers.FirstOrDefault(u => u.Firstname == username);
if (user != null)
{
// получаем роль
TRole userRole = db.TRoles.Find(user.C_TRole);
if (userRole != null)
{
role = new string[] { userRole.Name }
}
;
}
}
return(role);
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
TBuyer user = null;
using (ToyStoreAccessContext db = new ToyStoreAccessContext())
{
user = db.TBuyers.FirstOrDefault(u => u.Firstname == model.Name);
}
if (user == null)
{
// создаем нового пользователя
using (ToyStoreAccessContext db = new ToyStoreAccessContext())
{
db.TBuyers.Add(new TBuyer {
Firstname = model.Name, Password = model.Password, Email = model.Email, C_TRole = 4
});
db.SaveChanges();
user = db.TBuyers.Where(u => u.Firstname == model.Name && u.Password == model.Password).FirstOrDefault();
}
// если пользователь удачно добавлен в бд
if (user != null)
{
FormsAuthentication.SetAuthCookie(model.Name, true);
HttpContext.Response.Cookies["idBuyer"].Value = user.idBuyer.ToString();
HttpContext.Response.Cookies["idBuyer"].Expires = DateTime.Now.AddYears(1);
return(Redirect("/Home/index"));
}
}
else
{
ModelState.AddModelError("", "Пользователь с таким логином уже существует");
}
}
return(View(model));
}
public override bool IsUserInRole(string username, string roleName)
{
bool outputResult = false;
// Находим пользователя
using (ToyStoreAccessContext db = new ToyStoreAccessContext())
{
// Получаем пользователя
TBuyer user = db.TBuyers.FirstOrDefault(u => u.Firstname == username);
if (user != null)
{
// получаем роль
TRole userRole = db.TRoles.Find(user.C_TRole);
//сравниваем
if (userRole != null && userRole.Name == roleName)
{
outputResult = true;
}
}
}
return(outputResult);
}
