public static bool SaveSponosorDetail(XmlSponosorUpload model, int StudentId) { try { var relationship = DropDownManager.GetRelationShipByName(model.SponosorRelationship); var sponosor = new StudentGuardianDetial() { FullName = model.SponosorName, Email = model.SponosorEmail, MobileNo = model.SponosorPhone, Address = model.SponosorAddress, RelationShip = relationship, StudentId = StudentId }; unitofwork.GuardianDetails.Insert(sponosor); unitofwork.Save(); UpdateStudentData(sponosor.ID, StudentId); // InsertAudit("Student Sponosor Details", sponosor.Id, "Insert"); // AddStudent(xmlStudent, sponosor.ID); return(true); } catch (Exception ex) { return(false); } }
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"); } }