private void fillUnusedForm()
{
using (PupilBookEntities db = new PupilBookEntities())
{
var item = (from i in db.SheduleHoursSet
where i.Id == _SheduleHoursSet_ID
select new { start = i.BeginTime, end = i.EndTime }).First();
LabelInfo.Text = "Zvolte předmět a studíjní skupinu";
Label1.Text = "Začátek - " + item.start + " Konec - " + item.end;
Label2.Text = "Den v týdnu " + MainMenu.Days.GetDay(_Day);
var StudyGroups = from i in db.StudyGroupSet
where i.SchoolYear_Id == _YearID
select new { StudyGroupID = i.Id, StudyGroupName = i.GroupNameShort };
ddlStudyGroup.Items.Add(new ListItem("Vybert studíjní skupinu", "-1"));
ddlSubject.Items.Add(new ListItem("Vyberte předmět", "-1"));
foreach (var i in StudyGroups)
{
ddlStudyGroup.Items.Add(new ListItem(i.StudyGroupName, i.StudyGroupID.ToString()));
}
var Subjects = from i in db.StudySubjectSet
join j in db.SubjectSubCategorySet on i.Id equals j.StudySubject_Id
where i.SchoolYear_Id == _YearID
select new { SubjectName = i.Name, SubjectSubCatName = j.Name, j.Id };
foreach (var i in Subjects)
{
ddlSubject.Items.Add(new ListItem(i.SubjectName + " - " + i.SubjectSubCatName, i.Id.ToString()));
}
}
}
protected void Add_Click(object sender, EventArgs e)
{
using (var db = new PupilBookEntities())
{
db.StudyGroupSet.Add(new StudyGroupSet()
{
GroupDescription = ClassDesription.Text,
GroupName = ClassRoom.Text,
GroupNameShort = ClassRoomShort.Text,
SchoolYear_Id = Int32.Parse(DropDownListYears.SelectedValue)
});
db.SaveChanges();
}
GridViewClassRooms.DataBind();
}
private void CreateSimpleCalendar(int SheduleID)
{
using (PupilBookEntities db = new PupilBookEntities())
{
var times = from i in db.SheduleHoursSet
where i.Shedule_Id == SheduleID
select i;
int YearID = Int32.Parse(Server.UrlDecode(Request.QueryString["YearID"]));
var Subjects = from i in db.SubjectSubCategorySet
join j in db.StudySubjectSet on i.StudySubject_Id equals j.Id
where j.SchoolYear_Id == YearID
select i;
var StudyGroup = from i in db.StudyGroupSet
where i.SchoolYear_Id == YearID
select i;
TableRow rowHeader = new TableRow();
TableCell FirstCell = new TableCell();
FirstCell.CssClass = "Form-Control";
FirstCell.Text = "<b>Rozvrh Hodin<b/>";
rowHeader.Cells.Add(FirstCell);
foreach (var i in times)
{
TableCell cell = new TableCell();
cell.CssClass = "Form-Control";
cell.Text = String.Format("{0}<br/>{1}", i.BeginTime.ToString(), i.EndTime.ToString());
rowHeader.Cells.Add(cell);
SheduleTable.Rows.Add(rowHeader);
}
for (int j = 0; j < 5; j++)
{
TableCell Days = new TableCell();
Days.CssClass = "Form-Control";
Days.Text = MainMenu.Days.GetDay(j);
TableRow row = new TableRow();
row.Cells.Add(Days);
foreach (var i in times)
{
TableCell cell1 = new TableCell();
SheduleButtons button = new SheduleButtons(YearID, i.Id, j, SheduleID, null);
cell1.Controls.Add(button);
row.Cells.Add(cell1);
}
SheduleTable.Rows.Add(row);
}
}
}
private void LoadShedule()
{
using (PupilBookEntities db = new PupilBookEntities())
{
int SheduleID = Int32.Parse(Server.UrlDecode(Request.QueryString["SheduleID"]));
var shedule = (from i in db.SheduleSet
where i.Id == SheduleID
select i).First();
//Testing if User using for this Shedule Even/ODD System
if (shedule.EvenWeek == true)
{
MultiViewSheduleCreator.ActiveViewIndex = 1;
CreateDoubleCalendar(SheduleID);
}
else
{
MultiViewSheduleCreator.ActiveViewIndex = 0;
CreateSimpleCalendar(SheduleID);
}
}
}
private void SaveData(int SubjectId, int StudyGroupID)
{
_SheduleHoursSet_ID = Int32.Parse(Server.UrlDecode(Request.QueryString["SheduleHoursSet_ID"]));
_Day = Int32.Parse(Server.UrlDecode(Request.QueryString["Day"]));
_SheduleID = Int32.Parse(Server.UrlDecode(Request.QueryString["SheduleID"]));
switch (Server.UrlDecode(Request.QueryString["Even"]).ToLower())
{
case "true": _Even = true;
break;
case "false": _Even = false;
break;
default: _Even = null;
break;
};
try
{
_SheduleItemID = Int32.Parse(Server.UrlDecode(Request.QueryString["SheduleItemID"]));
}
catch
{
_SheduleItemID = null;
}
if (_SheduleItemID == null)
{
//TODO Security
SheduleItemSet item = new SheduleItemSet()
{
Day = (byte)_Day,
Even = _Even,
Shedule_Id = (int)_SheduleID,
SheduleHoursSet_ID = (int)_SheduleHoursSet_ID,
StudyGroup_Id = StudyGroupID,
SubjectSubCategory_Id = SubjectId
};
using (PupilBookEntities db = new PupilBookEntities())
{
if (item.StudyGroup_Id == -1) item.StudyGroup_Id = null;
if (item.SubjectSubCategory_Id == -1) item.SubjectSubCategory_Id = null;
db.SheduleItemSet.Add(item);
db.SaveChanges();
}
Response.Redirect("~/MainMenu/SheduleEditor?YearID=" + Server.UrlDecode(Request.QueryString["Year"]) + "&SheduleID=" + _SheduleID);
}
else
{
using (PupilBookEntities db = new PupilBookEntities())
{
int? StudyGroupTmp = Int32.Parse(ddlStudyGroup.SelectedValue);
int? SubjectTmp = Int32.Parse(ddlSubject.SelectedValue);
if (StudyGroupTmp == -1 && SubjectTmp == -1)
{
var item = (from i in db.SheduleItemSet
where i.Id == _SheduleItemID
select i).First();
db.SheduleItemSet.Remove(item);
db.SaveChanges();
}
else
{
SheduleItemSet SheduleItem = (from i in db.SheduleItemSet
where i.Id == _SheduleItemID
select i).First();
SheduleItem.StudyGroup_Id = StudyGroupTmp;
SheduleItem.SubjectSubCategory_Id = SubjectTmp;
db.SaveChanges();
}
}
Response.Redirect("~/MainMenu/SheduleEditor?YearID=" + Server.UrlDecode(Request.QueryString["Year"]) + "&SheduleID=" + _SheduleID);
}
}
