//api/AttendanceTeacher/ViewTeacherAttendance public HttpResponseMessage ViewTeacherAttendance(AddAttendanceVM data) { string EmpName = data.EmpName; string SectionName = data.SectionName; //int CourseID = 7; Int32.TryParse(data.CourseID, out int CourseID); //int empId = id; // teacher login id var db = DbUtils.GetDBConnection(); db.Connection.Open(); IEnumerable <Attend> response; response = db.Query("TeacherAttendanceDetails").Where("EmpName", EmpName) .Where("CourseID", CourseID) .Where("SectionName", SectionName) .Select("AttendanceDate", "ClassDuration") .Distinct() .Get <Attend>(); db.Connection.Close(); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public async Task <ActionResult> EditAttendance(FormCollection formCollection) { string teacherName = formCollection[1]; string sectionName = formCollection[2]; string courseID = formCollection[3]; string AttendanceDate = formCollection[4]; string ClassDuration = formCollection[5]; AttendanceDate = AttendanceDate.Remove(10); AddAttendanceVM addAttendanceVM = new AddAttendanceVM { CourseID = courseID, EmpName = teacherName, SectionName = sectionName, AttendanceDate = DateTime.Parse(AttendanceDate), ClassDuration = Int32.Parse(ClassDuration) }; var json = JsonConvert.SerializeObject(addAttendanceVM); var data = new StringContent(json, Encoding.UTF8, "application/json"); using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://localhost:44380/api/"); client.DefaultRequestHeaders.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage result = await client.PostAsync("AttendanceTeacher/EditStudentAttendance/", data); var response = result.Content.ReadAsStringAsync().Result; addAttendanceVM.students = JsonConvert.DeserializeObject <List <Student> >(response); } //addAttendanceVM.AttendanceDate = DateTime.Parse(AttendanceDate); //addAttendanceVM.ClassDuration = 1; return(View("EditAttendance", addAttendanceVM)); }
public async Task <ActionResult> DeleteAttendance(FormCollection formCollection) { string teacherName = formCollection[1]; string sectionName = formCollection[2]; string courseID = formCollection[3]; string AttendanceDate = formCollection[4]; AttendanceDate = AttendanceDate.Remove(10); AddAttendanceVM addAttendanceVM = new AddAttendanceVM { CourseID = courseID, EmpName = teacherName, SectionName = sectionName, AttendanceDate = DateTime.Parse(AttendanceDate) }; var json = JsonConvert.SerializeObject(addAttendanceVM); var data = new StringContent(json, Encoding.UTF8, "application/json"); using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://localhost:44380/api/"); client.DefaultRequestHeaders.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage result = await client.PostAsync("AttendanceTeacher/DeleteStudentAttendance/", data); var response = result.Content.ReadAsStringAsync().Result; addAttendanceVM.attendances = JsonConvert.DeserializeObject <List <Attend> >(response); } return(View("ViewTeacherAttendance", addAttendanceVM)); //string[] test = form[1].Split(','); //string Date = test[test.Length - 2]; //return Content("Here"); }
//api/AttendanceTeacher/UpdateStudentAttendance public HttpResponseMessage UpdateStudentAttendance(AddAttendanceVM data) //List<Attend> data { string EmpName = data.EmpName; string SectionName = data.SectionName; //int CourseID = 7; Int32.TryParse(data.CourseID, out int CourseID); DateTime AttendanceDate = data.AttendanceDate; DateTime oldAttendanceDate = data.oldAttendanceDate; var db = DbUtils.GetDBConnection(); db.Connection.Open(); IEnumerable <int> enrollmentID = db.Query("TeacherAttendanceDetails").Where("AttendanceDate", oldAttendanceDate) .Where("EmpName", EmpName) .Where("CourseID", CourseID) .Where("SectionName", SectionName) .Select("EnrollmentID").Distinct().Get <int>(); foreach (int i in enrollmentID) { using (TransactionScope scope = new TransactionScope()) { foreach (var item in data.attendances) { db.Query("Attendance").Where("EnrollmentID", i) .Where("AttendanceDate", oldAttendanceDate).Update(new { AttendanceDate = item.AttendanceDate, AttendanceStatus = item.AttendanceStatus, ClassDuration = item.ClassDuration, }); } scope.Complete(); } } IEnumerable <Attend> response; response = db.Query("TeacherAttendanceDetails").Where("EmpName", EmpName) .Where("CourseID", CourseID) .Where("SectionName", SectionName) .Select("AttendanceDate", "ClassDuration") .Distinct() .Get <Attend>(); db.Connection.Close(); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public async Task <ActionResult> UpdateStudentAttendance(FormCollection formCollection) { string teacherName = formCollection[1]; string courseID = formCollection[2]; string sectionName = formCollection[3]; string oldDate = formCollection[4]; string Date = formCollection[5]; string Duration = formCollection[6]; string[] EnrollmentID = formCollection[7].Split(','); string[] Presence = formCollection[8].Split(','); List <Attend> attendances = new List <Attend>(); for (int i = 0; i < EnrollmentID.Count(); i++) { attendances.Add(new Attend { EnrollmentID = Int32.Parse(EnrollmentID[i]), AttendanceStatus = Presence[i], ClassDuration = Int32.Parse(Duration), AttendanceDate = Date }); } AddAttendanceVM addAttendanceVM = new AddAttendanceVM { CourseID = courseID, EmpName = teacherName, SectionName = sectionName, oldAttendanceDate = DateTime.Parse(oldDate), AttendanceDate = DateTime.Parse(Date), ClassDuration = Int32.Parse(Duration), attendances = attendances }; var json = JsonConvert.SerializeObject(addAttendanceVM); var data = new StringContent(json, Encoding.UTF8, "application/json"); using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://localhost:44380/api/"); client.DefaultRequestHeaders.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage result = await client.PostAsync("AttendanceTeacher/UpdateStudentAttendance/", data); var response = result.Content.ReadAsStringAsync().Result; addAttendanceVM.attendances = JsonConvert.DeserializeObject <List <Attend> >(response); } return(View("ViewTeacherAttendance", addAttendanceVM)); }
//it will give all students of that teacher course //api/AttendanceTeacher/GetTeacherStudents/11 public HttpResponseMessage GetTeacherStudents(AddAttendanceVM data)//courseid { //int FSID = 13; //int SemesterID = 1; string EmpName = data.EmpName; string SectionName = data.SectionName; //int CourseID = 7; Int32.TryParse(data.CourseID, out int CourseID); //int empId = id; // teacher login id var db = DbUtils.GetDBConnection(); db.Connection.Open(); //IEnumerable<FacultySections> response0; //response = db.Query("CourseEnrollment").Where("StudentID", id).Get<CourseEnrollment>(); //response0 = db.Query("TeacherCourseSectionDetail").Where("EmpID", empId).Select("FSID").Get<FacultySections>(); //return Request.CreateResponse(HttpStatusCode.OK, response0); //int CFID = db.Query("CourseFaculty").Where("EmpID", empId).Select("CFID").Get<int>().First(); //int FSID = db.Query("FacultySections").Where("CFID", CFID).Select("FSID").Get<int>().First(); //return FSID; IEnumerable <Student> response; response = db.Query("TeacherAttendanceDetails").Where("EmpName", EmpName) .Where("CourseID", CourseID) .Where("SectionName", SectionName) .Select("StudentID", "SName", "RollNumber", "EnrollmentID").Distinct() .Get <Student>(); db.Connection.Close(); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public HttpResponseMessage DeleteStudentAttendance(AddAttendanceVM data) { string EmpName = data.EmpName; string SectionName = data.SectionName; //int CourseID = 7; Int32.TryParse(data.CourseID, out int CourseID); DateTime AttendanceDate = data.AttendanceDate; //int[] EnrollmentID; //int empId = id; // teacher login id var db = DbUtils.GetDBConnection(); db.Connection.Open(); IEnumerable <int> enrollmentID = db.Query("TeacherAttendanceDetails").Where("AttendanceDate", AttendanceDate) .Where("EmpName", EmpName) .Where("CourseID", CourseID) .Where("SectionName", SectionName) .Select("EnrollmentID").Distinct().Get <int>(); foreach (int i in enrollmentID) { _ = db.Query("Attendance").Where("AttendanceDate", "=", AttendanceDate) .Where("EnrollmentID", "=", i).Delete(); } IEnumerable <Attend> response; response = db.Query("TeacherAttendanceDetails").Where("EmpName", EmpName) .Where("CourseID", CourseID) .Where("SectionName", SectionName) .Select("AttendanceDate") .Distinct() .Get <Attend>(); db.Connection.Close(); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
//api/AttendanceTeacher/AddStudentAttendance public HttpResponseMessage AddStudentAttendance(AddAttendanceVM data) { string EmpName = data.EmpName; string SectionName = data.SectionName; //int CourseID = 7; Int32.TryParse(data.CourseID, out int CourseID); var db = DbUtils.GetDBConnection(); db.Connection.Open(); using (TransactionScope scope = new TransactionScope()) { foreach (var item in data.attendances) { var query = db.Query("Attendance").InsertGetId <int>(new { AttendanceDate = item.AttendanceDate, AttendanceStatus = item.AttendanceStatus, ClassDuration = item.ClassDuration, EnrollmentID = item.EnrollmentID }); } scope.Complete(); // if record is entered successfully , transaction will be committed IEnumerable <Attend> response; response = db.Query("TeacherAttendanceDetails").Where("EmpName", EmpName) .Where("CourseID", CourseID) .Where("SectionName", SectionName) .Select("AttendanceDate", "EnrollmentID") .Distinct() .Get <Attend>(); db.Connection.Close(); return(Request.CreateResponse(HttpStatusCode.OK, response)); } }
public HttpResponseMessage EditStudentAttendance(AddAttendanceVM data) { string EmpName = data.EmpName; string SectionName = data.SectionName; Int32.TryParse(data.CourseID, out int CourseID); DateTime AttendanceDate = data.AttendanceDate; var db = DbUtils.GetDBConnection(); db.Connection.Open(); IEnumerable <Student> response; response = db.Query("TeacherAttendanceDetails").Where("AttendanceDate", AttendanceDate) .Where("EmpName", EmpName) .Where("CourseID", CourseID) .Where("SectionName", SectionName) .Select("StudentID", "SName", "RollNumber", "EnrollmentID", "AttendanceStatus", "ClassDuration", "AttendanceDate") .Get <Student>(); db.Connection.Close(); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public async System.Threading.Tasks.Task <ActionResult> ChooseSection(FormCollection formCollection) { string teacherName = formCollection[1]; string courseID = formCollection[2]; string sectionName = formCollection[3]; AddAttendanceVM addAttendanceVM = new AddAttendanceVM { CourseID = courseID, EmpName = teacherName, SectionName = sectionName }; var json = JsonConvert.SerializeObject(addAttendanceVM); var data = new StringContent(json, Encoding.UTF8, "application/json"); using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://localhost:44380/api/"); client.DefaultRequestHeaders.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage result = await client.PostAsync("AttendanceTeacher/GetTeacherStudents/", data); var response = result.Content.ReadAsStringAsync().Result; addAttendanceVM.students = JsonConvert.DeserializeObject <List <Student> >(response); } return(View("AddAttendance", addAttendanceVM)); }