internal UserProfileModal GetProfileData(string uidNo, string rollNo)
{
UserProfileModal userProfileModal = new UserProfileModal();
var genInfo = _dbConnection.GetModelDetails(RawSQL.GetProfileData(uidNo, rollNo)).AsEnumerable().FirstOrDefault();
var branchInfo = _dbConnection.GetModelDetails(RawSQL.GetProfileBrInfo(Convert.ToDouble(rollNo))).AsEnumerable().FirstOrDefault();
var sdfsd = genInfo.Table;
var profileData = new ProfileInfo()
{
Title = genInfo?.Field <string>("Title"),
FullName = genInfo?.Field <string>("Name_Full"),
DateOfBirth = genInfo?.Field <DateTime?>("Date_Birth"),
Gender = genInfo?.Field <string>("Gender"),
Caste = genInfo?.Field <string>("Caste"),
MaritalStatus = Convert.ToString(genInfo?.Field <Double?>("Marital_Status")) == "0" ? "Married"
: Convert.ToString(genInfo?.Field <Double?>("Marital_Status")) == "1" ? "Single"
: Convert.ToString(genInfo?.Field <Double?>("Marital_Status")) == "3" ? "Widowed"
: Convert.ToString(genInfo?.Field <Double?>("Marital_Status")) == "4" ? "Divorced"
: Convert.ToString(genInfo?.Field <Double?>("Marital_Status")) == "5" ? "Other"
: "Other",
Nationality = genInfo?.Field <string>("Nationality") == "I" ? "Indian" : "Other",
AadharNo = genInfo.Field <string>("AadharNo"),
PanNo = genInfo.Field <string>("PanCardNo")
};
var contactData = new ContactInfo()
{
ResidenceAddr = genInfo?.Field <string>("Add1") +
genInfo?.Field <string>("Add2") +
genInfo?.Field <string>("Add3"),
City = genInfo?.Field <string>("City"),
Pincode = genInfo?.Field <string>("Pin_cd"),
MobileNo1 = genInfo?.Field <string>("Mobile"),
MobileNo2 = genInfo?.Field <string>("Mobile1"),
EmergencyContact = genInfo?.Field <string>("EmergencyContact"),
EmergencyContactNo = genInfo?.Field <string>("EmergencyContactNo"),
Email1 = genInfo?.Field <string>("Email1"),
Email2 = genInfo?.Field <string>("Email2")
};
var occupationData = new CompanyInfo
{
OrgName = genInfo?.Field <string>("Organization"),
OrgAddress = genInfo?.Field <string>("Place"),
Designation = genInfo?.Field <string>("Designation"),
Occupation = genInfo?.Field <string>("Occupation"),
OfficePh1 = genInfo?.Field <string>("Off_ph1"),
OfficePh2 = genInfo?.Field <string>("Off_ph2")
};
var qualificationData = new QualificationInfo
{
Qualification = genInfo?.Field <string>("Qualification")
};
var personBrInfo = new PersonBrInfo
{
RollNo = Convert.ToInt32(genInfo?.Field <Double?>("Roll_NO")),
UidNo = genInfo?.Field <string>("UID_No"),
BrTitle = genInfo?.Field <string>("Title_1"),
GridCoord = genInfo?.Field <string>("Grid_Coord"),
DateOfIni1 = branchInfo?.Field <DateTime?>("DOI_1"),
DateOfIni2 = branchInfo?.Field <DateTime?>("DOI_2")
};
userProfileModal.ProfileList = profileData;
userProfileModal.ContactInfo = contactData;
userProfileModal.CompanyInfo = occupationData;
userProfileModal.QualificationInfo = qualificationData;
userProfileModal.PersonBrInfo = personBrInfo;
return(userProfileModal);
}
public static void insertQualification(QualificationInfo info)
{
string sql = "insert into cvformat_qualification(cvformatid,qualification) values (?cvformatid,?qualification)";
DAO.ExecuteNonQuery(sql, new MySqlParameter("cvformatid", info.CVFormatId), new MySqlParameter("qualification", info.Qualification));
}
