protected void btnReUpdate_Click(object sender, EventArgs e)
{
ServiceReference1.WebService1SoapClient ws = new ServiceReference1.WebService1SoapClient();
Business.ScsBO sbo = new Business.ScsBO();
List <Student> stFAP = new List <Student>();
ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient();
string stf = fap.GetStudenK10JS();
stFAP = JsonConvert.DeserializeObject <List <Student> >(stf);
List <StaffTakeCare> listfromDB = sbo.showListTable();
List <String> listStudentIdDub = new List <String>();
Business.RankDAL rdal = new Business.RankDAL();
Business.StudentDAL stdl = new Business.StudentDAL();
//Entity.Rank r = null;
var tasks = new Task[stFAP.Count];
for (int i = 0; i < stFAP.Count; i++)
{
string rollNumber = stFAP[i].rollNumber;
tasks[i] = Task.Factory.StartNew(() =>
{
List <StudentProfile> stp = new List <StudentProfile>();
string inf = fap.GetStudentById(rollNumber);
stp = JsonConvert.DeserializeObject <List <StudentProfile> >(inf);
bool flag = false;
for (int j = 0; j < listfromDB.Count; j++)
{
if (rollNumber.ToString().Equals(listfromDB[j].studentID.ToString()))
{
flag = true;
break;
}
}
if (!flag)
{
stdl.insertStudentToTakeCare(rollNumber.ToString(), stp[0].fullName);
}
});
}
Task.WaitAll(tasks);
rdal.rankking();
stdl.filterStudent();
string check = "";
Response.Redirect("~/UI/distribution.aspx?check=" + check);
}
public List <OldListTakecare> getOldStudent()
{
List <Student> listStudentAPI = new List <Student>();
ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient();
string stf = fap.GetStudenK10JS();
listStudentAPI = JsonConvert.DeserializeObject <List <Student> >(stf);
List <OldListTakecare> list = new List <OldListTakecare>();
List <OldListTakecare> list2 = new List <OldListTakecare>();
SqlConnection con = DbConnect.GetConnection();
string sql = " SELECT Student.studentID,Account.staffName,Rank.rankName "
+ " FROM Student"
+ " LEFT JOIN Rank"
+ " ON Rank.studentID = Student.studentID LEFT JOIN Account"
+ " ON Account.accountID = Student.accountID"
+ " Where takecareStatus = 0 AND caution=0 ";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
OldListTakecare ol = new OldListTakecare();
ol.studentID = dr["studentID"].ToString();
ol.staffName = dr["staffName"].ToString();
list.Add(ol);
}
list2 = list;
for (int j = 0; j < listStudentAPI.Count; j++)
{
for (int i = 0; i < list2.Count; i++)
{
if (listStudentAPI[j].rollNumber.Equals(list[i].studentID))
{
list2.Remove(list[i]);
}
}
}
con.Close();
return(list2);
}