protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
Int32 records = 0;
if (validateData())
{
Entities.Course oSubject = new Entities.Course();
oSubject.id = Convert.ToInt32(txtCode.Text);
oSubject.description = txtName.Text;
oSubject.state = Convert.ToInt16(cboState.SelectedValue);
oSubject.oProgram.code = Convert.ToInt32(cboprogram.SelectedValue);
if (CourseBLL.getInstance().exists(oSubject.id))
{
records = CourseBLL.getInstance().modify(oSubject);
}
else
{
records = CourseBLL.getInstance().insert(oSubject);
}
blockControls();
loadData();
if (records > 0)
{
lblMessage.Text = "Datos almacenados correactamente";
}
}
}
public override void AddCourse(Course course)
{
if (course.WeeklyHours + TotalWeeklyHours() > MaxWeeklyHours)
{
throw new Exception("Your selection exceeds the maximum weekly hours: " + MaxWeeklyHours);
}
else
{
Courses.Add(course);
}
}
public override void AddCourse(Course course)
{
if (Courses.Count == MaxNumCourses)
{
throw new Exception("Your selection exceeds the maximum number of courses: " + MaxNumCourses);
}
else
{
Courses.Add(course);
}
}
private void insertButton_Click(object sender, EventArgs e)
{
if (courseNameTextBox.Text.Length != 0)
{
Course courseObj = new Course();
courseObj.NAME = courseNameTextBox.Text;
CourseData courseData = new CourseData();
courseData.Insert(courseObj);
populate();
}
}
public void Insert(Course courseObj)
{
string insertQuery = "INSERT INTO Course (NAME) VALUES(@NAME)";
SqlCommand insertCommand = new SqlCommand(insertQuery);
SqlParameter nameParam = new SqlParameter("@NAME", SqlDbType.NVarChar, 50);
nameParam.Value = courseObj.NAME;
insertCommand.Parameters.Add(nameParam);
dataAccess.Execute(insertCommand);
}
public void Update(Course courseObje)
{
string updateQuery = "UPDATE Course SET NAME = @NAME WHERE ID = @ID";
SqlCommand updateCommand = new SqlCommand(updateQuery);
SqlParameter idParam = new SqlParameter("@ID", SqlDbType.Int);
idParam.Value = courseObje.ID;
SqlParameter nameParam = new SqlParameter("@NAME", SqlDbType.NVarChar, 50);
nameParam.Value = courseObje.NAME;
updateCommand.Parameters.Add(idParam);
updateCommand.Parameters.Add(nameParam);
dataAccess.Execute(updateCommand);
}
public override void AddCourse(Course course)
{
if (Courses.Count < MaxNumCourses)
{
if (TotalWeeklyHours() + course.WeeklyHours <= MaxWeeklyHours)
{
Courses.Add(course);
}
else
{
throw new Exception("Your selection exceeds the maximum weekly hours: " + MaxWeeklyHours);
}
}
else
{
throw new Exception("Your selection exceeds the maximum number of courses: " + MaxNumCourses);
}
}
protected void gvCourse_RowEditing(object sender, GridViewEditEventArgs e)
{
unlockControls();
Int32 code = Convert.ToInt32(gvCourse.Rows[e.NewEditIndex].Cells[0].Text);
Entities.Course oSubject = CourseBLL.getInstance().getCourse(code);
txtCode.Text = oSubject.id.ToString();
txtName.Text = oSubject.description.ToString();
try
{
cboState.SelectedValue = oSubject.state.ToString();
}
catch (Exception)
{
cboState.SelectedValue = "1";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "$('html, body').animate({ scrollTop: $('body').offset().top });", true);
}
public List<Course> getList()
{
SqlCommand command = new SqlCommand("SELECT * FROM Course");
List<Course> courseList = new List<Course>();
DataTable dt = dataAccess.Query(command);
for (int i = 0; i < dt.Rows.Count; i++)
{
Course courseObj = new Course();
courseObj.ID = (int)dt.Rows[i][0];
courseObj.NAME = (string)dt.Rows[i][1];
courseList.Add(courseObj);
}
return courseList;
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
Int32 records = 0;
if (validateData())
{
Entities.Period oPeriod = new Entities.Period();
Entities.Program oProgram = new Entities.Program();
Entities.Course oCourse = new Entities.Course();
Entities.ClassRoom oClassRoom = new Entities.ClassRoom();
Entities.Schedule oSchedule = new Entities.Schedule();
Entities.Teacher oteacher = new Entities.Teacher();
Int32 code = Convert.ToInt32(txtCode.Text.ToString());
oPeriod.code = Convert.ToInt32(cboPeriod.SelectedValue.ToString());
oProgram.code = Convert.ToInt32(cboProgram.SelectedValue.ToString());
oCourse.id = Convert.ToInt32(cboCourse.SelectedValue.ToString());
Decimal price = Convert.ToDecimal(txtPrice.Text.ToString());
oSchedule.code = Convert.ToInt32(cboSchedule.SelectedValue.ToString());
oClassRoom.code = Convert.ToInt32(cboRoom.SelectedValue.ToString());
oteacher.code = Convert.ToInt32(cboTeacher.SelectedValue.ToString());
Int32 hour = Convert.ToInt32(cboHours.SelectedValue.ToString());
Entities.AcademicOffer oAcademicOffer = new Entities.AcademicOffer(code, oPeriod, oProgram, oCourse, price, oClassRoom, oSchedule, oteacher, hour);
if (BLL.AcademicOfferBLL.getInstance().exists(code))
{
lblMessage.Text = "Esta solicitud no puede ser procesada";
}
else
{
records = BLL.AcademicOfferBLL.getInstance().insert(oAcademicOffer);
insertClasroomSchedule(oAcademicOffer);
insertTeacherSchedule(oAcademicOffer);
}
blockControls();
loadData();
if (records > 0)
{
lblMessage.Text = "Datos almacenados correactamente";
}
}
}
public StudentsInCourse(Course course, Student student)
{
Course = course;
Student = student;
}
public AssignmentsPerCourse(Course course, Assignment assignment)
{
Course = course;
assignmentsInCourseList.Add(assignment);
}
public AssignmentsCourseStudent(Assignment assignment, Student student, Course course)
{
assignmentlist.Add(assignment);
this.student = student;
this.course = course;
}
protected void submitCourse_OnClick(object sender, EventArgs e)
{
if (db.Courses.Any())
{
using (var context = new Lab7DbEntities1())
{
Course course = new Course
{
CourseID = courseNumber.Text,
CourseTitle = courseName.Text,
HoursPerWeek = Int32.Parse(wklyHours.Text),
Description = txtbxDesc.Text
};
context.Courses.AddOrUpdate(course);
context.SaveChanges();
}
}
else
{
using (var context = new Lab7DbEntities1())
{
Course course = new Course
{
CourseID = courseNumber.Text,
CourseTitle = courseName.Text,
HoursPerWeek = Int32.Parse(wklyHours.Text),
Description = txtbxDesc.Text
};
context.Courses.AddOrUpdate(course);
context.SaveChanges();
}
}
}
protected void submitCourse_OnClick(object sender, EventArgs e)
{
if (db.Courses.Any())
{
using (var context = new Lab7DbEntities1())
{
foreach (var c in db.Courses)
{
if (c.CourseID == courseNumber.Text)
{
Title = "Course already exists";
}
else
{
Course course = new Course
{
CourseID = courseNumber.Text,
CourseTitle = courseName.Text,
HoursPerWeek = Int32.Parse(wklyHours.Text)
};
context.Courses.Add(course);
context.SaveChanges();
}
}
}
}
else
{
using (var context = new Lab7DbEntities1())
{
Course course = new Course
{
CourseID = courseNumber.Text,
CourseTitle = courseName.Text,
HoursPerWeek = Int32.Parse(wklyHours.Text)
};
context.Courses.Add(course);
context.SaveChanges();
}
}
}
public abstract void AddCourse(Course course);
public void QueryByCourse(Course courseObj)
{
string courseQuery = "SELECT * FROM Course WHERE ID = @ID";
string registraionQuery = "SELECT STUDENTID FROM Registraton WHERE COURSEID = @ID";
SqlCommand courseCommand = new SqlCommand(courseQuery);
SqlCommand registraionCommand = new SqlCommand(registraionQuery);
SqlParameter courseIDParam = new SqlParameter("@ID", SqlDbType.Int);
SqlParameter regCourseIDParam = new SqlParameter("@ID", SqlDbType.Int);
courseIDParam.Value = courseObj.ID;
regCourseIDParam.Value = courseObj.ID;
courseCommand.Parameters.Add(courseIDParam);
registraionCommand.Parameters.Add(regCourseIDParam);
Console.WriteLine("Course Info: ");
Console.WriteLine("Registration Info: ");
ShowStudentName(dataAccess.Query(registraionCommand));
}
public TrainersInCourse(Course course, Trainer trainer)
{
Course = course;
trainersInCourse.Add(trainer);
//Trainer = trainer;
}
