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);
}
}
