public void MarkDeleted(long id)
{
var data = GetById(id);
data.IsDeleted = true;
ctx.SaveChanges();
}
//重载了上面的AddUser方法，传进来一个UserDTO的对象，然后对上面的方法进行少量修改
public long AddUser(UserDTO model)
{
User user = new User();
user.Email = model.Email;
user.NickName = model.NickName;
user.PhoneNum = model.PhoneNum;
user.Gender = model.Gender;
user.Account = model.Account;
var salt = commonhelper.CreateVerifyCode(4);
user.PasswordSalt = salt;
string pwdHash = commonhelper.CalcMD5(salt + model.Password);
user.PasswordHash = pwdHash;
var level = checkpassword(model.Password);
user.level = level;
using (Dbcontext ctx = new Dbcontext())
{
BaseService <User> bs = new BaseService <User>(ctx);
bool exists = bs.GetAll().Any(e => e.Account == model.Account);
if (exists)
{
return(-123); //这里要注意以下，上面的原方法中是抛出一个异常，但是如果是发布之后的话，异常是要进行处理掉的，不然会出现黄屏等问题
//我这里就暂时定义了 -123的意思就是存在相同的账号,这个是可以随意修改，但是最好有一定规则
}
ctx.User.Add(user);
ctx.SaveChanges();
}
return(user.Id);
}
public bool UpdateUser(long id, string nickname, string phoneNum, string gender,
string password, string email)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <User> bs
= new BaseService <User>(ctx);
var user = bs.GetById(id);
if (user == null)
{
throw new ArgumentException("找不到id=" + id + "的用户");
}
user.NickName = nickname;
user.PhoneNum = phoneNum;
user.Gender = gender;
user.Email = email;
if (!string.IsNullOrEmpty(password))
{
user.PasswordHash =
commonhelper.CalcMD5(user.PasswordSalt + password);
}
ctx.SaveChanges();
return(true);
}
}
public long AddUser(string account, string nickename, string phoneNum, string gender, string password, string email)
{
User user = new User();
user.Email = email;
user.NickName = nickename;
user.PhoneNum = phoneNum;
user.Gender = gender;
user.Account = account;
var salt = commonhelper.CreateVerifyCode(4);
user.PasswordSalt = salt;
string pwdHash = commonhelper.CalcMD5(salt + password);
user.PasswordHash = pwdHash;
using (Dbcontext ctx = new Dbcontext())
{
BaseService <User> bs = new BaseService <User>(ctx);
bool exists = bs.GetAll().Any(e => e.PhoneNum == phoneNum);
if (exists)
{
throw new ArgumentException("手机号已经存在" + phoneNum);
}
ctx.User.Add(user);
ctx.SaveChanges();
}
return(user.Id);
}
public bool UpdateGuide(long id, string school, string intro)
{
using (Dbcontext ctx = new Dbcontext())
{
try
{
BaseService <Guide> bs
= new BaseService <Guide>(ctx);
BaseService <User> userbs = new BaseService <User>(ctx);
var guide = bs.GetById(id);
var user = userbs.GetById(guide.Users_Id);
if (guide == null)
{
throw new ArgumentException("找不到id=" + id + "的导游");
}
if (user == null)
{
throw new ArgumentException("找不到id=" + guide.Users_Id + "的用户");
}
guide.school = school;
guide.intro = intro;
ctx.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public void changlevel(long level, long gid)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <Guide> bs = new BaseService <Guide>(ctx);
bs.GetById(gid).level = (int)level;
ctx.SaveChanges();
}
}
public void Shenhe(long id)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <Guide> bs = new BaseService <Guide>(ctx);
var data = bs.GetById(id);
data.shenhe = true;
ctx.SaveChanges();
}
}
public void RecoveryDeleted(long id)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <GuideUser> bs = new BaseService <GuideUser>(ctx);
GuideUser gu = bs.GetRecoveries().Where(e => e.GuideId == id).SingleOrDefault();
gu.IsDeleted = false;
ctx.SaveChanges();
}
}
public bool ClickTops(long Uid, long Tid)
{
using (Dbcontext ctx = new Dbcontext())
{
UserTravels ut = new UserTravels();
ut.UId = Uid;
ut.TId = Tid;
ctx.UserTravels.Add(ut);
ctx.SaveChanges();
return(true);
}
}
public long AddGuideUser(long uid, long gid)
{
GuideUser g = new GuideUser();
g.Uid = uid;
g.GuideId = gid;
using (Dbcontext ctx = new Dbcontext())
{
ctx.GuideUser.Add(g);
ctx.SaveChanges();
}
return(g.Id);
}
public void UpdatePermission(long id, string permName, string description)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <Permission> bs = new BaseService <Permission>(ctx);
var perm = bs.GetById(id);
if (perm == null)
{
throw new ArgumentException("id不存在" + id);
}
perm.Name = permName;
perm.Description = description;
ctx.SaveChanges();
}
}
public bool CompleteOrder(long oid)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <Order> bs = new BaseService <Order>(ctx);
var order = bs.GetById(oid);
if (order == null)
{
return(false);
}
order.state = 1;
ctx.SaveChanges();
return(true);
}
}
public long AddGidLid(long gid, long lid)
{
GuidLines GLs = new GuidLines();
GLs.Gid = gid;
GLs.Lid = lid;
using (Dbcontext ctx = new Dbcontext())
{
ctx.GuidLines.Add(GLs);
ctx.SaveChanges();
}
return(GLs.Id);
}
public long AddTravel(string title, string context, long?tops, long Uid)
{
Travels lines = new Travels();
lines.title = title;
lines.content = context;
lines.tops = tops;
lines.Uid = Uid;
using (Dbcontext ctx = new Dbcontext())
{
ctx.Travels.Add(lines);
ctx.SaveChanges();
}
return(lines.Id);
}
public void Update(long roleId, string roleName)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <Role> roleBS = new BaseService <Role>(ctx);
bool exists = roleBS.GetAll().Any(r => r.Name == roleName && r.Id != roleId);
if (exists)
{
throw new ArgumentException("角色名字已存在" + roleName);
}
Role role = new Role();
role.Id = roleId;
ctx.Entry(role).State = System.Data.Entity.EntityState.Unchanged;
role.Name = roleName;
ctx.SaveChanges();
}
}
public long AddNew(string roleName)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <Role> bs = new BaseService <Role>(ctx);
bool exists = bs.GetAll().Any(e => e.Name == roleName);
if (exists)
{
throw new ArgumentException("角色名字已经存在" + roleName);
}
Role role = new Role();
role.Name = roleName;
ctx.Role.Add(role);
ctx.SaveChanges();
return(role.Id);
}
}
public long AddPermission(string permName, string description)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <Permission> permBS = new BaseService <Permission>(ctx);
bool exists = permBS.GetAll().Any(p => p.Name == permName);
if (exists)
{
throw new ArgumentException("权限项已经存在");
}
Permission perm = new Permission();
perm.Name = permName;
perm.Description = description;
ctx.Permission.Add(perm);
ctx.SaveChanges();
return(perm.Id);
}
}
public long?Updatetops(long id)
{
using (Dbcontext ctx = new Dbcontext())
{
try
{
BaseService <Travels> bs = new BaseService <Travels>(ctx);
bs.GetById(id).tops += 1;
ctx.SaveChanges();
return(bs.GetById(id).tops);
}
catch (DbEntityValidationException ex)
{
return(null);
}
}
}
public bool AddNumOfPeople(long tid)
{
using (Dbcontext ctx = new Dbcontext())
{
try
{
BaseService <Line> bs = new BaseService <Line>(ctx);
var line = bs.GetById(tid);
line.NumOfPeople += 1;
ctx.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool AddSchool(string name)
{
using (Dbcontext ctx = new Dbcontext())
{
try
{
school s = new school();
s.schoolname = name;
ctx.school.Add(s);
ctx.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool Addjifen(long gid)
{
using (Dbcontext ctx = new Dbcontext())
{
try
{
BaseService <Guide> bs = new BaseService <Guide>(ctx);
var guide = bs.GetById(gid);
guide.jifen += 10;
ctx.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public long AddLine(string Province, string city, string intro, string title, long PastPrice, float discount)
{
Line lines = new Line();
lines.Province = Province;
lines.city = city;
lines.intro = intro;
lines.title = title;
lines.NowPrice = (PastPrice * (discount * 0.1));
lines.PastPrice = PastPrice;
lines.discount = discount;
using (Dbcontext ctx = new Dbcontext())
{
ctx.Line.Add(lines);
ctx.SaveChanges();
}
return(lines.Id);
}
public bool appointment(long GuideId, long Uid)
{
using (Dbcontext ctx = new Dbcontext())
{
try
{
GuideUser u = new GuideUser();
u.GuideId = GuideId;
u.Uid = Uid;
ctx.GuideUser.Add(u);
ctx.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public void UpdateTravel(long id, string title, string context, long tops, long Uid)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <Travels> bs
= new BaseService <Travels>(ctx);
var line = bs.GetById(id);
if (line == null)
{
throw new ArgumentException("找不到id=" + id + "的游记");
}
line.title = title;
line.content = context;
line.tops = tops;
line.title = title;
line.Uid = Uid;
ctx.SaveChanges();
}
}
public bool appointment(long uid, long oid)
{
using (Dbcontext ctx = new Dbcontext())
{
try
{
OrderUser ou = new OrderUser();
ou.Uid = uid;
ou.Oid = oid;
ctx.OrderUser.Add(ou);
ctx.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
//public bool check_Yuyue(long Guide_Id)
//{
// using (Dbcontext ctx = new Dbcontext())
// {
// BaseService<Guide> bs = new BaseService<Guide>(ctx);
// var guide = bs.GetAll().Where(e => e.Id == Guide_Id).FirstOrDefault();
// if (guide.isappointment)
// return false;
// else
// return true;
// }
//}
//public bool appointment(long Tid, long userid)
//{
// using (Dbcontext ctx = new Dbcontext())
// {
// try
// {
// }
// catch (DbEntityValidationException ex)
// {
// return false;
// }
// return true;
// }
//}
public long AddGuide(long uid, string school, string schoolnum, string picture, string intro)
{
Guide g = new Guide();
g.intro = intro;
g.isappointment = false;
g.level = 1;
g.school = school;
g.schoolnum = schoolnum;
g.picture = picture;
g.Users_Id = uid;
using (Dbcontext ctx = new Dbcontext())
{
ctx.Guide.Add(g);
ctx.SaveChanges();
}
return(g.Id);
}
public void UpdatePermIds(long roleId, long[] permIds)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <Role> roleBs = new BaseService <Role>(ctx);
var role = roleBs.GetById(roleId);
if (role == null)
{
throw new ArgumentException("roleId不存在" + roleId);
}
role.Permissions.Clear();
BaseService <Permission> permBs = new BaseService <Permission>(ctx);
var perms = permBs.GetAll().Where(p => permIds.Contains(p.Id)).ToArray();
foreach (var perm in perms)
{
role.Permissions.Add(perm);
}
ctx.SaveChanges();
}
}
public void Update(long id, string phoneNum,
string email, string context)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <Comment> bs
= new BaseService <Comment>(ctx);
var comment = bs.GetAll().Include(h => h.User).Include(h => h.Raiders).SingleOrDefault(h => h.Id == id);
if (comment == null)
{
throw new ArgumentException("找不到id=" + id + "的评论");
}
comment.User.PhoneNum = phoneNum;
comment.User.Email = email;
comment.Context = context;
ctx.SaveChanges();
}
}
public void UpdateRoleIds(long adminUserId, long[] roleIds)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <AdminUser> userBs = new BaseService <AdminUser>(ctx);
var user = userBs.GetById(adminUserId);
if (user == null)
{
throw new ArgumentException("用户不存在" + adminUserId);
}
user.Roles.Clear();
BaseService <Role> roleBs = new BaseService <Role>(ctx);
var roles = roleBs.GetAll().Where(p => roleIds.Contains(p.Id)).ToArray();
foreach (var role in roles)
{
user.Roles.Add(role);
}
ctx.SaveChanges();
}
}
public void AddPermIds(long roleId, long[] permIds)
{
using (Dbcontext ctx = new Dbcontext())
{
BaseService <Role> roleBs = new BaseService <Role>(ctx);
var role = roleBs.GetById(roleId);
if (role == null)
{
throw new ArgumentException("roleId不存在" + roleId);
}
var permBs = ctx.Permission.Where(h => h.IsDeleted == false);
var perms = permBs.Where(p => permIds.Contains(p.Id)).ToArray();
foreach (var perm in perms)
{
role.Permissions.Add(perm);
}
ctx.SaveChanges();
}
}
