protected void Page_Load(object sender, EventArgs e)
{
string pagename = Path.GetFileName(Request.PhysicalPath);
if (Session["admin"] != null)
{
string action = Request.QueryString["action"];
id = int.Parse(Request.QueryString["Timetableid"]);
if (!IsPostBack)
{
DBFunctions db = new DBFunctions();
if (action == "update")
{
CourseList.DataSource = db.getcourselist();
CourseList.DataValueField = "ID";
CourseList.DataTextField = "Course";
CourseList.DataBind();
// Courses_tbl course = db.getcourses(id);
TimeTable_tbl ds = db.getTimeTable(id);
DropDownDay.SelectedValue = ds.Day;
STime.Text = ds.StartTime;
ETime.Text = ds.EndTime;
TeacherList.SelectedValue = ds.Teacher;
}
else
{
}
}
}
else
{
Response.Redirect("Login.aspx?Redirecturl=" + pagename);
}
}
protected void TimeTableBtn_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
int course = int.Parse(CourseList.SelectedValue);
string starttime = STime.Text;
string endtime = ETime.Text;
string day = DropDownDay.SelectedValue;
TimeTable_tbl dsFlag = db.checkTimeTable(course, starttime, endtime, day);
if (dsFlag != null)
{
Span1.InnerText = "TimeTable Already Exist";
}
else
{
//Program_tbl prgram = new Program_tbl { ProgramName = ProgrammeNametxt.Text, SecondChoice = int.Parse(dropdownSecondChoise.SelectedValue), HasCampus = int.Parse(dropdownCampus.SelectedValue), ApplicationFee = txtApplicationFee.Text, FormNumber = txtFormCh.Text, ProgrameType = dropdownPrograms.SelectedValue, HasJambData = int.Parse(dropdownJamb.SelectedValue), HasBioDataSection = int.Parse(dropdownBioData.SelectedValue), HasPreviousRecord = int.Parse(dropdownPreviousRecord.SelectedValue), HasCBTSchedule = int.Parse(dropdownCbtSchedule.SelectedValue), HasOlevelResult = int.Parse(dropdownOlevel.SelectedValue), Enable = true, DeptID = int.Parse(DropDownDept.SelectedValue), CutoffPoints = Cuttofpointstxt.Text, DateCreated = DateTime.Now.Date, AcceptenceFee = txtAcceptenceFee.Text, FormCh = txtFormCh.Text };
TimeTable_tbl ttable = new TimeTable_tbl {
CourseID = int.Parse(CourseList.SelectedValue), StartTime = STime.Text, EndTime = ETime.Text, Day = DropDownDay.SelectedItem.ToString(), Teacher = ""
};
db.addTimeTable(ttable);
}
Response.Redirect("AddTimeTable.aspx");
}
protected void TimeTableUpdateBtn_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
// Program_tbl prgram = new Program_tbl { ID = id, ProgramName = ProgrammeNametxt.Text, SecondChoice = int.Parse(dropdownSecondChoise.SelectedValue), HasCampus = int.Parse(dropdownCampus.SelectedValue), ApplicationFee = txtApplicationFee.Text, FormNumber = txtFormNum.Text, ProgrameType = dropdownPrograms.SelectedValue, HasJambData = int.Parse(dropdownJamb.SelectedValue), HasBioDataSection = int.Parse(dropdownBioData.SelectedValue), HasPreviousRecord = int.Parse(dropdownPreviousRecord.SelectedValue), HasCBTSchedule = int.Parse(dropdownCbtSchedule.SelectedValue), HasOlevelResult = int.Parse(dropdownOlevel.SelectedValue), Enable = true, DeptID = int.Parse(DropDownDept.SelectedValue), CutoffPoints = Cuttofpointstxt.Text, DateCreated = DateTime.Now.Date, AcceptenceFee = txtAcceptenceFee.Text, FormCh = txtFormCh.Text };
TimeTable_tbl timetable = new TimeTable_tbl { ID = id,CourseID = int.Parse(CourseList.SelectedValue), StartTime = STime.Text, EndTime = ETime.Text,Day=DropDownDay.SelectedValue,Teacher=TeacherList.SelectedValue };
db.updateTimeTable(timetable);
Response.Redirect("AddTimeTable.aspx");
}
protected void TimeTableUpdateBtn_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
// Program_tbl prgram = new Program_tbl { ID = id, ProgramName = ProgrammeNametxt.Text, SecondChoice = int.Parse(dropdownSecondChoise.SelectedValue), HasCampus = int.Parse(dropdownCampus.SelectedValue), ApplicationFee = txtApplicationFee.Text, FormNumber = txtFormNum.Text, ProgrameType = dropdownPrograms.SelectedValue, HasJambData = int.Parse(dropdownJamb.SelectedValue), HasBioDataSection = int.Parse(dropdownBioData.SelectedValue), HasPreviousRecord = int.Parse(dropdownPreviousRecord.SelectedValue), HasCBTSchedule = int.Parse(dropdownCbtSchedule.SelectedValue), HasOlevelResult = int.Parse(dropdownOlevel.SelectedValue), Enable = true, DeptID = int.Parse(DropDownDept.SelectedValue), CutoffPoints = Cuttofpointstxt.Text, DateCreated = DateTime.Now.Date, AcceptenceFee = txtAcceptenceFee.Text, FormCh = txtFormCh.Text };
TimeTable_tbl timetable = new TimeTable_tbl {
ID = id, CourseID = int.Parse(CourseList.SelectedValue), StartTime = STime.Text, EndTime = ETime.Text, Day = DropDownDay.SelectedValue, Teacher = TeacherList.SelectedValue
};
db.updateTimeTable(timetable);
Response.Redirect("AddTimeTable.aspx");
}
protected void TimeTableBtn_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
int course = int.Parse(CourseList.SelectedValue);
string starttime = STime.Text;
string endtime = ETime.Text;
string day = DropDownDay.SelectedValue;
TimeTable_tbl dsFlag = db.checkTimeTable(course,starttime,endtime,day);
if (dsFlag != null)
{
Span1.InnerText = "TimeTable Already Exist";
}
else
{
//Program_tbl prgram = new Program_tbl { ProgramName = ProgrammeNametxt.Text, SecondChoice = int.Parse(dropdownSecondChoise.SelectedValue), HasCampus = int.Parse(dropdownCampus.SelectedValue), ApplicationFee = txtApplicationFee.Text, FormNumber = txtFormCh.Text, ProgrameType = dropdownPrograms.SelectedValue, HasJambData = int.Parse(dropdownJamb.SelectedValue), HasBioDataSection = int.Parse(dropdownBioData.SelectedValue), HasPreviousRecord = int.Parse(dropdownPreviousRecord.SelectedValue), HasCBTSchedule = int.Parse(dropdownCbtSchedule.SelectedValue), HasOlevelResult = int.Parse(dropdownOlevel.SelectedValue), Enable = true, DeptID = int.Parse(DropDownDept.SelectedValue), CutoffPoints = Cuttofpointstxt.Text, DateCreated = DateTime.Now.Date, AcceptenceFee = txtAcceptenceFee.Text, FormCh = txtFormCh.Text };
TimeTable_tbl ttable = new TimeTable_tbl { CourseID = int.Parse(CourseList.SelectedValue), StartTime = STime.Text, EndTime = ETime.Text, Day = DropDownDay.SelectedItem.ToString(), Teacher = "" };
db.addTimeTable(ttable);
}
Response.Redirect("AddTimeTable.aspx");
}
public void updateTimeTable(TimeTable_tbl updatedts)
{
db = new CollegeERPDBEntities();
db.TimeTable_tbl.Attach(updatedts);
// var progrm = db.Program_tbl.Where(x => x.ID == id).FirstOrDefault();
db.Entry(updatedts).State = EntityState.Modified;
db.SaveChanges();
}
public void addTimeTable(TimeTable_tbl ttable)
{
using (db = new CollegeERPDBEntities())
{
db.TimeTable_tbl.Add(ttable);
db.SaveChanges();
}
}