//添加课程信息
private void AddSchedule(Entity.Schedule schedule)
{
Border border = new Border();
border.Background = ColorUtils.GetSolidColorBrush(schedule.colorCode);
border.Tag = schedule;
border.Tapped += new TappedEventHandler(ShowScheduleDetailInfo);
TextBlock textBlock = new TextBlock();
textBlock.TextTrimming = TextTrimming.CharacterEllipsis;
textBlock.TextWrapping = TextWrapping.Wrap;
textBlock.TextAlignment = TextAlignment.Center;
textBlock.HorizontalAlignment = HorizontalAlignment.Center;
textBlock.VerticalAlignment = VerticalAlignment.Center;
textBlock.FontSize = 13;
textBlock.Foreground = new SolidColorBrush(Colors.White);
textBlock.Text = schedule.scheduleName + "@" + schedule.scheduleLocation;
border.Child = textBlock;
Grid.Children.Add(border);
Grid.SetRow(border, schedule.row.Value + 2);
Grid.SetColumn(border, schedule.column.Value + 1);
Grid.SetRowSpan(border, schedule.scheduleLength.Value);
elementList.Add(border);
scheduleList.Add(schedule);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int sid = Convert.ToInt32(Request.QueryString["id"]);
Schedule Schedule=new Entity.Schedule();
List<Department> Departments=new List<Department> ();
List<User> Users = new List<User>();
using (Dal.DB db = new Dal.DB())
{
Departments=(from d in db.Departments select d).ToList();
Schedule = db.Schedules.Find(sid);
Users = db.Users.Where<User>(u => u.DepartmentID == Schedule.DepartmentID).ToList();
txtEditScheduleName.Text = Schedule.Title;
txtEditScheduleContent.Text = Schedule.Content;
foreach (Department Department in Departments)
{
ddlEditScheduleDepartment.Items.Add(Department.Title);
ddlEditScheduleDepartment.Items.FindByText(Department.Title).Value = Department.ID.ToString();
}
ddlEditScheduleDepartment.SelectedValue = Schedule.DepartmentID.ToString();
foreach (User User in Users)
{
ddlEditScheduleToUser.Items.Add(User.Username);
ddlEditScheduleToUser.Items.FindByText(User.Username).Value = User.ID.ToString();
}
ddlEditScheduleToUser.SelectedValue = Schedule.ToUserID.ToString();
}
}
}
//显示课程表详细信息
private async void ShowScheduleDetailInfo(object sender, TappedRoutedEventArgs e)
{
Entity.Schedule schedule = (sender as Border).Tag as Entity.Schedule;
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("课程类型：" + schedule.scheduleType + "\n");
stringBuilder.Append("上课节数：" + schedule.scheduleLesson + "\n");
stringBuilder.Append("上课周数：" + "第" + schedule.minScheduleWeek + "周至第" + schedule.maxScheduleWeek + "周\n");
stringBuilder.Append("任课教师：" + schedule.scheduleTeacher + "\n");
stringBuilder.Append("上课地点：" + schedule.scheduleLocation + "\n");
var messageDialog = new MessageDialog(stringBuilder.ToString())
{
Title = schedule.scheduleName
};
messageDialog.Commands.Add(new UICommand("确定"));
await messageDialog.ShowAsync();
}
private void btnSave_Click(object sender, EventArgs e)
{
//MessageBox.Show("fdsf");
//First we have to insert data into route table and then into the schedule table
this.RouteFill();
Entity.Schedule schedule = new Entity.Schedule();
try
{
schedule.ScheduleId = ScheduleRepo.GetId();
}
catch (Exception exception)
{
Console.WriteLine(exception);
}
schedule.DeptTime = this.dtpDeparture.Text;
schedule.ArrivalTime = this.dtpArrival.Text;
schedule.RouteId = this.Route.RouteId; //In Schedule table route_id is a foreign key.
try
{
RouteRepo.Insert(this.Route); //inserting into the route table
ScheduleRepo.Insert(schedule); //inserting into schedule table
MessageBox.Show("Created Successfully");
//After inserting data the route home page will be redirected
controlRoute route = new controlRoute();
MainControl.showControl(route, frmAdminDashboard.ActiveForm);
}
catch (Exception exception)
{
MessageBox.Show("Please Select A Bus No", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public abstract bool Update(Entity.Schedule item);
public abstract bool Delete(Entity.Schedule item);
public abstract uint Insert(Entity.Schedule item);
private void btnSave_Click(object sender, EventArgs e)
{
bool idExist;
bool checkIfBusExistSignal;
try
{
idExist = RouteRepo.SearchRouteId(this.disableBusIdText.Text);
}
catch (Exception exception)
{
Console.WriteLine(exception);
throw;
}
if (idExist) //For Update purpose
{
if (!this.RouteFill())
{
return;
}
else
{
Route.Status = this.routeStatus.Text;
//Following line used to store Route information when a row from data grid view is double clicked.
Route singleRouteInfo = RouteRepo.SingleRouteInfo(this.disableBusIdText.Text);
//Following line gets the route_id.
string secondRouteId = RouteRepo.CheckIfTwoRoutesExist(singleRouteInfo);
try
{
if (secondRouteId != null)//if two routes exist, will get a route_id, else null
{
//So there is two routes, and now checking if the bus exist to any different route if we select a different
//bus and click on save button.
checkIfBusExistSignal = RouteRepo.CheckIfBusExistInTwoRoutesForUpdate(this.cmbBus.Text, this.disableBusIdText.Text, secondRouteId);
}
else
{
//So there is one route, and now checking if the bus exist to any different route if we select a different
//bus and click on save button.
checkIfBusExistSignal = RouteRepo.CheckIfBusExistInRouteForUpdate(this.cmbBus.Text, this.disableBusIdText.Text);
}
}
catch (Exception exception)
{
MessageBox.Show("Something went wrong when check bus exist or not");
throw;
}
//we will check if the bus number exist for particular route_id in route table.
//If exist we will not update, else will update.
if (checkIfBusExistSignal == false)
{
try
{
bool updateRouteSignal = RouteRepo.Update(this.Route);
Entity.Schedule schedule = new Entity.Schedule();
schedule.ScheduleId = this.invisibleScheduleIdText.Text;
schedule.DeptTime = this.dateTimePicker1.Text;
schedule.ArrivalTime = this.dateTimePicker2.Text;
schedule.RouteId = this.disableBusIdText.Text;
bool updateScheduleSignal = ScheduleRepo.Update(schedule);
if (secondRouteId != null)
{
//MessageBox.Show("not null");
bool updateSecondRouteSignal = RouteRepo.UpdateSecondRoute(this.Route, secondRouteId);
}
if (updateRouteSignal && updateScheduleSignal)
{
MessageBox.Show("Route Updated Successuflly!!");
//Once the save button is clicked for edit, new Id, as primary key, will be generated for the route table.
this.disableBusIdText.Text = RouteRepo.GetId();
this.ClearRouteInput();
this.FillRouteDataGridView();
}
}
catch (Exception exception)
{
Console.WriteLine("Something went wrong in Update!\n" + exception);
}
}
else
{
MessageBox.Show("Bus Number already Exists in different Route!\nCannot Update. Get a new Bus!");
}
}
}
if (!idExist) //for insert purpose
{
if (!this.RouteFill())
{
return;
}
else if (this.RouteFill())
{
try
{
checkIfBusExistSignal = RouteRepo.CheckIfBusExistInRoute(this.cmbBus.Text);
}
catch (Exception exception)
{
MessageBox.Show("Something went wrong when check bus exist or not");
throw;
}
//we will check if the bus number exist in route table. If exist we will not insert, else will insert.
if (!checkIfBusExistSignal)//if return false we will insert, else not
{
bool insertSignal;
try
{
insertSignal = RouteRepo.Insert(this.Route); //inserting into the route table
}
catch (Exception exception)
{
MessageBox.Show("Something went wrong when inserting route");
throw;
}
//First we have to insert data into route table and then into the schedule table
Entity.Schedule schedule = new Entity.Schedule();
try
{
schedule.ScheduleId = ScheduleRepo.GetId();
}
catch (Exception exception)
{
MessageBox.Show("Something went wrong when getting schedule Id");
}
schedule.DeptTime = this.dateTimePicker1.Text;
schedule.ArrivalTime = this.dateTimePicker2.Text;
schedule.RouteId = this.disableBusIdText.Text; //In Schedule table route_id is a foreign key.
//this.Route.ScheduleId = schedule.ScheduleId; //In Route table schedule_id is a foreign key.
bool insertSignalSchedule;
try
{
insertSignalSchedule = ScheduleRepo.Insert(schedule); //inserting into schedule table
}
catch (Exception exception)
{
MessageBox.Show("Something went wrong when inserting schedule");
throw;
}
if (insertSignal && insertSignalSchedule)
{
MessageBox.Show("Route Created Successuflly!!");
//Once the save button is clicked, new Id, as primary key, will be generated for the route table.
try
{
this.disableBusIdText.Text = RouteRepo.GetId();
}
catch (Exception exception)
{
Console.WriteLine("Something went wrong in Create!\n" + exception);
}
this.ClearRouteInput();
this.FillRouteDataGridView();
}
}
else
{
MessageBox.Show("Bus Number already Exists in different Route!\nCannot Insert. Get a new Bus!");
}
}
}
}
