private void loadList(string testId, bool disableSelect)
{
loadingListView = disableSelect;
lvServiceItems.ListViewItemSorter = null;
lvServiceItems.Items.Clear();
//Application.DoEvents();
for (int i = 0; i < clsSvcItems.RowCount; i++)
{
ListViewItem lvi = new ListViewItem(CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_SvcCategory
, Convert.ToInt32(clsSvcItems.GetDataValue("ItemType", i).ToString())));
lvi.Name = clsSvcItems.GetDataValue("ItemKey", i).ToString();
lvi.SubItems.Add(clsSvcItems.GetDataValue("ItemDesc", i).ToString());
lvi.SubItems.Add(clsSvcItems.GetDataValue("LbsPerItem", i).ToString());
lvi.SubItems.Add(clsSvcItems.GetDataValue("ItemKey", i).ToString());
lvi.UseItemStyleForSubItems = false;
lvi.SubItems[3].ForeColor = Color.Blue;
setlvServicesImage(clsSvcItems.GetDataValueBool("NotAvailable", i), lvi);
lvServiceItems.Items.Add(lvi);
Application.DoEvents();
}
if (testId != "")
{
lvServiceItems.Items[testId].Selected = true;
}
else if (lvServiceItems.Items.Count > 0)
{
loadingListView = false;
lvServiceItems.Items[0].Selected = true;
}
lvServiceItems.ListViewItemSorter = lvColSorter;
loadingListView = false;
}
} // end of DisplayControls
//-----------------------------------------------------------------------------------------
/// <summary>
/// Special handling is required to display the TypeCode value in the DataGridView. This
/// method provides the necessary processing to the base class.
/// </summary>
//-----------------------------------------------------------------------------------------
public override bool DisplayGridLineSpecial(int a_dataSetRow, int a_gridRow)
{
string rcdType = CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_VolType
, Convert.ToInt16(DataSetValue(a_dataSetRow, COLUMN_RCD_TYPE))); // Get the ID from DataSet row.
gridEditVol[COLUMN_GRID_RCD_TYPE, a_gridRow].Value = rcdType;
return(rcdType.Length > 0);
} // end of DisplayGridLineSpecial
private void SchoolSupplyPickupTicket_Load(object sender, EventArgs e)
{
tbID.Text = clsClient.clsHH.ID.ToString();
lblHHName.Text = clsClient.clsHH.Name;
chkSchoolSupplyFlag.Checked = clsClient.clsHH.SchSupplyFlag;
cboPickupPerson.Text = clsClient.clsHH.SchSupplyPickupPerson;
cboRegistration.Text = CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_SchSupplyRegistration, clsClient.clsHH.SchSupplyRegistration);
loadHHMems(true);
}
/// <summary>
/// Loads the Donation Log with the Donations for the selected date
/// </summary>
private void loadDonationLogList()
{
lvFoodDonations.Items.Clear();
double totLbs = 0;
int totCnt = 0;
btnEditDnrTrx.Text = "";
btnEditDnrTrx.Enabled = false;
btnDeleteTrx.Text = "";
btnDeleteTrx.Enabled = false;
btnShowDnrHist.Text = "";
btnShowDnrHist.Enabled = false;
if (dateIndex >= 0)
{
ListViewItem lvItm;
currentlogdate = donationDates[dateIndex];
for (int i = 0; i < clsFoodDonations.RowCount; i++)
{
clsFoodDonations.setDataRow(i);
lvItm = new ListViewItem();
lvItm.Name = clsFoodDonations.TrxID.ToString();
lvItm.Text = (i + 1).ToString();
lvItm.SubItems.Add(clsFoodDonations.TrxDate.ToShortDateString());
lvItm.SubItems.Add(CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_Donation, clsFoodDonations.DonationType));
clsDonors.find(clsFoodDonations.DonorID);
if (clsDonors.ID != clsFoodDonations.DonorID)
{
clsDonors.openWhere("");
clsDonors.find(clsFoodDonations.DonorID);
}
if (clsDonors.ID == clsFoodDonations.DonorID)
{
lvItm.SubItems.Add(clsDonors.Name);
}
else
{
lvItm.SubItems.Add("ID " + clsFoodDonations.DonorID.ToString());
}
lvItm.SubItems.Add(String.Format("{0:0,0}", clsFoodDonations.Pounds));
lvItm.SubItems.Add(clsFoodDonations.Notes);
lvItm.SubItems.Add(CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_FoodClass, clsFoodDonations.FoodClass));
lvItm.SubItems.Add(clsFoodDonations.FoodCode);
lvItm.SubItems.Add(clsFoodDonations.DonorID.ToString());
lvItm.SubItems.Add(clsFoodDonations.TrxID.ToString());
lvFoodDonations.Items.Add(lvItm);
totCnt++;
totLbs += clsFoodDonations.Pounds;
}
tbTotalCount.Text = CCFBGlobal.formatNumberWithCommas(totCnt);
tbTotalLbs.Text = String.Format("{0:0,0}", totLbs);
}
else
{
clsFoodDonations.open(0);
}
}
/// <summary>
/// Loads the Donor log listView with the donoations for the
/// Selected donor
/// </summary>
private void loadDonorLogList()
{
double totLbs = 0;
int totCnt = 0;
lvDonorHistory.Items.Clear();
Application.DoEvents();
ListViewItem lvItm;
string donorWhereClause = " WHERE DonorID=" + donorID.ToString();
switch (cboDonorPeriod.SelectedIndex)
{
case 0: donorWhereClause += CCFBGlobal.SQLDateRangeCurMonth(); break;
case 1: donorWhereClause += CCFBGlobal.SQLDateRangePrevMonth(); break;
case 2: donorWhereClause += CCFBGlobal.SQLDateRangeLast90Days(); break;
case 3: donorWhereClause += CCFBGlobal.SQLDateRangeCurYear(); break;
case 4: donorWhereClause += CCFBGlobal.SQLDateRangePrevYear(); break;
case 5: break;
default: donorWhereClause += DateRangeCustom(); break;
}
clsFDHist.openWhere(donorWhereClause);
for (int i = 0; i < clsFDHist.RowCount; i++)
{
clsFDHist.setDataRow(i);
lvItm = new ListViewItem((i + 1).ToString());
lvItm.SubItems.Add(CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_Donation, clsFDHist.DonationType));
lvItm.SubItems.Add(clsFDHist.TrxDate.ToShortDateString());
lvItm.SubItems.Add(String.Format("{0:0,0}", clsFDHist.Pounds));
lvItm.SubItems.Add(clsFDHist.Notes);
lvItm.SubItems.Add(CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_FoodClass, clsFDHist.FoodClass));
lvItm.SubItems.Add(clsFDHist.FoodCode);
lvItm.SubItems.Add(clsFDHist.TrxID.ToString());
lvDonorHistory.Items.Add(lvItm);
totCnt++;
totLbs += clsFDHist.Pounds;
}
tbDonorCnt.Text = CCFBGlobal.formatNumberWithCommas(totCnt);
tbDonorLbs.Text = String.Format("{0:0,0}", totLbs);
}
public void fillEditFields(string itemDescr)
{
btnPost.Focus();
//tbVoucherType.Text = clsVoucher.ClientType.ToString();
tbVoucherId.Text = clsVoucher.TrxId.ToString();
tbTrxDate.Text = clsVoucher.TrxDate.ToLongDateString(); // clsVoucher.TrxDate.ToShortDateString();
if (clsVoucher.TrxId > 0)
{
dtpTrxDate.Value = clsVoucher.TrxDate;
}
foreach (TextBox tb in pnlDemographics.Controls.OfType <TextBox>())
{
tb.Text = clsVoucher.GetDataValue(tb.Tag.ToString()).ToString();
}
foreach (CheckBox chk in pnlDemographics.Controls.OfType <CheckBox>())
{
chk.Checked = (bool)clsVoucher.GetDataValue(chk.Tag.ToString());
}
tbNotes.Text = clsVoucher.Notes;
tbVoucherType.Text = itemDescr;
cboHHCat.SelectedValue = clsVoucher.ClientType.ToString();
lblAmt.Text = CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_VoucherType, clsVItems.VoucherType);
oriAmt = clsVoucher.Amount;
switch (clsVItems.VoucherType)
{
case 0:
tbQty.Text = clsVoucher.Amount.ToString();
tbQty.Visible = true;
break;
case 1:
tbQty.Text = Convert.ToInt32(clsVoucher.Amount).ToString();
tbQty.Visible = true;
break;
case 2:
tbQty.Text = Convert.ToInt32(clsVoucher.Amount).ToString();
tbQty.Visible = false;
break;
default:
tbQty.Text = clsVoucher.Amount.ToString();
tbQty.Visible = true;
break;
}
}
} // end of DisplayControls
//-----------------------------------------------------------------------------------------
/// <summary>
/// Special handling is required to display the TypeCode value in the DataGridView. This
/// method provides the necessary processing to the base class.
/// </summary>
//-----------------------------------------------------------------------------------------
public override bool DisplayGridLineSpecial(int a_dataSetRow, int a_gridRow)
{
string rcdType = CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_Donation
, Convert.ToInt16(DataSetValue(a_dataSetRow, COLUMN_DefaultDonationType))); // Get the ID from DataSet row.
gridEditDonor[COLUMN_GRID_DFLTDONATETYPE, a_gridRow].Value = rcdType;
rcdType = CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_Donor
, Convert.ToInt16(DataSetValue(a_dataSetRow, COLUMN_RCD_TYPE))); // Get the ID from DataSet row.
gridEditDonor[COLUMN_GRID_RCD_TYPE, a_gridRow].Value = rcdType;
if (Convert.ToBoolean(DataSetValue(a_dataSetRow, COLUMN_INACTIVE)) == true)
{
gridEditDonor.Rows[a_gridRow].DefaultCellStyle.ForeColor = Color.Red;
}
return(rcdType.Length > 0);
} // end of DisplayGridLineSpecial
/// <summary>
/// Loads the Donation Log with the Donations for the selected date
/// </summary>
private void loadDonationLogList()
{
double totLbs = 0;
int totCnt = 0;
lvFoodDonations.Items.Clear();
ListViewItem lvItm;
btnEditDnrTrx.Text = "";
btnEditDnrTrx.Enabled = false;
btnDeleteTrx.Text = "";
btnDeleteTrx.Enabled = false;
btnShowDnrHist.Text = "";
btnShowDnrHist.Enabled = false;
for (int i = 0; i < clsFoodDonations.RowCount; i++)
{
clsFoodDonations.setDataRow(i);
lvItm = new ListViewItem();
lvItm.Name = clsFoodDonations.TrxID.ToString();
lvItm.Text = (i + 1).ToString();
lvItm.SubItems.Add(CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_Donation, clsFoodDonations.DonationType));
clsDonors.find(clsFoodDonations.DonorID);
lvItm.SubItems.Add(clsDonors.Name);
lvItm.SubItems.Add(clsFoodDonations.Pounds.ToString());
lvItm.SubItems.Add(clsFoodDonations.Notes);
lvItm.SubItems.Add(CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_FoodClass, clsFoodDonations.FoodClass));
lvItm.SubItems.Add(clsFoodDonations.FoodCode);
lvItm.SubItems.Add(clsFoodDonations.DonorID.ToString());
lvItm.SubItems.Add(clsFoodDonations.TrxID.ToString());
lvFoodDonations.Items.Add(lvItm);
totCnt++;
totLbs += clsFoodDonations.Pounds;
}
tbTotalCount.Text = totCnt.ToString();
tbTotalLbs.Text = totLbs.ToString();
}
/// <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;
}
public void createReport(Client clsClient)
{
Application m_oExcelApp;
_Workbook m_oBook;
_Worksheet m_oSheet;
int eRow = 7;
object saveAs = "";
string templatePath = "";
string savePath = CCFBGlobal.pathExe + "SchoolSupply\\PickupTickets" + DateTime.Today.Year.ToString() + "\\";
m_oExcelApp = new Application();
m_oExcelApp.Visible = true;
m_oSheet = null;
object missing = Type.Missing;
CCFBGlobal.verifyPath(savePath);
saveAs = savePath + "HhID" + CCFBGlobal.formatNumberWithSixLeadingZeros(clsClient.clsHH.ID) + ".xlsx";
templatePath = CCFBGlobal.pathTemplates + "NCCFBSchoolSupplyPickupTicket.xlsx";
//Object oTemplatePath = templatePath;
try
{
m_oBook = m_oExcelApp.Workbooks.Open(templatePath
, XlUpdateLinks.xlUpdateLinksNever, false, missing, missing, missing, true, missing, missing, true
, missing, missing, false, missing, XlCorruptLoad.xlNormalLoad);
Debug.Print(m_oBook.Sheets.Count.ToString());
m_oSheet = (_Worksheet)m_oBook.Sheets[1];
//m_oSheet.Cells[4, 2] = CCFBPrefs.FoodBankName;
m_oSheet.Cells[3, 2] = clsClient.clsHH.ID.ToString();
m_oSheet.Cells[4, 5] = clsClient.clsHH.SchSupplyPickupPerson;
for (int i = 0; i < clsClient.clsHHmem.RowCount; i++)
{
clsClient.clsHHmem.SetRecord(i);
if (clsClient.clsHHmem.Inactive == false && clsClient.clsHHmem.SchSupply == true)
{
eRow++;
m_oSheet.Cells[eRow, 1] = clsClient.clsHHmem.Name;
m_oSheet.Cells[eRow, 4] = clsClient.clsHHmem.Grade.ToString();
m_oSheet.Cells[eRow, 5] = clsClient.clsHHmem.Age.ToString();
m_oSheet.Cells[eRow, 6] = clsClient.clsHHmem.Sex;
m_oSheet.Cells[eRow, 7] = CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_SchSupplySchool, clsClient.clsHHmem.SchSupplySchool);
}
}
if (File.Exists(saveAs.ToString()) == true)
{
File.Delete(saveAs.ToString());
}
m_oBook.SaveAs(saveAs, XlFileFormat.xlWorkbookDefault, missing,
missing, true, false, XlSaveAsAccessMode.xlShared, missing, false, missing, missing, true);
m_oExcelApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_oExcelApp);
m_oSheet = null;
m_oBook = null;
m_oExcelApp = null;
error = false;
CCFBGlobal.openDocumentOutsideCCFB(saveAs.ToString());
}
catch (Exception ex)
{
m_oExcelApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_oExcelApp);
CCFBGlobal.appendErrorToErrorReport("", ex.GetBaseException().ToString());
error = true;
m_oSheet = null;
m_oBook = null;
m_oExcelApp = null;
//MessageBox.Show("Error accessing Excel: " + ex.ToString());
}
}