protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
var controller = new RacingController();
var schedule = controller.Schedules_List(Calendar1.SelectedDate);
ScheduleGridView.DataSource = schedule;
ScheduleGridView.DataBind();
Close_Results();
RecordRaceTimes.Visible = false;
GridView1.Visible = false;
}
private void EditScheduleButton_Click(object sender, EventArgs e)
{
bool isChanged = false;
if (ScheduleGridView.SelectedRows.Count == 0)
{
return;
}
if (WorkersComboBox.Text.Trim().Length == 0 || WorkersComboBox.Text == null)
{
return;
}
if (WorkTimeTextbox.Text.Trim().Length == 0 || WorkTimeTextbox.Text == null)
{
return;
}
using (LibraryDBEntities dbContext = new LibraryDBEntities()) {
int day_IdCell = ScheduleGridView.ColumnCount - 1;
int name_Cell = ScheduleGridView.ColumnCount - 3;
int day_Id = Convert.ToInt32(ScheduleGridView.SelectedRows[0].Cells[day_IdCell].Value);
string[] arr = WorkersComboBox.Text.Split('-');
int workerID = Convert.ToInt32(arr[0].Trim());
Schedule day = dbContext.Schedules.SingleOrDefault(d => d.Day_Id == day_Id);
foreach (Employee employee in dbContext.Employees)
{
if (employee.Employee_Id == workerID)
{
day.Employee_Id = workerID;
day.WorkTime = WorkTimeTextbox.Text;
}
}
dbContext.SaveChanges();
isChanged = true;
Employee newScheduleLibrarian = dbContext.Employees.SingleOrDefault(w => w.Employee_Id == workerID);
ScheduleGridView.SelectedRows[0].Cells[name_Cell].Value = newScheduleLibrarian.Name;
ScheduleGridView.SelectedRows[0].Cells[name_Cell + 1].Value = WorkTimeTextbox.Text;
ScheduleGridView.Refresh();
if (isChanged)
{
MessageBox.Show("Schedule was edited", "Success", MessageBoxButtons.OK);
}
}
}
protected void SaveButton_Command(object sender, CommandEventArgs e)
{
string error = string.Empty;
var controller = new RacingController();
HiddenField raceId = null;
foreach (GridViewRow row in GridView1.Rows)
{
raceId = (HiddenField)row.FindControl("RaceID");
}
DropDownList memberDropDown = (DropDownList)GridView1.FooterRow.FindControl("MemberDropDown");
DropDownList feeDropDown = (DropDownList)GridView1.FooterRow.FindControl("FeeDropDown");
DropDownList carDropDown = (DropDownList)GridView1.FooterRow.FindControl("SerialDropDown");
decimal raceFee;
if (feeDropDown.SelectedIndex == 1)
{
TextBox feeTextBox = (TextBox)GridView1.FooterRow.FindControl("FeeTextBox");
raceFee = int.Parse(feeTextBox.Text);
}
else if (feeDropDown.SelectedIndex == 0)
{
raceFee = 0;
}
else
{
raceFee = decimal.Parse(feeDropDown.SelectedItem.Text);
}
RosterViewModel roster = new RosterViewModel()
{
MemberID = int.Parse(memberDropDown.SelectedValue),
CarID = int.Parse(carDropDown.SelectedValue),
RaceID = int.Parse(raceId.Value),
RaceFee = raceFee
};
var racerCount = controller.Racer_Count(roster);
InvoiceViewModel invoice = null;
if (memberDropDown.SelectedIndex == 0)
{
error = error + " You must select a member when adding a new racer.";
}
if (raceFee == 0)
{
error = error + " You must enter a race fee in order to add a new racer.";
}
if (racerCount.Current > racerCount.Max)
{
error = error + " Race is already full. Cannot register additional racers.";
}
if (error.Trim().Length == 0)
{
try
{
invoice = controller.Add_Racer(roster, User.Identity.Name);
} catch (Exception ex)
{
MessageUserControl1.ShowInfo(ex.Message, "Unable to save racer");
}
var updateSchedule = controller.Schedules_List(Calendar1.SelectedDate);
RosterDataSource.SelectParameters.Clear();
RosterDataSource.SelectParameters.Add(new Parameter("raceId", TypeCode.Int32, raceId.Value));
RosterDataSource.DataBind();
ScheduleGridView.DataSource = updateSchedule;
ScheduleGridView.DataBind();
MessageUserControl1.ShowInfo("Success", ($"Racer Added to roster. Invoice #{invoice.InvoiceID} created by {User.Identity.Name}. Subtotal - {invoice.Subtotal:C2}, GST - {invoice.GST:C2}, Total - {invoice.Total:C2}"));
}
else
{
MessageUserControl1.ShowInfo("Failure", error);
}
CloseFooter();
}