protected void btnaddprogramme_Click(object sender, EventArgs e) { DBFunctions db = new DBFunctions(); var checkcourse = db.getcourselist().Where(x => x.CourseCode == CourseCode.Text).FirstOrDefault(); if (checkcourse == null) { //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 }; Courses_tbl course = new Courses_tbl { Course = coursename.Text, Fee = Feetxt.Text, Marks = Markstxt.Text, Credit_Hours = int.Parse(CreditHours.Text), CourseCode = CourseCode.Text }; int cid = db.addcourse(course); foreach (ListItem chck in CheckBoxPrgramlist.Items) { if (chck.Selected) { ProgrammeCourses_tbl prgcrs = new ProgrammeCourses_tbl { ProgramID = int.Parse(chck.Value), CourseID = cid }; db.addprogrammecourse(prgcrs); } } messagae.Text = "Course Successfully Added"; messagae.Visible = true; // Response.Redirect("ManageCourses.aspx"); } else { messagae.Text = "Course Code Already Exist"; messagae.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { string pagename = Path.GetFileName(Request.PhysicalPath); if (Session["userid"] != null) { if (!IsPostBack) { DBFunctions db = new DBFunctions(); int userid = int.Parse(Session["userid"].ToString()); List <CourseTeacherAssignment_tbl> courses = db.getassigncourses(userid); List <Courses_tbl> crslist = new List <Courses_tbl>(); Courses_tbl tempcours = new Courses_tbl { Course = "Select Course" }; crslist.Add(tempcours); foreach (var crs in courses) { crslist.Add(crs.Courses_tbl); } Dropdowncrs.DataSource = crslist.OrderBy(x => x.ID); Dropdowncrs.DataValueField = "ID"; Dropdowncrs.DataTextField = "Course"; Dropdowncrs.DataBind(); } } else { Response.Redirect("Login.aspx?Redirecturl=" + pagename); } }
protected void Page_Load(object sender, EventArgs e) { string pagename = Path.GetFileName(Request.PhysicalPath); if (Session["userid"] != null) { if (!IsPostBack) { DBFunctions db = new DBFunctions(); int userid = int.Parse(Session["userid"].ToString()); List<CourseTeacherAssignment_tbl> courses= db.getassigncourses(userid); List<Courses_tbl> crslist=new List<Courses_tbl>(); Courses_tbl tempcours = new Courses_tbl { Course = "Select Course" }; crslist.Add(tempcours); foreach(var crs in courses) { crslist.Add(crs.Courses_tbl); } Dropdowncrs.DataSource =crslist.OrderBy(x=>x.ID); Dropdowncrs.DataValueField = "ID"; Dropdowncrs.DataTextField = "Course"; Dropdowncrs.DataBind(); } } else { Response.Redirect("Login.aspx?Redirecturl=" + pagename); } }
protected void Page_Load(object sender, EventArgs e) { string action = Request.QueryString["action"]; string pagename = Path.GetFileName(Request.PhysicalPath); if (Session["admin"] != null) { if (Request.QueryString["Courseid"] != null) { id = int.Parse(Request.QueryString["Courseid"]); if (!IsPostBack) { DBFunctions db = new DBFunctions(); if (action == "update") { checkbocprogamlist.DataSource = db.getprogramslist(); checkbocprogamlist.DataValueField = "ID"; checkbocprogamlist.DataTextField = "ProgramName"; checkbocprogamlist.DataBind(); foreach (ListItem item in checkbocprogamlist.Items) { var check = db.getprogramcours(int.Parse(item.Value), id); if (check != null) { item.Selected = true; } } Courses_tbl course = db.getcourses(id); coursename.Text = course.Course; Feetxt.Text = course.Fee; Markstxt.Text = course.Marks; CourseCode.Text = course.CourseCode; CreditHours.Text = course.Credit_Hours.ToString(); } else { } } } else { Response.Redirect("ManageCourses.aspx"); } } else { if (id != -1) { Response.Redirect("Login.aspx?Redirecturl=" + pagename + "?Courseid=" + id + "&action=update"); } else { Response.Redirect("Login.aspx?Redirecturl=" + pagename); } } }
protected void btnupdatecourse_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 }; Courses_tbl course = new Courses_tbl { ID = int.Parse(Request.QueryString["Courseid"]), Course = coursename.Text, Fee = Feetxt.Text, Marks = Markstxt.Text, CourseCode = CourseCode.Text, Credit_Hours = int.Parse(CreditHours.Text) }; db.updatecourse(course); db.clearprogramcourses(int.Parse(Request.QueryString["Courseid"])); foreach (ListItem item in checkbocprogamlist.Items) { if (item.Selected) { ProgrammeCourses_tbl programcourse = new ProgrammeCourses_tbl { CourseID = int.Parse(Request.QueryString["Courseid"]), ProgramID = int.Parse(item.Value) }; db.addprogrammecourse(programcourse); } } Response.Redirect("ManageCourses.aspx"); }
protected void btnaddprogramme_Click(object sender, EventArgs e) { DBFunctions db = new DBFunctions(); var checkcourse= db.getcourselist().Where(x => x.CourseCode == CourseCode.Text).FirstOrDefault(); if (checkcourse == null) { //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 }; Courses_tbl course = new Courses_tbl { Course = coursename.Text, Fee = Feetxt.Text, Marks = Markstxt.Text, Credit_Hours = int.Parse(CreditHours.Text), CourseCode = CourseCode.Text }; int cid = db.addcourse(course); foreach (ListItem chck in CheckBoxPrgramlist.Items) { if (chck.Selected) { ProgrammeCourses_tbl prgcrs = new ProgrammeCourses_tbl { ProgramID = int.Parse(chck.Value), CourseID = cid }; db.addprogrammecourse(prgcrs); } } messagae.Text = "Course Successfully Added"; messagae.Visible = true; // Response.Redirect("ManageCourses.aspx"); } else { messagae.Text = "Course Code Already Exist"; messagae.Visible = true; } }
public void updatecourse(Courses_tbl updatecrs) { db = new CollegeERPDBEntities(); db.Courses_tbl.Attach(updatecrs); // var progrm = db.Program_tbl.Where(x => x.ID == id).FirstOrDefault(); db.Entry(updatecrs).State = EntityState.Modified; db.SaveChanges(); }
public int addcourse(Courses_tbl course) { using (db = new CollegeERPDBEntities()) { db.Courses_tbl.Add(course); db.SaveChanges(); } return course.ID; }