public ActionResult Create(AspNetTopic aspNetTopic) { var dbTransaction = db.Database.BeginTransaction(); try { IEnumerable <string> topics = Request.Form["DynamicTextBox"].Split(','); if (ModelState.IsValid) { foreach (var item in topics) { AspNetTopic aspnettopic = new AspNetTopic(); aspnettopic.SubjectID = aspNetTopic.SubjectID; aspnettopic.TopicName = item; db.AspNetTopics.Add(aspnettopic); db.SaveChanges(); } return(RedirectToAction("Index")); } dbTransaction.Commit(); } catch (Exception) { dbTransaction.Dispose(); } ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetTopic.SubjectID); return(View(aspNetTopic)); }
public ActionResult Create([Bind(Include = "Id,SubjectID,ClassID,Title,Description,Date,TotalMarks,Weightage,TeacherID")] AspNetExam aspNetExam) { var dbTransection = db.Database.BeginTransaction(); try { if (ModelState.IsValid) { db.AspNetExams.Add(aspNetExam); db.SaveChanges(); int examID = db.AspNetExams.Max(item => item.Id); List <string> StudentIDs = db.AspNetStudent_Subject.Where(s => s.SubjectID == aspNetExam.SubjectID).Select(s => s.StudentID).ToList(); foreach (var item in StudentIDs) { AspNetStudent_Exam stu_exams = new AspNetStudent_Exam(); stu_exams.StudentID = item; stu_exams.ExamID = examID; db.AspNetStudent_Exam.Add(stu_exams); db.SaveChanges(); } } dbTransection.Commit(); } catch (Exception) { dbTransection.Dispose(); } return(RedirectToAction("Index")); ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName"); ViewBag.SubjectID = new SelectList(db.AspNetSubjects.Where(s => s.TeacherID == TeacherID), "Id", "SubjectName"); ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(s => s.Id == TeacherID), "Id", "Name"); return(View(aspNetExam)); }
public ActionResult Create([Bind(Include = "Id,TeacherID,JoiningDate")] AspNetTeacher aspNetTeacher) { var TransactionObj = db.Database.BeginTransaction(); try { if (ModelState.IsValid) { db.AspNetTeachers.Add(aspNetTeacher); db.SaveChanges(); } TransactionObj.Commit(); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// var UserNameLog = User.Identity.Name; AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog); string UserIDLog = a.Id; var logMessage = "New Teacher Added, TeacherID: " + aspNetTeacher.TeacherID + ", JoiningDate: " + aspNetTeacher.JoiningDate; var LogControllerObj = new AspNetLogsController(); LogControllerObj.CreateLogSave(logMessage, UserIDLog); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// return(RedirectToAction("Index")); } catch { TransactionObj.Dispose(); } ViewBag.TeacherID = new SelectList(db.AspNetUsers, "Id", "Email", aspNetTeacher.TeacherID); return(View(aspNetTeacher)); }
public ActionResult Create([Bind(Include = "Id,SubjectName,ClassID,TeacherID")] AspNetSubject aspNetSubject) { var TransactionObj = db.Database.BeginTransaction(); try { if (ModelState.IsValid) { db.AspNetSubjects.Add(aspNetSubject); db.SaveChanges(); } TransactionObj.Commit(); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// var UserNameLog = User.Identity.Name; AspNetUser a = db.AspNetUsers.First(x => x.UserName == UserNameLog); string UserIDLog = a.Id; string user = db.AspNetUsers.Where(x => x.Id == aspNetSubject.TeacherID).Select(x => x.Name).FirstOrDefault(); var logMessage = "New Subject Added, SubjectName: " + aspNetSubject.SubjectName + ", ClassID: " + aspNetSubject.ClassID + ", TeacherName: " + user; var LogControllerObj = new AspNetLogsController(); LogControllerObj.CreateLogSave(logMessage, UserIDLog); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// return(RedirectToAction("ClassIndexs")); } catch { TransactionObj.Dispose(); ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", aspNetSubject.ClassID); ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(x => x.AspNetRoles.Select(y => y.Name).Contains("Teacher")), "Id", "Name"); return(View("Create", aspNetSubject)); } }
public ActionResult Create([Bind(Include = "Id,EmployeeId,AdvanceSalary,Months,Date,Status,SessionId")] EmployeeAdvanceSalary employeeAdvanceSalary) { try { if (ModelState.IsValid) { var name = Request.Form["MonthName"]; employeeAdvanceSalary.Status = "Pending"; employeeAdvanceSalary.Months = name; db.EmployeeAdvanceSalaries.Add(employeeAdvanceSalary); db.SaveChanges(); //Ledger ledger_exp = db.Ledgers.Where(x => x.Name == "Employee Clearing").FirstOrDefault();////Expence //ledger_exp.StartingBalance += employeeAdvanceSalary.AdvanceSalary; //ledger_exp.CurrentBalance += employeeAdvanceSalary.AdvanceSalary; //db.SaveChanges(); //Ledger ledger_lib = db.Ledgers.Where(x => x.Name == "Employee Salary").FirstOrDefault();////Liability //ledger_lib.StartingBalance += employeeAdvanceSalary.AdvanceSalary; //ledger_lib.CurrentBalance += employeeAdvanceSalary.AdvanceSalary; //db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception e) { ViewBag.ErrorMessage = e.Message; } ViewBag.SessionId = new SelectList(db.AspNetSessions, "Id", "Year", employeeAdvanceSalary.SessionId); ViewBag.EmployeeId = new SelectList(db.AspNetEmployees, "Id", "Name", employeeAdvanceSalary.EmployeeId); return(View(employeeAdvanceSalary)); }
public ActionResult Create([Bind(Include = "Id,Name,Description,SubjectId,FAQ,OrderBy")] AspnetSubjectTopic aspnetSubjectTopic) { aspnetSubjectTopic.StartDate = null; aspnetSubjectTopic.EndDate = null; if (ModelState.IsValid) { db.AspnetSubjectTopics.Add(aspnetSubjectTopic); db.SaveChanges(); return(RedirectToAction("ViewTopicsAndLessons")); } var UserId = User.Identity.GetUserId(); //Teacher Subjects var SubjectofCurrentSessionTeacher = from subject in db.GenericSubjects join TeacherSubject in db.Teacher_GenericSubjects on subject.Id equals TeacherSubject.SubjectId join employee in db.AspNetEmployees on TeacherSubject.TeacherId equals employee.Id where employee.UserId == UserId select new { subject.Id, subject.SubjectName, }; ViewBag.SubjectId = new SelectList(SubjectofCurrentSessionTeacher, "Id", "SubjectName", aspnetSubjectTopic.SubjectId); return(View(aspnetSubjectTopic)); }
public ActionResult Student_Assignment_Submission(Student_Assignment stu_assignmnet) { int id = Convert.ToInt32(Request.Form["id"]); Student_Assignment result = (from p in db.Student_Assignment where p.Id == id select p).SingleOrDefault(); var dbTransaction = db.Database.BeginTransaction(); try { HttpPostedFileBase file = Request.Files["document"]; if (ModelState.IsValid) { if (file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/App_Data/SubmittedAssignments"), fileName); file.SaveAs(path); result.SubmittedFileName = fileName; } } result.Status = "Submitted"; result.Date = DateTime.Now; db.SaveChanges(); dbTransaction.Commit(); } catch (Exception) { dbTransaction.Dispose(); } return(RedirectToAction("Student_Assignment_Submission", new { id = result.AssignmentID })); }
public ActionResult Create(AspnetStudentAssignment aspnetStudentAssignment) { HttpPostedFileBase file = Request.Files["Assignment"]; if (ModelState.IsValid) { if (file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); file.SaveAs(Server.MapPath("~/Content/StudentAssignments/") + fileName); aspnetStudentAssignment.FileName = fileName; } else { aspnetStudentAssignment.FileName = "-/-"; } aspnetStudentAssignment.CreationDate = DateTime.Now; db.AspnetStudentAssignments.Add(aspnetStudentAssignment); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.LessonId = new SelectList(db.AspnetLessons, "Id", "Name", aspnetStudentAssignment.LessonId); return(View(aspnetStudentAssignment)); }
public ActionResult Create([Bind(Include = "Id,StudentId,Months,Status,InstalmentAmount,Date")] StudentFeeMonth studentFeeMonth) { try { var checkbox = Request.Form["ingredients"]; List <string> names = new List <string>(checkbox.Split(',')); if (ModelState.IsValid) { foreach (var item in names) { studentFeeMonth.Months = item; db.StudentFeeMonths.Add(studentFeeMonth); db.SaveChanges(); } return(RedirectToAction("Index")); } ViewBag.StudentId = new SelectList(db.AspNetStudents, "Id", "Name", studentFeeMonth.StudentId); return(View(studentFeeMonth)); } catch { return(RedirectToAction("Create")); } }
private void SomeMethodRunsAt1600() { var datetime = DateTime.Now; var currentdate = datetime.Date; var timeout = datetime.TimeOfDay; var tout = db.AspNetStudent_AutoAttendance.Where(x => x.Date == currentdate && x.TimeOut == null).ToList(); foreach (var item in tout) { AspNetStudent_AutoAttendance at = db.AspNetStudent_AutoAttendance.Where(x => x.Roll_Number == item.Roll_Number && x.Date == currentdate).FirstOrDefault(); at.TimeOut = timeout; db.SaveChanges(); } var pstd = db.AspNetStudent_AutoAttendance.Where(x => x.Date == currentdate).Select(x => x.Roll_Number).ToList(); var tstd = db.AspNetStudents.Where(x => x.AspNetUser.Status != "False").Select(x => x.AspNetUser.UserName).ToList(); var astd = tstd.Except(pstd).ToList(); foreach (var item in astd) { AspNetAbsent_Student at = new AspNetAbsent_Student(); var att = (from user in db.AspNetUsers join std in db.AspNetStudents on user.Id equals std.StudentID where user.UserName == item && std.StudentID == user.Id select new { user.UserName, std.AspNetClass.ClassName }).FirstOrDefault(); at.Class = att.ClassName; at.Date = currentdate; at.Roll_Number = att.UserName; db.AspNetAbsent_Student.Add(at); db.SaveChanges(); } }
// // GET: /Manage/ChangePassword // public ActionResult ChangePassword() //{ // return View(); //} // // POST: /Manage/ChangePassword // [HttpPost] // [ValidateAntiForgeryToken] public async Task <ActionResult> ChangePassword(ChangePasswordViewModel model) { // if (!ModelState.IsValid) if (model.NewPassword != model.ConfirmPassword) { return(Content("error")); } var result = await UserManager.ChangePasswordAsync(User.Identity.GetUserId(), model.OldPassword, model.NewPassword); if (result.Succeeded) { var user = await UserManager.FindByIdAsync(User.Identity.GetUserId()); if (user != null) { await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); } db.AspNetUsers.Where(x => x.Id == user.Id).FirstOrDefault().LastPasswordChange = DateTime.Now; db.SaveChanges(); // return RedirectToAction("Index", new { Message = ManageMessageId.ChangePasswordSuccess }); return(Content("success")); } AddErrors(result); return(Content("error")); }
public ActionResult Create([Bind(Include = "Id,Name,Amount")] FeeDiscount feeDiscount) { if (ModelState.IsValid) { db.FeeDiscounts.Add(feeDiscount); db.SaveChanges(); return(RedirectToAction("FeeDiscountIndex")); } return(View(feeDiscount)); }
public ActionResult Edit([Bind(Include = "Id,Name")] AspNetRole aspNetRole) { if (ModelState.IsValid) { db.Entry(aspNetRole).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetRole)); }
public ActionResult Create([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status")] AspNetSession aspNetSession) { if (ModelState.IsValid) { db.AspNetSessions.Add(aspNetSession); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetSession)); }
public ActionResult Create([Bind(Include = "Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName,Name")] AspNetUser aspNetUser) { if (ModelState.IsValid) { db.AspNetUsers.Add(aspNetUser); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetUser)); }
public ActionResult Create([Bind(Include = "Id,Name")] AspNetFinanceLedgerType aspNetFinanceLedgerType) { if (ModelState.IsValid) { db.AspNetFinanceLedgerTypes.Add(aspNetFinanceLedgerType); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetFinanceLedgerType)); }
public ActionResult ReceiveMessageDetail(int messageID) { var UserID = User.Identity.GetUserId(); AspNetMessage_Receiver messageReceiver = (from receiveMessage in db.AspNetMessage_Receiver where receiveMessage.ReceiverID == UserID && receiveMessage.MessageID == messageID select receiveMessage).FirstOrDefault(); messageReceiver.Seen = "Seen"; db.SaveChanges(); return(View(messageReceiver)); }
public ActionResult Create([Bind(Include = "Id,CatalogName")] AspNetCatalog aspNetCatalog) { if (ModelState.IsValid) { db.AspNetCatalogs.Add(aspNetCatalog); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetCatalog)); }
public ActionResult Create([Bind(Include = "Id,Name,Amount")] PenaltyFee penaltyFee) { if (ModelState.IsValid) { db.PenaltyFees.Add(penaltyFee); db.SaveChanges(); return(RedirectToAction("PenaltyFeeIndex")); } return(View(penaltyFee)); }
public ActionResult Create([Bind(Include = "Id,RoleName")] AspNetPTMFormRole aspNetPTMFormRole) { if (ModelState.IsValid) { db.AspNetPTMFormRoles.Add(aspNetPTMFormRole); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetPTMFormRole)); }
public ActionResult Create([Bind(Include = "Id,CategoryName")] AspNetAssessment_Questions_Category aspNetAssessment_Questions_Category) { if (ModelState.IsValid) { db.AspNetAssessment_Questions_Category.Add(aspNetAssessment_Questions_Category); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetAssessment_Questions_Category)); }
public ActionResult Create([Bind(Include = "Id,BreakDownHeadingName")] AspNetLessonPlanBreakdownHeading aspNetLessonPlanBreakdownHeading) { if (ModelState.IsValid) { db.AspNetLessonPlanBreakdownHeadings.Add(aspNetLessonPlanBreakdownHeading); db.SaveChanges(); return(RedirectToAction("Index", "AspNetLessonPlanBreakdownHeading")); } return(View(aspNetLessonPlanBreakdownHeading)); }
public ActionResult Create([Bind(Include = "Id,TypeName,MonthsDuration")] AspNetDurationType aspNetDurationType) { if (ModelState.IsValid) { db.AspNetDurationTypes.Add(aspNetDurationType); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetDurationType)); }
public ActionResult Create([Bind(Include = "Id,CurriculumName")] AspNetCurriculum aspNetCurriculum) { if (ModelState.IsValid) { db.AspNetCurriculums.Add(aspNetCurriculum); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetCurriculum)); }
public ActionResult Create([Bind(Include = "Id,Name,URL,LessonId,CreationDate")] AspnetStudentLink aspnetStudentLink) { if (ModelState.IsValid) { db.AspnetStudentLinks.Add(aspnetStudentLink); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.LessonId = new SelectList(db.AspnetLessons, "Id", "Name", aspnetStudentLink.LessonId); return(View(aspnetStudentLink)); }
public ActionResult Create([Bind(Include = "Id,Year,Month,Title,VirtualRoleID")] AspNetSalary aspNetSalary) { if (ModelState.IsValid) { db.AspNetSalaries.Add(aspNetSalary); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.VirtualRoleID = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetSalary.VirtualRoleID); return(View(aspNetSalary)); }
public ActionResult Edit([Bind(Include = "Id,ClassID,FeeTypeID,Amount")] AspNetClass_FeeType aspNetClass_FeeType) { if (ModelState.IsValid) { db.Entry(aspNetClass_FeeType).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", aspNetClass_FeeType.ClassID); ViewBag.FeeTypeID = new SelectList(db.AspNetFeeTypes, "Id", "TypeName", aspNetClass_FeeType.FeeTypeID); return(View(aspNetClass_FeeType)); }
public ActionResult Create([Bind(Include = "Id,TeacherID,JoiningDate")] AspNetTeacher aspNetTeacher) { if (ModelState.IsValid) { db.AspNetTeachers.Add(aspNetTeacher); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.TeacherID = new SelectList(db.AspNetUsers, "Id", "Email", aspNetTeacher.TeacherID); return(View(aspNetTeacher)); }
public ActionResult Create([Bind(Include = "Id,Subject,Description,Time,SenderID")] AspNetNotification aspNetNotification) { if (ModelState.IsValid) { db.AspNetNotifications.Add(aspNetNotification); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SenderID = new SelectList(db.AspNetUsers, "Id", "Email", aspNetNotification.SenderID); return(View(aspNetNotification)); }
public ActionResult Create([Bind(Include = "Id,ClassName,TeacherID")] AspNetClass aspNetClass) { if (ModelState.IsValid) { db.AspNetClasses.Add(aspNetClass); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.TeacherID = new SelectList(db.AspNetUsers.Where(x => x.AspNetRoles.Select(y => y.Name).Contains("Teacher")), "Id", "Name", aspNetClass.TeacherID); return(View(aspNetClass)); }