private void btnInsert_Click(object sender, EventArgs e)
{
u.Username = txtUsername.Text;
u.Password = txtPassword.Text;
u.FirstName = txtFirstName.Text;
u.MiddleName = txtMiddleName.Text;
u.LastName = txtLastName.Text;
u.Address = txtAddress.Text;
u.Email = txtEmail.Text;
u.Birthdate = dtpBirthdate.Value;
u.SecurityQuestion = drpSecurityQuestion.Text;
u.SecurityAnswer = txtSecurityAnswer.Text;
u.ID = txtID.Text;
if (u.IncompleteUserData() == 1)
{
MessageBox.Show("Please fill all boxes!");
}
else if (u.EmailError() == 1)
{
MessageBox.Show(u.InvalidEmail());
}
else
{
u.UserInsert();
rdoAdmin.Checked = true;
View();
Clear();
}
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
UserLibrary u = new UserLibrary();
int Upload = 0;
foreach (DataGridViewRow row in dgvUserUpload.Rows)
{
u.GENID = u.UserID();
for (int i = 0; i < row.Cells.Count; i++)
{
if (row.Cells[i].Value == null || row.Cells[i].Value == DBNull.Value || String.IsNullOrWhiteSpace(row.Cells[i].Value.ToString()))
{
}
else
{
if (Convert.ToInt32(row.Cells[5].Value) == 110)
{
u.ID = "AD-" + (u.UserID() + 1).ToString().PadLeft(5, '0');
}
else if (Convert.ToInt32(row.Cells[5].Value) == 111)
{
u.ID = "TR-" + (u.UserID() + 1).ToString().PadLeft(5, '0');
}
else if (Convert.ToInt32(row.Cells[5].Value) == 112)
{
u.ID = "ST-" + (u.UserID() + 1).ToString().PadLeft(5, '0');
}
u.Username = row.Cells[0].Value.ToString();
u.Password = "******";
u.FirstName = row.Cells[1].Value.ToString();
u.MiddleName = row.Cells[2].Value.ToString();
u.LastName = row.Cells[3].Value.ToString();
u.ContactNumber = row.Cells[4].Value.ToString();
u.Usertype = Convert.ToInt32(row.Cells[5].Value);
Upload = 1;
}
}
if (Upload == 1)
{
u.UserInsert();
Upload = 0;
}
}
}