public ActionResult AddResources(FormCollection form) { Resource resources = new Resource(); //resources.ResourceId = Convert.ToInt32(form["ResourceId"]); resources.ResourceName = form["ResourceName"]; entities.Resources.Add(resources); entities.SaveChanges(); return(View()); }
public ActionResult Register(FormCollection formCollection) { try { int empId = Convert.ToInt32(formCollection["EmployeeNumber"]); string uname = formCollection["NewUsername"]; //check the record is already available or not var checkRegistration = entities.UserRegistrationDetails.Where(q => q.EmployeeNumber == empId).FirstOrDefault(); var username = entities.UserRegistrationDetails.Where(q => q.Username == uname).FirstOrDefault(); if (checkRegistration == null && username == null) { //inserting data into User registration details table UserRegistrationDetail user = new UserRegistrationDetail(); user.EmployeeNumber = empId; user.EmployeeName = formCollection["EmployeeName"]; user.ContactNumber = formCollection["ContactNumber"]; user.Username = formCollection["NewUsername"]; user.Password = formCollection["Pass"]; entities.UserRegistrationDetails.Add(user); //adding data in user questions details UserQuestionDetail userQuestion = new UserQuestionDetail(); string qname = formCollection["AllQuestions"]; int qid = (from res in entities.Questions where res.Question1 == qname select res.QuestionId).FirstOrDefault(); userQuestion.QuestionId = qid; userQuestion.Answer = formCollection["Answer"]; userQuestion.EmpoyeeNumber = Convert.ToInt32(formCollection["EmployeeNumber"]); entities.UserQuestionDetails.Add(userQuestion); entities.SaveChanges(); return(Content("<script language='javascript' type='text/javascript'>alert('Employee Registered Successfully');window.location = 'Index';</script>")); } else { // Content("<script language='javascript' type='text/javascript'>alert('This EmployeeId already Registered');window.location = "Index";</script>"); return(Content("<script language='javascript' type='text/javascript'>alert('This Employee already Registered');window.location = 'Index';</script>")); } } catch (Exception) { return(Content("<script language='javascript' type='text/javascript'>alert('This Username already Registered');window.location = 'Index';</script>")); } }
public ActionResult AddClassroomDetails(FormCollection form) { ClassRoomDetail detail = new ClassRoomDetail(); detail.ClassroomId = Convert.ToInt32(form["AllClassroomId"]); detail.ResourceQuantity = Convert.ToInt32(form["ResourceQuantity"]); detail.ResourceId = Convert.ToInt32(form["AllResourceId"]); entities.ClassRoomDetails.Add(detail); entities.SaveChanges(); var addedData = entities.ClassRoomDetails.Where(s => s.ClassroomId == detail.ClassroomId); //return RedirectToAction("List", "ClassroomDetails"); return(Content("<script languagr='javascript' type='text/javascript'>alert('Data Added successfully');window.location = '/ClassroomDetails/List';</script>")); }
public ActionResult AddResource(Resource form) { try { Resource resource = new Resource(); resource.ResourceName = form.ResourceName; entities.Resources.Add(resource); entities.SaveChanges(); //return View("List"); // return RedirectToAction("List", "Admin"); return(Content("<script languagr='javascript' type='text/javascript'>alert('Resource added to the database successfully');window.location = '/Home/Index';</script>")); } catch (Exception) { return(Content("<script languagr='javascript' type='text/javascript'>alert('Resource already in the database');window.location = '/Admin/AddResource';</script>")); } }
public ActionResult SaveEvent(Event e) { var status = false; using (ClassroomAllocationSystemEntities1 dc = new ClassroomAllocationSystemEntities1()) { if (e.EventID > 0) { //Update the event var v = dc.Events.Where(a => a.EventID == e.EventID).FirstOrDefault(); if (v != null) { v.Subject = e.Subject; v.Start = e.Start; v.End = e.End; v.Description = e.Description; v.IsfullDay = e.IsfullDay; v.ClassRoomId = e.ClassRoomId; v.Employeeid = e.Employeeid; dc.SaveChanges(); status = true; } } else { var count = dc.ValidateBookingClassroom(e.Start, e.End, e.ClassRoomId).ToList(); int? save = count.FirstOrDefault(); Int32 insert = save.HasValue ? save.Value : 0; if (insert == 0) { dc.Events.Add(e); dc.SaveChanges(); status = true; } else { status = false; } } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult AddClassroom(ClassRoom model, string ClassRoomName, HttpPostedFileBase ClassroomImage) { try { if (ClassroomImage != null) { model.ClassroomImage = new byte[ClassroomImage.ContentLength]; ClassroomImage.InputStream.Read(model.ClassroomImage, 0, ClassroomImage.ContentLength); } string fileName = Path.GetFileName(ClassroomImage.FileName); string filePath = "~/Content/Images/ClassroomImages" + fileName; ClassroomImage.SaveAs(Server.MapPath(filePath)); entities.ClassRooms.Add(model); entities.SaveChanges(); return(RedirectToAction("Welcome", "Resource")); } catch (Exception) { throw; } }
public JsonResult DeleteEvent(int eventID) { var status = false; using (ClassroomAllocationSystemEntities1 dc = new ClassroomAllocationSystemEntities1()) { var v = dc.Events.Where(a => a.EventID == eventID).FirstOrDefault(); if (v != null) { dc.Events.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }