public async Task <IActionResult> PutUserTb([FromRoute] int id, [FromBody] UserTb userTb)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != userTb.UserId)
{
return(BadRequest());
}
_context.Entry(userTb).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UserTbExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PostUserTb([FromBody] UserTb userTb)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.UserTb.Add(userTb);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (UserTbExists(userTb.UserId))
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
else
{
throw;
}
}
return(CreatedAtAction("GetUserTb", new { id = userTb.UserId }, userTb));
}
public ActionResult DeleteConfirmed(int id)
{
UserTb userTb = db.UserTbs.Find(id);
db.UserTbs.Remove(userTb);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public UserTb ForgerPassnumber(ForgetVm item)
{
var Join = new UserTb
{
Email = item.Email,
MiNember = item.Password,
};
return(Join);
}
public UserTb Update(UserTb item)
{
Db.Entry(item).State = System.Data.Entity.EntityState.Modified;
this.Db.SaveChanges();
return(item);
}
public static ForgetVm Forget(UserTb user)
{
var UserTbs = new ForgetVm()
{
Email = user.Email,
ID = user.ID
};
return(UserTbs);
}
public static UserVm Login(UserTb user)
{
LoginUser = (user == null) ? null : new UserVm()
{
Acc = user.Email,
Name = user.Name,
UserId = user.ID,
};
return(LoginUser);
}
public static bool NewUser(UserTb tb)
{
db = new UcasProEntities();
db.UserTbs.Add(tb);
db.SaveChanges();
return true;
}
public ActionResult Register(UserTb tb, string uFName, string uEmail, string uLName, string uPass)
{
tb.UserFirstName = uFName;
tb.UserLastName = uLName;
tb.UserEmail = uEmail;
tb.UserPassword = uPass;
tb.UserStatus = true;
db.UserTb.Add(tb);
db.SaveChanges();
return(View());
}
public UserTb Join(SignupVm item)
{
var Join = new UserTb
{
Email = item.Email,
MiNember = item.Password,
Name = item.Fullname
};
return(Join);
}
public async Task <IActionResult> PostUserTb([FromBody] UserTb userTb)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.UserTb.Add(userTb);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetUserTb", new { id = userTb.Id }, userTb));
}
// GET: UserTbs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserTb userTb = db.UserTbs.Find(id);
if (userTb == null)
{
return(HttpNotFound());
}
return(View(userTb));
}
// GET: UserTbs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UserTb userTb = db.UserTbs.Find(id);
if (userTb == null)
{
return(HttpNotFound());
}
ViewBag.Fk_Role = new SelectList(db.RoleTbs, "Id", "Role", userTb.Fk_Role);
return(View(userTb));
}
public ActionResult Edit([Bind(Include = "Id,UserName,Password,Salt,Fk_Role")] UserTb userTb)
{
if (ModelState.IsValid)
{
string MySalt = Mycrypt.GetRandomSalt();
userTb.Salt = MySalt;
userTb.Password = Mycrypt.HashPassword(userTb.Password, MySalt);
db.Entry(userTb).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Fk_Role = new SelectList(db.RoleTbs, "Id", "Role", userTb.Fk_Role);
return(View(userTb));
}
public UserTb Insert(UserTb item)
{
Exp exp = new Exp();
item.Status = (Models.Src.Status) 1;
item.Iden_ID = 1;
item.CreateDate = DateTime.Now;
this.Db.UserTb.Add(item);
exp.Level = "1";
exp.SumExp = "0";
exp.User_ID = item.ID;
this.Db.Exp.Add(exp);
this.Db.SaveChanges();
return(item);
}
public ActionResult Login(UserTb tb, string uEmail, string uPass)
{
var query = (from x in db.UserTb
where x.UserEmail == uEmail && x.UserPassword == uPass
select x).FirstOrDefault();
if (query != null)
{
Session.Add("login", "omid");
return(Redirect("~/Admin/Panel"));
}
else
{
ViewBag.message = "نام کاربری یا رمز عبور اشتباه است";
return(View());
}
}
public UpdateUserVm ChatUsre(UserTb item)
{
var item0 = new UpdateUserVm
{
Email = item.Email,
Fullname = item.Name,
NiName = item.Niname,
Phone = item.Phone,
Sex = 1,
Bireday = item.UserText,
};
return(item0);
}
public ActionResult Index(UserTb Myuser)
{
UserTb TjekUser = db.UserTbs.Where(u => u.UserName == Myuser.UserName).FirstOrDefault();
if (TjekUser != null)
{
string PassWord = Mycrypt.HashPassword(Myuser.Password, TjekUser.Salt);
UserTb NewUser = db.UserTbs.Where(u => u.UserName == TjekUser.UserName && u.Password == PassWord).FirstOrDefault();
if (NewUser != null)
{
Session["UserId"] = NewUser.Id;
Session["UserName"] = NewUser.UserName;
Session["UserPassword"] = NewUser.Password;
Session["UserRole"] = NewUser.Fk_Role;
Response.Redirect("~/EventsTbs");
}
}
return(View());
}
public static bool EditUser(UserTb tb)
{
try
{
db = new UcasProEntities();
var q = db.UserTbs.Where(p => p.ID == tb.ID).SingleOrDefault();
q.ID = tb.ID;
q.UserName = tb.UserName;
q.Password = tb.Password;
q.TypeUser = tb.TypeUser;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
// throw ex;
Xprema.XpremaException e = new Xprema.XpremaException();
e.CodeNumber = 6;
e.OtherDescription = ex.InnerException.InnerException.Message;
File.WriteAllText("t.txt", ex.InnerException.InnerException.Message);
e.UserDescription = "Error in Save Changed";
if (ex.InnerException.InnerException.Message.Contains("Cannot insert duplicate key row in object 'dbo.UserTbs' with unique index 'IX_UserTbs'"))
{
e.UserDescriptionArabic = "اسم المستخدم موجود يرجى تغير الاسم";
}
else
e.UserDescriptionArabic = e.OtherDescription;//"خطاء في اضافة البيانات";
throw e;
}
}
public async Task <UserTbOutputDto> AddUserAccount(UserAccountAddUserInput input)
{
var existUser = _userRepo.FirstOrDefault(u => u.UserCode == input.UserCode);
if (existUser != null)
{
throw new UserFriendlyException(string.Format("{0}此账户名已被占用", input.UserCode));
}
var addUser = new UserTb()
{
Enable = false,
Password = input.Password,
UserCode = input.UserCode
};
var id = await _userRepo.InsertAndGetIdAsync(addUser);
addUser.Id = id;
return(addUser.MapTo <UserTbOutputDto>());
}
public static bool DeleteUser(int xid)
{
try
{
db = new UcasProEntities();
UserTb tb = new UserTb();
tb = db.UserTbs.Where(u => u.ID == xid).Single();
if (tb.ID != 0)
{
db.UserTbs.Remove(tb);
db.SaveChanges();
return true;
}
return false;
}
catch (Exception)
{
return false;
}
}
