public ActionResult Index()
{
ViewBag.Message = false;
Dropdownlistdata("", "");
var Group = Connection.GDgetAllSubject("Y");
List <GDgetAllSubject_Result> Grouplist = Group.ToList();
Grade_SubjectModel tcm = new Grade_SubjectModel();
List <Grade_SubjectModel> tcmlist = Grouplist.Select(x => new Grade_SubjectModel
{
SubjectId = x.SubjectId,
ShortName = x.ShortName,
SubjectName = x.SubjectName,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
IsActive = x.IsActive,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).ToList();
return(PartialView(tcmlist));
// return View();
}
public ActionResult Delete(string AcademicYear, string GradeId, string SubjectId)
{
Grade_SubjectModel TModel = new Grade_SubjectModel();
TModel.AcademicYear = AcademicYear;
TModel.GradeId = GradeId;
TModel.SubjectId = Convert.ToInt32(SubjectId);
return(PartialView("DeleteView", TModel));
}
public ActionResult Edit(Grade_SubjectModel Model)
{
try
{
SchoolId = USession.School_Id;
UserId = USession.User_Id;
Connection.GDModifyGradeSubject(Model.AcademicYear, SchoolId, Model.GradeId, Model.SubjectId, Model.SubjectCategoryId, Model.Optional, UserId);
Connection.SaveChanges();
ViewBag.ShowDiv = false;
// Detail(Model.AcademicYear, Model.GradeId);
return(RedirectToAction("Detail", Model));
}
catch
{
return(View());
}
}
public ActionResult Delete(Grade_SubjectModel Model)
{
try
{
SchoolId = USession.School_Id;
UserId = USession.User_Id;
Connection.GDdeleteGradeSubject(Model.AcademicYear, SchoolId, Model.GradeId, Model.SubjectId, "N", UserId);
Connection.SaveChanges();
//return View();
return(Json(true, JsonRequestBehavior.AllowGet));
//return RedirectToAction("Detail",Model);
}
catch
{
return(View());
}
}
public ActionResult Edit(string AcademicYear, string GradeId, string SubjectId, string SubjectCategoryId, string Optional)
{
Dropdownlistdata(AcademicYear, GradeId);
int suid = Convert.ToInt32(SubjectId);
Grade_SubjectModel TModel = new Grade_SubjectModel();
tblSubject TCtable = Connection.tblSubjects.SingleOrDefault(x => x.SubjectId == suid);
TModel.AcademicYear = AcademicYear;
TModel.GradeId = GradeId;
TModel.SubjectName = TCtable.SubjectName;
TModel.ShortName = TCtable.ShortName;
TModel.SubjectId = Convert.ToInt32(SubjectId);
TModel.SubjectCategoryId = Convert.ToInt32(SubjectCategoryId);
TModel.Optional = Optional;
tblGrade TGtable = Connection.tblGrades.SingleOrDefault(x => x.GradeId == GradeId);
TModel.GradeName = TGtable.GradeName;
return(PartialView("Edit", TModel));
}
public ActionResult Detail(string AcademicYear, string GradeId)
{
try
{
Dropdownlistdata(AcademicYear, GradeId);
SchoolId = USession.School_Id;
var Group = Connection.GDgetAllGradeSubject(AcademicYear, SchoolId, GradeId, "Y");
List <GDgetAllGradeSubject_Result> Grouplist = Group.ToList();
Grade_SubjectModel tcm = new Grade_SubjectModel();
List <Grade_SubjectModel> tcmlist = Grouplist.Select(x => new Grade_SubjectModel
{
AcademicYear = x.AcademicYear,
GradeId = x.GradeId,
GradeName = x.GradeName,
SubjectId = x.SubjectId,
ShortName = x.ShortName,
SubjectName = x.SubjectName,
SubjectCategoryId = x.SubjectCategoryId,
SubjectCategoryName = x.SubjectCategoryName,
Optional = x.Optional,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
IsActive = x.IsActive,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).ToList();
return(View("Create", tcmlist));
}
catch (Exception ex) {
Errorlog.ErrorManager.LogError(ex);
return(View());
}
// return View();
}
public ActionResult Create(int[] SubjectCategoryId, int[] selectedNames, string GradeId, string[] optional, string AcademicYear)
{
try
{
SchoolId = USession.School_Id;
UserId = USession.User_Id;
int valCounter = 0;
int valCounter1 = 0;
int lenth = 0;
foreach (int SubCatId in SubjectCategoryId)
{
if (SubCatId != 0)
{
valCounter++;
}
}
foreach (string val in optional)
{
if (val != "")
{
valCounter1++;
}
}
if (selectedNames != null)
{
lenth = selectedNames.Length;
}
if (lenth != valCounter || valCounter1 != lenth || GradeId == "" || AcademicYear == "")
{
return(RedirectToAction("Index"));
}
else
{
ViewBag.Message = false;
Dropdownlistdata(AcademicYear, GradeId);
int count = -1;
foreach (int SubCatId in SubjectCategoryId)
{
if (SubCatId != 0)
{
count++;
int count1 = -1;
foreach (int SubId in selectedNames)
{
count1++;
if (count == count1)
{
int count2 = -1;
foreach (string optionalval in optional)
{
count2++;
if (count2 == count1)
{
Connection.GDsetGradeSubject(AcademicYear, SchoolId, GradeId, SubId, SubCatId, optionalval, UserId, "Y");
}
}
}
}
}
}
var Group = Connection.GDgetAllGradeSubject(AcademicYear, SchoolId, GradeId, "Y");
List <GDgetAllGradeSubject_Result> Grouplist = Group.ToList();
Grade_SubjectModel tcm = new Grade_SubjectModel();
List <Grade_SubjectModel> tcmlist = Grouplist.Select(x => new Grade_SubjectModel
{
AcademicYear = x.AcademicYear,
GradeId = x.GradeId,
GradeName = x.GradeName,
SubjectId = x.SubjectId,
ShortName = x.ShortName,
SubjectName = x.SubjectName,
SubjectCategoryId = x.SubjectCategoryId,
SubjectCategoryName = x.SubjectCategoryName,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
IsActive = x.IsActive,
Optional = x.Optional,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).ToList();
return(View(tcmlist));
}
}
catch (Exception ex)
{
Errorlog.ErrorManager.LogError(ex);
return(View());
}
}
