public ActionResult Edit(SEdefaulters sEdefaulters)
{
try
{
if (ModelState.IsValid)
{
db.Entry(sEdefaulters).State = EntityState.Modified;
db.SaveChanges();
var extra = new List <extratotal>();
int semt = Convert.ToInt32(Session["sem"]);
int stdrollnot = Convert.ToInt32(sEdefaulters.stdrollno);
using (var adv = new AttendanceContext())
{
var sem = new SqlParameter("@sem", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = semt
};
var stdrollno = new SqlParameter("@stdrollno", SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Input,
Value = stdrollnot
};
extra = adv.Database.SqlQuery <extratotal>("exec extraattendance @stdrollno, @sem ", stdrollno, sem).ToList();
}
return(RedirectToAction("Index"));
}
return(View(sEdefaulters));
}
catch
{
return(View());
}
}
public ActionResult ParticipationForClass(string ClassCode)
{
//använd action och partialview istället för att kunna populera listan på ett bra sätt + uppdatera partialview automatiskt.
var participation = db.Participation.ToList();
var students = db.Students.ToList();
using (AttendanceContext db = new AttendanceContext())
{
var obj = (from p in participation
join s in students on p.StudentId equals s.Id
select new studentParticipation
{
Name = s.FirstName + " " + s.LastName,
Message = p.StudentMessage
}).ToList();
if (obj.Count() > 0)
{
return(PartialView(obj));
}
else
{
return(null);
}
}
}
private void SeedAttendance(AttendanceContext context)
{
context.Attendances.AddOrUpdate(u => u.AttendanceId, new Attendance
{
AttendanceId = 1,
ModuleId = 1,
CollegeId = "S00000001",
AttendanceDateTime = DateTime.Now,
Present = true
});
context.Attendances.AddOrUpdate(u => u.AttendanceId, new Attendance
{
AttendanceId = 1,
ModuleId = 2,
CollegeId = "S00000001",
AttendanceDateTime = DateTime.Now,
Present = false
});
context.Attendances.AddOrUpdate(u => u.AttendanceId, new Attendance
{
AttendanceId = 1,
ModuleId = 3,
CollegeId = "S00000001",
AttendanceDateTime = DateTime.Now,
Present = true
});
}
public ActionResult InitClass(string TeacherId)
{
if (Convert.ToInt32(TeacherId) > 0)
{
using (AttendanceContext db = new AttendanceContext())
{
String uniqueCode = DateTime.Now.Ticks.ToString("x");
db.Init.Add(new Init()
{
Code = uniqueCode,
Status = "Started",
TeacherId = Convert.ToInt32(TeacherId)
});
db.SaveChanges();
var teacherToInt = int.Parse(TeacherId);
var obj = db.Init.Where(a => a.TeacherId.Equals(teacherToInt) && a.Status.Equals("Started")).FirstOrDefault();
var teacher = db.Teachers.Where(a => a.Id.Equals(teacherToInt)).FirstOrDefault();
var createStarted = new StartedClasses
{
InitId = obj.Id,
Code = obj.Code,
TeacherId = obj.TeacherId,
TeacherName = teacher.FirstName
};
return(View(createStarted));
}
}
return(View("Index"));
}
public void ConfigureAuth(IAppBuilder app)
{
AttendanceContext db = new AttendanceContext();
app.SetDefaultSignInAsAuthenticationType(CookieAuthenticationDefaults.AuthenticationType);
app.UseCookieAuthentication(new CookieAuthenticationOptions());
app.UseOpenIdConnectAuthentication(
new OpenIdConnectAuthenticationOptions
{
ClientId = clientId,
Authority = Authority,
PostLogoutRedirectUri = postLogoutRedirectUri,
Notifications = new OpenIdConnectAuthenticationNotifications()
{
// If there is a code in the OpenID Connect response, redeem it for an access token and refresh token, and store those away.
AuthorizationCodeReceived = (context) =>
{
var code = context.Code;
ClientCredential credential = new ClientCredential(clientId, appKey);
string signedInUserID = context.AuthenticationTicket.Identity.FindFirst(ClaimTypes.NameIdentifier).Value;
AuthenticationContext authContext = new AuthenticationContext(Authority, new ADALTokenCache(signedInUserID));
AuthenticationResult result = authContext.AcquireTokenByAuthorizationCode(
code, new Uri(HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Path)), credential, graphResourceId);
return(Task.FromResult(0));
}
}
});
}
public ActionResult updatestudentsem()
{
using (var adv = new AttendanceContext())
{
var advisor = adv.Database.SqlQuery <admin>("exec updatestudentsem").ToList();
}
return(RedirectToAction("admin", "admin"));
}
public List <yesno> getyesno()
{
var advisor = new List <yesno>();
using (var adv = new AttendanceContext())
{
advisor = adv.Database.SqlQuery <yesno>("exec getyesno").ToList();
}
return(advisor);
}
public List <chooseyearteacher> getyear()
{
var be = new List <chooseyearteacher>();
using (var adv = new AttendanceContext())
{
be = adv.Database.SqlQuery <chooseyearteacher>("exec fetchsubjectyear ").ToList();
}
return(be);
}
public List <chooseTE> getTE()
{
var te = new List <chooseTE>();
using (var adv = new AttendanceContext())
{
te = adv.Database.SqlQuery <chooseTE>("exec fetchsem TE").ToList();
}
return(te);
}
public List <chooseSE> getSE()
{
var se = new List <chooseSE>();
using (var adv = new AttendanceContext())
{
se = adv.Database.SqlQuery <chooseSE>("exec fetchsem SE").ToList();
}
return(se);
}
public List <chooseBE> getBE()
{
var be = new List <chooseBE>();
using (var adv = new AttendanceContext())
{
be = adv.Database.SqlQuery <chooseBE>("exec fetchsem BE").ToList();
}
return(be);
}
public List <chooseadvisor> getteachers()
{
var advisor = new List <chooseadvisor>();
using (var adv = new AttendanceContext())
{
advisor = adv.Database.SqlQuery <chooseadvisor>("exec fetchteacher").ToList();
}
return(advisor);
}
public List <subjectpracticalyear> getyear()
{
var year = new List <subjectpracticalyear>();
using (var reg = new AttendanceContext())
{
year = reg.Database.SqlQuery <subjectpracticalyear>("exec fetchsubjectyear").ToList();
}
return(year);
}
public AttendanceController(AttendanceContext context)
{
_context = context;
if (_context.Attendances.Count() == 0)
{
NoContent();
_context.SaveChanges();
}
}
public List <subjectpracticalsem> getsem()
{
var sem = new List <subjectpracticalsem>();
using (var reg = new AttendanceContext())
{
sem = reg.Database.SqlQuery <subjectpracticalsem>("exec fetchsubjectsem").ToList();
}
return(sem);
}
public List <role> getroles()
{
var role = new List <role>();
using (var reg = new AttendanceContext())
{
role = reg.Database.SqlQuery <role>("exec fetchrole").ToList();
}
return(role);
}
public List <nampracteach> nameteacher()
{
int xxx = Convert.ToInt32(TempData["techid"]);
var advisor = new List <nampracteach>();
using (var adv = new AttendanceContext())
{
advisor = adv.Database.SqlQuery <nampracteach>("exec namepracteacher @id", new SqlParameter("@id", xxx)).ToList();
}
return(null);
}
public ActionResult updatedefaulter()
{
int sem = Convert.ToInt32(Session["sem"]);
string year = Convert.ToString(Session["year"]);
using (var adv = new AttendanceContext())
{
var advi = adv.Database.SqlQuery <advisor>("exec updatedefaulter @sem, @year", new SqlParameter("@sem", sem), new SqlParameter("@year", year)).ToList();
}
return(RedirectToAction("advisor", "advisor"));
}
public ActionResult getsubsem(stdlistpractical aa)
{
string name = Convert.ToString(Session["subname2"]);
using (var adv = new AttendanceContext())
{
var advisor = adv.Database.SqlQuery <stdlistpractical>("exec fetchsubjectsembyname @name", new SqlParameter("@name", name)).ToList();
TempData["sem"] = advisor[0].sem;
}
return(RedirectToAction("Index", "practicalattendancelist"));
}
public List <studentlist> getstd()
{
int sem = Convert.ToInt32(Session["sem"]);
var std = new List <studentlist>();
using (var adv = new AttendanceContext())
{
std = adv.Database.SqlQuery <studentlist>("exec fetchstdid @sem", new SqlParameter("@sem", sem)).ToList();
}
return(std);
}
public List <assignpracteacher> getsubteach()
{
//int sem = Convert.ToInt32(Session["sem"]);
var teachers = new List <assignpracteacher>();
using (var adv = new AttendanceContext())
{
teachers = adv.Database.SqlQuery <assignpracteacher>("exec assgnpracteacher ").ToList();
}
return(teachers);
}
public List <totalattendacelistrollno> gettotalroll()
{
var advisor = new List <totalattendacelistrollno>();
string subjectname = Convert.ToString(Session["subname2"]);
using (var adv = new AttendanceContext())
{
advisor = adv.Database.SqlQuery <totalattendacelistrollno>("exec gettotaltheoryattendancerollno @subjectname ", new SqlParameter("@subjectname", subjectname)).ToList();
}
return(advisor);
}
//Details
public List <attendancelisttt> getliststd()
{
var advisor = new List <attendancelisttt>();
string modifiedon = Convert.ToString(TempData["moddate"]);
using (var adv = new AttendanceContext())
{
advisor = adv.Database.SqlQuery <attendancelisttt>("exec getstudentmoddate @modifiedon", new SqlParameter("@modifiedon", modifiedon)).ToList();
}
return(advisor);
}
//New
public List <attendancelist> gettheorystd()
{
var advisor = new List <attendancelist>();
int sem = Convert.ToInt32(TempData["sem"]);
using (var adv = new AttendanceContext())
{
advisor = adv.Database.SqlQuery <attendancelist>("exec studentfetchtheory @sem", new SqlParameter("@sem", sem)).ToList();
}
return(advisor);
}
public List <fetchsubthoerysubjectforselect> gettheorysub()
{
int teacherid = Convert.ToInt32(Session["id"]);
var advisor = new List <fetchsubthoerysubjectforselect>();
using (var adv = new AttendanceContext())
{
advisor = adv.Database.SqlQuery <fetchsubthoerysubjectforselect>("exec attendfetchtheorysub @teacherid", new SqlParameter("@teacherid", teacherid)).ToList();
}
return(advisor);
}
//New
public ActionResult testdemo(stdlisttheory aa)
{
int id = Convert.ToInt32(TempData["id"]);
using (var adv = new AttendanceContext())
{
var advisor = adv.Database.SqlQuery <stdlisttheory>("exec getsubsemfromid @id", new SqlParameter("@id", id)).ToList();
TempData["sem"] = advisor[0].sem;
}
return(RedirectToAction("Index", "attendancelist"));
}
public List <practicalattendancelist> getpracstd()
{
var advisor = new List <practicalattendancelist>();
int sem = Convert.ToInt32(TempData["sem"]);
string batch = Convert.ToString(TempData["batch"]);
using (var adv = new AttendanceContext())
{
advisor = adv.Database.SqlQuery <practicalattendancelist>("exec studentfetchpractical @sem, @batch ", new SqlParameter("@sem", sem), new SqlParameter("@batch", batch)).ToList();
}
return(advisor);
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.AddCors();
JwtSecurityTokenHandler.DefaultInboundClaimTypeMap.Clear();
JwtSecurityTokenHandler.DefaultOutboundClaimTypeMap.Clear();
services.AddAuthentication()
.AddJwtBearer(options =>
{
options.Authority = "http://*****:*****@"data source =.\sqlexpress; initial catalog = MyMicroservices4; integrated security = True; MultipleActiveResultSets = True", a => a.MigrationsAssembly("Persistence")));
services.AddScoped <IAttendanceService, AttendanceService>();
services.AddSwaggerGen(s =>
{
s.SwaggerDoc("v1", new Info
{
Title = "Attendance MicroAPI",
Version = "v1"
});
var security = new Dictionary <string, IEnumerable <string> >
{
{ "Bearer", Array.Empty <string>() },
};
s.AddSecurityDefinition("Bearer", new ApiKeyScheme
{
Description = "JWT Authorization header using the Bearer scheme. Example: \"Authorization: Bearer {token}\"",
Name = "Authorization",
In = "header",
Type = "apiKey"
});
s.AddSecurityRequirement(security);
s.CustomSchemaIds(x => x.FullName);
});
using (var context = new AttendanceContext())
{
context.Database.Migrate();
}
//services.AddDbContext<AttendanceContext>(builder =>
// builder.UseSqlServer(@"data source =.\sqlexpress; initial catalog = MyMicroservices; integrated security = True; MultipleActiveResultSets = True"));
}
public List <totalattendacelistcount> gettotalstd()
{
var advisor = new List <totalattendacelistcount>();
string subjectname = Convert.ToString(Session["subname2"]);
string modifiedon1 = Convert.ToString(Session["demo2"]);
string modifiedon2 = Convert.ToString(Session["secondmoddate"]);
using (var adv = new AttendanceContext())
{
advisor = adv.Database.SqlQuery <totalattendacelistcount>("exec gettotaltheoryattendance @subjectname , @modifiedon1, @modifiedon2", new SqlParameter("@subjectname", subjectname), new SqlParameter("@modifiedon1", modifiedon1), new SqlParameter("@modifiedon2", modifiedon2)).ToList();
}
return(advisor);
}
public ActionResult gettotal(stdlisttheory aa, FormCollection form)
{
using (var reg = new AttendanceContext())
{
var modifiedon2 = new SqlParameter("@modifiedon2", SqlDbType.VarChar, 50)
{
Direction = System.Data.ParameterDirection.Input,
Value = aa.modifiedon2
};
}
Session["secondmoddate"] = aa.modifiedon2;
return(RedirectToAction("total", "attendancelist"));
}