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"); } }