internal static void FillByUserName(User user) { // #1- Logger variables System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); string className = System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name; string methodName = stackFrame.GetMethod().Name; string query = "SELECT id, groupName,password,passwordDate,deleted,disabled,dateCreated,dateDeleted,dateDisabled FROM incuser WHERE userName = @userName"; Hashtable param = new Hashtable(); param.Add("@userName", user.userName); // #2- Logger pre query Logger.LogDebug("(%s) (%s) -- Ejecuta query para obtener todos los folios. QUERY: %s", className, methodName, query); using (DataTable dt = ExecuteDataTableQuery(query, param)) { if (dt != null && dt.Rows.Count > 0) { // #3- Logger post query Logger.LogDebug("Row count: %s", dt.Rows.Count.ToString()); DataRow row = dt.Rows[0]; user.userName = user.userName; user.id = (row["id"] != DBNull.Value) ? row["id"].ToString() : string.Empty; user.groupName = (row["groupName"] != DBNull.Value) ? row["groupName"].ToString() : string.Empty; user.password = (row["password"] != DBNull.Value) ? row["password"].ToString() : string.Empty; user.passwordDate = (row["passwordDate"] != DBNull.Value) ? DateTime.Parse(row["passwordDate"].ToString()) : DateTime.Now; user.deleted = (row["deleted"] != DBNull.Value) ? int.Parse(row["deleted"].ToString()) : 0; user.disabled = (row["disabled"] != DBNull.Value) ? int.Parse(row["disabled"].ToString()) : 0; user.dateCreated = (row["dateCreated"] != DBNull.Value) ? DateTime.Parse(row["dateCreated"].ToString()) : DateTime.Now; user.dateDeleted = (row["dateDeleted"] != DBNull.Value) ? DateTime.Parse(row["dateDeleted"].ToString()) : DateTime.Now; user.dateDisabled = (row["dateDisabled"] != DBNull.Value) ? DateTime.Parse(row["dateDisabled"].ToString()) : DateTime.Now; } } }
public string CheckLogin(string username, string password, bool isPasswordInput_hashed, bool isTokenLogin = false) { string result = string.Empty; if (!string.IsNullOrWhiteSpace(username) && !string.IsNullOrWhiteSpace(password)) { User user = new User("", username); if (user != null && !string.IsNullOrWhiteSpace(user.id) && user.deleted != 1 && user.disabled != 1) { if (!isTokenLogin) { // If is hashed in DB, then get my input password hashed string password_hash = password; if (!isPasswordInput_hashed) { password_hash = BCrypt.HashPassword(password, user.password); } if (user.password.Equals(password_hash)) { result = user.id; } } else { result = user.id; } } } return result; }
private void Perform_login(string username, string password, bool isPasswordInput_hashed = false, bool isTokenLogin = false) { if (!string.IsNullOrWhiteSpace(username) || !string.IsNullOrWhiteSpace(password)) { bool ok = false; try { string userID = Global.GlobalMethods.CheckLogin(username, password, isPasswordInput_hashed, isTokenLogin); if (!string.IsNullOrWhiteSpace(userID)) { User user = new User(userID, ""); if (user != null) { ok = true; Session["UserID"] = user.id; Session["UserName"] = user.userName; string returnURL = "Dashboard.aspx"; string query_string = Request.QueryString["folioID"]; if (!string.IsNullOrWhiteSpace(query_string)) { returnURL = "Dashboard.aspx?folioID=" + query_string; } Response.Redirect(returnURL, false); } } if (!ok) { ScriptManager.RegisterStartupScript(this, typeof(Page), "ShowErrorMessage", "ShowErrorMessage('" + 2 + "');", true); } } catch (Exception e) { ScriptManager.RegisterStartupScript(this, typeof(Page), "ShowErrorMessage", "ShowErrorMessage('" + 3 + "');", true); // #1- Logger variables System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); string className = System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name; string methodName = stackFrame.GetMethod().Name; // #2- Logger exception Logger.LogError("(%s) (%s) -- Excepcion. Haciendo login. ERROR: %s", className, methodName, e.Message); } } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "ShowErrorMessage", "ShowErrorMessage('" + 1 + "');", true); } }
public static int ConfirmRemoveElement(string userID, string password_input, int tapeID, bool isExtra) { int result = 0; /* 0 - Invalid password * 1 - OK * 2 - DB Error * */ if (!string.IsNullOrWhiteSpace(userID) && !string.IsNullOrWhiteSpace(password_input)) { // #1- Logger variables System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); string className = System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name; string methodName = stackFrame.GetMethod().Name; // #1-2- Params register Logger.LogDebug("(%s) (%s) -- Info WebMethod. Parametros recibidos: " + userID + ", " + password_input + ", " + tapeID.ToString() + ", " + isExtra.ToString(), className, methodName); User user = new User(userID, ""); if (user != null) { string uID = Global.GlobalMethods.CheckLogin(user.userName, password_input); { if (!string.IsNullOrWhiteSpace(uID)) { result = 1; // OK } } } if (result == 1) { result = Global.GlobalMethods.RemoveTimelineElement(tapeID, isExtra) ? 1 : 2; } } return result; }