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