private void button4_Click(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count > 0)
{
if (subjid[listView1.SelectedIndices[0]] != null)
{
AssignTeacher frm = new AssignTeacher(gradelevel, listView1.SelectedItems[0].SubItems[3].Text,
listView1.SelectedItems[0].SubItems[0].Text,
listView1.SelectedItems[0].SubItems[1].Text,
int.Parse(subjid[listView1.SelectedIndices[0]]));
frm.ShowDialog();
listView1.SelectedItems[0].SubItems[4].Text = frm.TeacherName;
teacherIds[listView1.SelectedIndices[0]] = frm.selectedIdTeacher;
button1.Enabled = true;
}
else
{
MessageBox.Show("Please assign a subject in the list");
}
}
else
{
MessageBox.Show("Please Select In the List");
}
}
public JsonResult IsCourseCodeExist(AssignTeacher assignTeacher)
{
List <AssignTeacher> courses = aCourseManager.GetAssignCourse();
bool isExist = courses.FirstOrDefault(c => c.CourseId.ToStringInvariant().Equals(assignTeacher.CourseId.ToStringInvariant())) != null;
return(Json(!isExist, JsonRequestBehavior.AllowGet));
}
public string SaveCourseAssigntoTeacherInformation(AssignTeacher aAssignTeacher, int courseId)
{
bool isCourseAssignToTeacher = aAssignTeacherGateway.IsCourseAssignToTeacher(courseId);
if (isCourseAssignToTeacher)
{
return("The Course is Already Assigned To Someone");
}
else
{
aAssignTeacher.RemainingCredit = aAssignTeacher.RemainingCredit - aAssignTeacher.CourseCredit;
int rowAffected = aAssignTeacherGateway.SaveCourseAssigntoTeacherInformation(aAssignTeacher);
if (rowAffected > 0)
{
return("Successfully Saved");
}
else
{
return("Not SuccessFully Saved");
}
}
}
public IResponse <ApiResponse> AssignTeachNow(AssignTeacher ObjAssignTeacher)
{
string Result = null;
Result = eventService.SaveAssignedTimetableService(ObjAssignTeacher);
return(null);
}
public string Assign(AssignTeacher assignTeacher)
{
if (SaveUpdate(assignTeacher.DeptId, assignTeacher.TeacherId, assignTeacher.CourseId))
{
return("Course Assign Successfully Done");
}
else
{
return("Course Assign Successfully Done");
}
}
public ActionResult UnassignCourses(AssignTeacher assignTeacher)
{
var unAssigns = coueseTeacherDAL.AssingTeacherGetAll();
foreach (var item in unAssigns)
{
item.IsUnassign = true;
}
coueseTeacherDAL.Complete();
ViewBag.SMessage = "Unassign Courses Successfully!";
return(View());
}
public bool Add(AssignTeacher assignTeacher)
{
if (db.AssignTeachers.Where(c => !c.IsUnassign).FirstOrDefault(c => c.CourseName.ToLower().Contains(assignTeacher.CourseName.ToLower())) == null)
{
db.AssignTeachers.Add(assignTeacher);
return(db.SaveChanges() > 0);
}
else
{
return(false);
}
}
public int UpdateTeacherRemainingCredit(int teacherId, AssignTeacher aAssignTeacher)
{
Query = "UPDATE Teacher SET RemainingCredit='" + aAssignTeacher.RemainingCredit + "' WHERE Teacher.TeacherId='" + teacherId + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public string SaveAssignedTimetableService(AssignTeacher ObjAssignTeacher)
{
DbParam[] param = new DbParam[]
{
new DbParam(ObjAssignTeacher.TimetableUid, typeof(System.String), "_TimetableUid"),
new DbParam(ObjAssignTeacher.ClassDetailUid, typeof(System.String), "_ClassDetailUid"),
new DbParam(null, typeof(System.String), "_PeriodUid"),
new DbParam(userDetail.schooltenentId, typeof(System.String), "_TanentUid"),
new DbParam(ObjAssignTeacher.SubstitutedFacultyUid, typeof(System.String), "_SubstitutedFacultiUid"),
new DbParam(ObjAssignTeacher.FacultyUid, typeof(System.String), "_FacultyUid"),
new DbParam(ObjAssignTeacher.SubjectUid, typeof(System.String), "_SubjectUid"),
new DbParam(ObjAssignTeacher.Period, typeof(System.Int32), "_Period"),
new DbParam(ObjAssignTeacher.DayName, typeof(System.String), "_WeekDayName"),
new DbParam(userDetail.UserId, typeof(System.String), "_AdminId")
};
OutParam = db.ExecuteNonQuery("sp_Timetable_Modify", param, true);
return(OutParam);
}
public List <AssignTeacher> GetAssignCourse()
{
Query = "SELECT * FROM AssignTeacher_tb WHERE Status = 'True'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <AssignTeacher> courses = new List <AssignTeacher>();
while (Reader.Read())
{
AssignTeacher aCourse = new AssignTeacher()
{
Id = Convert.ToInt32(Reader["Id"]),
CourseId = Convert.ToInt32(Reader["CourseId"])
};
courses.Add(aCourse);
}
Connection.Close();
Reader.Close();
return(courses);
}
public ActionResult AssignTeacher(AssignTeacher assignTeacher)
{
//var message = "";
if (ModelState.IsValid)
{
bool isSaved = courseTeacherManager.Add(assignTeacher);
if (isSaved)
{
ViewBag.SMessage = "Assign Teacher Successfully!";
ModelState.Clear();
}
else
{
ViewBag.EMessage = "This Course Already Assigned";
}
}
else
{
ViewBag.EMessage = "Failed";
}
var model = new AssignTeacherViewModel();
model.DepartmentSelectListItems2 = courseTeacherDAL.TeacherGetAll().Select(c => new SelectListItem()
{
Value = c.DepartmentId.ToString(), Text = c.Department.DepartmentName
});
model.CoursetSelectListItems = courseTeacherDAL.CourseGetAll().Select(c => new SelectListItem()
{
Value = c.CourseId.ToString(), Text = c.CourseCode
});
model.TeachertSelectListItems = GetDefaultSelectListItem();
model.TeachertInfoListItems = GetTDefaultSelectListItem();
//ViewBag.EMessage = message;
return(View(model));
}
public int SaveCourseAssigntoTeacherInformation(AssignTeacher aAssignTeacher)
{
Query = "INSERT INTO CourseAssigntoTeacher VALUES(@departmentId,@teacherId,@courseId,@status,@remainingCredit)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("departmentId", SqlDbType.Int);
Command.Parameters["departmentId"].Value = aAssignTeacher.DepartmentId;
Command.Parameters.Add("teacherId", SqlDbType.Int);
Command.Parameters["teacherId"].Value = aAssignTeacher.TeacherId;
Command.Parameters.Add("courseId", SqlDbType.Int);
Command.Parameters["courseId"].Value = aAssignTeacher.CourseId;
Command.Parameters.Add("status", SqlDbType.Bit);
Command.Parameters["status"].Value = aAssignTeacher.Status;
Command.Parameters.Add("remainingCredit", SqlDbType.Decimal);
Command.Parameters["remainingCredit"].Value = aAssignTeacher.RemainingCredit;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
///----Save Teacher End----///
///
public bool Add(AssignTeacher assignTeacher)
{
bool isSavedT = coueseTeacherDAL.Add(assignTeacher);
return(isSavedT);
}
public ActionResult AssigntoTeacher(AssignTeacher assignTeacher)
{
ViewBag.Departments = aDepartmentManager.GetAllDepartments();
ViewBag.Message = aCourseManager.Assign(assignTeacher);
return(View());
}
public ActionResult SaveCourseAssigntoTeacher(int courseId, int teacherId, int departmentId, AssignTeacher aAssignTeacher)
{
List <Department> department = GetAllDepartments();
ViewBag.Departments = department;
ViewBag.RemainingCredit = aAssignTeacher.RemainingCredit;
ViewBag.CourseCredit = aAssignTeacher.CourseCredit;
string save = aAssignTeacherManager.SaveCourseAssigntoTeacherInformation(aAssignTeacher, courseId);
ViewBag.msg = save;
int updateCourseStatus = aAssignTeacherManager.UpdateCourseStatus(courseId);
int updateTeacherRemainingCredit = aAssignTeacherManager.UpdateTeacherRemainingCredit(teacherId,
aAssignTeacher);
return(View());
}
public int UpdateTeacherRemainingCredit(int teacherId, AssignTeacher aAssignTeacher)
{
return(aAssignTeacherGateway.UpdateTeacherRemainingCredit(teacherId, aAssignTeacher));
}
