public FoodReceiptsForm(int DonorID, int defaultDonorType, bool IsGroceryRescue) { InitializeComponent(); pnlEditDaily.Visible = false; pnlMonthly.Visible = false; pnlMonthly.SetBounds(pnlEditDaily.Location.X, pnlEditDaily.Location.Y, pnlMonthly.Width, pnlMonthly.Height); pnlViewable = pnlEditDaily; dset = new DataSet(); conn = new SqlConnection(CCFBGlobal.connectionString); dadAdpt = new SqlDataAdapter(); commandByWeek = new SqlCommand("GroceryRescueLbs", conn); commandByWeek.CommandType = CommandType.StoredProcedure; commandByWeek.Parameters.Add(new SqlParameter("@dateStart", SqlDbType.DateTime)); commandByWeek.Parameters.Add(new SqlParameter("@dateEnd", SqlDbType.DateTime)); commandByWeek.Parameters.Add(new SqlParameter("@DonorID", SqlDbType.Int)); donorID = DonorID; LoadcboDonor(); LoadcboYear(); foodClassList = CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_FoodClass); fillFoodClasses(); cboReportMonth.SelectedIndex = DateTime.Today.Month - 1; CCFBGlobal.InitCombo(cboDonationType, "parm_DonationType"); clsMonthlyReports.openWhere(" Where ReportName='Grocery Rescue'"); cboDonationType.SelectedValue = defaultDonorType.ToString(); isGroceryRescue = IsGroceryRescue; bool hasRows = cboStore.Items.Count > 0; btnLoadPeriodData.Enabled = hasRows; btnEdit.Enabled = hasRows; btnSummary.Enabled = hasRows; }
private void setupComboxBox(string colName, string tblName) { DataGridViewComboBoxColumn myColumn = (DataGridViewComboBoxColumn)dgvHHM.Columns[colName]; myColumn.DataSource = CCFBGlobal.TypeCodesArray(tblName); myColumn.ValueMember = "UID"; myColumn.DisplayMember = "LongName"; }
public FBJobsPlanForm() { InitializeComponent(); clsJobsPlan = new FBJobsPlan(CCFBGlobal.connectionString); clsVols = new Volunteers(CCFBGlobal.connectionString); showJobsView(); InitlvwJobs(CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_FBJobs)); tsb1.Checked = true; setupCopyMenu(); }
} // end of property FormSelectMode private void LoadlvwGroups() { lvwVol_Group.Items.Clear(); foreach (parmType item in CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_VolGroups)) { ListViewItem lvItm = new ListViewItem(item.ID.ToString()); lvItm.SubItems.Add(item.LongName); lvwVol_Group.Items.Add(lvItm); } }
private int getFoodClass(int colIndex) { foreach (parmType item in CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_FoodClass)) { if (item.SortOrder == colIndex) { return(item.ID); } } return(9); }
} // end of EditvolunteerForm_FormClosing //----------------------------------------------------------------------------------------- /// <summary> /// Read the Type Codes database table and display the data in a DataGridView control. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //----------------------------------------------------------------------------------------- private void EditVolForm_Load(object sender, EventArgs e) { TableName = "Volunteers"; // Read from this SQL table. ControlPage = this.Controls; DataGridViewObject = gridEditVol; editVol_cboRcdType.DataSource = CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_VolType); editVol_cboRcdType.DisplayMember = "LongName"; editVol_cboRcdType.ValueMember = "UID"; loadUserFieldLabels(); LoadlvwGroups(); RefreshGrid(); } // end of EditVolForm_Load
/// <summary> /// Retrives all distinct values for a given column Name in the Household Table /// </summary> /// <param name="colName">The Name of the Column to get distincts for</param> private void getDistints(string colName) { bool foundMatch = false; bLoadingCombo = true; cboFilter.Items.Clear(); cboFilter.Items.Add("No Filter"); cboFilter.SelectedIndex = 0; //Gets And Adds to the filter combo the distinct values of the column from the household table string whereClause = ""; if (chkIncludeInactive.Checked == false) { whereClause = " WHERE Inactive=0 "; } clsVolunteers.getDistincts(colName, whereClause); string sVal = ""; System.Collections.ArrayList typesVolunteer = CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_VolType); int iD = 0; for (int i = 0; i < clsVolunteers.RowCount; i++) { sVal = clsVolunteers.DSet.Tables[0].Rows[i][0].ToString(); foundMatch = true; if (colName == "RcdType") { iD = Convert.ToInt32(sVal); sVal = CCFBGlobal.formatNumberWithLeadingZero(iD); foundMatch = false; for (int j = 0; j < typesVolunteer.Count; j++) { parmType pt = (parmType)typesVolunteer[j]; if (pt.ID == iD) { sVal += " = " + pt.LongName; foundMatch = true; break; } } } if (foundMatch == true) { cboFilter.Items.Add(sVal + new String((char)32, (30 - sVal.Length)) + "[ " + clsVolunteers.DSet.Tables[0].Rows[i][1].ToString() + " ]"); } } bLoadingCombo = false; }
private void initSchoolComboBox() { DataGridViewComboBoxColumn colCbo = (DataGridViewComboBoxColumn)dgvHHMembers.Columns["clmSchool"]; System.Collections.ArrayList newList = new System.Collections.ArrayList(CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_SchSupplySchool)); if (newList != null && newList.Count > 0) { colCbo.DataSource = newList; colCbo.DisplayMember = "LongName"; colCbo.ValueMember = "UID"; } else { colCbo.DataSource = null; colCbo.Items.Add("Not Initialized"); } //dgvHHMembers.Columns.Add(colCbo); }
} // end of EditDonorForm_FormClosing //----------------------------------------------------------------------------------------- /// <summary> /// Read the Type Codes database table and display the data in a DataGridView control. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //----------------------------------------------------------------------------------------- private void EditDonorForm_Load(object sender, EventArgs e) { TableName = "Donors"; // Read from this SQL table. //ControlPage = tpgCompanyInfo.Controls; ControlPage = this.Controls; DataGridViewObject = gridEditDonor; editDonor_cboRcdType.DataSource = CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_Donor); editDonor_cboRcdType.DisplayMember = "LongName"; editDonor_cboRcdType.ValueMember = "UID"; cboDonationType.DataSource = CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_Donation); cboDonationType.DisplayMember = "LongName"; cboDonationType.ValueMember = "UID"; loadUserFieldLabels(); SetWhereClause(); RefreshGrid(); GridSelectionHandlerEnabled = true; } // end of EditDonorForm_Load
public frmFoodReceipts(int DonorID, int defaultDonorType) { InitializeComponent(); pnlEditDaily.Visible = false; pnlMonthly.Visible = false; pnlMonthly.SetBounds(pnlEditDaily.Location.X, pnlEditDaily.Location.Y, pnlMonthly.Width, pnlMonthly.Height); pnlViewable = pnlEditDaily; dset = new DataSet(); conn = new SqlConnection(CCFBGlobal.connectionString); dadAdpt = new SqlDataAdapter(); donorID = DonorID; LoadcboDonor(); LoadcboYear(); foodClassList = CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_FoodClass); fillFoodClasses(); cboReportMonth.SelectedIndex = DateTime.Today.Month - 1; CCFBGlobal.InitCombo(cboDonationType, "parm_DonationType"); clsMonthlyReports.openWhere(" Where ReportName='Grocery Rescue'"); cboDonationType.SelectedValue = defaultDonorType.ToString(); }
/// <summary> /// Loads the View By Day Donations Grid /// </summary> private void loadByDayData() { DateTime trxDate; int foodClass = 0; int colFoodClass = 0; int rowTrxDate = 0; for (int i = 0; i < idbRowCount; i++) { trxDate = dset.Tables[0].Rows[i].Field <DateTime>("TrxDate"); foodClass = dset.Tables[0].Rows[i].Field <short>("FoodClass"); foreach (parmType item in CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_FoodClass)) { if (item.ID == foodClass) { colFoodClass = item.SortOrder; break; } } rowTrxDate = trxDate.Day - 1; if (rowTrxDate >= 0 && rowTrxDate < dgvMonthReceipts.Rows.Count) { //for (int j = 0; j < dgvMonthReceipts.Rows.Count; j++) //{ //if (dgvMonthReceipts[colFoodClass, rowTrxDate].Tag != null && ((parmType)dgvMonthReceipts[colFoodClass, rowTrxDate].Tag).UID == dset.Tables[0].Rows[i]["FoodClass"].ToString()) //{ dgvMonthReceipts[colFoodClass, rowTrxDate].Value = CCFBGlobal.formatNumberWithCommas(dset.Tables[0].Rows[i]["Pounds"]); dgvMonthReceipts[colFoodClass, rowTrxDate].Tag = dset.Tables[0].Rows[i]["TrxID"]; dgvMonthReceipts[colFoodClass, rowTrxDate].Style.BackColor = Color.White; //} //} } } loadTotals(); }
public VolGroups(string connStringIn) { int iNbrRows = 0; conn = new SqlConnection(); conn.ConnectionString = connStringIn; foreach (parmType item in CCFBGlobal.TypeCodesArray(CCFBGlobal.parmTbl_VolGroups)) { VolGroup vgrp = new VolGroup(item.ID, item.TypeName); VolGrps.Add(vgrp); iNbrRows++; } //SqlCommand command = new SqlCommand("SELECT * FROM parm_VolunteerGroups ORDER BY [Type]", conn); //SqlDataAdapter dadAdpt = new SqlDataAdapter(); //dadAdpt.SelectCommand = command; //DataSet dset = new DataSet(); //iNbrRows = dadAdpt.Fill(dset); //foreach (DataRow drow in dset.Tables[0].Rows) //{ // VolGroup vgrp = new VolGroup(drow.Field<int>("Id"), drow.Field<string>("Type")); // VolGrps.Add(vgrp); //} }