private void changeGroupBoxVisibility(int option) { switch (option) { case 0: { pnlFindClient.Visible = true; pnlGiveService.Visible = false; dgvHD.Enabled = true; break; } case 1: { pnlFindClient.Visible = false; pnlGiveService.Visible = false; dgvHD.Enabled = false; string date = CCFBGlobal.NullToBlank(dgvHD.SelectedRows[0].Cells["clmExpiration"].Value); break; } case 2: { dgvHD.Enabled = false; pnlFindClient.Visible = false; pnlGiveService.Visible = true; break; } } }
/// <summary> /// Loads the DataGrid from the DataRows that are passed to the funtion /// </summary> /// <param name="drows">The Array of DataRows to load the data from</param> private void loadList(DataRow[] drows) { tbFindName.Text = ""; lastSearchText = ""; dgvBackpack.Rows.Clear(); progressBar1.Value = 0; progressBar1.Show(); tbFindName.Visible = false; Application.DoEvents(); progressBar1.Maximum = rowCount; DateTime toCheck = new DateTime(Convert.ToInt32(cboYear.SelectedItem), Convert.ToInt32(cboMonth.SelectedIndex + 1), 1); for (int i = 0; i < drows.Length; i++) { dgvBackpack.Rows.Add(); if (Convert.ToInt32(drows[i]["Backpack"]) == 0) { dgvBackpack.Rows[i].DefaultCellStyle.ForeColor = Color.Red; } else if (Convert.ToInt32(drows[i]["Inactive"]) == 1) { dgvBackpack.Rows[i].DefaultCellStyle.BackColor = Color.Red; dgvBackpack.Rows[i].DefaultCellStyle.BackColor = Color.White; } dgvBackpack["clmHHID", i].Value = drows[i]["HouseholdID"]; dgvBackpack["clmName", i].Value = drows[i]["colNameLF"]; dgvBackpack["clmAddress", i].Value = drows[i]["Address"]; dgvBackpack["clmAptNum", i].Value = dtbl.Rows[i]["AptNbr"]; dgvBackpack["clmExpiration", i].Value = convertToShortDate( CCFBGlobal.NullToBlank(drows[i]["BackpackExpiration"])); if (dgvBackpack["clmExpiration", i].Value.ToString() != "" && (DateTime)drows[i]["BackpackExpiration"] < toCheck) { dgvBackpack["clmExpiration", i].Style.BackColor = Color.Yellow; } dgvBackpack["clmMethod", i].Value = drows[i]["Route"]; dgvBackpack["clmMethodAsInt", i].Value = drows[i]["RouteAsInt"]; dgvBackpack["clmDateServed", i].Value = convertToShortDate( CCFBGlobal.NullToBlank(drows[i]["BackpackSvcDate"])); dgvBackpack["clmLbs", i].Value = CCFBGlobal.NullToBlank(drows[i]["Lbs"]); dgvBackpack["clmHHMemID", i].Value = CCFBGlobal.NullToBlank(drows[i]["hhmID"]); dgvBackpack.Rows[i].Cells["colNameLF"].Value = drows[i]["colNameLF"].ToString().ToUpper().Trim(); dgvBackpack.Rows[i].Cells["colNameFL"].Value = drows[i]["colNameFL"].ToString().ToUpper().Trim(); dgvBackpack.Rows[i].Cells["clmBackpack"].Value = drows[i]["Backpack"]; dgvBackpack.Rows[i].Cells["clmLogID"].Value = drows[i]["LogId"]; progressBar1.PerformStep(); } rowIndex = 0; progressBar1.Value = 0; progressBar1.Visible = false; tbFindName.Visible = true; }
private void btnSetPassword_Click(object sender, EventArgs e) { tbPassword1.Text = ""; tbPassword2.Text = ""; lblUsername.Text = CCFBGlobal.NullToBlank(dataGridViewUsers.CurrentRow.Cells[0].Value); pannelPassword.Visible = true; btnSetPassword.Visible = false; btnDelete.Enabled = false; tbPassword1.Focus(); }
private void changeGroupBoxVisibility(int option) { switch (option) { case 0: { gbFindClient.Visible = true; gbRenewExpDate.Visible = false; gbNewService.Visible = false; cboYear.Enabled = true; cboMonth.Enabled = true; btnRefreshList.Enabled = true; dgvCSFP.Enabled = true; break; } case 1: { gbFindClient.Visible = false; gbNewService.Visible = false; gbRenewExpDate.Visible = true; cboYear.Enabled = false; cboMonth.Enabled = false; btnRefreshList.Enabled = false; dgvCSFP.Enabled = false; string date = CCFBGlobal.NullToBlank(dgvCSFP.SelectedRows[0].Cells["clmExpiration"].Value); if (date != "") { dtpExpDate.Value = DateTime.Parse(date); } chkCSFP.Checked = (bool)dgvCSFP.SelectedRows[0].Cells["clmCSFP"].Value; break; } case 2: { cboYear.Enabled = false; cboMonth.Enabled = false; btnRefreshList.Enabled = false; dgvCSFP.Enabled = false; gbFindClient.Visible = false; gbNewService.Visible = true; gbRenewExpDate.Visible = false; tbLbsCSFP.Text = dfltCsfpLbs.ToString(); dtpSvcDate.Value = svcDate; break; } } }
private void changeGroupBoxVisibility(int option) { switch (option) { case 0: { gbRenewExpDate.Visible = false; gbNewService.Visible = false; cboYear.Enabled = true; cboMonth.Enabled = true; btnRefreshList.Enabled = true; dgvBackpack.Enabled = true; break; } case 1: { gbNewService.Visible = false; gbRenewExpDate.Visible = true; cboYear.Enabled = false; cboMonth.Enabled = false; btnRefreshList.Enabled = false; dgvBackpack.Enabled = false; string date = CCFBGlobal.NullToBlank(dgvBackpack.SelectedRows[0].Cells["clmExpiration"].Value); if (date != "") { dtpExpDate.Value = DateTime.Parse(date); } chkBackpack.Checked = (bool)dgvBackpack.SelectedRows[0].Cells["clmBackpack"].Value; break; } case 2: { cboYear.Enabled = false; cboMonth.Enabled = false; btnRefreshList.Enabled = false; dgvBackpack.Enabled = false; gbNewService.Visible = true; gbRenewExpDate.Visible = false; //tbLbsBackpack.Text = CCFBPrefs.BackpackLbsPerUnit * cls .ToString(); dtpSvcDate.Value = svcDate; break; } } }
private void dataGridViewUsers_CellEndEdit(object sender, DataGridViewCellEventArgs e) { int rowIndex = dataGridViewUsers.CurrentRow.Index; if (dataGridViewUsers.CurrentRow.Cells["clmId"].Value != null) { clsUsers.SetDataValue(rowIndex, "UserRole", dataGridViewUsers.CurrentRow.Cells[1].Value.ToString()); clsUsers.SetDataValue(rowIndex, "UserName", dataGridViewUsers.CurrentRow.Cells[0].Value.ToString()); clsUsers.update(); } else { switch (e.ColumnIndex) { case 0: { newUserName = CCFBGlobal.NullToBlank(dataGridViewUsers.Rows[rowIndex].Cells[0].Value); if (newUserName == "") { if (MessageBox.Show("Do you want me to delete this row?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { dataGridViewUsers.Rows.RemoveAt(rowIndex); } } dataGridViewUsers.Rows[rowIndex].Cells[1].Value = CCFBGlobal.nameUserRole_Intake; break; } default: { newUserRole = dataGridViewUsers.Rows[rowIndex].Cells[1].GetEditedFormattedValue (rowIndex, DataGridViewDataErrorContexts.LeaveControl).ToString(); break; } } pannelPassword.Visible = true; btnSetPassword.Visible = false; btnDelete.Enabled = false; tbPassword1.Focus(); } }
/// <summary> /// Clears Datagrid and Loads the Clients /// </summary> public void loadList() { bNormalMode = false; tbFindName.Text = ""; lastSearchText = ""; ClearHeader(); dgvClientList.Rows.Clear(); progressBar1.Value = 0; progressBar1.Maximum = 100; progressBar1.Show(); tbFindName.Visible = false; Application.DoEvents(); clsClient.openWhere(sWhereClause + includeInactive + sOrderBy); progressBar1.Maximum = clsClient.RowCount; for (int i = 0; i < clsClient.RowCount; i++) { dgvClientList.Rows.Add(); if ((bool)clsClient.DSet.Tables[0].Rows[i]["HHInactive"] == true) { dgvClientList.Rows[i].DefaultCellStyle.ForeColor = Color.Maroon; } else if (Convert.ToBoolean(CCFBGlobal.NullToZero(clsClient.DSet.Tables[0].Rows[i]["Inactive"])) == true) { dgvClientList.Rows[i].DefaultCellStyle.ForeColor = Color.DarkViolet; } else { dgvClientList.Rows[i].DefaultCellStyle.ForeColor = Color.Black; } if (clsClient.DSet.Tables[0].Rows[i][firstColName] == DBNull.Value) { dgvClientList.Rows[i].Cells["colName"].Value = clsClient.DSet.Tables[0].Rows[i]["Name"].ToString(); } else { dgvClientList.Rows[i].Cells["colName"].Value = clsClient.DSet.Tables[0].Rows[i][firstColName].ToString(); } dgvClientList.Rows[i].Cells["clmCity"].Value = clsClient.DSet.Tables[0].Rows[i]["City"].ToString(); if (clsClient.DSet.Tables[0].Rows[i]["ID"].ToString() == "") { dgvClientList.Rows[i].Cells["clmID"].Value = "0"; } else { dgvClientList.Rows[i].Cells["clmID"].Value = clsClient.DSet.Tables[0].Rows[i]["ID"].ToString(); } dgvClientList.Rows[i].Cells["clmZip"].Value = clsClient.DSet.Tables[0].Rows[i]["Zipcode"].ToString(); dgvClientList.Rows[i].Cells["clmHHID"].Value = clsClient.DSet.Tables[0].Rows[i]["HHId"].ToString(); dgvClientList.Rows[i].Cells["clmPhone"].Value = clsClient.DSet.Tables[0].Rows[i]["Phone"].ToString(); dgvClientList.Rows[i].Cells["clmAddress"].Value = clsClient.DSet.Tables[0].Rows[i]["Address"].ToString(); dgvClientList.Rows[i].Cells["clmHeadHH"].Value = CCFBGlobal.NullToBlank(clsClient.DSet.Tables[0].Rows[i]["HeadHH"].ToString()); dgvClientList.Rows[i].Cells["clmClientType"].Value = CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_Client, Convert.ToInt32(clsClient.DSet.Tables[0].Rows[i]["ClientType"])); dgvClientList.Rows[i].Cells["colHHName"].Value = clsClient.DSet.Tables[0].Rows[i]["Name"].ToString(); dgvClientList.Rows[i].Cells["colNameLF"].Value = clsClient.DSet.Tables[0].Rows[i]["colNameLF"].ToString().ToUpper().Trim(); dgvClientList.Rows[i].Cells["colNameFL"].Value = clsClient.DSet.Tables[0].Rows[i]["colNameFL"].ToString().ToUpper().Trim(); if (clsClient.DSet.Tables[0].Rows[i]["LatestService"].ToString() != "") { dgvClientList.Rows[i].Cells["clmLatestService"].Value = clsClient.DSet.Tables[0].Rows[i].Field <DateTime>("LatestService").ToShortDateString(); } else { dgvClientList.Rows[i].Cells["clmLatestService"].Value = ""; } progressBar1.PerformStep(); } //Fills the textbox's for the current selected client rowIndex = 0; fillTextBoxes(); progressBar1.Value = 0; progressBar1.Visible = false; tbFindName.Visible = true; bNormalMode = true; rowCount = dgvClientList.RowCount; }
private void changeGroupBoxVisibility(int option) { string tmpdate = ""; switch (option) { case 0: { gbFilter.Visible = true; gbRenewExpDate.Visible = false; gbNewService.Visible = false; cboYear.Enabled = true; cboMonth.Enabled = true; btnRefreshList.Enabled = true; dgvCSFP.Enabled = true; break; } case 1: { gbFilter.Visible = false; gbNewService.Visible = false; gbRenewExpDate.Visible = true; cboYear.Enabled = false; cboMonth.Enabled = false; btnRefreshList.Enabled = false; dgvCSFP.Enabled = false; tmpdate = CCFBGlobal.NullToBlank(dgvCSFP.SelectedRows[0].Cells["CSFPExpiration"].Value); if (tmpdate != "") { dtpExpDate.Value = DateTime.Parse(tmpdate); } else { dtpExpDate.Value = DateTime.Parse(DateTime.Today.ToShortDateString()); } chkCSFP.Checked = (bool)dgvCSFP.SelectedRows[0].Cells["clmCSFP"].Value; break; } case 2: { cboYear.Enabled = false; cboMonth.Enabled = false; btnRefreshList.Enabled = false; dgvCSFP.Enabled = false; gbFilter.Visible = false; gbNewService.Visible = true; gbRenewExpDate.Visible = false; tbLbsCSFP.Text = CCFBPrefs.CSFPLbsPerService.ToString(); dtpSvcDate.Value = svcDate; tmpdate = CCFBGlobal.NullToBlank(dgvCSFP.SelectedRows[0].Cells["clmDateServed"].Value); if (tmpdate != "") { dtpSvcDate.Value = DateTime.Parse(tmpdate); } else { dtpSvcDate.Value = DateTime.Parse(DateTime.Today.ToShortDateString()); } break; } } Application.DoEvents(); }