private void ViewMemberMenu_Click(object sender, EventArgs e)
{
Connection.Close();
Boolean flag = false;
string query1 = "Select ID from member;";
Connection.Open();
Command1 = new SqlCommand(query1, Connection);
SqlDataReader result1 = Command1.ExecuteReader();
while (result1.Read())
{
string id = result1["ID"].ToString();
flag = true;
}
if (!flag)
{
var w = new Form()
{
Size = new Size(0, 0)
};
Task.Delay(TimeSpan.FromSeconds(1))
.ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext());
MessageBox.Show(w, "No member available");
}
if (flag)
{
ViewUsers c = new ViewUsers();
if (!Window.Controls.Contains(c))
{
Window.Controls.Add(c);
c.Dock = DockStyle.Fill;
c.BringToFront();
}
else
{
c.BringToFront();
}
}
Connection.Close();
}
private void NewMemberSaveButton_Click(object sender, EventArgs e)
{
ArrayList User = new ArrayList();
string Username = UserNameTextBox.Text;
string Userid = UserIDTextBox.Text;
string UseremailAddress = UserEmailTextBox.Text;
string UsercarID = VehicleIDTextBox.Text;
string UserVehicleName = VehicleNameTextBox.Text;
string UserVehicleModel = VehicleModelTextBox.Text;
string UserVehicleColour = VehicleColorTextBox.Text;
string UserGender = "";
Boolean flag = false;
if (MaleUser.Checked)
{
UserGender = "Male";
}
if (FemaleUser.Checked)
{
UserGender = "Female";
}
Boolean empty = string.IsNullOrEmpty(Username) || string.IsNullOrEmpty(Userid) || string.IsNullOrEmpty(UseremailAddress) || string.IsNullOrEmpty(UsercarID) || string.IsNullOrEmpty(UserVehicleName) || string.IsNullOrEmpty(UserVehicleModel) || string.IsNullOrEmpty(UserVehicleColour) || string.IsNullOrEmpty(UserGender);
string query = "select ID from member where ID= '" + Userid + "';";
Connection.Open();
Command = new SqlCommand(query, Connection);
SqlDataReader result = Command.ExecuteReader();
while (result.Read())
{
string id = result["ID"].ToString();
flag = true;
}
Connection.Close();
if (empty)
{
var w = new Form()
{
Size = new Size(0, 0)
};
Task.Delay(TimeSpan.FromSeconds(1))
.ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext());
MessageBox.Show(w, "Please fill all the fields");
}
else if (flag)
{
var w = new Form()
{
Size = new Size(0, 0)
};
Task.Delay(TimeSpan.FromSeconds(1))
.ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext());
MessageBox.Show(w, "ID already exist");
}
else
{
User.Add(Username);
User.Add(Userid);
User.Add(UseremailAddress);
User.Add(UserGender);
User.Add(UsercarID);
User.Add(UserVehicleName);
User.Add(UserVehicleModel);
User.Add(UserVehicleColour);
database.InsertNewUser(User);
var w = new Form()
{
Size = new Size(0, 0)
};
Task.Delay(TimeSpan.FromSeconds(1))
.ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext());
MessageBox.Show("User Added successfully");
ViewUsers vu = new ViewUsers();
vu.LoadData();
}
}
