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";
}
