public bool TryGetValue(int key, out CacheObstacle value)
{
bool found = obstacles.TryGetValue(key, out value);
if (found && value.RefreshRemovalCounter < 0)
{
RemovalList.Remove(key); //we exclude this from being removed..
}
return(found);
}
public ActionResult RemoveStudent()
{
String selectedclass = TempData["Class"].ToString();
string connectionString = @"Data Source=msi;Initial Catalog=SEFASSIGNMENT;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(connectionString);
sqlConnection.Open();
System.Data.SqlClient.SqlCommand sqlCommand = new System.Data.SqlClient.SqlCommand("SELECT Stu_ID FROM [SEFASSIGNMENT].[dbo].[Student] WHERE CLASS_ID='" + selectedclass + "'");
sqlCommand.Connection = sqlConnection;
SqlDataReader myreader = sqlCommand.ExecuteReader();
List <String> StudentIDList = new List <String>();
while (myreader.Read())
{
StudentIDList.Add(myreader[0].ToString());
}
myreader.Close();
sqlCommand = new System.Data.SqlClient.SqlCommand("SELECT Stu_Name FROM [SEFASSIGNMENT].[dbo].[Student] WHERE CLASS_ID='" + selectedclass + "'");
sqlCommand.Connection = sqlConnection;
SqlDataReader newmyreader = sqlCommand.ExecuteReader();
List <String> StudentNameList = new List <String>();
while (newmyreader.Read())
{
StudentNameList.Add(newmyreader[0].ToString());
}
newmyreader.Close();
sqlConnection.Close();
List <RemoveStudent> Student = new List <RemoveStudent>();
for (int i = 0; i < StudentIDList.Count; i++)
{
Student.Add(new RemoveStudent()
{
StudentID = StudentIDList[i], StudentName = StudentNameList[i], IsCheck = false
});
}
RemovalList CL = new RemovalList();
CL.ViewRemoveList = Student;
return(View(CL));
}
public ActionResult RemoveStudent(RemovalList cl, string action)
{
if (action.Equals("home"))
{
return(RedirectToAction("HomeLec", "HomeLec"));
}
else if (action.Equals("back"))
{
return(RedirectToAction("ManageClass"));
}
else if (action.Equals("remove"))
{
int counter = 0;
List <String> removelistid = new List <String>();
List <String> removelistname = new List <String>();
foreach (var item in cl.ViewRemoveList)
{
if (item.IsCheck)
{
counter++;
removelistid.Add(item.StudentID);
removelistname.Add(item.StudentName);
}
}
if (counter == 0)
{
TempData["AlertMessage"] = "You selected none student to be removed!";
return(RedirectToAction("ManageClass"));
}
else
{
TempData["StudentRemovalID"] = removelistid;
TempData["StudentRemovalName"] = removelistname;
return(RedirectToAction("ConfirmRemoval"));
}
}
return(View());
}
