public void AddContactDetails(StudentContactDetails studentContactDetails, 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();
studentContactDetails.StudentId = Convert.ToInt32(id);
string AddContactDetails = "Insert into StudentContactDetails values(@CorrespondenceAddress,@StateName,@City,@PinCode,@PermanentAddress,@PermanentStateName,@PermanentCity,@PermanentPinCode,@Email,@MobileNo,@PhoneNo,@ParentMobileNo,@StudentId)";
connection.Execute(AddContactDetails, new
{
studentContactDetails.CorrespondenceAddress,
studentContactDetails.StateName,
studentContactDetails.City,
studentContactDetails.PinCode,
studentContactDetails.PermanentAddress,
studentContactDetails.PermanentStateName,
studentContactDetails.PermanentCity,
studentContactDetails.PermanentPinCode,
studentContactDetails.Email,
studentContactDetails.MobileNo,
studentContactDetails.PhoneNo,
studentContactDetails.ParentMobileNo,
studentContactDetails.StudentId
});
}
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);
}
