static public int INSERTLogins(Logins Object)
{
int result = -1;
SqlConnection cn = GetSqlConnection();
cn.Open();
string sqlQuery = "INSERT INTO Logins (Username, Password)";
sqlQuery += " VALUES (@Username, @Password)";
SqlCommand Mycmd = new SqlCommand(sqlQuery, cn);
Mycmd.Parameters.AddWithValue("@Username", SqlDbType.NVarChar).Value = Object.Username;
Mycmd.Parameters.AddWithValue("@Password", SqlDbType.NVarChar).Value = Object.Password;
result = Mycmd.ExecuteNonQuery();
cn.Close();
cn.Dispose();
return(result);
}
public async Task <IActionResult> Edit(long id, [Bind("Id,Login,Password,AccountId,IsBlocked,LastUse,UseForParsing,UseProxy,ProxyIp,Description,LastUpdate")] Logins logins)
{
if (id != logins.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(logins);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LoginsExists(logins.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(logins));
}
public ActionResult DeleteConfirmed(int id)
{
if (Request.IsAjaxRequest())
{
if (Session["username"] != null)
{
if (Session["Admin"].Equals("Yes"))
{
Logins logins = db.Logins.Find(id);
db.Logins.Remove(logins);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(PartialView("Error", new ErrorViewModel {
Description = "This function is only for Admins."
}));
}
}
else
{
return(View("ErrorLogin", new ErrorViewModel {
Description = "Your must login first!!."
}));
}
}
else
{
return(View("Error404"));
}
}
public virtual void RemoveLogin([NotNull] string loginProvider, [NotNull] string providerKey)
{
Check.NotNull(loginProvider, nameof(loginProvider));
Check.NotNull(providerKey, nameof(providerKey));
Logins.RemoveAll(userLogin => userLogin.LoginProvider == loginProvider && userLogin.ProviderKey == providerKey);
}
private void Button1_Click(object sender, EventArgs e)
{
Logins login = new Logins();
AuthenticateTableAdapter taAuth = new AuthenticateTableAdapter();
login.userName = textBox1.Text;
login.passWord = textBox2.Text;
try
{
DataTable dt = new DataTable();
taAuth.Fill(authDS.Authenticate, login.userName, login.passWord);
if (authDS.Tables[0].Rows.Count == 1)
{
label3.Text = "Success!";
// Application.Run(new Main());
}
else
{
label3.Text = "Failure!";
}
}
catch (Exception ex)
{
label3.Text = ex.Message;
}
}
public async Task <UserDto> CreateUser(UserDto userDto)
{
var authenticationDto = new AuthenticationDto();
var userSpecification = new UserSpecification().
And(new UserNameSpecification()).
And(new PasswordSpecification()).
And(new UniqueUserSpecification(this.userRepository));
if (userSpecification.IsSatisfiedBy(userDto))
{
string passwordSalt = "";
string passwordHash = "";
ECWRNGRfcSaltedHashManager.GenrateSaltedHash(userDto.Password, out passwordHash, out passwordSalt);
var newUser = new Logins
{
UserName = userDto.UserName,
PasswordSalt = passwordSalt,
PasswordHash = passwordHash
};
int identity = await this.userRepository.CreateLogin(newUser);
if (identity <= 0)
{
userDto.AddRule("User", "Creation faild!");
}
else
{
userDto.AddRule("Success", "Authentication is successfull.");
}
}
return(userDto);
}
public ActionResult AccessLog()
{
var listAC = Logins.Logins_Get();
ViewBag.ListAccessLog = listAC;
return(View("~/Views/Login/AccessLog.cshtml"));
}
public string Login(Logins data)
{
bool isPasswordCorrect = false;
string un = data.UserName;
string Password = data.Password;
using (ApplicationDbContext entity = new ApplicationDbContext())
{
var user = entity.logins.Where(u => u.UserName == un).FirstOrDefault();
if (user != null)
{
if (Password == user.Password)
{
Session["LoginID"] = user.ID;
Session["Username"] = user.Fname + ' ' + user.Lname;
return(user.ID.ToString());
}
else
{
return("0");
}
}
else
{
return("-1");
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
SqlServer server = SqlServer.CurrentServer;
server.Connect();
SqlDatabase database = SqlDatabase.CurrentDatabase(server);
Logins.DataSource = server.Logins;
Logins.DataBind();
// Remove existing users from the Logins selection
foreach (SqlUser user in database.Users)
{
ListItem item = Logins.Items.FindByValue(user.Login);
if (item != null)
{
Logins.Items.Remove(item);
}
}
if (Logins.Items.Count == 0)
{
CreateButton.Enabled = false;
ErrorMessage.Text = "All Logins are Users of this database.";
}
Username.Text = Logins.SelectedValue;
server.Disconnect();
}
}
public LoginsResponse get_Logins(Logins logins)
{
LoginsResponse loginsResponse = new LoginsResponse();
try
{
NCH.Fwk.Bd.MySql.Coneccion = NCH.Fwk.Configuration.SettingsServices.MysqlConect;
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "SP_CONS_LOGINS";
cmd.Parameters.AddWithValue("@in_idlogin", logins.idlogin);
cmd.Parameters.AddWithValue("@in_login", logins.login);
cmd.Parameters.AddWithValue("@in_rut", logins.rut);
cmd.Parameters.AddWithValue("@in_dvr", logins.dvr);
cmd.Parameters.AddWithValue("@in_nombrecompleto", logins.nombrecompleto);
cmd.Parameters.AddWithValue("@in_contraseña", logins.contraseña);
cmd.Parameters.AddWithValue("@in_estado", logins.estado);
cmd.Parameters.AddWithValue("@in_email", logins.email);
loginsResponse.Result = NCH.Fwk.Bd.MySql.executar(cmd).ToList <Logins>();
loginsResponse.ErrorCode = NCH.Fwk.Bd.MySql.ErrorCode;
loginsResponse.ErrorDescription = NCH.Fwk.Bd.MySql.ErrorDescription;
}
catch (Exception ex)
{
loginsResponse.ErrorCode = "16";
loginsResponse.ErrorDescription = ex.Message;
}
return(loginsResponse);
}
/// <summary>
/// Получаем информавцию о пользовтале
/// </summary>
/// <param name="id">Id пользователя</param>
/// <returns></returns>
public ActionResult Details(int?id)
{
using (Soc_NetWorkCF db = new Soc_NetWorkCF()) // создаем подключение
{
if (id == null) // если такого пользователя нет
{
return(Redirect("~/home/Error")); //то плохо
}
UserInfo userInfo = db.UserInfo.Find(id);// находим по ID
if (userInfo == null)
{
return(Redirect("~/home/Error"));//то плохо
}
Logins logTmp = db.Logins.Find(id);
if (logTmp.LoginUser == User.Identity.Name) // при попытки перейти на самого себя
{
return(Redirect("~/home/Error")); //то плохо
}
ViewBag.ID = ReturnRoleID(id);
return(View(userInfo));// возращаем пользователя
}
}
/// <summary>
/// Актион выводит на страницу всю информацию о пользователе
/// </summary>
/// <returns></returns>
public ActionResult Details()
{
string LoginName = User.Identity.Name; // достаем имя
int? id; // для определение по ID
UserInfo infoAboutUser; // пересенная для хранения информации пользователе
using (Soc_NetWorkCF db = new Soc_NetWorkCF()) // поключаемся бд
{
Logins tmp = db.Logins.FirstOrDefault(x => x.LoginUser == LoginName); //находим по id польховтаеля
id = tmp.ID; // передеем ID
if (id == null) // если такого пользователя нет
{
return(Redirect("~/home/Error")); //то плохо
}
infoAboutUser = db.UserInfo.Find(id); // в базе ищем инфу по ID
if (infoAboutUser == null) // если пустой
{
return(Redirect("~/home/Error")); //то плохо
}
}
return(View(infoAboutUser)); // возращаем вью с инфой по пользователю
}
public async Task <ActionResult> Manage(ManageUserViewModel model)
{
string userId = User.Identity.GetUserId();
string localUserName = await Logins.GetProviderKey(User.Identity.GetUserId(), IdentityConfig.LocalLoginProvider);
bool hasLocalLogin = localUserName != null;
ViewBag.HasLocalPassword = hasLocalLogin;
ViewBag.ReturnUrl = Url.Action("Manage");
if (hasLocalLogin)
{
if (ModelState.IsValid)
{
bool changePasswordSucceeded = await ChangePassword(localUserName, model.OldPassword, model.NewPassword);
if (changePasswordSucceeded)
{
return(RedirectToAction("Manage", new { Message = ManageMessageId.ChangePasswordSuccess }));
}
else
{
ModelState.AddModelError(String.Empty, "The current password is incorrect or the new password is invalid.");
}
}
}
else
{
// User does not have a local password so remove any validation errors caused by a missing OldPassword field
ModelState state = ModelState["OldPassword"];
if (state != null)
{
state.Errors.Clear();
}
if (ModelState.IsValid)
{
try
{
// Create the local login info and link the local account to the user
localUserName = User.Identity.GetUserName();
if (await Secrets.Create(new UserSecret(localUserName, model.NewPassword)) &&
await Logins.Add(new UserLogin(userId, IdentityConfig.LocalLoginProvider, localUserName)))
{
return(RedirectToAction("Manage", new { Message = ManageMessageId.SetPasswordSuccess }));
}
else
{
ModelState.AddModelError(String.Empty, "Failed to set password");
}
}
catch (Exception e)
{
ModelState.AddModelError(String.Empty, e);
}
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public async Task <ActionResult> Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
try
{
// Create a profile, password, and link the local login before signing in the user
User user = new User(model.UserName);
if (await Users.Create(user) &&
await Secrets.Create(new UserSecret(model.UserName, model.Password)) &&
await Logins.Add(new UserLogin(user.Id, IdentityConfig.LocalLoginProvider, model.UserName)))
{
await SignIn(user.Id, isPersistent : false);
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError(String.Empty, "Failed to create login for: " + model.UserName);
}
}
catch (DbEntityValidationException e)
{
ModelState.AddModelError("", e.EntityValidationErrors.First().ValidationErrors.First().ErrorMessage);
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public AccGoogle(Sex sexInput, string alternativeEmail)
{
Names n = new Names();
Names.Info info = null;
info = n.GetFirstLastNameInfo(sexInput);
if (info != null)
{
firstName = info.FirstName;
lastName = info.LastName;
}
login = Logins.GenerateLogin(firstName, lastName);
//login = "******";
domen = "google.com";
password = System.Web.Security.Membership.GeneratePassword(8, 0);
Random r = new Random(DateTime.Now.Millisecond);
password = Regex.Replace(password, @"[^a-zA-Z0-9]", m => r.Next(0, 9).ToString());
sexString = MyData.Sex[(int)sexInput];
int year = r.Next(DateTime.Now.Year - 60, DateTime.Now.Year - 20);
int month = r.Next(1, 12);
int day = r.Next(1, 28);
dateBirth = new DateTime(year, month, day);
this.alterEmail = alternativeEmail;
//country = MyData.Countrys[1];
//city = MyData.Citys[1];
//secretQuestion = MyData.SecretQuestions[4];
//answer = n.GetFirstLastNameInfo().LastName;
}
/// <summary>
/// 更新用户登陆信息
/// </summary>
/// <param name="num"></param>
/// <param name="pass"></param>
/// <returns></returns>
public bool ModifyLogin(Logins login)
{
StringBuilder sb = new StringBuilder();
sb.Append("update user set login=@login,token=@token,error=@error,etime=@etime where id=@id ");
return(dal.ExecBool(sb.ToString(), login));
}
public Logins GetLogin(Logins data)
{
var result = _memberServices.LoginMember(data).Result;
_Member = result;
getmem = getmem;
return(result);
}
public CreateDatabaseUser(IDatabaseUserAccessService databaseUserAccessService, IServerUserAccessService serverUserAccessService, string database)
{
_databaseUserAccessService = databaseUserAccessService;
_database = database;
Logins = serverUserAccessService.GetLoginsName();
Login = Logins.FirstOrDefault();
InitializeComponent();
}
private static void RevokeLogins(string tenant, int revokedBy)
{
ThreadPool.QueueUserWorkItem(async delegate
{
await Task.Delay(new TimeSpan(0, 2, 0)).ConfigureAwait(true);
await Logins.RevokeLoginsAsync(tenant, revokedBy).ConfigureAwait(true);
}, null);
}
public async Task <int> CreateLogin(Logins logins)
{
logins.Users = new Users {
UserName = logins.UserName
};
eCodeWorldContext.Logins.Add(logins);
return(await eCodeWorldContext.SaveChangesAsync());
}
public Usuarios PesquisarUsuario(Logins login)
{
var retorno = _RepositoryUsuario.List()
.Where(y => y.CodigoLogin == login.CodigoLogin)
.FirstOrDefault();
return(retorno);
}
// pré carrega um programa com um usuario e alguns itens ja criados
public static Program loadProgramTeste(Logins login)
{
Program pgm = new Program(login);
pgm.PreLoadProgram();
return(pgm);
}
public virtual void RemoveLogin(UserLoginInfo login)
{
var loginsToRemove = Logins
.Where(l => l.LoginProvider == login.LoginProvider)
.Where(l => l.ProviderKey == login.ProviderKey);
Logins = Logins.Except(loginsToRemove).ToList();
}
public ActionResult RemoveAccountList()
{
return(Task.Run(async() =>
{
var linkedAccounts = await Logins.GetLogins(User.Identity.GetUserId());
ViewBag.ShowRemoveButton = linkedAccounts.Count > 1;
return (ActionResult)PartialView("_RemoveAccountPartial", linkedAccounts);
}).Result);
}
public virtual void AddLogin(Login login)
{
if (login == null)
{
throw new ArgumentNullException("login");
}
login.User = this;
Logins.Add(login);
}
public virtual void RemoveLogin(Login login)
{
if (login == null)
{
throw new ArgumentNullException("login");
}
Logins.Remove(login);
}
public ActionResult Authorize(Logins LoginsModel)
{
ScrumEntities1 db = new ScrumEntities1();
var LoggedUser = db.Logins.SingleOrDefault(x => x.UserName == LoginsModel.UserName && x.PassWord == LoginsModel.PassWord);
if (LoggedUser != null)
{
ViewBag.LoginMessage = "Successfull login";
ViewBag.LoggedStatus = "In";
ViewBag.Acceslevel = LoggedUser.AccessLevel;
ViewBag.LoginId = LoggedUser.LoginId;
Session["UserName"] = LoggedUser.UserName;
Session["Accesslevel"] = LoggedUser.AccessLevel.ToString();
Session["LoginId"] = LoggedUser.LoginId;
if (LoggedUser.AccessLevel.ToString() == "1")
{
//Admin
}
else if (LoggedUser.AccessLevel.ToString() == "2")
{
//Opettaja
int henkiloId;
int LoginId = LoggedUser.LoginId;
Opettajat opet = new Opettajat();
opet = db.Opettajat.Where(o => o.LoginId == LoginId).FirstOrDefault();
henkiloId = opet.HenkiloID;
Session["henkiloId"] = henkiloId;
Session["KirjautunutKayttajaNimi"] = opet.Etunimi + " " + opet.Sukunimi;
}
else if (LoggedUser.AccessLevel.ToString() == "3")
{
//Opiskelija
int opiskelijaId;
int LoginId = LoggedUser.LoginId;
Opiskelijat opisk = new Opiskelijat();
opisk = db.Opiskelijat.Where(o => o.LoginId == LoginId).FirstOrDefault();
opiskelijaId = opisk.Opiskelijanumero;
Session["opiskelijaId"] = opiskelijaId;
Session["KirjautunutKayttajaNimi"] = opisk.Etunimi + " " + opisk.Sukunimi;
}
else
{
//Vihre
}
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.LoginMessage = "Login unsuccessfull";
ViewBag.LoggedStatus = "Out";
LoginsModel.LoginIdErrorMessage = "Tuntematon käyttäjätunnus tai salasana.";
return(View("Index"));
}
}
public virtual void RemoveLogin(string loginProvider, string providerKey)
{
if (HasLogins())
{
Logins.RemoveAll(x =>
x.LoginProvider.Equals(loginProvider, StringComparison.OrdinalIgnoreCase) &&
x.ProviderKey.Equals(providerKey, StringComparison.OrdinalIgnoreCase));
}
}
public virtual void AddLogin(MongoUserLogin userLogin)
{
if (userLogin == null)
{
throw new ArgumentNullException(nameof(userLogin));
}
Logins.Add(userLogin);
}
public Login(int rec_id, ViewModel.Records r)
{
InitializeComponent();
this.r = r;
record = rec_id;
//DataContext = new Doctors(sp_ID);
log = new Logins(record, r);
DataContext = log;
}
public async Task<ActionResult> Login(LoginViewModel model, string returnUrl)
{
if (ModelState.IsValid)
{
var user = await UserManager.FindAsync(model.UserName, model.Password);
if (user != null)
{
await SignInAsync(user, model.RememberMe);
// Successful login here; do something...
try
{
// Update the last login time
DataModelContainer db = new DataModelContainer();
Guid userId = Guid.Parse(user.Id);
Logins l = db.Logins.Find(userId);
if (l == null)
{
l = new Logins();
l.Id = userId;
l.LastLoginTime = DateTime.UtcNow;
db.Logins.Add(l);
}
else
{
l.LastLoginTime = DateTime.UtcNow;
}
db.SaveChanges();
// Set the company name
//if (User.IsInRole(Constants.PARTNER_ADMIN))
{
PartnerStaffMember psmu = db.PartnerStaffMembers.Where(x => x.Id == userId).FirstOrDefault();
if (psmu != null)
{
Session["CompanyName"] = psmu.PartnerCompany.Name;
}
else
{
PartnerAdmin pau = db.PartnerAdmins.Where(x => x.Id == userId).FirstOrDefault();
if (pau != null)
{
Session["CompanyName"] = pau.PartnerCompany.Name;
}
}
}
}
catch (Exception ex)
{
}
//return RedirectToLocal(returnUrl);
// Always go to Home
return RedirectToAction("Index", "Home");
}
else
{
ModelState.AddModelError("", "Invalid username or password.");
}
}
// If we got this far, something failed, redisplay form
return View(model);
}
