public ActionResult AddAttendence(string course, string degree, string batch)
{
using (CMSEntities db = new CMSEntities())
{
assigned_course assCourse = db.assigned_course.Where(x => x.course == course && x.degree1.title == degree && x.batch1.name == batch).FirstOrDefault();
if (assCourse != null)
{
List <student> studentList = db.students.Where(x => x.degree1.title == degree && x.batch1.name == batch).ToList();
List <attendence> model = new List <attendence>();
for (int i = 0; i < studentList.Count; i++)
{
attendence atten = new attendence();
atten.ass_course_id = assCourse.Id;
atten.rollno = studentList[i].rollno;
atten.status = false;
atten.assigned_course = assCourse;
atten.student = studentList[i];
atten.date = DateTime.Now;
model.Add(atten);
}
return(View(model));
}
}
return(View());
}
public ActionResult Attendance(attendence obj, HttpPostedFileBase attendfile)
{
try
{
string PhotoPath = Server.MapPath("~/Docs/Images/");
string PhotoName = Guid.NewGuid() + Path.GetFileName(attendfile.FileName); //3l4an lw atb3t tokins m3 asm l swra y4lha
string FinalPhotoPath = Path.Combine(PhotoPath, PhotoName);
attendfile.SaveAs(FinalPhotoPath);
if (ModelState.IsValid)
{
obj.attendfile = PhotoName;
db.attendence.Add(obj);
db.SaveChanges();
ModelState.Clear();
return(RedirectToAction("Grades"));
}
return(View(obj));
}
catch (Exception ex)
{
ViewBag.AttendType = new SelectList(db.attendtype, "id", "TypeOfAttend");
return(View(obj));
}
}
public ActionResult DeleteConfirmed(int id)
{
attendence attendence = db.attendences.Find(id);
db.attendences.Remove(attendence);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult EditAttendence(AttendenceDTO s, int id)
{
attendence result = _db.attendences.Single(attendence => attendence.id == id);
result.id = s.attendenceData.id;
result.date = s.attendenceData.date;
result.aattendence = s.attendenceData.aattendence;
result.emp_id = s.attendenceData.emp_id;
_db.SaveChanges();
return(RedirectToAction("Index", "Attendence"));
}
public ActionResult Edit([Bind(Include = "Attendence_Id,Employee_Id,Present_Id,Attendence_Date")] attendence attendence)
{
if (ModelState.IsValid)
{
db.Entry(attendence).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Employee_Id = new SelectList(db.employees, "Employee_Id", "Employee_Name", attendence.Employee_Id);
ViewBag.Present_Id = new SelectList(db.presents, "Present_Id", "Value", attendence.Present_Id);
return(View(attendence));
}
// GET: attendences/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
attendence attendence = db.attendences.Find(id);
if (attendence == null)
{
return(HttpNotFound());
}
return(View(attendence));
}
// GET: attendences/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
attendence attendence = db.attendences.Find(id);
if (attendence == null)
{
return(HttpNotFound());
}
ViewBag.Employee_Id = new SelectList(db.employees, "Employee_Id", "Employee_Name", attendence.Employee_Id);
ViewBag.Present_Id = new SelectList(db.presents, "Present_Id", "Value", attendence.Present_Id);
return(View(attendence));
}
public void add(attendence entity)
{
atn.Insert(entity.Studentid, entity.Batchid, entity.Branchid, entity.Totaldays
, entity.Attendence, entity.Percentage);
}
