protected void btnSave_Click(object sender, EventArgs e) { IList <XmlStudent> student = new List <XmlStudent>(); IList <XmlStudentUpload> uploads = new List <XmlStudentUpload>(); IList <XmlSponosorUpload> sponosorUploads = new List <XmlSponosorUpload>(); XmlStudentUpload newUploads; XmlSponosorUpload sponosorUpload; DataSet ds = new DataSet(); ds.ReadXml(lblFileName.Text); if (ds.Tables.Count > 0) { int counter = 0; for (int i = 0; i < ds.Tables["Student"].Rows.Count; i++) { newUploads = new XmlStudentUpload() { ID = int.Parse(ds.Tables[0].Rows[i]["ID"].ToString()), RegNum = ds.Tables[0].Rows[i]["REG_NUMBER"].ToString(), LastName = ds.Tables[0].Rows[i]["SURNAME"].ToString(), FirstName = ds.Tables[0].Rows[i]["LASTNAME"].ToString(), OtherName = ds.Tables[0].Rows[i]["OTHERNAME"].ToString(), FullName = ds.Tables[0].Rows[i]["FULLNAME"].ToString(), DateofBirth = ds.Tables[0].Rows[i]["DATE_OF_BIRTH"].ToString(), Gender = ds.Tables[0].Rows[i]["GENDER"].ToString(), ExamYear = ds.Tables[0].Rows[i]["EXAM_YEAR"].ToString(), Address = ds.Tables[0].Rows[i]["ADDRESS"].ToString(), Base64Picture = ds.Tables[0].Rows[i]["PICTURE"].ToString(), SponosorId = int.Parse(ds.Tables[0].Rows[i]["SPONOSORID"].ToString()) }; if (newUploads.Gender == "Male") { newUploads.Gender = "M"; } else { newUploads.Gender = "F"; } uploads.Add(newUploads); for (int j = 0; j < ds.Tables["SPONOSOR_DETAIL"].Rows.Count; j++) { sponosorUpload = new XmlSponosorUpload() { SponosorId = int.Parse(ds.Tables["SPONOSOR_DETAIL"].Rows[j]["ID"].ToString()), SponosorName = ds.Tables["SPONOSOR_DETAIL"].Rows[j]["FULLNAME"].ToString(), SponosorEmail = ds.Tables["SPONOSOR_DETAIL"].Rows[j]["EMAIL"].ToString(), SponosorPhone = ds.Tables["SPONOSOR_DETAIL"].Rows[j]["PHONE_NUMBER"].ToString(), SponosorAddress = ds.Tables["SPONOSOR_DETAIL"].Rows[j]["ADDRESS"].ToString(), SponosorRelationship = ds.Tables["SPONOSOR_DETAIL"].Rows[j]["RELATIONSHIP"].ToString(), }; sponosorUploads.Add(sponosorUpload); if (sponosorUpload.SponosorId == newUploads.SponosorId) { var result = GeneralUtility.HasQuotaFinished(SessionUser.SchoolId); if (result) { ++counter; GeneralUtility.AddStudent(sponosorUpload, newUploads); } } } } DropDownManager.ShowPopUp($"{counter} students upload successfully"); Response.Redirect("~/Modules/School/AllStudents"); } }