private void TryLogin(string Username, string Password)
{
cnn = new SqlConnection(connectionString);
var sql = @"Select * FROM Users WHERE Username = '******'";
OpenConnection();
cmd = new SqlCommand(sql, cnn);
cmd.ExecuteNonQuery();
dataReader = cmd.ExecuteReader();
//if (!dataReader.Read()) { MessageBox.Show("No user by that name found."); }
while (dataReader.Read())
{
if ((Username == dataReader.GetValue(4).ToString()) && (Password == dataReader.GetValue(5).ToString()))
{
MessageBox.Show("Welcome " + dataReader.GetValue(1).ToString() + "!");
frmParent parent = (frmParent)this.Owner;
this.userID = Int32.Parse(dataReader.GetValue(0).ToString());
this.adminP = Convert.ToBoolean(dataReader.GetValue(3));
this.username = dataReader.GetValue(1).ToString();
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show("Incorrect login credentials. Please try again.");
txtPassword.Clear();
}
}
cnn.Close();
}
private void ViewMaintainToolStripMenuItem_Click(object sender, EventArgs e)
{
frmMaintainClient maintainClient = new frmMaintainClient();
frmParent parent = this;
maintainClient.MdiParent = parent;
maintainClient.Show();
}
private void MaintainVehicleToolStripMenuItem_Click(object sender, EventArgs e)
{
frmSearchVehicles searchVehicle = new frmSearchVehicles();
frmParent parent = this;
searchVehicle.MdiParent = parent;
searchVehicle.Show();
}
private void RegionToolStripMenuItem_Click(object sender, EventArgs e)
{
frmRegionDetails regionDetails = new frmRegionDetails();
frmParent parent = this;
regionDetails.MdiParent = parent;
regionDetails.Show();
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
maintain = new frmMaintainParcels();
frmParent parent = this;
maintain.MdiParent = parent;
maintain.Show();
}
private void DeliveriesToolStripMenuItem_Click(object sender, EventArgs e)
{
frmMaintainDeliveries maintain = new frmMaintainDeliveries(getUserID());
frmParent parent = this;
maintain.MdiParent = parent;
maintain.Show();
}
private void AllocateParcelsToVehiclesToolStripMenuItem_Click(object sender, EventArgs e)
{
frmAssignParcels maintain = new frmAssignParcels(getUserID());
frmParent parent = this;
maintain.MdiParent = parent;
maintain.Show();
}
private void MaintainUserToolStripMenuItem_Click(object sender, EventArgs e)
{
frmSearchUser searchUsers = new frmSearchUser();
frmParent parent = this;
searchUsers.MdiParent = parent;
searchUsers.Show();
}
private void DeliverParcelsToolStripMenuItem_Click(object sender, EventArgs e)
{
frmDeliverParcels deliver = new frmDeliverParcels();
frmParent parent = this;
deliver.MdiParent = parent;
deliver.Show();
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
frmMaintainParcels parcel = new frmMaintainParcels(getUserID());
frmParent parent = this;
parcel.MdiParent = parent;
parcel.Show();
}
private void HistoricalParcelsToolStripMenuItem_Click(object sender, EventArgs e)
{
frmReport report = new frmReport();
frmParent parent = this;
report.MdiParent = parent;
report.Show();
}
private void ReportingToolStripMenuItem1_Click(object sender, EventArgs e)
{
frmDeliveryReport deliveryReport = new frmDeliveryReport();
frmParent parent = this;
deliveryReport.MdiParent = parent;
deliveryReport.Show();
}
private void addToolStripMenuItem1_Click(object sender, EventArgs e)
{
frmMaintainClient client = new frmMaintainClient();
frmClientDetails details = new frmClientDetails(client);
frmParent parent = this;
details.MdiParent = parent;
details.Show();
}
private void addToolStripMenuItem_Click(object sender, EventArgs e)
{
frmMaintainParcels parcels = new frmMaintainParcels(getUserID());
frmParcelDetails details = new frmParcelDetails(parcels, true, getUserID());
frmParent parent = this;
details.MdiParent = parent;
details.Show();
}
private void addToolStripMenuItem_Click(object sender, EventArgs e)
{
maintain = new frmMaintainParcels();
frmParent parent = this;
frmParcelDetails details = new frmParcelDetails(maintain);
details.disableButton(true);
details.MdiParent = parent;
details.Show();
}
private void AddNewVehicleToolStripMenuItem_Click(object sender, EventArgs e)
{
frmMaintainVehicles vehicle = new frmMaintainVehicles();
frmParent parent = this;
vehicle.setMode("add");
vehicle.clearForm();
vehicle.MdiParent = parent;
vehicle.Show();
}
private void AddNewUserToolStripMenuItem_Click(object sender, EventArgs e)
{
frmSearchUser user = new frmSearchUser();
frmMaintainUsers users = new frmMaintainUsers(user);
frmParent parent = this;
users.setMode("add");
users.clearForm();
users.MdiParent = parent;
users.Show();
}
private void AddToolStripMenuItem1_Click(object sender, EventArgs e)
{
frmMaintainClient maintain = new frmMaintainClient();
frmParent parent = this;
maintain.MdiParent = parent;
frmClientDetails details = new frmClientDetails(maintain, true);
details.MdiParent = parent;
details.Show();
}
private void MaintainToolStripMenuItem1_Click(object sender, EventArgs e)
{
//maintain user
if (getUserAdmin() == false)
{
MessageBox.Show("Access denied: Only admin users have access to this feature");
}
else
{
frmSearchUser searchUsers = new frmSearchUser();
frmParent parent = this;
searchUsers.MdiParent = parent;
searchUsers.Show();
}
}
private void AddToolStripMenuItem2_Click(object sender, EventArgs e)
{
//add new user
if (getUserAdmin() == false)
{
MessageBox.Show("Access denied: Only admin users have access to this feature");
}
else
{
frmSearchUser user = new frmSearchUser();
frmMaintainUsers users = new frmMaintainUsers(user);
frmParent parent = this;
users.setMode("add");
users.clearForm();
users.MdiParent = parent;
users.Show();
}
}
