protected void gvStudents_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Edit") { // Retrieve the row index stored in the // CommandArgument property. int index = Convert.ToInt32(e.CommandArgument); // Retrieve the row that contains the button // from the Rows collection. GridViewRow row = gvLessons.Rows[index]; ///////////////////////////////////////////////////////////////// ///////////// ADD A MODAL HERE FOR EDITING LESSON /////////////// //////////////////////////////////////////////////////////////// } if (e.CommandName == "Details") { // Retrieve the row index stored in the // CommandArgument property. int index = Convert.ToInt32(e.CommandArgument); // Retrieve the row that contains the button // from the Rows collection. GridViewRow row = gvLessons.Rows[index]; string id = row.Cells[0].Text; if (!(string.IsNullOrEmpty(id))) { Lesson lo = rep.FindByLessonID(id.ToInt()); tbxLessonID.InnerText = lo.LessonID.ToString(); tbxLessonTitle.InnerText = lo.LessonTitle; tbxUnit.InnerText = lo.Unit.ToString(); //tbxEmail.Value = lo.Email; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script type='text/javascript'>"); sb.Append("$('#modalShowDetails').modal('show');"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ModalScript", sb.ToString(), false); } } if (e.CommandName == "Delet") { // Retrieve the row index stored in the // CommandArgument property. int index = Convert.ToInt32(e.CommandArgument); // Retrieve the row that contains the button // from the Rows collection. GridViewRow row = gvLessons.Rows[index]; LessonsRepository lr = new LessonsRepository(); lr.DeleteLesson(row.Cells[0].Text.ToInt()); LoadLessons(); } }
public void LoadLessons() { LessonsRepository le = new LessonsRepository(); gvLessons.DataSource = le.GetAllLessons(); gvLessons.DataBind(); tbxSearch.Value = ""; }
public ScheduleRepository(string connectionString) { Database.SetInitializer(new MigrateDatabaseToLatestVersion<ScheduleContext, Configuration>()); Auditoriums = new AuditoriumsRepository(); Buildings = new BuildingsRepository(); Calendars = new CalendarsRepository(); Disciplines = new DisciplinesRepository(); DisciplineNames = new DisciplineNameRepository(); Lessons = new LessonsRepository(this); Rings = new RingsRepository(); Students = new StudentsRepository(); StudentGroups = new StudentGroupsRepository(); StudentsInGroups = new StudentsInGroupsRepository(); Teachers = new TeachersRepository(); TeacherForDisciplines = new TeacherForDisciplinesRepository(); ConfigOptions = new ConfigOptionRepository(); AuditoriumEvents = new AuditoriumEventsRepository(); Faculties = new FacultiesRepository(); GroupsInFaculties = new GroupsInFacultiesRepository(); ScheduleNotes = new ScheduleNotesRepository(); LessonLogEvents = new LessonLogEventsRepository(); TeacherWishes = new TeacherWishesRepository(); CustomTeacherAttributes = new CustomTeacherAttributesRepository(); CustomDisciplineAttributes = new CustomDisciplineAttributesRepository(); CustomStudentGroupAttributes = new CustomStudentGroupAttributesRepository(); Shifts = new ShiftsRepository(); ShiftRings = new ShiftRingsRepository(); Exams = new ExamsRepository(); LogEvents = new LogEventsRepository(); CommonFunctions = new CommonFunctions(this); SetConnectionString(connectionString); }
public void LoadDrpDList() { LessonsRepository LR = new LessonsRepository(); KarmandRepository KR = new KarmandRepository(); vLessonGroupRepository vLR = new vLessonGroupRepository(); ddGrade.Items.Add("مقطع"); ddGrade.Items[0].Value = "0"; ddGrade.Items.Add("اول"); ddGrade.Items[1].Value = "1"; ddGrade.Items.Add("دوم"); ddGrade.Items[2].Value = "2"; ddGrade.Items.Add("سوم"); ddGrade.Items[3].Value = "3"; ddGrade.Items.Add("چهارم"); ddGrade.Items[4].Value = "4"; ddGrade.Items.Add("پنجم"); ddGrade.Items[5].Value = "5"; ddGrade.Items.Add("ششم"); ddGrade.Items[6].Value = "6"; ddGrade.Items.Add("هفتم"); ddGrade.Items[7].Value = "7"; ddGrade.Items.Add("هشتم"); ddGrade.Items[8].Value = "8"; ddGrade.Items.Add("نهم"); ddGrade.Items[9].Value = "9"; ddGrade.Items.Add("دهم"); ddGrade.Items[10].Value = "10"; ddGrade.Items.Add("یازدهم"); ddGrade.Items[11].Value = "11"; ddGrade.Items.Add("دوازدهم"); ddGrade.Items[12].Value = "12"; ///////////// Field.Items.Add("رشته تحصیلی"); Field.Items[0].Value = "0"; Field.Items.Add("ریاضی"); Field.Items[1].Value = "1"; Field.Items.Add("تجربی"); Field.Items[2].Value = "2"; Field.Items.Add("انسانی"); Field.Items[3].Value = "3"; /////////////// Day.Items.Add("روز"); Day.Items[0].Value = "0"; Day.Items.Add("شنبه"); Day.Items[1].Value = "1"; Day.Items.Add("یکشنبه"); Day.Items[2].Value = "2"; Day.Items.Add("دوشنبه"); Day.Items[3].Value = "3"; Day.Items.Add("سه شنبه"); Day.Items[4].Value = "4"; Day.Items.Add("چهار شنبه"); Day.Items[5].Value = "5"; Day.Items.Add("پنج شنبه"); Day.Items[6].Value = "6"; //////////////////////// Class.Items.Add("شماره کلاس"); Class.Items[0].Value = "0"; Class.Items.Add("101"); Class.Items[1].Value = "101"; Class.Items.Add("102"); Class.Items[2].Value = "102"; Class.Items.Add("103"); Class.Items[3].Value = "103"; Class.Items.Add("201"); Class.Items[4].Value = "201"; Class.Items.Add("202"); Class.Items[5].Value = "202"; Class.Items.Add("203"); Class.Items[6].Value = "203"; ///////////////////////////////// Time.Items.Add("ساعت"); Time.Items[0].Value = "0"; Time.Items.Add("ساعت اول"); Time.Items[1].Value = "1"; Time.Items.Add("ساعت دوم"); Time.Items[2].Value = "2"; Time.Items.Add("ساعت سوم"); Time.Items[3].Value = "3"; Time.Items.Add("ساعت چهارم"); Time.Items[4].Value = "4"; //////////////////////// List <Lesson> lessonList = LR.GetListOfAllLessons(); LessonDrpDList.Items.Add("نام درس"); LessonDrpDList.Items[0].Value = "0"; for (int i = 1; i <= lessonList.Count; i++) { LessonDrpDList.Items.Add(lessonList[i - 1].LessonTitle); LessonDrpDList.Items[i].Value = lessonList[i - 1].LessonID.ToString(); } //////////////////////////// List <Karmand> teacherList = KR.GetListOfAllEmployees(); Teacher.Items.Add("نام مدرس"); Teacher.Items[0].Value = "0"; for (int i = 1; i <= teacherList.Count; i++) { Teacher.Items.Add(teacherList[i - 1].FirstName + " " + teacherList[i - 1].LastName); Teacher.Items[i].Value = teacherList[i - 1].PersonalCode.ToString(); } ////////////////////// List <string> yearsList = vLR.GetlistOfAllYears(); Year.Items.Add("سال تحصیلی"); Year.Items[0].Value = "0"; }