/// <summary> /// Adds a new user. /// </summary> /// <param name="sessionID">The sessionID of the current session</param> /// <param name="username">The username.</param> /// <param name="password">The password.</param> /// <param name="firstname">The firstname.</param> /// <param name="lastname">The lastname.</param> /// <param name="roles">The roles.</param> public void AddUser(string sessionID, string username, string password, string firstname, string lastname, List<string> roles) { UsersTableAdapter uta = new UsersTableAdapter(); int id = (int)((decimal)(uta.InsertAndGetIdentity(username, password, "", firstname, lastname))); foreach (string role in roles) { RolesTableAdapter rta = new RolesTableAdapter(); rta.Insert(id, role); } }
private void initalLogin() { pnlContent.Enabled = false; btnLogin.Enabled = false; var UsersTableAdapter = new UsersTableAdapter(); var users = UsersTableAdapter.GetDataByUserLogIn(cbxUsername.Text.Trim().ToLower(), tbxPassword.Text.Trim().ToLower()); if (users.Count == 0) { this.pnlContent.Enabled = true; this.btnLogin.Enabled = true; this.tbxPassword.Text = String.Empty; MessageBox.Show("ชื่อผู้ใช้หรือรหัสผ่านไม่ถูกต้อง", "ชื่อผู้ใช้หรือรหัสผ่านไม่ถูกต้อง", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { var list = Properties.Settings.Default.fUsernameList; var lists = list.Split('|'); if (lists.Length > 0 && list.Trim().Length != 0) { var result = string.Empty; for (var i = 0; i < lists.Length; i++) { if (!cbxUsername.Text.Trim().Equals(lists[i])) { if (i == 0) { result += lists[i]; } else { result += "|" + lists[i]; } } } result = String.Format("{0}|{1}", cbxUsername.Text.Trim(), result); Properties.Settings.Default.fUsernameList = result; Properties.Settings.Default.Save(); } else { Properties.Settings.Default.fUsernameList = cbxUsername.Text; Properties.Settings.Default.Save(); } var log = new UserLogTableAdapter(); log.Insert(TypeUtil.User, users[0].UserID.ToString(), users[0].UserID, TypeUtil.EVENT_USER_LOGIN, DateTime.Now); MainForm.User = users[0]; DialogResult = System.Windows.Forms.DialogResult.Yes; } }
/// <summary> /// Initializes the Buffer Class /// </summary> public static void Initialize() { _utDisposed = false; _ptDisposed = false; _rqDisposed = false; _userTable = new UsersTableAdapter(); _pkmnTable = new PokemonTableAdapter(); _requTable = new RequirementsTableAdapter(); _userTable.Disposed += (sender, args) => _utDisposed = true; _pkmnTable.Disposed += (sender, args) => _ptDisposed = true; _requTable.Disposed += (sender, args) => _rqDisposed = true; }
public Object QueryUserIdByName(string name) { try { UsersTableAdapter userAdapter = new UsersTableAdapter(); return(userAdapter.QueryUserIdByName(name)); } catch (Exception e) { Log4NetHelper.WriteErrorLog(typeof(UserManager), e); } return(null); }
private void btnFill_Click(object sender, RoutedEventArgs e) { ds = new UserCityDataSet(); UsersTableAdapter daUser = new UsersTableAdapter(); daUser.Fill(ds.Users); CitiesTableAdapter daCity = new CitiesTableAdapter(); daCity.Fill(ds.Cities); dgUser.ItemsSource = ds.Users.DefaultView; dgCity.ItemsSource = ds.Cities.DefaultView; }
public bool DeleteUser(int Original_ID, string usr, string pass) { if (authenticate(usr, pass, 27) == false) { return(false); } try { UsersTableAdapter u = new UsersTableAdapter(); u.DeleteQuery(Original_ID); } catch (Exception e) { return(false); } return(true); }
public bool UpdateUser(string username, string password, int phone, string fname, string lname, short type, string airport, int Original_ID, string usr, string pass) { if (authenticate(usr, pass, 29) == false) { return(false); } try { UsersTableAdapter u = new UsersTableAdapter(); u.UpdateQuery(username, password, phone, fname, lname, type, airport, Original_ID); } catch (Exception e) { return(false); } return(true); }
public bool InsertUser(string username, string password, int phone, string fname, string lname, short type, string airport, string usr, string pass) { if (authenticate(usr, pass, 28) == false) { return(false); } try { UsersTableAdapter u = new UsersTableAdapter(); u.Insert(username, password, phone, fname, lname, type, airport); } catch (Exception e) { return(false); } return(true); }
/// <summary> /// Verify user login /// </summary> /// <param name="username">username</param> /// <param name="password">passsword</param> /// <returns>is login success</returns> public bool VerifyUserLogin(string userName, string password) { UsersTableAdapter userAdapter = new UsersTableAdapter(); int?userNameCheck = userAdapter.VerifyUserName(userName); if (!userNameCheck.HasValue || userNameCheck.Value != onlyOneRecord) { throw new UserNameNotExistentException(); } int?result = userAdapter.VerifyLogin(userName, password); return(result.HasValue && result.Value == onlyOneRecord); }
protected void Login() { UsersTableAdapter ta = new UsersTableAdapter(); DataSet1.UsersDataTable userDataTable = new DataSet1.UsersDataTable(); ta.Fill(userDataTable); string passWord = (userDataTable.AsEnumerable().Where(x => x.userName == TextBoxUser.Text).Select(x => x.password.ToString()).First()); if (TextBoxPw.Text == passWord) { Session["UserName"] = TextBoxUser.Text; Session["PersonName"] = (userDataTable.AsEnumerable().Where(x => x.userName == TextBoxUser.Text).Select(x => x.personName.ToString()).First()); Response.Redirect("OrderPage.aspx", true); } }
protected void CreateNewUser() { UsersTableAdapter ta = new UsersTableAdapter(); ta.Fill(ds.Users); DataRow dr = ds.Users.NewRow(); dr["userName"] = TextBoxUsername.Text; dr["password"] = TextBoxPw.Text; dr["personName"] = TextBoxName.Text; dr["personAddress"] = TextBoxAddress.Text; ds.Tables["Users"].Rows.Add(dr); ta.Update(ds.Users); LabelError.Text = "Account Created Successfully"; Response.Redirect("Default.aspx"); }
private bool InitDataset(string userName, string password) { bool result = false; System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder(Properties.Settings.Default.DetroitConnectionString); builder.UserID = userName; builder.Password = password; builder.IntegratedSecurity = false; Security.Properties.Settings.ChangeConnectionString(builder.ConnectionString); this.logProvider.LogAlert(AlertType.Info, DateTime.Now.ToString() + " --- " + "Security", "builder.ConnectionString = " + builder.ConnectionString); this.logProvider.LogAlert(AlertType.Info, DateTime.Now.ToString() + " --- " + "Security", "DetroitConnectionString = " + Properties.Settings.Default.DetroitConnectionString.ToString()); // test connection ?! // try { string cnStr = builder.ConnectionString; SqlConnection cn = new SqlConnection(); cn.ConnectionString = cnStr; cn.Open(); this.detroit = new Detroit(); this.usersTableAdapter = new UsersTableAdapter(); this.permissionsTableAdapter = new PermissionsTableAdapter(); this.userPermissionsTableAdapter = new UserPermissionsTableAdapter(); result = true; return(result); } catch (SqlException ex) { this.logProvider.LogAlert(AlertType.Info, DateTime.Now.ToString() + " --- " + "Security", "There is no access to SQL database."); //MessageBox.Show("There is no access to SQL database. User \"" + userName + "\". \n Please, try again.", "SQL connecting ...", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } // }
private void btnlogin_Click(object sender, EventArgs e) { if (txbusername.Text != String.Empty && txbpassword.Text != String.Empty) { //do login _userTa = new UsersTableAdapter(); _dt = new DataTable(); _dt = _userTa.DoLogin(txbusername.Text, txbpassword.Text); if (_dt.Rows.Count > 0) { frmManager frm = new frmManager(); frm.Show(); this.Hide(); } } else { MessageBox.Show("Fields musst not be empty"); } }
private void btnLogin_Click(object sender, EventArgs e) { try { UsersTableAdapter myUsersAd = new UsersTableAdapter(); POSDataSet.UsersDataTable myUsersTbl = new POSDataSet.UsersDataTable(); myUsersTbl = myUsersAd.GetUsersDataBy(); bool UserRecordFound = false; foreach (DataRow myRow in myUsersTbl.Rows) { if (myRow["User_Name"].ToString().ToLower().Trim() == txtUserName.Text.ToLower().Trim() && myRow["Password"].ToString().Trim() == txtPassword.Text.Trim()) { global.user_id = Convert.ToInt32(myRow["User_ID"]); global.user_type = Convert.ToByte(myRow["Type"].ToString()); global.user_name = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(myRow["User_Name"].ToString()); global.password = myRow["Password"].ToString().Trim(); UserRecordFound = true; new homescreen().Show(); this.Hide(); //this.Close(); break; } } if (!UserRecordFound) { MessageBox.Show("Invalid User Name/Password\nPlease Try Again"); } } catch (Exception exc) { MessageBox.Show("Unable to Load Database\n" + exc.Message); } }
protected void loginButton_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString); conn.Open(); String checkUser = "******" + username.Text + "'"; SqlCommand com = new SqlCommand(checkUser, conn); int temp = Convert.ToInt32(com.ExecuteScalar().ToString()); conn.Close(); if (temp == 1) { conn.Open(); string checkPassQuery = "select password from Users where username='******'"; SqlCommand comm = new SqlCommand(checkPassQuery, conn); string pass = comm.ExecuteScalar().ToString(); string loginPasswd = passsword.Text; if (pass == loginPasswd) { Session["loggedInUser"] = username.Text; UsersTableAdapter U = new UsersTableAdapter(); string role = U.getRoleByUsername(username.Text); string avatar = U.getImage(username.Text); Session["userRole"] = role; Session["avatar"] = avatar; Response.Write("Passwd is correct"); Response.Redirect("Default.aspx"); } else { gresit.Visible = true; } } else { gresit.Visible = true; } conn.Close(); }
//private static void StartIcon() //{ // var icon = new NotifyIcon(); // icon.Icon = new Icon("Icon.ico"); // icon.Visible = true; // icon.DoubleClick += new EventHandler(Icon_DoubleClick); // icon.Text = "Aura Server Console"; // ShowWindow(GetConsoleWindow(), showWindow ? 0 : 1); //} //private static void Icon_DoubleClick(object sender, EventArgs e) //{ // showWindow = !showWindow; // ShowWindow(GetConsoleWindow(), showWindow ? 0 : 1); //} private static void StartDataBases() { //настраиваем соединения с БД DataBaseCreator creator = new DataBaseCreator(); creator.CreateDataBaseForLogs(dbForLogsFileName); creator.CreateMainDataBase(dbFileName); creator.UpdateTables(dbFileName); creator = null; LogManager.Instance.InitializeLogManager(dbForLogsFileName); dataBase = new DataBaseManager(); dataBase.ConnectToDataBase(dbFileName); usersDataBase = new UsersTableAdapter(dataBase); purchasesDataBase = new PurchasesTableAdapter(dataBase); organisationsDataBase = new OrganisationsDataBaseAdapter(dataBase); reportsDataBaseAdapter = new ReportsDataBaseAdapter(dataBase); Console.WriteLine("Connection to DBs established successfully"); }
/// <summary> /// Changes the user password. /// </summary> /// <param name="sessionID">The sessionID of the current session</param> /// <param name="EmployeeID">The employee ID.</param> /// <param name="password">The new password.</param> public void ChangeUserPassword(string sessionID, int EmployeeID, string password) { UsersTableAdapter uta = new UsersTableAdapter(); uta.UpdatePassword(password, EmployeeID); }
public DatabaseUsers() { Adapter = new UsersTableAdapter(); }
/// <summary> /// Removes the user. /// </summary> /// <param name="sessionID">The sessionID of the current session</param> /// <param name="EmployeeID">The employee ID.</param> public void RemoveUser(string sessionID, int EmployeeID) { UsersTableAdapter uta = new UsersTableAdapter(); uta.DeleteUser(EmployeeID); }
/// <summary> /// Gets all employees. /// </summary> /// <param name="sessionID">The sessionID of the current session</param> /// <returns></returns> public List<EmployeeData> GetAllEmployees(string sessionID) { UsersTableAdapter uta = new UsersTableAdapter(); List<EmployeeData> re = new List<EmployeeData>(); var rows = uta.GetData(); foreach (var row in rows) { EmployeeData ed = new EmployeeData(); ed.id = row.ID; ed.name = row.FirstName + " " + row.LastName; ed.roles = getRoles(row.ID); ed.username = row.Username; re.Add(ed); } return re; }
public User GetUserByID(int ID) { List<User> lstUsers = new List<User>(); UsersTableAdapter usersAdapter = new UsersTableAdapter(); PostAroundMeDataSet.UsersDataTable dtResult = usersAdapter.GetUserByID(ID); lstUsers = UserTranslator(dtResult); return lstUsers.FirstOrDefault(); }
public int GetUserIdByFacebookId(string fid) { int retVal = 0; UsersTableAdapter usersAdapter = new UsersTableAdapter(); Object obj = usersAdapter.GetUserIdByFacebookId(fid); if (obj != null) retVal = Convert.ToInt32(obj); return retVal; }
public int InsertUpdateUser(User user) { int result = 0; UsersTableAdapter usersAdapter = new UsersTableAdapter(); Object obj = usersAdapter.InsertUpdateUser(user.firstName, user.lastName, user.email, user.phone1, user.phone2, user.address, user.longtitude, user.latidute, user.avatarImageUrl, user.gender, user.facebookID, user.birthday, user.regDate, user.link, user.timezone, user.facebookToken); if (obj != null) result = Convert.ToInt32(obj); return result; }
public Object queryUserIdByName(string name) { UsersTableAdapter userAdapter = new UsersTableAdapter(); return(userAdapter.QueryUserIdByName(name)); }
private void btnModify_Click(object sender, RoutedEventArgs e) { UsersTableAdapter daUser = new UsersTableAdapter(); daUser.Update(ds.Users); }
/// <summary> /// Gets the payrole report. /// </summary> /// <param name="sessionID">The sessionID of the current session</param> /// <param name="startTime">The start time of the report.</param> /// <param name="endTime">The end time of the report.</param> /// <returns></returns> public PayroleReport GetPayroleReport(string sessionID, DateTime startTime, DateTime endTime) { PayroleReport re = new PayroleReport(); UsersTableAdapter uta = new UsersTableAdapter(); RolePayrateTableAdapter rta = new RolePayrateTableAdapter(); var payoutTable = rta.GetData(); var employees = uta.GetData(); decimal totalPayout = 0; re.Employees = new List<EmployeePayout>(); foreach (var employee in employees) { EmployeePayout ep = GetEmployeePayout(employee, startTime, endTime, payoutTable); if (ep != null) { totalPayout += ep.TotalPayment; re.Employees.Add(ep); } } re.TotalPayout = totalPayout; re.StartReportTimeframe = startTime; re.EndReportTimeframe = endTime; return re; }
public LoginWindow(UsersTableAdapter dataBase) { InitializeComponent(); usersDataBase = dataBase; }
public UsersDataBaseForm(UsersTableAdapter adapter) { InitializeComponent(); this.adapter = adapter; ReloadTable(adapter.GetUsersInTable()); }