private void clear()
{
PrivilegeID.Text = "";
PrivilegeName.Text = "";
PrivilegeType.SelectedIndex = 0;
PrivilegeID.Focus();
}
private void Main_Menu_Load(object sender, EventArgs e)
{
timer1.Start();
string PrivilegeDescription;
int PrivilegeID;
string Name;
string Surname;
lblDate.Text = System.DateTime.Now.ToLongDateString();
//Get Privilege
SqlConnection sqlcon = new SqlConnection(Globals.ConnectionString);
sqlcon.Open();
string cmd = "SELECT PrivilegeID, Name, Surname FROM Users WHERE UserID ='" + Globals.UserID.ToString() + "'";
SqlCommand sqlcom = new SqlCommand(cmd, sqlcon);
SqlDataReader dr = sqlcom.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
PrivilegeID = Convert.ToInt32((dr["PrivilegeID"]));
Name = (dr["Name"].ToString());
Surname = (dr["Surname"].ToString());
lblUser.Text = Name + " " + Surname;
//Get Description
SqlConnection sqlcon2 = new SqlConnection(Globals.ConnectionString);
sqlcon2.Open();
string cmd2 = "SELECT PrivilegeDescription FROM Privilege WHERE PrivilegeID ='" + PrivilegeID.ToString() + "'";
SqlCommand sqlcom2 = new SqlCommand(cmd2, sqlcon2);
SqlDataReader dr2 = sqlcom2.ExecuteReader();
if (dr2.HasRows)
{
while (dr2.Read())
{
PrivilegeDescription = (dr2["PrivilegeDescription"].ToString());
if (PrivilegeDescription == "Administrator" || PrivilegeDescription == "Manager")
{
mtManagerFeatures.Enabled = true;
}
else
{
mtManagerFeatures.Enabled = false;
}
}
}
dr2.Close();
sqlcon2.Close();
}
}
dr.Close();
sqlcon.Close();
//Check if Daily First Login
SqlConnection sqlcon3 = new SqlConnection(Globals.ConnectionString);
sqlcon3.Open();
string cmd3 = "SELECT HasLoggedIn From DailyLogin WHERE Date ='" + lblDate.Text + "' AND UserID ='" + Globals.UserID.ToString() + "'";
SqlCommand sqlcom3 = new SqlCommand(cmd3, sqlcon3);
SqlDataReader dr3 = sqlcom3.ExecuteReader();
if (dr3.HasRows)
{
while (dr3.Read())
{
int HasLoggedIn = Convert.ToInt32((dr3["HasLoggedIn"]));
if (HasLoggedIn == 2)
{
}
else
{
Capture_Float_Amount myform = new Capture_Float_Amount();
myform.ShowDialog();
}
}
}
dr3.Close();
sqlcon3.Close();
}
private void UserInfo()
{
string Name;
string Surname;
string PhoneNumber;
string EmailAddress;
string UserName;
string UserPassword;
int PrivilegeID;
int GenderID;
int TitleID;
string GenderDescription;
int UserTypeID;
string PrivilegeDescription;
string UserTypeDescription;
string TitleDescription;
SqlConnection sqlcon = new SqlConnection(Globals.ConnectionString);
sqlcon.Open();
string cmd = "SELECT * FROM Users Where UserID ='" + Globals.SelectedUserID.ToString() + "'";
SqlCommand sqlcom = new SqlCommand(cmd, sqlcon);
SqlDataReader dr = sqlcom.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
// try
// {
Name = (dr["Name"].ToString());
Surname = (dr["Surname"].ToString());
PhoneNumber = (dr["PhoneNumber"].ToString());
UserName = (dr["UserName"].ToString());
UserPassword = (dr["UserPassword"].ToString());
PrivilegeID = Convert.ToInt32((dr["PrivilegeID"]));
GenderID = Convert.ToInt32((dr["GenderID"]));
TitleID = Convert.ToInt32((dr["TitleID"]));
UserTypeID = Convert.ToInt32((dr["UserTypeID"]));
EmailAddress = (dr["EmailAddress"].ToString());
txtName.Text = Name;
txtSurname.Text = Surname;
txtPhoneNumber.Text = PhoneNumber;
txtUsername.Text = UserName;
txtPassword.Text = UserPassword;
txtEmailAddress.Text = EmailAddress;
//Get Gender
SqlConnection sqlcon2 = new SqlConnection(Globals.ConnectionString);
sqlcon2.Open();
string cmd2 = "SELECT GenderDescription FROM Gender WHERE GenderID ='" + GenderID.ToString() + "'";
SqlCommand sqlcom2 = new SqlCommand(cmd2, sqlcon2);
SqlDataReader dr2;
dr2 = sqlcom2.ExecuteReader();
if (dr2.HasRows)
{
while (dr2.Read())
{
GenderDescription = (dr2["GenderDescription"].ToString());
cbxGender.Text = GenderDescription;
}
}
dr2.Close();
sqlcon2.Close();
//Get Title
SqlConnection sqlcon3 = new SqlConnection(Globals.ConnectionString);
sqlcon3.Open();
string cmd3 = "SELECT TitleDescription FROM Title WHERE TitleID ='" + TitleID.ToString() + "'";
SqlCommand sqlcom3 = new SqlCommand(cmd3, sqlcon3);
SqlDataReader dr3;
dr3 = sqlcom3.ExecuteReader();
if (dr3.HasRows)
{
while (dr3.Read())
{
TitleDescription = (dr3["TitleDescription"].ToString());
cbxTitle.Text = TitleDescription;
}
}
dr3.Close();
sqlcon3.Close();
//Get Privilege
SqlConnection sqlcon4 = new SqlConnection(Globals.ConnectionString);
sqlcon4.Open();
string cmd4 = "SELECT PrivilegeDescription FROM Privilege WHERE PrivilegeID ='" + PrivilegeID.ToString() + "'";
SqlCommand sqlcom4 = new SqlCommand(cmd4, sqlcon4);
SqlDataReader dr4;
dr4 = sqlcom4.ExecuteReader();
if (dr4.HasRows)
{
while (dr4.Read())
{
PrivilegeDescription = (dr4["PrivilegeDescription"].ToString());
cbxPrivilegeType.Text = PrivilegeDescription;
}
}
dr4.Close();
sqlcon4.Close();
//Get UserType
SqlConnection sqlcon5 = new SqlConnection(Globals.ConnectionString);
sqlcon5.Open();
string cmd5 = "SELECT UserDescription FROM UserType WHERE UserTypeID ='" + UserTypeID.ToString() + "'";
SqlCommand sqlcom5 = new SqlCommand(cmd5, sqlcon5);
SqlDataReader dr5;
dr5 = sqlcom5.ExecuteReader();
if (dr5.HasRows)
{
while (dr5.Read())
{
UserTypeDescription = (dr5["UserDescription"].ToString());
cbxUserType.Text = UserTypeDescription;
}
}
dr5.Close();
sqlcon5.Close();
// }
// catch
// {
// }
}
}
dr.Close();
sqlcon.Close();
}
