public ActionResult ApproveDiary(int HomeWorkId)
{
var stid = db.AspNetStudent_HomeWork.Where(p => p.HomeworkID == HomeWorkId).FirstOrDefault().StudentID;
var clasid = db.AspNetStudents.Where(p => p.StudentID == stid).FirstOrDefault().ClassID;
var gh = db.AspNetStudents.Where(p => p.ClassID == clasid).ToList();
List <string> ParentList = new List <string>();
foreach (var g in gh)
{
var parent = db.AspNetParent_Child.Where(p => p.ChildID == g.StudentID).FirstOrDefault();
if (parent != null)
{
ParentList.Add(parent.ParentID);
}
else
{
var mee = "This student id don't have parent " + g.StudentID + " NGS Portal";
Utility ob = new Utility();
ob.messagetosupport(mee);
}
}
Utility obtj = new Utility();
AspNetMessage oob = new AspNetMessage();
oob.Message = "Dear Parents, Please check the assigned homework to your child on portal. IPC Aziz Avenue Campus";
obtj.SendSMS(oob, ParentList);
//var obje = db.AspNetHomeworks.Where(x => x.Id == HomeWorkId).FirstOrDefault();
//obje.PrincipalApproved_status = false;
//db.Entry(obje).State = EntityState.Modified;
//db.SaveChanges();
//var ty = db.AspNetHomeworks.Where(x => x.Id == HomeWorkId).FirstOrDefault().PrincipalApproved_status;
var obj = db.AspNetHomeworks.Where(x => x.Id == HomeWorkId).FirstOrDefault();
obj.PrincipalApproved_status = "Approved";
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
var tyu = db.AspNetHomeworks.Where(x => x.Id == HomeWorkId).FirstOrDefault().PrincipalApproved_status;
var result1 = new { status = "success", Value = tyu };
return(Json(result1, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit([Bind(Include = "Id,SubjectName,ClassID,TeacherID,IsMandatory,Points")] AspNetSubject aspNetSubject)
{
var class_id = db.AspNetClasses.Where(x => x.SessionID == SessionID).FirstOrDefault().Id;
aspNetSubject.ClassID = class_id;
try
{
var IsMan = Request.Form["IsMandatory"];
if (IsMan == null)
{
aspNetSubject.IsManadatory = false;
}
else
{
aspNetSubject.IsManadatory = true;
}
aspNetSubject.CourseType = Request.Form["CourseType"];
if (ModelState.IsValid)
{
db.Entry(aspNetSubject).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ClassIndex"));
}
ViewBag.ClassID = new SelectList(db.AspNetClasses, "Id", "ClassName", aspNetSubject.ClassID);
ViewBag.TeacherID = new SelectList(db.AspNetUsers, "Id", "Email", aspNetSubject.TeacherID);
return(View(aspNetSubject));
}
catch (Exception e)
{
ViewBag.Error = e.Message;
return(RedirectToAction("Edit", aspNetSubject));
}
}
public ActionResult Edit([Bind(Include = "Id,TopicNo,TopicName,StartDate,EndDate,ChapterID,Status")] AspNetTopic aspNetTopic)
{
if (ModelState.IsValid)
{
db.Entry(aspNetTopic).State = EntityState.Modified;
db.SaveChanges();
var status = db.AspNetTopics.Where(x => x.ChapterID == aspNetTopic.ChapterID).Select(x => x.Status).ToList();
bool completed = true;
foreach (var item in status)
{
if (item == false)
{
completed = false;
break;
}
}
AspNetChapter aspNetChapter = db.AspNetChapters.Where(x => x.Id == aspNetTopic.ChapterID).FirstOrDefault();
if (completed)
{
aspNetChapter.Status = true;
db.SaveChanges();
}
else
{
aspNetChapter.Status = false;
db.SaveChanges();
}
return(RedirectToAction("Dashboard", "Account"));
}
ViewBag.ChapterID = new SelectList(db.AspNetChapters, "Id", "ChapterName", aspNetTopic.ChapterID);
return(View(aspNetTopic));
}
public ActionResult PrepaidConfirmOdr(int TotalAmount, int[] IDs)
{
AspNetOrder order = new AspNetOrder();
order.TotalAmount = TotalAmount;
order.OrderType = "Prepaid";
order.Status = "Pending";
order.PublishDate = DateTime.Now;
db.AspNetOrders.Add(order);
db.SaveChanges();
int OrderId = order.Id;
List <AspNetNotesOrder> AllNotesOrder = db.AspNetNotesOrders.ToList();
List <AspNetNotesOrder> OrdersToModify = new List <AspNetNotesOrder>();
foreach (var OrderIds in IDs)
{
foreach (var findOrder in AllNotesOrder)
{
if (OrderIds == findOrder.Id)
{
OrdersToModify.Add(findOrder);
}
}
}
foreach (var OrderModify in OrdersToModify)
{
OrderModify.OrderId = OrderId;
OrderModify.Status = "Pending";
db.Entry(OrderModify).State = EntityState.Modified;
db.SaveChanges();
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult EditStudent([Bind(Include = "Id,Email,PasswordHash,SecurityStamp,PhoneNumber,UserName,Name")] AspNetUser aspNetUser)
{
var dbTransaction = db.Database.BeginTransaction();
try
{
if (ModelState.IsValid)
{
ApplicationDbContext context = new ApplicationDbContext();
IEnumerable <string> selectedsubjects = Request.Form["subjects"].Split(',');
AspNetStudent_Subject stu_sub_rem = new AspNetStudent_Subject();
do
{
stu_sub_rem = db.AspNetStudent_Subject.FirstOrDefault(x => x.StudentID == aspNetUser.Id);
try
{
db.AspNetStudent_Subject.Remove(stu_sub_rem);
db.SaveChanges();
}
catch
{
}
}while (stu_sub_rem != null);
foreach (var item in selectedsubjects)
{
AspNetStudent_Subject stu_sub = new AspNetStudent_Subject();
stu_sub.StudentID = aspNetUser.Id;
stu_sub.SubjectID = Convert.ToInt32(item);
db.AspNetStudent_Subject.Add(stu_sub);
db.SaveChanges();
}
db.Entry(aspNetUser).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("StudentsIndex"));
}
dbTransaction.Commit();
}
catch (Exception) { dbTransaction.Dispose(); }
return(View("StudentsIndex"));
}
public ActionResult Edit([Bind(Include = "Id,Name,Notes,Date,CreatedBy")] Voucher voucher)
{
if (ModelState.IsValid)
{
db.Entry(voucher).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Voucher"));
}
return(View(voucher));
}
public ActionResult Edit([Bind(Include = "Id,Name,Amount")] FeeDiscount feeDiscount)
{
if (ModelState.IsValid)
{
db.Entry(feeDiscount).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("FeeDiscountIndex"));
}
return(View(feeDiscount));
}
public ActionResult Edit([Bind(Include = "Id,Name,Start_Time,End_Time,Minutes")] AspNetTimeslot aspNetTimeslot)
{
if (ModelState.IsValid)
{
db.Entry(aspNetTimeslot).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetTimeslot));
}
public ActionResult Edit([Bind(Include = "Id,SessionName,SessionStartDate,SessionEndDate,Status")] AspNetSession aspNetSession)
{
if (ModelState.IsValid)
{
db.Entry(aspNetSession).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetSession));
}
public ActionResult Edit([Bind(Include = "Id,Name,Amount")] PenaltyFee penaltyFee)
{
if (ModelState.IsValid)
{
db.Entry(penaltyFee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("PenaltyFeeIndex"));
}
return(View(penaltyFee));
}
public ActionResult Edit([Bind(Include = "Id,TypeName,MonthsDuration")] AspNetDurationType aspNetDurationType)
{
if (ModelState.IsValid)
{
db.Entry(aspNetDurationType).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetDurationType));
}
public ActionResult Edit([Bind(Include = "Id,CurriculumName")] AspNetCurriculum aspNetCurriculum)
{
if (ModelState.IsValid)
{
db.Entry(aspNetCurriculum).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetCurriculum));
}
public ActionResult Edit([Bind(Include = "Id,BreakDownHeadingName")] AspNetLessonPlanBreakdownHeading aspNetLessonPlanBreakdownHeading)
{
if (ModelState.IsValid)
{
db.Entry(aspNetLessonPlanBreakdownHeading).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetLessonPlanBreakdownHeading));
}
public ActionResult Edit([Bind(Include = "Id,Title,Description,Date")] AspNetAnnouncement aspNetAnnouncement)
{
if (ModelState.IsValid)
{
db.Entry(aspNetAnnouncement).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetAnnouncement));
}
public ActionResult Edit([Bind(Include = "Id,PenaltyType,Amount,TimeStamp")] EmployeePenaltyType employeePenaltyType)
{
if (ModelState.IsValid)
{
db.Entry(employeePenaltyType).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("PenaltyTypeIndex"));
}
return(View(employeePenaltyType));
}
public ActionResult Edit([Bind(Include = "Id,CategoryName")] AspNetAssessment_Questions_Category aspNetAssessment_Questions_Category)
{
if (ModelState.IsValid)
{
db.Entry(aspNetAssessment_Questions_Category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetAssessment_Questions_Category));
}
public ActionResult Edit([Bind(Include = "Id,Title,Description,Date,Time,Status")] AspNetParentTeacherMeeting aspNetParentTeacherMeeting)
{
if (ModelState.IsValid)
{
db.Entry(aspNetParentTeacherMeeting).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetParentTeacherMeeting));
}
public ActionResult Edit([Bind(Include = "Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName,Name")] AspNetUser aspNetUser)
{
if (ModelState.IsValid)
{
db.Entry(aspNetUser).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetUser));
}
public ActionResult Edit([Bind(Include = "Id,RoleName")] AspNetPTMFormRole aspNetPTMFormRole)
{
if (ModelState.IsValid)
{
db.Entry(aspNetPTMFormRole).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetPTMFormRole));
}
public ActionResult Edit([Bind(Include = "Id,EmployeeId,PenaltyType,Description,Amount,Months,Status,Time")] TeacherPenaltyRecord teacherPenaltyRecord)
{
if (ModelState.IsValid)
{
db.Entry(teacherPenaltyRecord).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeId = new SelectList(db.AspNetEmployees, "Id", "PositionAppliedFor", teacherPenaltyRecord.EmployeeId);
return(View(teacherPenaltyRecord));
}
public ActionResult Edit([Bind(Include = "Id,TeacherID,JoiningDate")] AspNetTeacher aspNetTeacher)
{
if (ModelState.IsValid)
{
db.Entry(aspNetTeacher).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TeacherID = new SelectList(db.AspNetUsers, "Id", "Email", aspNetTeacher.TeacherID);
return(View(aspNetTeacher));
}
public ActionResult Edit([Bind(Include = "Id,Name,Description,FileName,LessonId,DueDate,Path,CreationDate")] AspnetStudentAssignment aspnetStudentAssignment)
{
if (ModelState.IsValid)
{
db.Entry(aspnetStudentAssignment).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LessonId = new SelectList(db.AspnetLessons, "Id", "Name", aspnetStudentAssignment.LessonId);
return(View(aspnetStudentAssignment));
}
public ActionResult Edit([Bind(Include = "Id,Operation,Time,UserID")] AspNetLog aspNetLog)
{
if (ModelState.IsValid)
{
db.Entry(aspNetLog).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserID = new SelectList(db.AspNetUsers, "Id", "Email", aspNetLog.UserID);
return(View(aspNetLog));
}
public ActionResult Edit([Bind(Include = "Id,ClassName,TeacherID")] AspNetClass aspNetClass)
{
if (ModelState.IsValid)
{
db.Entry(aspNetClass).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TeacherID = new SelectList(db.AspNetUsers, "Id", "Name", aspNetClass.TeacherID);
return(View(aspNetClass));
}
public ActionResult Edit([Bind(Include = "Id,Month,Title,VirtualRoleID")] AspNetSalary aspNetSalary)
{
if (ModelState.IsValid)
{
db.Entry(aspNetSalary).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.VirtualRoleID = new SelectList(db.AspNetVirtualRoles, "Id", "Name", aspNetSalary.VirtualRoleID);
return(View(aspNetSalary));
}
public ActionResult Edit([Bind(Include = "Id,TopicName,SubjectID")] AspNetTopic aspNetTopic)
{
if (ModelState.IsValid)
{
db.Entry(aspNetTopic).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetTopic.SubjectID);
return(View(aspNetTopic));
}
public ActionResult Edit([Bind(Include = "Id,Month,StartData,EndDate,Name,PeriodId")] AspNetFinanceMonth aspNetFinanceMonth)
{
if (ModelState.IsValid)
{
db.Entry(aspNetFinanceMonth).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PeriodId = new SelectList(db.AspNetFinancePeriods, "Id", "Year", aspNetFinanceMonth.PeriodId);
return(View(aspNetFinanceMonth));
}
public ActionResult Edit([Bind(Include = "Id,Message,UserID,Time,IsOpen")] AspNetPushNotification aspNetPushNotification)
{
if (ModelState.IsValid)
{
db.Entry(aspNetPushNotification).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserID = new SelectList(db.AspNetUsers, "Id", "Name", aspNetPushNotification.UserID);
return(View(aspNetPushNotification));
}
public ActionResult Edit([Bind(Include = "Id,Subject,Description,Time,SenderID")] AspNetNotification aspNetNotification)
{
if (ModelState.IsValid)
{
db.Entry(aspNetNotification).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SenderID = new SelectList(db.AspNetUsers, "Id", "Email", aspNetNotification.SenderID);
return(View(aspNetNotification));
}
public ActionResult Edit([Bind(Include = "Id,Name,URL,LessonId,CreationDate")] AspnetStudentLink aspnetStudentLink)
{
if (ModelState.IsValid)
{
db.Entry(aspnetStudentLink).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LessonId = new SelectList(db.AspnetLessons, "Id", "Name", aspnetStudentLink.LessonId);
return(View(aspnetStudentLink));
}
