private string GetOthers(string count, string year)
{
SQLCon.DbCon();
SQLCon.dataTable = new DataTable();
SQLCon.sqlDataApater = new SqlDataAdapter(
@"SELECT * from ServiceRequestInfoes where NOT TypeOfServiceProvided like '%DESKTOP%' and
NOT TypeOfServiceProvided like '%LAPTOP%' and
NOT TypeOfServiceProvided like '%PRINTER%' and
NOT TypeOfServiceProvided like '%NETWORK%' and
YEAR(DateAccomplished) = @3 ", SQLCon.sqlConnection);
SQLCon.sqlDataApater.SelectCommand.Parameters.AddWithValue("@3", Int32.Parse(year));
SQLCon.sqlDataApater.Fill(SQLCon.dataTable);
int i = 0;
foreach (DataRow row in SQLCon.dataTable.Rows)
{
i++;
}
string number;
number = i.ToString();
return(number);
}
private string TotalService(string year)
{
SQLCon.DbCon();
SQLCon.dataTable = new DataTable();
SQLCon.sqlDataApater = new SqlDataAdapter(
@"SELECT * from ServiceRequestInfoes where YEAR(DateAccomplished) = @3 ", SQLCon.sqlConnection);
SQLCon.sqlDataApater.SelectCommand.Parameters.AddWithValue("@3", Int32.Parse(year));
SQLCon.sqlDataApater.Fill(SQLCon.dataTable);
int i = 0;
foreach (DataRow row in SQLCon.dataTable.Rows)
{
i++;
}
string number;
number = i.ToString();
return(number);
}
private void LoadListRequest()
{
SQLCon.DbCon();
SQLCon.sqlDataApater = new SqlDataAdapter(
@"SELECT
er_ID,
partyOrganization AS [Organization],
contactPerson,
contactNo,
titleOfEvent AS [Title of Event],
dateOfEvent AS [Date of Event],
timeOfEvent AS [Time of Event],
venueOfEvent AS [Venue of Event],
granted AS [Granted],
denied AS [Denied],
pd_Solo,
pd_Duet,
pd_Chorale,
pd_RondallaBand,
pd_FolkDance,
pd_HipHop,
pd_Contemporary,
pd_DanceSports,
noOfPerformance,
noOfPerformer,
bitaw,
specify,
denied_Reason,
notedBy,
ApprovedBy
FROM
ExternalRequests", SQLCon.sqlConnection);
SQLCon.dataTable = new DataTable();
SQLCon.sqlDataApater.Fill(SQLCon.dataTable);
dataGridView_ListOfRequest.DataSource = SQLCon.dataTable;
dataGridView_ListOfRequest.Columns["er_ID"].Visible = false;
dataGridView_ListOfRequest.Columns["contactNo"].Visible = false;
dataGridView_ListOfRequest.Columns["contactPerson"].Visible = false;
dataGridView_ListOfRequest.Columns["pd_Solo"].Visible = false;
dataGridView_ListOfRequest.Columns["pd_Duet"].Visible = false;
dataGridView_ListOfRequest.Columns["pd_Chorale"].Visible = false;
dataGridView_ListOfRequest.Columns["pd_RondallaBand"].Visible = false;
dataGridView_ListOfRequest.Columns["pd_FolkDance"].Visible = false;
dataGridView_ListOfRequest.Columns["pd_HipHop"].Visible = false;
dataGridView_ListOfRequest.Columns["pd_Contemporary"].Visible = false;
dataGridView_ListOfRequest.Columns["pd_DanceSports"].Visible = false;
dataGridView_ListOfRequest.Columns["noOfPerformance"].Visible = false;
dataGridView_ListOfRequest.Columns["noOfPerformer"].Visible = false;
dataGridView_ListOfRequest.Columns["bitaw"].Visible = false;
dataGridView_ListOfRequest.Columns["specify"].Visible = false;
dataGridView_ListOfRequest.Columns["denied_Reason"].Visible = false;
dataGridView_ListOfRequest.Columns["notedBy"].Visible = false;
dataGridView_ListOfRequest.Columns["ApprovedBy"].Visible = false;
label_Count.Text = dataGridView_ListOfRequest.RowCount.ToString();
}
public void PopulateComboBox(string tableName, string valueName, string displayName, ComboBox cb_Name)
{
SQLCon.DbCon();
SQLCon.sqlDataApater = new SqlDataAdapter("SELECT DISTINCT " + displayName + " FROM " + tableName + " ORDER BY " + displayName, SQLCon.sqlConnection);
SQLCon.dataTable = new DataTable();
SQLCon.sqlDataApater.Fill(SQLCon.dataTable);
cb_Name.DataSource = SQLCon.dataTable;
// cb_Name.ValueMember = valueName;
cb_Name.DisplayMember = displayName;
cb_Name.AutoCompleteMode = AutoCompleteMode.Append;
cb_Name.AutoCompleteSource = AutoCompleteSource.ListItems;
cb_Name.SelectedIndex = -1;
}
private void bt_Enter_Click(object sender, EventArgs e)
{
SQLCon.DbCon();
SQLCon.sql = "SELECT ua_ID, UserName, Password, IsActive, Role FROM UserAccounts WHERE UserName=@1 AND Password=@2";
SQLCon.sqlCommand = new SqlCommand(SQLCon.sql, SQLCon.sqlConnection);
SQLCon.sqlCommand.Parameters.AddWithValue("@1", tb_Username.Text);
SQLCon.sqlCommand.Parameters.AddWithValue("@2", tb_Password.Text);
SQLCon.sqlDataReader = SQLCon.sqlCommand.ExecuteReader();
while (SQLCon.sqlDataReader.Read())
{
Username = (SQLCon.sqlDataReader["Username"].ToString());
Password = (SQLCon.sqlDataReader["Password"].ToString());
accountValidation = (SQLCon.sqlDataReader["IsActive"].ToString());
Role = (SQLCon.sqlDataReader["Role"].ToString());
}
if (Username == tb_Username.Text && Password == tb_Password.Text && accountValidation == "True")
{
this.Close();
if (Role == "0")
{
MainForm.UserAccessLevel = "0";
}
else
{
MainForm.UserAccessLevel = "1";
}
}
else if (accountValidation == "False" && Username == tb_Username.Text && Password == tb_Password.Text)
{
MessageBox.Show("Your account has been suspended. Please contact the Administrator");
}
else
{
MessageBox.Show("Incorrect username or password");
}
}
