public string Login(string username, string password) { try { AccountModel accountModel = new AccountModel(); using (entity = new serverEntity()) { var checklogin = entity.user_info .Where(x => x.username.Equals(username)) .FirstOrDefault(); if (checklogin != null) { accountModel.fakepassword(); var res = accountModel.verify(password, checklogin.password.TrimEnd()).ToString(); return(res); } else { return("false"); } } } catch (Exception ee) { return("Error : " + ee.Message); } }
public string InserUser([FromBody] user_info user) { string res = ""; try { user_info utdb = new user_info(); jsoncon = new JsonConvert(); using (entity = new serverEntity()) { //if (!entity.user_info // .Where(x => x.username.Equals(user.username, StringComparison.CurrentCulture)).Any()) //{ // entity.user_info.Add(new user_info() // { // user_id = idGenerate.generateUserId().Result, // username = user.username.TrimEnd(), // password = user.password.TrimEnd(), // role = "admin", // dcd2 = DateTime.Now, // }); // entity.SaveChanges(); // return "Success"; // } //else // { // return "Duplicate"; //} var useridParameter = new SqlParameter("@userid", user.user_id.ToString()); var usernaParameter = new SqlParameter("@username", user.username.ToString()); var passwordParameter = new SqlParameter("@password", user.password.ToString()); var roleParameter = new SqlParameter("@role", user.role.ToString()); var reSqlParameter = new SqlParameter("@res", SqlDbType.VarChar.ToString()); reSqlParameter.Direction = ParameterDirection.Output; var ss = entity.Database.ExecuteSqlCommand("exec dbo.insertUserInfo @userid, @username, @password, @role", useridParameter, usernaParameter, passwordParameter, roleParameter); return(ss.ToString()); } } catch (Exception ee) { res = "Error : " + ee.Message; } return(res); }
public dynamic userlist() { AccountModel amModel = new AccountModel(); List <AccountModel.UserModel> userModel = new List <AccountModel.UserModel>(); using (entity = new serverEntity()) { var modelList = entity.SelectUser().ToList(); return(modelList); } }
public async Task <string> generateUserId() { var res = ""; using (serverEntity = new serverEntity()) { var lastuser = serverEntity.user_info.OrderByDescending(x => x.id).Count(); string userid = "000000000"; int id = Int32.Parse(userid) + (lastuser + 1); res = String.Format("{0:000000000", id); } return(res); }
public roleModel getUserRole(string username) { using (server = new serverEntity()) { var userRole = server.user_info.Where(x => x.username.Equals(username, StringComparison.CurrentCulture)) .FirstOrDefault(); var roleMod = new roleModel() { role = userRole.role, user_id = userRole.user_id, username = userRole.username, }; return(roleMod); } }
public dynamic getEdituser(int id) { try { using (entity = new serverEntity()) { var userid = new SqlParameter("@id", id); var result = entity.Database.SqlQuery <AccountModel.UserModel>("exec getUsertoEdit @id", userid).FirstOrDefault(); return(result); } } catch (Exception ee) { return(ee.Message); } }