public ActionResult studentsPromotion(FormCollection fc)
{
string [] ids = fc["classid"].Split(',');
string[] roll = fc["rollno"].Split(',');
string[] sessionid = fc["cbosession"].Split(',');
string[] clas = fc["cboclass"].Split(',');
string[] cat = fc["cat"].Split(',');
string[] pid = fc["pid"].Split(',');
int clases = Convert.ToInt32(clas[0]);
int cates = Convert.ToInt32(cat[0]);
int pids = Convert.ToInt32(pid[0]);
IEnumerable <Tuple <string, string, string> > result = ids
.Zip(roll, (e1, e2) => new { e1, e2 })
.Zip(sessionid, (z1, e3) => Tuple.Create(z1.e1, z1.e2, e3));
foreach (var tuple in result)
{
StudentCurrentStatus stdcurent = new StudentCurrentStatus();
//classesStudentMapping classesStudentMapping = new classesStudentMapping();
var product = StudentCurrentStatuseservice.getbyid(Convert.ToInt32(tuple.Item1));
//classesStudentMapping.StudentID =rols;
//classesStudentMapping.id = Convert.ToInt32(tuple.ids);
stdcurent.id = Convert.ToInt32(tuple.Item1);
stdcurent.StudentID = Convert.ToInt32(tuple.Item2);
stdcurent.SessionID = Convert.ToInt32(tuple.Item3);
stdcurent.CategoryID = cates;
stdcurent.TermID = Convert.ToInt32(fc["tids"]);
stdcurent.classesID = clases;
stdcurent.SectionID = Convert.ToInt32(fc["sid"]);;
stdcurent.ProgramdegreeID = pids;
stdcurent.BranchID = Convert.ToString(1);
StudentCurrentStatuseservice.updateStudentCurrentStatus(stdcurent);
Masterstudentcurrentstatus masterstudentcurrentstatus = new Masterstudentcurrentstatus();
masterstudentcurrentstatus.classesID = clases;
masterstudentcurrentstatus.CategoryID = cates;
masterstudentcurrentstatus.ProgramdegreeID = pids;
masterstudentcurrentstatus.SectionID = Convert.ToInt32(fc["sid"]);
masterstudentcurrentstatus.SessionID = Convert.ToInt32(tuple.Item3);
masterstudentcurrentstatus.TermID = Convert.ToInt32(fc["tids"]);
masterstudentcurrentstatus.StudentID = Convert.ToInt32(tuple.Item2);
masterstudentcurrentstatus.date = DateTime.Now;
SMSContext sMSContext = new SMSContext();
sMSContext.masterstudentcurrentstatuses.Add(masterstudentcurrentstatus);
ViewBag.name = "studentsPromotion?cboclass=" + stdcurent.classesID + "&" + "cbosession=" + stdcurent.SessionID + "&" + "cbocategory=" + stdcurent.CategoryID + "&" + "cboterm=" + stdcurent.TermID + "&" + "cbosection=" + stdcurent.SectionID + "&" + "cboprogram=" + stdcurent.ProgramdegreeID;
sMSContext.SaveChanges();
}
return(Redirect(ViewBag.name));
}
public ActionResult allsemesterRecords()
{
SMSContext sMSContext = new SMSContext();
ViewBag.session = sessionservice.getsession().ToList();
ViewBag.getclass = Classservice.getclasses().ToList();
return(View());
}
public void DeleteTeacher(int iD)
{
using (SMSContext cntxt = new SMSContext())
{
var findRes = cntxt.Teachers.Find(iD);
cntxt.Teachers.Remove(findRes);
cntxt.SaveChanges();
}
}
public void GetNextRowIdTest()
{
RegisterTeacher teacher = new RegisterTeacher();
SMSContext ctx = new SMSContext();
int expected = teacher.GetNextRowID();
int actual = ctx.Teachers.Select(id => id.teacherID).DefaultIfEmpty(0).Max() + 1;
Assert.AreEqual(expected, actual);
}
//Get - Delete Vehicle
public ActionResult DeleteVehicle(int id)
{
using (var db = new SMSContext())
{
var vdel = db.Vehicle.Find(id);
db.Vehicle.Remove(vdel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public void Update()
{
using (var db = new SMSContext())
{
var admin = db.Admins.FirstOrDefault(a => a.username == Username);
admin.password = NewPassword.Trim();
db.SaveChanges();
}
}
public void InsertAdmin()
{
using (var db = new SMSContext())
{
var admin = new Admin {
username = Username.Trim(), password = Password.Trim()
};
db.Admins.Add(admin);
db.SaveChanges();
}
}
public void Delete(int teacherId)
{
using (var db = new SMSContext())
{
var teachers = db.Teachers.FirstOrDefault(a => a.teacherID == TeacherId);
db.Teachers.Remove(teachers);
db.SaveChanges();
}
}
//Post - Delete Extras
//Delete -POST
public ActionResult DeleteExtra(int e_id, int?v_id)
{
if (e_id != 0)
{
using (var db = new SMSContext())
{
db.ExtraCost.Remove(db.ExtraCost.Find(e_id));
db.SaveChanges();
}
}
return(RedirectToAction("ExtraDetails", new { id = v_id }));
}
public int GetNextRowID()
{
int nextRowId = 0;
using (var db = new SMSContext())
{
var max = db.Teachers.Select(id => id.teacherID).DefaultIfEmpty(0).Max();
nextRowId = max + 1;
}
return(nextRowId);
}
public ViewResult ExtraDetails(int id)
{
if (id == 0)
{
return(View("Index"));
}
using (var db = new SMSContext())
{
var extraList = db.ExtraCost.Where(e => e.VehicleId == id && e.TraderId == usr_id).ToList();
return(View(extraList));
}
}
public ActionResult AddResult(FormCollection fc)
{
//string[] ids = fc["classid"].Split(',');
string[] ids = fc["AssignmentMakrs"].Split(',');
string[] roll = fc["rollno"].Split(',');
string[] finall = fc["FinalTerm"].Split(',');
string[] sessionid = fc["MidMarks"].Split(',');
string[] clas = fc["classesID"].Split(',');
string[] term = fc["TermsID"].Split(',');
string[] ses = fc["SessionsID"].Split(',');
string[] sec = fc["SectionID"].Split(',');
string[] sub = fc["ID"].Split(',');
int clases = Convert.ToInt32(clas[0]);
int terms = Convert.ToInt32(term[0]);
int sess = Convert.ToInt32(ses[0]);
int subs = Convert.ToInt32(sub[0]);
int secs = Convert.ToInt32(sub[0]);
IEnumerable <Tuple <string, string, string> > result = ids
.Zip(roll, (e1, e2) => new { e1, e2 })
.Zip(sessionid, (z1, e3) => Tuple.Create(z1.e1, z1.e2, e3));
foreach (var tuple in result)
{
ResultSheet resultSheet = new ResultSheet();
resultSheet.AssignmentMakrs = Convert.ToInt32(tuple.Item1);
resultSheet.Studentid = Convert.ToInt32(tuple.Item2);
resultSheet.MidMarks = Convert.ToInt32(tuple.Item3);
resultSheet.TermsID = terms;
resultSheet.classesID = clases;
resultSheet.SectionID = secs;
resultSheet.SessionsID = sess;
resultSheet.FinalTerm = 10;
resultSheet.Subjectid = subs;
resultSheet.AddDetails = DateTime.Now;
SMSContext sMSContext = new SMSContext();
sMSContext.ResultSheet.Add(resultSheet);
sMSContext.SaveChanges();
}
return(RedirectToAction("FindallStudentResults"));
}
private void StudentFeesStatusv(int cboclass, int cbosession)
{
SMSContext SMSContext = new SMSContext();
//ViewBag.name = "cboclass=" + cboclass + "&" + "cbosession=" + cbosession + "&" + "cbocategory=" + cbocategory + "&" + "cboterm=" + cboterm + "&" + "cbosection=" + cbosection;
var list = SMSContext.allSemesterfeesRecord.ToList().Where(x => x.session == cbosession && x.classes == cboclass);
ReportDataSource rd = new ReportDataSource("DataSet1", list);
ReportViewer1.LocalReport.DataSources.Add(rd);
ReportViewer1.LocalReport.Refresh();
}
public ActionResult StudentFeesStatusv(int?cboclass, int?cbosession, int?cbocategory, int cboterm, int cbosection)
{
SMSContext SMSContext = new SMSContext();
SqlParameter classids = new SqlParameter("@classid", cboclass);
SqlParameter catids = new SqlParameter("@catid", cbosession);
SqlParameter sids = new SqlParameter("@Sid", cbocategory);
SqlParameter tids = new SqlParameter("@tid", cboterm);
SqlParameter secs = new SqlParameter("@sec", cbosection);
ViewBag.name = "cboclass=" + cboclass + "&" + "cbosession=" + cbosession + "&" + "cbocategory=" + cbocategory + "&" + "cboterm=" + cboterm + "&" + "cbosection=" + cbosection;
var list = SMSContext.Database.SqlQuery <StudentfeesStatusmodel>("studentfeesstatussshared @classid,@catid,@Sid,@tid,@sec", classids, catids, sids, tids, secs).ToList();
return(View(list));
}
public int SearchCourseCount(string searchTerm)
{
var context = new SMSContext();
var course = context.Courses.AsQueryable();
if (!string.IsNullOrEmpty(searchTerm))
{
course = course.Where(a => a.Name.ToLower().Contains(searchTerm.ToLower()));
}
return(course.Count());
}
private void StudentFeesStatusv(int?cboclass, int?cbosession, int?cbocategory, int cboterm, int cbosection)
{
SMSContext SMSContext = new SMSContext();
SqlParameter classids = new SqlParameter("@classid", cboclass);
SqlParameter catids = new SqlParameter("@catid", cbosession);
SqlParameter sids = new SqlParameter("@Sid", cbocategory);
SqlParameter tids = new SqlParameter("@tid", cboterm);
SqlParameter secs = new SqlParameter("@sec", cboterm);
//ViewBag.name="cboclass="+ cboclass + "&" + "cboclass" + cboclass;
var list = SMSContext.Database.SqlQuery <StudentfeesStatusmodel>("studentfeesstatussshared @classid,@catid,@Sid,@tid,@sec", classids, catids, sids, tids, secs).ToList();
ReportDataSource rd = new ReportDataSource("DataSet1", list);
ReportViewer1.LocalReport.DataSources.Add(rd);
ReportViewer1.LocalReport.Refresh();
}
public static void InsertPhoneDirectory(PhoneDirectory phoneDirectory)
{
try
{
using (var db = new SMSContext())
{
db.PhoneDirectories.Add(phoneDirectory);
db.SaveChanges();
}
}
catch (Exception exception)
{
LogManage.Log("MethodName:GetClassById " + Environment.NewLine + " Time: " + DateTime.Now + Environment.NewLine + " ErrorMsg: " + exception.Message);
}
}
public static void InsertStudentEnrollment(StudentEnrollment studentEnrollment)
{
try
{
using (var db = new SMSContext())
{
db.StudentEnrollments.Add(studentEnrollment);
db.SaveChanges();
}
}
catch (Exception exception)
{
LogManage.Log("MethodName:GetClassById " + Environment.NewLine + " Time: " + DateTime.Now + Environment.NewLine + " ErrorMsg: " + exception.Message);
}
}
public static void InsertPreviousSchool(PreviousSchool previousSchool)
{
try
{
using (var db = new SMSContext())
{
db.PreviousSchools.Add(previousSchool);
db.SaveChanges();
}
}
catch (Exception exception)
{
LogManage.Log("MethodName:GetClassById " + Environment.NewLine + " Time: " + DateTime.Now + Environment.NewLine + " ErrorMsg: " + exception.Message);
}
}
private void classmarkslist(int?classs, int?cbosession, int?cboterm, int?cbosection, int?cbosubject)
{
SMSContext SMSContext = new SMSContext();
SqlParameter tids = new SqlParameter("@termid", cboterm);
SqlParameter subject = new SqlParameter("@subjectid", cbosubject);
SqlParameter secs = new SqlParameter("@sectionid", cbosection);
SqlParameter classids = new SqlParameter("@classid", classs);
SqlParameter session = new SqlParameter("@session", cbosession);
//ViewBag.name="cboclass="+ cboclass + "&" + "cboclass" + cboclass;
var list = SMSContext.Database.SqlQuery <Studentclassresult>("classMarkslist @termid,@subjectid,@sectionid,@classid,@session", tids, subject, secs, classids, session).ToList();
ReportDataSource rd = new ReportDataSource("DataSet1", list);
ReportViewer1.LocalReport.DataSources.Add(rd);
ReportViewer1.LocalReport.Refresh();
}
public static void UpdateCity(City city)
{
try
{
using (var db = new SMSContext())
{
var tempCity = db.Cities.Single(x => x.Id == city.Id);
tempCity.CityName = city.CityName;
db.SaveChanges();
}
}
catch (Exception exception)
{
LogManage.Log("MethodName:GetClassById " + Environment.NewLine + " Time: " + DateTime.Now + Environment.NewLine + " ErrorMsg: " + exception.Message);
}
}
public static void UpdateGrade(Grade grade)
{
try
{
using (var db = new SMSContext())
{
var tempGrade = db.Grades.Single(x => x.Id == grade.Id);
tempGrade.Grades = grade.Grades;
db.SaveChanges();
}
}
catch (Exception exception)
{
LogManage.Log("MethodName:GetClassById " + Environment.NewLine + " Time: " + DateTime.Now + Environment.NewLine + " ErrorMsg: " + exception.Message);
}
}
public static void DeletePhoneDirectory(int phoneDirectoryId)
{
try
{
using (var db = new SMSContext())
{
var tempPhoneDirectory = db.PhoneDirectories.Single(x => x.Id == phoneDirectoryId);
db.PhoneDirectories.Remove(tempPhoneDirectory);
db.SaveChanges();
}
}
catch (Exception exception)
{
LogManage.Log("MethodName:GetClassById " + Environment.NewLine + " Time: " + DateTime.Now + Environment.NewLine + " ErrorMsg: " + exception.Message);
}
}
public static void DeleteStudentEnrollment(int studentEnrollmentId)
{
try
{
using (var db = new SMSContext())
{
var tempStudentEnrollment = db.StudentEnrollments.Single(x => x.Id == studentEnrollmentId);
db.StudentEnrollments.Remove(tempStudentEnrollment);
db.SaveChanges();
}
}
catch (Exception exception)
{
LogManage.Log("MethodName:GetClassById " + Environment.NewLine + " Time: " + DateTime.Now + Environment.NewLine + " ErrorMsg: " + exception.Message);
}
}
public static void DeletePreviousSchool(int previousSchoolId)
{
try
{
using (var db = new SMSContext())
{
var tempPreviousSchcool = db.PreviousSchools.Single(x => x.Id == previousSchoolId);
db.PreviousSchools.Remove(tempPreviousSchcool);
db.SaveChanges();
}
}
catch (Exception exception)
{
LogManage.Log("MethodName:GetClassById " + Environment.NewLine + " Time: " + DateTime.Now + Environment.NewLine + " ErrorMsg: " + exception.Message);
}
}
public void Update(int teacherId, string surname, string forename, DateTime dob, string phone, char type, decimal salary, string subjects)
{
using (var db = new SMSContext())
{
var teachers = db.Teachers.FirstOrDefault(a => a.teacherID == TeacherId);
teachers.surname = surname.Trim();
teachers.forename = forename.Trim();
teachers.dob = dob.Date;
teachers.type = type.ToString();
teachers.phone = phone.Trim();
teachers.subjects = subjects;
db.SaveChanges();
}
}
public static void UpdateRole(Role role)
{
try
{
using (var db = new SMSContext())
{
var objrole = db.Roles.Single(x => x.Id == role.Id);
objrole.RoleName = role.RoleName;
db.SaveChanges();
}
}
catch (Exception exception)
{
LogManage.Log("MethodName:GetClassById " + Environment.NewLine + " Time: " + DateTime.Now + Environment.NewLine + " ErrorMsg: " + exception.Message);
}
}
public static void DeleteBranch(Branch branch)
{
try
{
using (var db = new SMSContext())
{
var tempBranch = db.Branches.Single(x => x.Id == branch.Id);
db.Branches.Remove(tempBranch);
db.SaveChanges();
}
}
catch (Exception exception)
{
LogManage.Log("MethodName:GetClassById " + Environment.NewLine + " Time: " + DateTime.Now + Environment.NewLine + " ErrorMsg: " + exception.Message);
}
}
public static ObservableCollection <ITeacher> GetTeacherList()
{
ObservableCollection <ITeacher> list = new ObservableCollection <ITeacher>();
using (var db = new SMSContext())
{
var teachers = from t in db.Teachers select t;
foreach (var row in teachers)
{
list.Add(new ITeacher(row.teacherID, row.surname.Trim(), row.forename.Trim(), row.dob.Date, row.phone.Trim(), row.type.ToCharArray()[0], Convert.ToDecimal(row.salary), row.subjects));
}
}
return(list);
}
public List <Subject> SearchSubjects(string searchTerm, int pageNo, int recordSize)
{
var context = new SMSContext();
var courses = context.Subjects.AsQueryable();
if (!string.IsNullOrEmpty(searchTerm))
{
courses = courses.Where(a => a.Name.ToLower().Contains(searchTerm.ToLower()));
}
var skipCount = (pageNo - 1) * recordSize;
return(courses.OrderBy(x => x.Name).Skip(skipCount).Take(recordSize).ToList());
//return accomodationTypes.ToList();
}
