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));
}
