public void AddDocumentDetails(SubmittedDocuments submittedDocuments, Student student)
{
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
string query = "select id as StudentId from Student where FirstName='" + student.FirstName + "' and FatherName='" + student.FatherName + "' and Datepart(YEAR,DateOFBirth) ='" + student.DateOfBirth.Year + "' and Datepart(MONTH,DateOFBirth) ='" + student.DateOfBirth.Month + "' and Datepart(DAY,DateOFBirth) ='" + student.DateOfBirth.Day + "'";
var id = connection.Query <string>(query).SingleOrDefault();
submittedDocuments.StudentId = Convert.ToInt32(id);
string AddContactDetails = "Insert into SubmittedDocuments values(@TenthMarksheet,@TwelthMarksheet,@GraduationMarksheet,@SchoolLeavingCerti,@VoterId,@DrivingLicense,@Passport,@ElectricBill,@StudentId,@ProvisionalCerti,@TransferCerti,@CharacterCerti,@AadharCard,@Remark)";
connection.Execute(AddContactDetails, new
{
submittedDocuments.TenthMarksheet,
submittedDocuments.TwelthMarksheet,
submittedDocuments.GraduationMarksheet,
submittedDocuments.SchoolLeavingCerti,
submittedDocuments.VoterId,
submittedDocuments.DrivingLicense,
submittedDocuments.Passport,
submittedDocuments.ElectricBill,
submittedDocuments.StudentId,
submittedDocuments.ProvisionalCerti,
submittedDocuments.TransferCerti,
submittedDocuments.CharacterCerti,
submittedDocuments.AadharCard,
submittedDocuments.Remark
});
}
catch (Exception ex)
{
}
}
public void AddStudent(StudentDetailsViewModel studentviewmodel)
{
var student = new Student()
{
Surname = studentviewmodel.Surname,
FirstName = studentviewmodel.FirstName,
MiddleName = studentviewmodel.FatherName,
FatherName = studentviewmodel.FatherName,
Age = studentviewmodel.Age,
DateOfBirth = studentviewmodel.DateOfBirth,
DateOfRegistration = studentviewmodel.DateOfRegistration,
MaritialStatus = studentviewmodel.MaritialStatus,
Category = studentviewmodel.Category,
Gender = studentviewmodel.Gender,
Nationality = studentviewmodel.Nationality,
CourseApplied = studentviewmodel.CourseApplied,
PassportNo = studentviewmodel.PassportNo
};
var contactDetails = new StudentContactDetails()
{
CorrespondenceAddress = studentviewmodel.CorrespondenceAddress,
StateName = studentviewmodel.StateName,
City = studentviewmodel.City,
PinCode = studentviewmodel.PinCode,
PermanentAddress = studentviewmodel.PermenantAddress,
PermanentStateName = studentviewmodel.PermanentStateName,
PermanentCity = studentviewmodel.PermanentCity,
PermanentPinCode = studentviewmodel.PermanentPinCode,
Email = studentviewmodel.Email,
ParentMobileNo = studentviewmodel.ParentMobileNo,
MobileNo = studentviewmodel.MobileNo,
PhoneNo = studentviewmodel.PhoneNo
};
var documnet = new SubmittedDocuments()
{
TenthMarksheet = studentviewmodel.TenthMarksheet,
TwelthMarksheet = studentviewmodel.TwelthMarksheet,
GraduationMarksheet = studentviewmodel.GraduationMarksheet,
SchoolLeavingCerti = studentviewmodel.SchoolLeavingCerti,
VoterId = studentviewmodel.VoterId,
DrivingLicense = studentviewmodel.DrivingLicense,
Passport = studentviewmodel.Passport,
ElectricBill = studentviewmodel.ElectricBill,
ProvisionalCerti = studentviewmodel.ProvisionalCerti,
TransferCerti = studentviewmodel.TransferCerti,
CharacterCerti = studentviewmodel.CharacterCerti,
AadharCard = studentviewmodel.AadharCard,
Remark = studentviewmodel.Remark
};
//foreach (var item in studentviewmodel.AcademicDetailList)
//{
// var listOfAcademicDetails = new AcademicDetails()
// {
// LevelOfExamination = item.LevelOfExamination,
// BoardUniversity = item.BoardUniversity,
// YearOfPassing = item.YearOfPassing,
// MarksObtained = item.MarksObtained,
// Percentage = item.Percentage,
// Grade = item.Grade
// };
// studentDataAccess.AddAcadamicDetails(listOfAcademicDetails);
//}
studentDataAccess.AddStudent(student);
studentDataAccess.AddContactDetails(contactDetails, student);
studentDataAccess.AddDocumentDetails(documnet, student);
}
