public void InsertItem(DayItem Item)
{
daysTableAdapter.Insert(Date, Item.ProfileId, Item.Lunch, Item.LunchPrice, Item.TakeOutPrice,Item.ProgramPrice,Item.MiscellaneousPrice, Item.VanPrice, Item.RoundTripPrice, Item.BookOfTickets, Item.Comments, Item.Attendance,Item.Total,ProfileProvider.GetCategory(Item.ProfileId));
}
public bool IsInDay(DayItem Item)
{
bool _IsInDay = false;
daysTableAdapter.Fill(tDayDataSet.Days, Date);
foreach (DataRow Row in tDayDataSet.Days)
{
if ((int)Row["ProfileId"] == Item.ProfileId)
{
_IsInDay = true;
break;
}
}
return _IsInDay;
}
public void CreateDay()
{
IsCreated = CheckCreated();
if (!IsCreated)
{
attendanceTableAdapter.Fill(tDayDataSet.Attendance);
foreach (DataRow Row in tDayDataSet.Attendance)
{
if (Date.DayOfWeek != DayOfWeek.Saturday && Date.DayOfWeek != DayOfWeek.Sunday)
{
if ((bool)Row[Date.DayOfWeek.ToString()] == true && (int)Row["ProfileId"] > 0 && !ProfileProvider.GetDelStatus((int)Row["ProfileId"]))
{
DayItem Item = new DayItem((int)Row["ProfileId"]);
InsertItem(Item);
}
}
}
}
}
private void dataGridView2_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.Button == System.Windows.Forms.MouseButtons.Left)
{
FormProvider.CurrentRowIndex = e.RowIndex;
FormProvider.CurrentColIndex = e.ColumnIndex;
switch (e.ColumnIndex)
{
case 1:
if ((bool)dataGridView2.Rows[e.RowIndex].Cells[e.ColumnIndex].Value)
{
if (DialogResult.Yes == MessageBox.Show("Are you sure you want to delete this entry?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
daysTableAdapter.Delete((int)dataGridView2.Rows[e.RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value);
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
}
else
{
dataGridView2.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = 1;
dataGridView2.RefreshEdit();
}
}
break;
case 2:
if ((bool)dataGridView2.Rows[e.RowIndex].Cells[e.ColumnIndex].EditedFormattedValue)
{
DayItem Item = new DayItem((int)dataGridView2.Rows[e.RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.Lunch = false;
Item.LunchPrice = Decimal.Zero;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
}
else
{
DayItem Item = new DayItem((int)dataGridView2.Rows[e.RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.Lunch = true;
Item.LunchPrice = Item.GetLunchPrice();
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
}
break;
}
ReCountTotals();
}
else if (e.Button == System.Windows.Forms.MouseButtons.Right)
{
FormProvider.CurrentRowIndex = e.RowIndex;
FormProvider.CurrentColIndex = e.ColumnIndex;
dataGridView2.Rows[e.RowIndex].Cells[e.ColumnIndex].Selected = true;
switch (e.ColumnIndex)
{
case 3:
contextMenuStrip1.Tag = e.ColumnIndex;
contextMenuStrip1.Show(MousePosition.X, MousePosition.Y);
break;
case 6:
if (ProfileProvider.GetCategory((int)dataGridView2.Rows[e.RowIndex].Cells["profileIdDataGridViewTextBoxColumn1"].Value) == 1)
{
contextMenuStrip1.Tag = e.ColumnIndex;
contextMenuStrip1.Show(MousePosition.X, MousePosition.Y);
}
break;
case 8:
if (ProfileProvider.GetCategory((int)dataGridView2.Rows[e.RowIndex].Cells["profileIdDataGridViewTextBoxColumn1"].Value) == 1)
{
contextMenuStrip1.Tag = e.ColumnIndex;
contextMenuStrip1.Show(MousePosition.X, MousePosition.Y);
}
break;
}
}
}
private void dataGridView2_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
FormProvider.CurrentRowIndex = e.RowIndex;
FormProvider.CurrentColIndex = e.ColumnIndex;
switch (e.ColumnIndex)
{
case 3:
DayItem Item = new DayItem((int)dataGridView2.Rows[e.RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.LunchPrice = (decimal)dataGridView2.Rows[e.RowIndex].Cells["lunchPriceDataGridViewTextBoxColumn"].Value;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
case 4:
Item = new DayItem((int)dataGridView2.Rows[e.RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.TakeOutPrice = (decimal)dataGridView2.Rows[e.RowIndex].Cells["takeOutPriceDataGridViewTextBoxColumn"].Value;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
case 5:
Item = new DayItem((int)dataGridView2.Rows[e.RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.MiscellaneousPrice = (decimal)dataGridView2.Rows[e.RowIndex].Cells["miscellaneousPriceDataGridViewTextBoxColumn"].Value;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
case 6:
Item = new DayItem((int)dataGridView2.Rows[e.RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.ProgramPrice = (decimal)dataGridView2.Rows[e.RowIndex].Cells["ProgramPrice"].Value;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
case 7:
Item = new DayItem((int)dataGridView2.Rows[e.RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.VanPrice = (decimal)dataGridView2.Rows[e.RowIndex].Cells["vanPriceDataGridViewTextBoxColumn"].Value;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
case 8:
Item = new DayItem((int)dataGridView2.Rows[e.RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.RoundTripPrice = (decimal)dataGridView2.Rows[e.RowIndex].Cells["roundTripPriceDataGridViewTextBoxColumn"].Value;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
case 9:
Item = new DayItem((int)dataGridView2.Rows[e.RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.BookOfTickets = (decimal)dataGridView2.Rows[e.RowIndex].Cells["bookOfTicketsDataGridViewTextBoxColumn"].Value;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
case 11:
Item = new DayItem((int)dataGridView2.Rows[e.RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.Comments = dataGridView2.Rows[e.RowIndex].Cells["commentsDataGridViewTextBoxColumn"].Value.ToString();
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
}
ReCountTotals();
}
private void toolStripButton6_Click(object sender, EventArgs e)
{
if (dataGridView3.Rows.Count > 0)
{
DayItem Item = new DayItem((int)dataGridView3.Rows[dataGridView3.SelectedCells[0].RowIndex].Cells[0].Value);
if (!CurrentDay.IsInDay(Item))
{
CurrentDay.InsertItem(Item);
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
panel5.Visible = false;
ReCountTotals();
}
else
{
panel5.Visible = false;
if (ProfileProvider.GetCategory(Item.ProfileId) == 1)
{
foreach (DataGridViewRow Row in dataGridView2.Rows)
{
if ((int)Row.Cells["profileIdDataGridViewTextBoxColumn1"].Value == Item.ProfileId)
{
Row.Cells["profileIdDataGridViewTextBoxColumn1"].Selected = true;
}
}
}
else
{
foreach (DataGridViewRow Row in dataGridView8.Rows)
{
if ((int)Row.Cells["dataGridViewComboBoxColumn2"].Value == Item.ProfileId)
{
Row.Cells["dataGridViewComboBoxColumn2"].Selected = true;
}
}
}
}
}
}
private void permaToolStripMenuItem_Click(object sender, EventArgs e)
{
switch ((int)contextMenuStrip1.Tag)
{
case 3:
servicesTableAdapter.Fill(tDayDataSet.Services);
DataRow Row = tDayDataSet.Services.FindByServiceId(1);
Row["ServiceFee"] = dataGridView2.Rows[dataGridView2.SelectedCells[0].RowIndex].Cells[3].Value.ToString();
servicesTableAdapter.Update(tDayDataSet);
foreach (DataRow Dat in tDayDataSet.Days)
{
if ((bool)Dat["Lunch"] && (int)Dat["Category"]==1)
{
DayItem Item = new DayItem((int)Dat["DayId"],CurrentDay.Date);
Item.LunchPrice = (decimal)dataGridView2.Rows[dataGridView2.SelectedCells[0].RowIndex].Cells[3].Value;
Item.Update();
}
}
break;
case 6:
servicesTableAdapter.Fill(tDayDataSet.Services);
Row = tDayDataSet.Services.FindByServiceId(3);
Row["ServiceFee"] = dataGridView2.Rows[dataGridView2.SelectedCells[0].RowIndex].Cells[6].Value.ToString();
servicesTableAdapter.Update(tDayDataSet);
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
foreach (DataRow Dat in tDayDataSet.Days)
{
if (ProfileProvider.GetCategory((int)Dat["ProfileId"]) == 1)
{
DayItem Item = new DayItem((int)Dat["DayId"], CurrentDay.Date);
Item.ProgramPrice = (decimal)dataGridView2.Rows[dataGridView2.SelectedCells[0].RowIndex].Cells[6].Value;
Item.Update();
}
}
break;
case 8:
servicesTableAdapter.Fill(tDayDataSet.Services);
Row = tDayDataSet.Services.FindByServiceId(2);
Row["ServiceFee"] = dataGridView2.Rows[dataGridView2.SelectedCells[0].RowIndex].Cells[8].Value.ToString();
servicesTableAdapter.Update(tDayDataSet);
foreach (DataRow Dat in tDayDataSet.Days)
{
if (ProfileProvider.GetCategory((int)Dat["ProfileId"]) == 1 && Double.Parse(Dat["RoundTripPrice"].ToString())>0)
{
DayItem Item = new DayItem((int)Dat["DayId"], CurrentDay.Date);
Item.RoundTripPrice = (decimal)dataGridView2.Rows[dataGridView2.SelectedCells[0].RowIndex].Cells[8].Value;
Item.Update();
}
}
break;
case -3:
servicesTableAdapter.Fill(tDayDataSet.Services);
Row = tDayDataSet.Services.FindByServiceId(4);
Row["ServiceFee"] = dataGridView8.Rows[dataGridView8.SelectedCells[0].RowIndex].Cells[3].Value.ToString();
servicesTableAdapter.Update(tDayDataSet);
foreach (DataRow Dat in tDayDataSet.Days)
{
if ((bool)Dat["Lunch"] && (int)Dat["Category"]!=1)
{
DayItem Item = new DayItem((int)Dat["DayId"],CurrentDay.Date);
Item.LunchPrice = (decimal)dataGridView8.Rows[dataGridView8.SelectedCells[0].RowIndex].Cells[3].Value;
Item.Update();
}
}
break;
}
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
}
private void noChargeToolStripMenuItem_Click(object sender, EventArgs e)
{
if (contextMenuStrip1.Tag != null)
{
switch ((int)contextMenuStrip1.Tag)
{
case 3:
DayItem Item = new DayItem((int)dataGridView2.Rows[dataGridView2.SelectedCells[0].RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.LunchPrice = 0;
Item.Lunch = false;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
case 6:
Item = new DayItem((int)dataGridView2.Rows[dataGridView2.SelectedCells[0].RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.ProgramPrice = 0;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
case 8:
Item = new DayItem((int)dataGridView2.Rows[dataGridView2.SelectedCells[0].RowIndex].Cells["dayIdDataGridViewTextBoxColumn"].Value, CurrentDay.Date);
Item.RoundTripPrice = 0;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
case -3:
Item = new DayItem((int)dataGridView8.Rows[dataGridView8.SelectedCells[0].RowIndex].Cells["dataGridViewTextBoxColumn12"].Value, CurrentDay.Date);
Item.LunchPrice = 0;
Item.Lunch = false;
Item.Update();
daysTableAdapter.Fill(tDayDataSet.Days, CurrentDay.Date);
break;
}
}
}