public JsonResult GetStudentbyYear(int?facultyid)
{
AssignmentManagementSystemEntities _db = new AssignmentManagementSystemEntities();
var tblYearBatch = _db.tblYearBatches.ToList();
Dictionary <string, int> data = new Dictionary <string, int>();
foreach (var items in tblYearBatch)
{
var total = 0;
if (facultyid != null)
{
total = _db.tblStudents.Where(s => s.YearBatchId == items.YearBatchId && s.Faculty_Id == facultyid).Count();
}
else
{
total = _db.tblStudents.Where(s => s.YearBatchId == items.YearBatchId).Count();
}
data.Add(items.Year_Batch, total);
}
return(new JsonResult
{
Data = data,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
//List Student Submitted Assignment By StudentId
//public List<TeacherViewModel> GetTeacherByTeacherName(string search)
//{
// return teaDB.SearchTeacherByName(search);
//}
//public HttpResponseMessage GetTeacherByTeacherName(string name)
//{
// AssignmentManagementSystemEntities _db = new AssignmentManagementSystemEntities();
// var teacher = _db.tblTeachers.Where(t => t.Name == name).ToList();
// string message = "No Data Found";
// if (teacher == null)
// {
// return Request.CreateErrorResponse(HttpStatusCode.NotFound, message);
// }
// else
// {
// return Request.CreateResponse(HttpStatusCode.OK, teacher);
// }
//}
public HttpResponseMessage Post([Bind(Include = "Email,Model")] TeacherViewModel tvm)
{
AssignmentManagementSystemEntities db = new AssignmentManagementSystemEntities();
string message = "Teacher Added Successfully";
bool isexists = teaDB.EmailExists(tvm.Email);
if (isexists)
{
ModelState.AddModelError("Email", "Email Already Exist");
}
if (ModelState.IsValid)
{
teaDB.Add(tvm);
//tblTeacher tb = db.tblTeachers.Where(x => x.Email == tvm.Email).FirstOrDefault();
//if (tb != null)
//{
// teaDB.SendEmail(tb.Teacher_Id);
//}
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public HttpResponseMessage GetFile(int routineid)
{
//Create HTTP Response.
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
//Fetch the File data from Database.
//FilesEntities entities = new FilesEntities();
AssignmentManagementSystemEntities _db = new AssignmentManagementSystemEntities();
tblAssignmentRoutine file = _db.tblAssignmentRoutines.Where(r => r.Routine_Id == routineid).FirstOrDefault();
//Set the Response Content.
response.Content = new ByteArrayContent(file.Data);
//Set the Response Content Length.
response.Content.Headers.ContentLength = file.Data.LongLength;
//Set the Content Disposition Header Value and FileName.
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
response.Content.Headers.ContentDisposition.FileName = file.Name;
//var filename = file.Name;
//Set the File Content Type.
response.Content.Headers.ContentType = new MediaTypeHeaderValue(file.Content_Type);
// return Request.CreateResponse(HttpStatusCode.OK, filename);
return(response);
}
public HttpResponseMessage Post([Bind(Include = "Email,Model")] StudentViewModel svm)
{
AssignmentManagementSystemEntities db = new AssignmentManagementSystemEntities();
string message = "Student Added Successfully";
bool isexists = stuDB.EmailExists(svm.Email);
if (isexists)
{
ModelState.AddModelError("Email", "Email Already Exist");
}
if (ModelState.IsValid)
{
// stuDB.Add(svm);
//stuDB.SendSMS();
tblStudent tb = db.tblStudents.Where(x => x.Email == svm.Email).FirstOrDefault();
if (tb != null)
{
stuDB.SendEMail(tb.Student_Id);
}
//tblStudent tb1 = db.tblStudents.Where(x => x.Phone == svm.Phone).FirstOrDefault();
//if (tb1 != null)
//{
// stuDB.SendSMS(tb1.Phone);
//}
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public JsonResult GetYearBatchList(string sortColumnName = "Year_Batch", string sortOrder = "asc", int pageSize = 3, int currentPage = 1, string searchText = "")
{
List <YearBatchViewModel> List = new List <YearBatchViewModel>();
int totalPage = 0;
int totalRecord = 0;
using (AssignmentManagementSystemEntities dc = new AssignmentManagementSystemEntities())
{
dc.Configuration.ProxyCreationEnabled = false;
var emp = yearDB.ListAll().Select(a => a);
//Search
if (!string.IsNullOrEmpty(searchText))
{
emp = emp.Where(x => x.Year_Batch.Contains(searchText));
}
totalRecord = emp.Count();
if (pageSize > 0)
{
totalPage = totalRecord / pageSize + ((totalRecord % pageSize) > 0 ? 1 : 0);
List = emp.OrderBy(sortColumnName + " " + sortOrder).Skip(pageSize * (currentPage - 1)).Take(pageSize).ToList();
}
else
{
List = emp.ToList();
}
}
return(new JsonResult
{
//Data = new { List = List, totalPage = totalPage, sortColumnName = sortColumnName, sortOrder = sortOrder, currentPage = currentPage},
Data = new { List = List, totalRecord = totalRecord, totalPage = totalPage, sortColumnName = sortColumnName, sortOrder = sortOrder, currentPage = currentPage, pageSize = pageSize },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public HttpResponseMessage GetFile(int fileId)
{
//Create HTTP Response.
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
//Fetch the File data from Database.
//FilesEntities entities = new FilesEntities();
AssignmentManagementSystemEntities _db = new AssignmentManagementSystemEntities();
tblfile file = _db.tblfiles.ToList().Find(p => p.id == fileId);
//Set the Response Content.
response.Content = new ByteArrayContent(file.Data);
//Set the Response Content Length.
response.Content.Headers.ContentLength = file.Data.LongLength;
//Set the Content Disposition Header Value and FileName.
//response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
//response.Content.Headers.ContentDisposition.FileName = file.Name;
response.Content.Headers.ContentDisposition = new System.Net.Http.Headers.ContentDispositionHeaderValue("inline");
//Set the File Content Type.
response.Content.Headers.ContentType = new MediaTypeHeaderValue(file.ContentType);
// response.Content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/msword");
//response.Content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("images/jpeg");
//response.Content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.wordprocessingml.document");
return(response);
}
public HttpResponseMessage GetFiles()
{
//FilesEntities entities = new FilesEntities();
AssignmentManagementSystemEntities _db = new AssignmentManagementSystemEntities();
var files = from file in _db.tblfiles
select new { id = file.id, Name = file.Name };
return(Request.CreateResponse(HttpStatusCode.OK, files));
}
public JsonResult GetStudentSubmittedAssignmentList(string sortColumnName = "Routine_Id", string sortOrder = "asc", int pageSize = 3, int currentPage = 1, string searchText = "", int?routineid = 0)
{
List <SubmittedAssignmentViewModel> List = new List <SubmittedAssignmentViewModel>();
int totalPage = 0;
int totalRecord = 0;
using (AssignmentManagementSystemEntities dc = new AssignmentManagementSystemEntities())
{
dc.Configuration.ProxyCreationEnabled = false;
var emp = subDB.ListAll().Select(a => a);
// var emp = subDB.ListAll().Where(e => e.Routine_Id == routineid);
if (routineid == null)
{
emp = subDB.ListAll().Select(a => a);
}
else
{
emp = subDB.ListAll().Select(a => a).Where(e => e.Routine_Id == routineid);
}
//Search
if (!string.IsNullOrEmpty(searchText))
{
emp = emp.Where(a => a.Assignment_Name.Contains(searchText) || a.TeacherName.Contains(searchText) || a.StudentName.Contains(searchText) || a.FacultyName.Contains(searchText) || a.SectionName.Contains(searchText) || a.SemesterName.Contains(searchText) || a.YearBatch.Contains(searchText) || a.Submitted_Date.ToString().Contains(searchText) || a.Checked_Status.ToString().Contains(searchText) || a.Feedback_Status.ToString().Contains(searchText) || a.Marking.ToString().Contains(searchText));
}
totalRecord = emp.Count();
if (pageSize > 0)
{
totalPage = totalRecord / pageSize + ((totalRecord % pageSize) > 0 ? 1 : 0);
List = emp.OrderBy(sortColumnName + " " + sortOrder).Skip(pageSize * (currentPage - 1)).Take(pageSize).ToList();
}
else
{
List = emp.ToList();
}
}
return(new JsonResult
{
//Data = new { List = List, totalPage = totalPage, sortColumnName = sortColumnName, sortOrder = sortOrder, currentPage = currentPage},
Data = new { List = List, totalRecord = totalRecord, totalPage = totalPage, sortColumnName = sortColumnName, sortOrder = sortOrder, currentPage = currentPage, pageSize = pageSize },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public HttpResponseMessage Post([Bind(Include = "Email,Model")] ForgetPasswordViewModel fpvm)
{
AssignmentManagementSystemEntities db = new AssignmentManagementSystemEntities();
string message = "Your Password is Sent to Email";
bool isexists = fpDB.EmailExists(fpvm.Email);
if (!isexists)
{
ModelState.AddModelError("Email", "Not Registered Email");
}
if (ModelState.IsValid)
{
fpDB.SendRecoveryPasswordEMail(fpvm);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public JsonResult GetStudentList(string sortColumnName = "Name", string sortOrder = "asc", int pageSize = 3, int currentPage = 1, string searchText = "")
{
List <StudentViewModel> List = new List <StudentViewModel>();
int totalPage = 0;
int totalRecord = 0;
using (AssignmentManagementSystemEntities dc = new AssignmentManagementSystemEntities())
{
dc.Configuration.ProxyCreationEnabled = false;
//var emp = dc.tblStudents.Select(a => a);
var emp = stuDB.ListAll().Select(a => a);
//var emp = stuDB.ListAll().Select(x => new { Id = x.Student_Id, Name = x.Name, Email = x.Email, Gender = x.Gender, Phone = x.Phone ,Address=x.Address, YearBatchId=x.YearBatchId, YearBatch=x.tblYearBatch.YearBatchId, FacultyId=x.Faculty_Id, FacultyName=x.tblFaculty.Faculty_Name, SectionId=x.Section_Id, SectionName=x.tblSection.Sec_Name, SemesterId=x.Semester_Id, SemesterName=x.tblSemester.Semester_Name});
//Search
if (!string.IsNullOrEmpty(searchText))
{
emp = emp.Where(x => x.Name.Contains(searchText) || x.Email.Contains(searchText) || x.Gender.Contains(searchText) || x.Phone.Contains(searchText) || x.Address.Contains(searchText) || x.Year_Batch.Contains(searchText) || x.Faculty_Name.Contains(searchText) || x.Sec_Name.Contains(searchText) || x.Semester_Name.Contains(searchText));
}
totalRecord = emp.Count();
if (pageSize > 0)
{
totalPage = totalRecord / pageSize + ((totalRecord % pageSize) > 0 ? 1 : 0);
List = emp.OrderBy(sortColumnName + " " + sortOrder).Skip(pageSize * (currentPage - 1)).Take(pageSize).ToList();
}
else
{
List = emp.ToList();
}
}
return(new JsonResult
{
//Data = new { List = List, totalPage = totalPage, sortColumnName = sortColumnName, sortOrder = sortOrder, currentPage = currentPage},
Data = new { List = List, totalRecord = totalRecord, totalPage = totalPage, sortColumnName = sortColumnName, sortOrder = sortOrder, currentPage = currentPage, pageSize = pageSize },
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public HttpResponseMessage Put([Bind(Include = "Faculty_Name,Model")] FacultyViewModel fvm)
{
AssignmentManagementSystemEntities db = new AssignmentManagementSystemEntities();
var faculty = facDB.ListAll().Find(f => f.Id.Equals(fvm.Id));
string message = "Faculty Updated Successfully";
tblFaculty tb = db.tblFaculties.Where(s => s.Faculty_Id == fvm.Id).FirstOrDefault();
bool isexists = facDB.CheckFacultyNameExist(fvm.Faculty_Name);
if (isexists)
{
if (tb.Faculty_Name == fvm.Faculty_Name)
{
if (ModelState.IsValid)
{
facDB.Update(fvm);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
else
{
ModelState.AddModelError("Faculty_Name", "Faculty Name Already Exist");
}
}
if (ModelState.IsValid)
{
facDB.Update(fvm);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public HttpResponseMessage Put([Bind(Include = "Routine_Id,Model")] SubmittedAssignmentViewModel sub)
{
AssignmentManagementSystemEntities _db = new AssignmentManagementSystemEntities();
string message = "Assignment Updated Successfully";
if (ModelState.IsValid)
{
bool isexists = subDB.StudentAssignmentMatch(sub.Student_Id, sub.Routine_Id);
if (!isexists)
{
ModelState.AddModelError("Routine_Id", "This Assignment is not Assigned to selected Student");
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
else
{
tblSubmittedAssignment tb = _db.tblSubmittedAssignments.Where(a => a.ID == sub.Id).FirstOrDefault();
if (tb.Assignmnet_Location == 1 && sub.Assignmnet_Location == 2)
{
ModelState.AddModelError("Routine_Id", "This Assignment can not be directly handover to student from teacher Location");
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
else if (tb.Assignmnet_Location == 2 && sub.Assignmnet_Location == 1)
{
ModelState.AddModelError("Routine_Id", "The Assignment can not be directly handover to Teacher from Student Location");
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
else
{
subDB.Update(sub);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public HttpResponseMessage Put([Bind(Include = "Year_Batch,Model")] YearBatchViewModel yvm)
{
AssignmentManagementSystemEntities db = new AssignmentManagementSystemEntities();
var year = yearDB.ListAll().Find(y => y.Id.Equals(yvm.Id));
string message = "Year/Batch Updated Successfully";
tblYearBatch tb = db.tblYearBatches.Where(y => y.YearBatchId == yvm.Id).FirstOrDefault();
bool isexists = yearDB.CheckYearbatch(yvm.Year_Batch);
if (isexists)
{
if (tb.Year_Batch == yvm.Year_Batch)
{
if (ModelState.IsValid)
{
yearDB.Update(yvm);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
else
{
ModelState.AddModelError("Year_Batch", "Year/Batch Already Exist");
}
}
if (ModelState.IsValid)
{
yearDB.Update(yvm);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public HttpResponseMessage Put([Bind(Include = "Email,Model")] TeacherViewModel tvm)
{
AssignmentManagementSystemEntities db = new AssignmentManagementSystemEntities();
var student = teaDB.ListAll().Find(t => t.Id.Equals(tvm.Id));
string message = "Teacher Updated Successfully";
tblTeacher tb = db.tblTeachers.Where(t => t.Teacher_Id == tvm.Id).FirstOrDefault();
bool isexists = teaDB.EmailExists(tvm.Email);
if (isexists)
{
if (tb.Email == tvm.Email)
{
if (ModelState.IsValid)
{
teaDB.Update(tvm);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
else
{
ModelState.AddModelError("Email", "Email Already Exist");
}
}
if (ModelState.IsValid)
{
teaDB.Update(tvm);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public HttpResponseMessage Put([Bind(Include = "Sec_Name,Model")] SectionViewModel svm)
{
AssignmentManagementSystemEntities db = new AssignmentManagementSystemEntities();
var section = secDB.ListAll().Find(s => s.Id.Equals(svm.Id));
string message = "Section Updated Successfully";
tblSection tb = db.tblSections.Where(s => s.Section_Id == svm.Id).FirstOrDefault();
bool isexists = secDB.CheckSectionNameExist(svm.Sec_Name);
if (isexists)
{
if (tb.Sec_Name == svm.Sec_Name)
{
if (ModelState.IsValid)
{
secDB.Update(svm);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
else
{
ModelState.AddModelError("Sec_Name", "Section Name Already Exist");
}
}
if (ModelState.IsValid)
{
secDB.Update(svm);
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public HttpResponseMessage SaveFile()
{
//Create HTTP Response.
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
//Check if Request contains File.
if (HttpContext.Current.Request.Files.Count == 0)
{
throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
}
//Read the File data from Request.Form collection.
HttpPostedFile postedFile = HttpContext.Current.Request.Files[0];
//Convert the File data to Byte Array.
byte[] bytes;
using (BinaryReader br = new BinaryReader(postedFile.InputStream))
{
bytes = br.ReadBytes(postedFile.ContentLength);
}
//Insert the File to Database Table.
AssignmentManagementSystemEntities _db = new AssignmentManagementSystemEntities();
tblfile file = new tblfile
{
Name = Path.GetFileName(postedFile.FileName),
ContentType = postedFile.ContentType,
Data = bytes
};
_db.tblfiles.Add(file);
_db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, new { id = file.id, Name = file.Name }));
}
public HttpResponseMessage Post()
{
var message = "Routine Added Successfully";
var Assignment_Name = HttpContext.Current.Request.Params["Assignment_Name"];
var Teacher_Id = HttpContext.Current.Request.Params["Teacher_Id"];
var Assignment_Release_Date = HttpContext.Current.Request.Params["Assignment_Release_Date"];
var Deadline = HttpContext.Current.Request.Params["Deadline"];
var Section_Id = HttpContext.Current.Request.Params["Section_Id"];
var Faculty_Id = HttpContext.Current.Request.Params["Faculty_Id"];
var Semester_Id = HttpContext.Current.Request.Params["Semester_Id"];
var Year_Batch_Id = HttpContext.Current.Request.Params["Year_Batch_Id"];
//var file= HttpContext.Current.Request.Files[0];
if (Assignment_Name == "")
{
ModelState.AddModelError("Assignment_Name", "Enter Assignment Name");
}
if (Teacher_Id == "")
{
ModelState.AddModelError("Teacher_Name", "Select Subject Teacher");
}
if (Assignment_Release_Date == "")
{
ModelState.AddModelError("Assignment_Release_Date", "Select Release Date");
}
if (Deadline == "")
{
ModelState.AddModelError("Deadline", "Select Assignmnet Deadline");
}
if (Section_Id == "")
{
ModelState.AddModelError("Section_Name", "Select Section");
}
if (Faculty_Id == "")
{
ModelState.AddModelError("Faculty_Name", "Select Faculty");
}
if (Semester_Id == "")
{
ModelState.AddModelError("Semester_Name", "Select Semester");
}
if (Year_Batch_Id == "")
{
ModelState.AddModelError("Year_Batch", "Select Year Batch");
}
if (HttpContext.Current.Request.Files.Count == 0)
{
ModelState.AddModelError("PDF", "Choose File");
}
if (ModelState.IsValid)
{
//Read the File data from Request.Form collection.
HttpPostedFile postedFile = HttpContext.Current.Request.Files[0];
//Convert the File data to Byte Array.
byte[] bytes;
using (BinaryReader br = new BinaryReader(postedFile.InputStream))
{
bytes = br.ReadBytes(postedFile.ContentLength);
}
//Insert the File to Database Table.
AssignmentManagementSystemEntities _db = new AssignmentManagementSystemEntities();
tblAssignmentRoutine tb = new tblAssignmentRoutine();
tb.Assignment_Name = Assignment_Name;
tb.Teacher_Id = Convert.ToInt32(Teacher_Id);
tb.Assignment_Release_Date = Convert.ToDateTime(Assignment_Release_Date);
tb.Deadline = Convert.ToDateTime(Deadline);
tb.Section_Id = Convert.ToInt32(Section_Id);
tb.Faculty_Id = Convert.ToInt32(Faculty_Id);
tb.Semester_Id = Convert.ToInt32(Semester_Id);
tb.YearBatchId = Convert.ToInt32(Year_Batch_Id);
tb.Name = Path.GetFileName(postedFile.FileName);
tb.Content_Type = postedFile.ContentType;
tb.Data = bytes;
_db.tblAssignmentRoutines.Add(tb);
_db.SaveChanges();
tblStudentRoutineRelation tsr = new tblStudentRoutineRelation();
var studnet = _db.tblStudents.Where(s => s.Faculty_Id == tb.Faculty_Id && s.Section_Id == tb.Section_Id && s.Semester_Id == tb.Semester_Id && s.YearBatchId == tb.YearBatchId).ToList();
foreach (var item in studnet)
{
tsr.RoutineId = tb.Routine_Id;
tsr.StudentId = item.Student_Id;
_db.tblStudentRoutineRelations.Add(tsr);
_db.SaveChanges();
}
return(Request.CreateResponse(HttpStatusCode.OK, message));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}