void webBrowser1_DocumentCompleted(object sender, WebBrowserDocumentCompletedEventArgs e)
{
if (Uploader)
{
HtmlDocument doc = this.webBrowser1.Document;
//this.webBrowser1.Focus();
SendKeys.Send("{TAB}" + "{TAB}" + VWA4Common.GlobalSettings.CurrentSiteName);
//SendKeys.Send("{TAB}" + VWA4Common.GlobalSettings.PrimaryUserName);
//SendKeys.Send("{TAB}" + VWA4Common.GlobalSettings.PrimaryUserEmail);
SendKeys.Send("{TAB}" + VWA4Common.AppContext.DBPathName);
webBrowser1.Show();
HtmlElement textBox = doc.GetElementsByTagName("input")["f3"];
//todo: need to set the attribute to the path name
//textBox.SetAttribute("value", "c:\\temp\\");
//textBox.SetAttribute("name", "name");
//textBox.SetAttribute("text", "text");
// Check the task complete
VWA4Common.UtilitiesInstance utils = new VWA4Common.UtilitiesInstance();
utils.setTaskCheck(DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek, CultureInfo.GetCultureInfo("en-US"), System.Globalization.DateTimeStyles.None), true, "uploadwastedata");
}
else
{
// Don't send any keys
HtmlDocument doc = this.webBrowser1.Document;
webBrowser1.Show();
}
}
private void viewer1_OnToolClick(object sender, DataDynamics.ActiveReports.Toolbar.ToolClickEventArgs e)
{
if (e.Tool.Caption == "&Print...")
{
if (_TaskName == "SWAT Agenda")
{
VWA4Common.UtilitiesInstance utils = new VWA4Common.UtilitiesInstance();
utils.setTaskCheck(DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek), true, "printswatform");
}
else if (_TaskName == "Staff Mtg. Agenda")
{
VWA4Common.UtilitiesInstance utils = new VWA4Common.UtilitiesInstance();
utils.setTaskCheck(DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek), true, "printmeetingscript");
}
}
}
private void ultraGrid1_AfterRowUpdate(object sender, RowEventArgs e)
{
if (this.ultraGrid1.ActiveRow.IsAddRow)
{
return;
}
CellsCollection row = null;
if (this.ultraGrid1.ActiveRow != null)
{
row = this.ultraGrid1.ActiveRow.Cells;
row["SiteID"].Value = VWA4Common.GlobalSettings.CurrentSiteID;
row["PeriodUniqueName"].Value = "Month";
if (row["PeriodStartDate"].Value == null)
{
MessageBox.Show("Period start date is required.");
return;
}
}
//ultraGrid1.UpdateData();
if (row != null)
{
decimal fca = row["FoodCostActual"].Value != DBNull.Value ? Convert.ToDecimal(row["FoodCostActual"].Value) : Convert.ToDecimal(0.00);
decimal fcb = row["FoodCostBudget"].Value != DBNull.Value ? Convert.ToDecimal(row["FoodCostBudget"].Value) : Convert.ToDecimal(0.00);
decimal fra = row["FoodRevenueActual"].Value != DBNull.Value ? Convert.ToDecimal(row["FoodRevenueActual"].Value) : Convert.ToDecimal(0.00);
decimal frb = row["FoodRevenueBudget"].Value != DBNull.Value ? Convert.ToDecimal(row["FoodRevenueBudget"].Value) : Convert.ToDecimal(0.00);
int mca = row["MealCountActual"].Value != DBNull.Value ? Convert.ToInt32(row["MealCountActual"].Value) : 0;
int mcb = row["MealCountBudget"].Value != DBNull.Value ? Convert.ToInt32(row["MealCountBudget"].Value) : 0;
this.updateFinancialData(fca, fcb, fra, frb, mca, mcb, row["PeriodUniqueName"].Value.ToString(), DateTime.Parse(row["PeriodStartDate"].Value.ToString()));
}
if (this.ultraGrid1.ActiveRow != null && this.ultraGrid1.ActiveRow.Cells["ID"].Value != DBNull.Value)
{
ultraGrid1.DataSource = VWA4Common.DB.Retrieve(sql);
Initialized = true;
ultraGrid1.Refresh();
}
// Check the task complete
VWA4Common.UtilitiesInstance utils = new VWA4Common.UtilitiesInstance();
utils.setTaskCheck(DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek), true, "entermonthlyfinancials");
}
private void bSave_Click(object sender, EventArgs e)
{
// First check to see if there is already a record for this site/date
//
// Load SWAT minutes for current week
//
string sql = "SELECT * FROM SWATMinutes WHERE (WeekStart >= #"
+ DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek).ToString("yyyy/MM/dd 00:00:00") + "#) AND (WeekStart < #"
+ DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek).AddDays(7).ToString("yyyy/MM/dd 00:00:00") + "#) AND (SiteID = "
+ VWA4Common.GlobalSettings.CurrentSiteID.ToString() + ")"
;
DataTable dt_result = VWA4Common.DB.Retrieve(sql);
if (dt_result.Rows.Count > 0)
{ // An entry for this week exists - update it
DataRow row = dt_result.Rows[0];
_CurrentID = int.Parse(row["ID"].ToString());
sql = "UPDATE SWATMinutes SET "
+ " SiteID=" + VWA4Common.GlobalSettings.CurrentSiteID.ToString() + ","
+ " WeekStart=#" + VWA4Common.GlobalSettings.StartDateOfSelectedWeek + "#,"
+ " AwardUserID='" + UserTypeID + "',"
+ " AwardType='" + tePartAward.Text + "',"
+ " ParticipationRating=" + (rgRateWeeklyPart.SelectedIndex + 1).ToString() + ","
+ " GoalsRating=" + (rgRateProgressGoals.SelectedIndex + 1).ToString() + ","
+ " Top10Review='" + teTop10ReviewNotes.Text + "',"
+ " GoalsReview='" + teWhatCanWeDo.Text + "',"
+ " KeySuccess='" + teKeySuccess.Text + "',"
+ " AwardReason='" + teAwardReason.Text + "'"
+ " WHERE ID=" + row["ID"].ToString();
VWA4Common.DB.Update(sql);
}
else
{ // No entry - insert one
sql = "INSERT INTO SWATMinutes (SiteID,WeekStart,AwardUserID,"
+ "AwardType,ParticipationRating,GoalsRating,Top10Review,"
+ "GoalsReview,KeySuccess,AwardReason)"
+ " VALUES('"
+ VWA4Common.GlobalSettings.CurrentSiteID.ToString()
+ "',#" + VWA4Common.GlobalSettings.StartDateOfSelectedWeek + "#"
+ ",'" + UserTypeID + "'"
+ ",'" + tePartAward.Text + "'"
+ "," + (rgRateWeeklyPart.SelectedIndex + 1).ToString()
+ "," + (rgRateProgressGoals.SelectedIndex + 1).ToString()
+ ",'" + teTop10ReviewNotes.Text + "'"
+ ",'" + teWhatCanWeDo.Text + "'"
+ ",'" + teKeySuccess.Text + "'"
+ ",'" + teAwardReason.Text + "'"
+ ")"
;
//sql = sql.Replace("\'", "\'\'");
_CurrentID = VWA4Common.DB.Insert(sql);
}
bCancel.Hide();
bSave.Hide();
// Check the task complete
VWA4Common.UtilitiesInstance utils = new VWA4Common.UtilitiesInstance();
utils.setTaskCheck(DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek), true, "enterswatminutes");
btnPrint.Visible = true;
//commonEvents.TaskSheetKey = "dashboard";
}
private void btnPrintReportSet_Click(object sender, EventArgs e)
{
VWA4Common.GlobalSettings.PrintViewReportsProgressCancelled = false;
//get the count of selected rows and drop each starting at the dropIndex
//this.Cursor = Cursors.WaitCursor;
try
{
//pf = new VWA4Common.ProgressForm();
//pf.SetupAndShow(this.ParentForm, "Printing Reports", "Creating Report List...", true, true);
int pd_left = (this.Left + ParentForm.Left) + this.Width / 2;
int pd_top = (this.Top + ParentForm.Top) + this.Height / 2;
VWA4Common.ProgressDialog.ShowProgressDialog("Looking for Reports' Names.", "", "", pd_left, pd_top);
frmReportViewer frmReports = new frmReportViewer();
frmReportViewer frmViewWaste = new frmReportViewer();
VWA4Common.ProgressDialog.SetLeadin("Report List created");
VWA4Common.ProgressDialog.SetLeadin("Report List inited");
bool isViewWaste = false, isReports = false;
btnPrintReportSet.Enabled = false;
int nRows = 0, nReports = 1;
if (ultraGrid1.Selected.Rows.Count > 0)
{
nRows = ultraGrid1.Selected.Rows.Count;
}
else
{
nRows = ultraGrid1.Rows.Count;
}
double progressTick = (nRows > 0 ? 100 / nRows : 1);
VWA4Common.ProgressDialog.SetLeadin("Generating Reports");
try
{
if (ultraGrid1.Selected.Rows.Count > 0)
{
foreach (UltraGridRow aRow in ultraGrid1.Selected.Rows)
{
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
if (VWA4Common.ProgressDialog.CancelPressed)
{
VWA4Common.ProgressDialog.CancelPressed = false;
btnPrintReportSet.Enabled = true;
return;
}
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPrint(id);
isViewWaste = true;
}
else
{
frmReports.AddPrint(id, true);
isReports = true;
}
nReports++;
}
}
else
{
foreach (UltraGridRow aRow in ultraGrid1.Rows)
{
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
if (VWA4Common.ProgressDialog.CancelPressed)
{
VWA4Common.ProgressDialog.CancelPressed = false;
btnPrintReportSet.Enabled = true;
return;
}
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPrint(id);
isViewWaste = true;
}
else
{
frmReports.AddPrint(id, true);
isReports = true;
}
nReports++;
}
}
//FinishProgress();
}
finally
{
FinishProgress();
btnPrintReportSet.Enabled = true;
}
//this.Cursor = Cursors.Default;
if (isReports)
{
frmReports.Print();
}
if (isViewWaste)
{
frmViewWaste.Print();
}
if (_IsWeekly)
{
//set checkbox in task
VWA4Common.UtilitiesInstance utils = new VWA4Common.UtilitiesInstance();
utils.setTaskCheck(DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek), true, "printweeklyreports");
}
}
catch (Exception ex)
{
//Note cancellation throws an exception
MessageBox.Show(ex.Message);
}
}
//private void GenerateViewReports()
//{
// frmReportViewer frmReports = new frmReportViewer();
// frmReportViewer frmViewWaste = new frmReportViewer();
// bool isReports = false;
// int nViewWaste = 0;
// pf.Visible = true;
// pf.Value = 0;
// //get the count of selected rows and drop each starting at the dropIndex
// if (ultraGrid1.Selected.Rows.Count > 0)
// {
// pf.Maximum = ultraGrid1.Selected.Rows.Count;
// foreach (UltraGridRow aRow in ultraGrid1.Selected.Rows)
// {
// int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
// if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
// {
// frmViewWaste.AddPDF(id);
// nViewWaste++;
// }
// else
// {
// frmReports.AddLoadParameters(id, true);
// isReports = true;
// }
// pf.PerformStep();
// }
// }
// else
// {
// pf.Maximum = ultraGrid1.Rows.Count;
// foreach (UltraGridRow aRow in ultraGrid1.Rows)
// {
// int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
// if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
// {
// frmViewWaste.AddPDF(id);
// nViewWaste++;
// }
// else
// {
// frmReports.AddLoadParameters(id, true);
// isReports = true;
// }
// pf.PerformStep();
// }
// }
// if (isReports)
// {
// frmReports.SetTitle(ultraGrid1.Rows[0].Cells["SerieName"].Value.ToString());
// frmReports.View();
// frmReports.Show();
// }
// if (nViewWaste > 0)
// {
// if (nViewWaste > 1)
// {
// DialogResult result = ShowSavePDF();
// if (result == DialogResult.Cancel)
// return;
// string fileName = this.saveFileDialog1.FileName;
// frmViewWaste.ShowPDF(fileName);
// }
// else
// {
// frmViewWaste.View();
// frmViewWaste.Show();
// }
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message);
// }
//}
private void btnViewReportSet_Click(object sender, EventArgs e)
{
VWA4Common.GlobalSettings.PrintViewReportsProgressCancelled = false;
try
{
//pf = new VWA4Common.ProgressForm();
//pf.SetupAndShow(this.ParentForm, "Showing Reports", "Creating Report List...", true, true);
int pd_left = (this.Left + ParentForm.Left) + this.Width / 2;
int pd_top = (this.Top + ParentForm.Top) + this.Height / 2;
VWA4Common.ProgressDialog.ShowProgressDialog("Looking for Reports' Names.", "", "", pd_left, pd_top);
frmReportViewer frmReports = new frmReportViewer();
frmReportViewer frmViewWaste = new frmReportViewer();
int nRows = 0, nReports = 1;
if (ultraGrid1.Selected.Rows.Count > 0)
{
nRows = ultraGrid1.Selected.Rows.Count;
}
else
{
nRows = ultraGrid1.Rows.Count;
}
btnViewReportSet.Enabled = false;
VWA4Common.ProgressDialog.SetLeadin("Report List created");
VWA4Common.ProgressDialog.SetLeadin("Report List created");
bool isReports = false;
int nViewWaste = 0;
double progressTick = (nRows > 0 ? 100 / nRows : 1);
VWA4Common.ProgressDialog.SetLeadin("Generating Reports");
try
{
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
//get the count of selected rows and drop each starting at the dropIndex
if (ultraGrid1.Selected.Rows.Count > 0)
{
foreach (UltraGridRow aRow in ultraGrid1.Selected.Rows)
{
if (_progressCancelled)
{
btnViewReportSet.Enabled = true;
return;
}
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
nViewWaste++;
}
else
{
frmReports.AddLoadParameters(id, true);
isReports = true;
}
nReports++;
}
}
else
{
foreach (UltraGridRow aRow in ultraGrid1.Rows)
{
if (_progressCancelled)
{
btnViewReportSet.Enabled = true;
return;
}
VWA4Common.ProgressDialog.SetStatus("Generating report " + nReports + " of " + nRows, (int)(nReports * progressTick));
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
nViewWaste++;
}
else
{
frmReports.AddLoadParameters(id, true);
isReports = true;
}
nReports++;
}
}
}
finally
{
FinishProgress();
btnViewReportSet.Enabled = true;
}
//FinishProgress();
//btnViewReportSet.Enabled = true;
if (isReports)
{
frmReports.SetTitle(ultraGrid1.Rows[0].Cells["SerieName"].Value.ToString());
frmReports.View();
frmReports.Show();
}
if (nViewWaste > 0)
{
if (nViewWaste > 1)
{
DialogResult result = ShowSavePDF();
if (result == DialogResult.Cancel)
{
return;
}
string fileName = this.saveFileDialog1.FileName;
frmViewWaste.ShowPDF(fileName);
}
else
{
frmViewWaste.View();
frmViewWaste.Show();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (!_IsWeekly)
{
//set checkbox in task
VWA4Common.UtilitiesInstance utils = new VWA4Common.UtilitiesInstance();
utils.setTaskCheck(DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek), true, "reviewreports");
}
}
private void btnViewReportSet_Click(object sender, EventArgs e)
{
SetReportOrder();
frmReportViewer frmReports = new frmReportViewer();
frmReportViewer frmViewWaste = new frmReportViewer();
bool isReports = false;
int nViewWaste = 0;
this.Cursor = Cursors.WaitCursor;
bool isWeekly = false;
//get the count of selected rows and drop each starting at the dropIndex
foreach (UltraGridRow aRow in ultraGrid1.Selected.Rows)
{
isWeekly = Regex.IsMatch(aRow.Cells["SerieName"].Value.ToString(), "weekly", RegexOptions.IgnoreCase);
if (aRow.Band.Key == "ReportSet")
{
int id = int.Parse(aRow.Cells["ReportMemorized.ID"].Value.ToString());
if (aRow.Cells["ReportType"].Value.ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
nViewWaste++;
}
else
{
frmReports.AddLoadParameters(id, isWeekly);
isReports = true;
}
}
else
{
DataView view = _ReportSeries.Tables["ReportSet"].DefaultView;
view.RowFilter = "ReportSeries.ID = " + aRow.Cells["ID"].Value;
view.Sort = "Order";
foreach (DataRowView viewRow in view)
{
if (viewRow["ReportMemorized.ID"].ToString() != "")
{
int id = int.Parse(viewRow["ReportMemorized.ID"].ToString());
if (viewRow["ReportType"].ToString() == "View Waste")
{
frmViewWaste.AddPDF(id);
nViewWaste++;
}
else
{
frmReports.AddLoadParameters(id, isWeekly);
isReports = true;
}
}
}
}
}
this.Cursor = Cursors.Default;
if (isReports)
{
frmReports.SetTitle(ultraGrid1.Rows[0].Cells["SerieName"].Value.ToString());
frmReports.View();
frmReports.Show();
}
if (nViewWaste > 0)
{
if (nViewWaste > 1)
{
DialogResult result = ShowSavePDF();
if (result == DialogResult.Cancel)
{
return;
}
string fileName = this.saveFileDialog1.FileName;
frmViewWaste.ShowPDF(fileName);
}
else
{
frmViewWaste.View();
frmViewWaste.Show();
}
}
// set task checkboxes
VWA4Common.UtilitiesInstance utils = new VWA4Common.UtilitiesInstance();
utils.setTaskCheck(DateTime.Parse(VWA4Common.GlobalSettings.StartDateOfSelectedWeek), true, "reviewreports");
}