public static bool AddStudent(XmlSponosorUpload xmlSponosor, XmlStudentUpload model)
{
try
{
var student = new Student()
{
FirstName = model.FirstName,
LastName = model.LastName,
MiddleName = model.OtherName,
FullName = model.FullName,
DateOfBirth = model.DateofBirth,
Sex = model.Gender,
PassportUrl = model.Base64Picture,
Address = model.Address,
LocalGovernmentID = SessionUser.LgaId,
RegNumber = model.RegNum,
ExamYear = model.ExamYear,
SchoolId = SessionUser.SchoolId,
DateCreated = DateTime.Now.ToShortDateString(),
CreatedBy = SessionUser.UserId
};
unitofwork.studentData.Insert(student);
unitofwork.Save();
SaveSponosorDetail(xmlSponosor, student.StudentId);
// InsertAudit("StudentBioData StudentPicture", student.Id, "Insert");
return(true);
}
catch (Exception ex)
{
return(false);
}
}
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");
}
}
