private void btnAdd_Click(object sender, EventArgs e) { u.FirstName = txtFirstname.Text; u.LastName = txtLastname.Text; u.Username = txtUsername.Text; u.Password = txtPassword.Text; u.Email = txtEmail.Text; u.Contact = Convert.ToInt32(txtContact.Text); u.Gender = cmbGender.Text; u.Address = txtAddress.Text; u.UserType = cmbUserType.Text; u.DateTime = DateTime.Now; // Inserting in to database bool success = dal.Insert(u); // If the data is successfully inserted then the value of success will be true else it will be false if (success == true) { //Data successfully inserted MessageBox.Show("User successfully Added."); Clear(); } else { //Fail to insert Data MessageBox.Show("Fail To Add User Try Again."); } //Refresh Data grid View DataTable dt = dal.Select(); dgvUser.DataSource = dt; }
private void btnAdd_Click(object sender, EventArgs e) { //get the values from the UI u.full_name = textBoxFullName.Text; u.email = textBoxEmail.Text; u.username = textBoxUsername.Text; u.password = textBoxPassword.Text; u.contact = textBoxContact.Text; u.address = textBoxAddress.Text; u.added_date = DateTime.Now; u.image_name = imageName; //adding the values from the UI to database //boolean variable to check wether the data is inserted successfully or not bool success = dal.Insert(u); //check wether the data is inserted successfully or not if (success == true) { //data or user added successfully MessageBox.Show("New user added successfully."); //display the user in data grid view DataTable dt = dal.Select(); dgvUsers.DataSource = dt; //clear textboxes Clear(); } else { //failed to add a new user MessageBox.Show("Failed to add new user."); } }
private void btnAdd_Click(object sender, EventArgs e) { u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; string loggedInUser = Login.loggedIn; userBLL usr = dal.GetIDFromUsername(loggedInUser); u.added_by = usr.id; bool success = dal.Insert(u); if (success == true) { MessageBox.Show("User created Successfully."); clear(); } else { MessageBox.Show("Failed to add new User!!"); } DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btnAdd_Click(object sender, EventArgs e) { u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; string loggedUser = frmLogin.loggedIn; userBLL usr = dal.GetIDFromUsername(loggedUser); u.added_by = usr.id; bool success = dal.Insert(u); if (success == true) { MessageBox.Show("ทำการบันทึกข้อมูลผู้ใช้งานเรียบร้อยแล้ว"); clear(); } else { MessageBox.Show("ไม่สามารถทำการบันทึกข้อมูลผู้ใช้งานได้! กรุณาลองใหม่อีกครั้ง"); } DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btnAdd_Click(object sender, EventArgs e) { //Step 1: Get the Values from UI u.full_name = txtFullName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.added_date = DateTime.Now; u.image_name = imageName; //Step2: Adding the Values from UI to the Database //Create a Boolean Variable to check whether the data is inserted successfully or not bool success = dal.Insert(u); //Step 3: Check whether the Data is Inserted Successfully or Not if (success == true) { //Data or User Added Successfully MessageBox.Show("New User added Successfully."); //Display the user in DataGrid View DataTable dt = dal.Select(); dgvUsers.DataSource = dt; //Clear TextBoxes Clear(); } else { //Failed to Add User MessageBox.Show("Failed to Add New User."); } }
private void btnCadastro_Click(object sender, EventArgs e) { u.pr_nome = txtFirstName.Text; u.sb_nome = txtLastName.Text; u.email = txtEmail.Text; u.user_name = txtUserName.Text; u.password = txtSenha.Text; u.contato = txtContato.Text; u.nm_endereco = txtEndereco.Text; u.sexo = cbxSexo.Text; u.user_type = cbxTpUser.Text; u.data = DateTime.Now; u.add_por = 1; bool sucess = dal.Insert(u); if (sucess = true) { MessageBox.Show("Usuário cadastrado com sucesso"); Limpar(); } else { MessageBox.Show("Não foi possivel cadastrar esse usuário"); } DataTable dt = dal.Select(); dgvUser.DataSource = dt; }
private void FrmUsers_Load(object sender, EventArgs e) { //Display users on load DataTable dt = dal.Select(); userDataGrid.DataSource = dt; }
private void textBox1_TextChanged(object sender, EventArgs e) { String keywords = txtSearch.Text; if (keywords != null) { DataTable dt = dal.Search(keywords); dgvUsers.DataSource = dt; } else { DataTable dt = dal.Select(); dgvUsers.DataSource = dt; } }
private void LoadUserList(DataGridView dgv) { DataTable dt = dalUser.Select(); dgv.Rows.Clear(); foreach (DataRow user in dt.Rows) { int n = dgv.Rows.Add(); dgv.Rows[n].Cells[dalUser.UserID].Value = user[dalUser.UserID].ToString(); dgv.Rows[n].Cells[dalUser.Username].Value = user[dalUser.Username].ToString(); dgv.Rows[n].Cells[dalUser.Permission].Value = user[dalUser.Permission].ToString(); dgv.Rows[n].Cells[dalUser.AddedDate].Value = user[dalUser.AddedDate].ToString(); dgv.Rows[n].Cells[dalUser.UpdatedDate].Value = user[dalUser.UpdatedDate].ToString(); dgv.Rows[n].Cells[dalUser.UpdatedBy].Value = user[dalUser.UpdatedBy].ToString(); if (Convert.ToInt32(user[dalUser.AddedBy]) <= 0) { dgv.Rows[n].Cells[dalUser.AddedBy].Value = "ADMIN"; } else { dgv.Rows[n].Cells[dalUser.AddedBy].Value = dalUser.getUsername(Convert.ToInt32(user[dalUser.AddedBy])); } if (int.TryParse(user[dalUser.UpdatedBy].ToString(), out int by)) { dgv.Rows[n].Cells[dalUser.UpdatedBy].Value = dalUser.getUsername(Convert.ToInt32(user[dalUser.UpdatedBy])); } } tool.listPaint(dgv); }
private void btnAdd_Click(object sender, EventArgs e) { //empty form error message if (txtFirstName.Text == "" || txtLastName.Text == "" || txtEmail.Text == "" || txtUsername.Text == "" || txtPassword.Text == "" || txtContact.Text == "" || txtAddress.Text == "") { MessageBox.Show("Please fill your detail first", "Error", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { //Gettting Data FRom UI u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; //Getting Username of the logged in user string loggedUser = frmLogin.loggedIn; userBLL usr = dal.GetIDFromUsername(loggedUser); u.added_by = usr.id; //Inserting Data into DAtabase bool success = dal.Insert(u); //If the data is successfully inserted then the value of success will be true else it will be false if (success == true) { //Data Successfully Inserted MessageBox.Show("User successfully created."); clear(); } else { //Failed to insert data MessageBox.Show("Failed to add new user"); } //Refreshing Data Grid View DataTable dt = dal.Select(); dgvUsers.DataSource = dt; } }
private void btnAdd_Click(object sender, EventArgs e) { // Getting Data from UI u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUserName.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbBoxGender.Text; u.user_type = cmbBoxUserType.Text; u.added_date = DateTime.Now; // Getting Username of the logged in user string loggedUser = frmLogin.loggedIn; userBLL usr = dal.GetIDFromUsername(loggedUser); u.added_by = usr.id; // Inserting Data into Database. we will declare one variable success which will take data to DAL bool success = dal.Inset(u); // now we wil ltest our condition that if data is successfully inserted, then good , otherwise it will be false if (success == true) { // Data Successfully inserted then the value will be true else will be false MessageBox.Show("User successfully Created"); // Here we will call clear method clear(); } else { // falied MessageBox.Show("Falied to add new user"); } // Refreshing Data Grid View.we will create a temporary storage data table to store data. DataTable dt = dal.Select(); // this will refer the data grid view dgvUsers.DataSource = dt; }
private void buttonAdd_Click(object sender, EventArgs e) { //on add get the text input u.username = textBoxUsername.Text; u.first_name = textBoxFirstName.Text; u.last_name = textBoxLastName.Text; u.email = textBoxEmail.Text; u.address = textBoxAddress.Text; u.mobile = textBoxMobile.Text; switch (comboBoxGender.SelectedIndex) { case 0: u.gender = "Male"; break; case 1: u.gender = "Female"; break; case 2: u.gender = "Others"; break; } u.enrolled_date = dateTimePickerEnrolledDate.Value; u.membership_expiry_date = dateTimePickerExpiryDate.Value; u.num_books_borrowed = int.Parse(textBoxBooksBorrowed.Text); bool success = dal.Insert(u); if (success) { MessageBox.Show("New User Added Successfully"); //display the user in DataGrid view DataTable dt = dal.Select(); dataGridViewUsers.DataSource = dt; //clear the text inputs Clear(); } else { MessageBox.Show("Failed to Add New User"); } }
private void textBox1_TextChanged_1(object sender, EventArgs e) { string keywords = txtBoxSearch.Text; //check if the keywords has value if (keywords != null) { //Show user based on keywords DataTable dataTable = userDAL.Search(keywords); dgvUser.DataSource = dataTable; } else { //show all users from the database DataTable dataTable = userDAL.Select(); dgvUser.DataSource = dataTable; } }
private void frmUsers_Load(object sender, EventArgs e) { DataTable dt = dal.Select(); dgvUser.DataSource = dt; dgvUser.Columns[0].HeaderText = "ID"; dgvUser.Columns[1].HeaderText = "NOME"; dgvUser.Columns[2].HeaderText = "SOBRENOME"; dgvUser.Columns[3].HeaderText = "E-MAIL"; dgvUser.Columns[4].HeaderText = "USUÁRIO"; dgvUser.Columns[5].HeaderText = "SENHA"; dgvUser.Columns[6].HeaderText = "TELEFONE"; dgvUser.Columns[7].HeaderText = "ENDEREÇO"; dgvUser.Columns[8].HeaderText = "SEXO"; dgvUser.Columns[9].HeaderText = "TIPO USUÁRIO"; dgvUser.Columns[10].HeaderText = "DATA/HORA"; dgvUser.Columns[11].HeaderText = "CADASTRADO POR"; }
private void button2_Click(object sender, EventArgs e) { if (lblUserType.Text == "Student") { userType = "Student"; } else if (lblUserType.Text == "Tutor") { userType = "Tutor"; } if (txtpassword.Text == txtrepassword.Text) { u.fullname = txtFullName.Text; u.address = txtAddress.Text; u.dob = dateTimePicker1.Value; u.parentName = txtParentName.Text; u.tell = txtTel.Text; u.username = txtusername.Text; u.password = txtpassword.Text; u.userType = lblUserType.Text; bool success = dal.Insert(u); if (success == true) { MessageBox mb = new MessageBox("User Added Successfully!!!", sampleframe.cs.MessageBox.MsgType.success); mb.Show(); clear(); Login f4 = new Login(); f4.Show(); this.Visible = false; } else { MessageBox mb = new MessageBox("Fail to Added!!!", sampleframe.cs.MessageBox.MsgType.retry); mb.Show(); } DataTable dt = dal.Select(); } else { MessageBox mb = new MessageBox("Passwords are not matched!!!", sampleframe.cs.MessageBox.MsgType.retry); mb.Show(); } }
private void btnAdd_Click(object sender, EventArgs e) { u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUserName.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = comboGender.Text; u.user_type = comboUserType.Text; u.added_date = DateTime.Now; string loggedUser = frmLogin.loggedIn; userBLL usr = dal.GetIdFromUsername(loggedUser); u.added_by = loggedUser; if (u.user_type == "") { MassageBox mb = new MassageBox("Added Failed", MsgType.retry); mb.Show(); } else { bool success = dal.Insert(u); if (success == true) { MassageBox mb = new MassageBox("Added Success", MsgType.success); mb.Show(); //MessageBox.Show("User Added Successfully!!!"); clear(); } else { MassageBox mb = new MassageBox("Added Failed", MsgType.retry); mb.Show(); //MessageBox.Show("Fail to Added!!!"); } } DataTable dt = dal.Select(); dgvUser.DataSource = dt; }
private void btnAdd_Click(object sender, EventArgs e) { //Getting username of the logged in user string loggedUser = frmLogin.loggedIn; //Getting Data from UI u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; //Getting Username of the logged in user string loggeduser = frmLogin.loggedIn; userBLL usr = dal.GetIDFromUsername(loggedUser); u.added_by = usr.id; //Inserting Data into Database bool success = dal.Insert(u); //If the data is successfully inserted then the value will be true else it will be false if (success == true) { //Data Successfully Inserted MessageBox.Show("User Suuccessfully Created"); clear(); } else { //Failed to Insert Data MessageBox.Show("Failed to Add New User"); } //Refresing DatagridView DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btnAdd_Click(object sender, EventArgs e) { //Getting Username of the logged in user string loggedUser = frmLogin.loggedIn; // Getting Data From UI // We will use BLL Object here u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; // This DateTime.Now will show the current date when user adds data userBLL usr = dal.GetIDFromUsername((loggedUser)); u.added_by = usr.id; // currently we don't have user id so we wil put it later ***** We have fixed it and we have user id now //Inserting Data into Database bool sucess = dal.Insert(u); // If the data is sucessfully inserted then the value will be true else it will be false if (sucess == true) { //Data Sucessfully Inserted MessageBox.Show("User Sucessfully Added"); clear(); } else { // Failed to insert data MessageBox.Show("Failed to Add New User"); } //Refreshing Data Grid View DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btnAdd_Click(object sender, EventArgs e) { //getting data from UI u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.Email_id = txtEmail_id.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.gender = cmbGender.Text; u.user_type = cmbUserType.Text; u.added_date = DateTime.Now; //getting username of the logged in user string loggedUser = frmLogin.loggedIn; userBLL usr = dal.GetIDFromUsername(loggedUser); u.added_by = usr.id; //inserting data into database bool success = dal.Insert(u); //if the data is successfully inserted then the value of success will be trueelse it will be false if (success == true) { //data successfully inserted MessageBox.Show("user successfully created"); clear(); } else { //failed to inserted data MessageBox.Show("failed to add new user"); } //refreshing data grid view DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void button1_Click(object sender, EventArgs e) { // Getting userID //update string loggedUser = frmLogin.loggedIn; // Geting data from UI u.first_name = textBox1.Text; u.last_name = textBox2.Text; u.email = textBox3.Text; u.username = textBox4.Text; u.password = textBox5.Text; u.contact = textBox6.Text; u.address = textBox7.Text; u.gender = comboBox1.Text; u.user_type = comboBox2.Text; u.added_date = DateTime.Now; // String loggedUser = frmLogin.loggedIn; userBLL usr = dal.GetIdFromUsername(loggedUser); u.added_by = usr.id; //Inserting data into database bool success = dal.Insert(u); if (success == true) { //data inserted sucesfully MessageBox.Show("User Added Succesfully"); clear(); } else { //error occured MessageBox.Show("Sorry..!! , Failed to add user"); } DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void btnAdd_Click(object sender, EventArgs e) { //..........................................Getting Data from UI......................................... u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAddress.Text; u.user_type = cnbUserType.Text; u.added_date = DateTime.Now; u.gender = cnbGender.Text; //Getting User Name From Logged In User string LoggedInUser = frmLogin.LoggedIn; userBLL usr = daL.GetIDFromUserName(LoggedInUser); u.added_by = usr.id; //Inserting Data into Database bool success = daL.Insert(u); //if data is successfully inserted value of success will be true if (success == true) { MessageBox.Show("User succesfully created."); clear(); } else { MessageBox.Show("Failed to create user"); } //Refreshing Data Grid View DataTable dt = daL.Select(); dgvUsers.DataSource = dt; }
private void btnAdd_Click(object sender, EventArgs e) { //Getting UserName of the loggedIn User string loggedUser = frmLogin.LoggedInUserName; //Getting the UserID basedon the UserNAme UserBll usr = userDl.GetIDFromUsername(loggedUser); //Getting data from UI userBl.firstName = txtFirstName.Text; userBl.lastName = txtLastName.Text; userBl.email = txtEmail.Text; userBl.userName = txtUserName.Text; userBl.passWord = txtpassword.Text; userBl.Contact = txtContact.Text; userBl.address = txtAdress.Text; userBl.gender = cmbGender.Text; userBl.user_type = cmbUserType.Text; userBl.addedDate = DateTime.Now; userBl.addedBy = usr.id; //inserting Data into DATABASE bool success = userDl.Insert(userBl); //if the data SuccessFully inserted then Success will be True if (success == true) { MessageBox.Show("User SuccessFully Created"); clear(); } else { MessageBox.Show("Failed!!!! to Add User"); } //Refreshing Data Grid View DataTable DT = userDl.Select(); dgvUsers.DataSource = DT; }
private void btnAdd_Click(object sender, EventArgs e) { string loggedUser = frmLogin.loggedIn; userBLL usr = dal.GetIDFromUSername(loggedUser); //Getting data from UI u.first_name = txtFirstName.Text; u.last_name = txtLastName.Text; u.email = txtEmail.Text; u.username = txtUsername.Text; u.password = txtPassword.Text; u.contact = txtContact.Text; u.address = txtAdress.Text; u.gender = cmbGender.Text; u.user_type = cmbUsertype.Text; u.added_date = DateTime.Now; u.added_by = usr.id; //Inserting data in to DB bool success = dal.Insert(u); if (success == true) { MessageBox.Show("User succesfully created"); clear(); } else { MessageBox.Show("Failed to add new user"); } //Refreshing Data Grid View DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }
private void Form1_Load(object sender, EventArgs e) { bool bit = true; if (bit) { tbl_users u = new tbl_users { first_name = "name", last_name = "name" }; dal.Insert(u); List <tbl_users> query = dal.Select(); foreach (var item in query) { textBox1.Text = textBox1.Text + Environment.NewLine + item.Id + " " + item.first_name; } } else { var user = new tbl_users { first_name = "firstname2" }; db.tbl_users.Add(user); db.SaveChanges(); // Display all Blogs from the database var query = from b in db.tbl_users orderby b.first_name select b; foreach (var item in query) { textBox1.Text = textBox1.Text + Environment.NewLine + item.Id + " " + item.first_name; } } }
private void refreshDataGridView(string type = null) { DataTable dt = type != null?dal.Search(type) : dal.Select(); dgvUsers.DataSource = dt; }
private void FrmUsers_Load(object sender, EventArgs e) { DataTable dt = dal.Select(); dgvUsers.DataSource = dt; }