// GET: AttendanceDetails public async Task <IActionResult> Index() { var date = DateTime.Today; var project1211Context1 = _context.AttendanceDetails.FirstOrDefault(a => a.CreatedDate.Value.Date == date); if ((HttpContext.Session.GetString("Type") == "2") && (project1211Context1 == null)) { var db = new project1211Context(); using (SqlConnection connection = new SqlConnection("Server=tcp:testserver1211.database.windows.net,1433;Initial Catalog=project1211;Persist Security Info=False;User ID=Admin123;Password=Garry@123;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;")) using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "exec p1"; connection.Open(); command.ExecuteNonQuery(); connection.Close(); } } var project1211Context = _context.AttendanceDetails.Include(a => a.FkStud).OrderByDescending(a => a.CreatedDate); return(View(await project1211Context.ToListAsync())); }
public MstUsersController(project1211Context context) { _context = context; }
public AdminDetailsController(project1211Context context) { _context = context; }
public MstDepartmentsController(project1211Context context) { _context = context; }
public MstRolesController(project1211Context context) { _context = context; }
public MstSubjectsController(project1211Context context) { _context = context; }
public MarksDetailsController(project1211Context context) { _context = context; }
public Login(project1211Context context) { _context = context; }
public FacultyDetailsController(project1211Context context) { _context = context; }
public StudentDetailsController(project1211Context context, IWebHostEnvironment hostEnvironment) { _context = context; this.hostEnvironment = hostEnvironment; }
public AttendanceDetailsController(project1211Context context) { _context = context; }