public int CreateQualificationDetails(QualificationDetailsEntities QualificationDetailsEntities)
{
//DateTime? enroldate = null;
//DateTime? closeddate = null;
var enroldate = (DateTime?)null;
var closeddate = (DateTime?)null;
if (QualificationDetailsEntities.ENROLLEDDATE != null && QualificationDetailsEntities.ENROLLEDDATE != "")
{
enroldate = DateTime.ParseExact(QualificationDetailsEntities.ENROLLEDDATE, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
if (QualificationDetailsEntities.COMPLETEDDATE != null && QualificationDetailsEntities.COMPLETEDDATE != "")
{
closeddate = DateTime.ParseExact(QualificationDetailsEntities.COMPLETEDDATE, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
if (QualificationDetailsEntities != null)
{
//var QualificationDetails = _UOW.EMP_QUALIFICATION_DETAILSRepository.GetAll().Where(x => x.EMPLOYEE_ID == QualificationDetailsEntities.EMPLOYEE_ID && x.EXAM_DEGREE_TYPE == QualificationDetailsEntities.EXAM_DEGREE_TYPE).ToList().FirstOrDefault();
//if (QualificationDetails != null)
//{
// if (QualificationDetailsEntities.EMPLOYEE_ID != null)
// {
// QualificationDetails.EMPLOYEE_ID = QualificationDetailsEntities.EMPLOYEE_ID;
// }
// if (QualificationDetailsEntities.SCHOOL_COLLEGE_NAME != "" && QualificationDetailsEntities.SCHOOL_COLLEGE_NAME != null)
// {
// QualificationDetails.SCHOOL_COLLEGE_NAME = QualificationDetailsEntities.SCHOOL_COLLEGE_NAME;
// }
// if (QualificationDetailsEntities.BOARD_UNIVERSITY_NAME != null)
// {
// QualificationDetails.BOARD_UNIVERSITY_NAME = QualificationDetailsEntities.BOARD_UNIVERSITY_NAME;
// }
// if (QualificationDetailsEntities.TYPE != null && QualificationDetailsEntities.TYPE != "")
// {
// QualificationDetails.TYPE = QualificationDetailsEntities.TYPE;
// }
// if (QualificationDetailsEntities.ENROLLEDDATE != null && QualificationDetailsEntities.ENROLLEDDATE != "")
// {
// QualificationDetails.START_DATE = enroldate;
// }
// if (QualificationDetailsEntities.COMPLETEDDATE != null && QualificationDetailsEntities.COMPLETEDDATE != "")
// {
// QualificationDetails.END_DATE = closeddate;
// }
// if (QualificationDetailsEntities.EXAM_DEGREE_TYPE != null)
// {
// QualificationDetails.EXAM_DEGREE_TYPE = QualificationDetailsEntities.EXAM_DEGREE_TYPE;
// }
// if (QualificationDetailsEntities.SUBJECT != "" && QualificationDetailsEntities.SUBJECT != null)
// {
// QualificationDetails.SUBJECT = QualificationDetailsEntities.SUBJECT;
// }
// if (QualificationDetailsEntities.TOTAL_MARKS != null)
// {
// QualificationDetails.TOTAL_MARKS = QualificationDetailsEntities.TOTAL_MARKS;
// }
// if (QualificationDetailsEntities.MARKS_SECURED != null)
// {
// QualificationDetails.MARKS_SECURED = QualificationDetailsEntities.MARKS_SECURED;
// }
// if (QualificationDetailsEntities.PERCENTAGE_OF_MARK_DIVISION != null)
// {
// QualificationDetails.PERCENTAGE_OF_MARK_DIVISION = QualificationDetailsEntities.PERCENTAGE_OF_MARK_DIVISION;
// }
// _UOW.EMP_QUALIFICATION_DETAILSRepository.Update(QualificationDetails);
// _UOW.Save();
//}
//else
//{
var QualificationDetail = new TBL_EMP_QUALIFICATION_DETAILS
{
EMPLOYEE_ID = QualificationDetailsEntities.EMPLOYEE_ID,
SCHOOL_COLLEGE_NAME = QualificationDetailsEntities.SCHOOL_COLLEGE_NAME,
BOARD_UNIVERSITY_NAME = QualificationDetailsEntities.BOARD_UNIVERSITY_NAME,
TYPE = QualificationDetailsEntities.TYPE,
START_DATE = enroldate,
END_DATE = closeddate,
EXAM_DEGREE_TYPE = QualificationDetailsEntities.EXAM_DEGREE_TYPE,
SUBJECT = QualificationDetailsEntities.SUBJECT,
TOTAL_MARKS = QualificationDetailsEntities.TOTAL_MARKS,
MARKS_SECURED = QualificationDetailsEntities.MARKS_SECURED,
PERCENTAGE_OF_MARK_DIVISION = QualificationDetailsEntities.PERCENTAGE_OF_MARK_DIVISION
};
_UOW.EMP_QUALIFICATION_DETAILSRepository.Insert(QualificationDetail);
_UOW.Save();
//}
}
return(Convert.ToInt32(QualificationDetailsEntities.ID));
}
public int CreateExcelupload(ExcelUploadEntities ExcelUploadEntity)
{
//if (ExcelUploadEntity.SUBDIVISION!=null)
//{
// ExcelUploadEntity.SUBDIVISION = Getsubdivisionid(ExcelUploadEntity.SUB_DIVISIONNAME);
//}
//if (ExcelUploadEntity.SECTION != null)
//{
// ExcelUploadEntity.SECTION = Getsectionid(ExcelUploadEntity.SECTIONNAME);
//}
if (ExcelUploadEntity.gradename != null)
{
ExcelUploadEntity.GRADE = Getdgradeid(ExcelUploadEntity.gradename);
}
if (ExcelUploadEntity.departmentname != null)
{
ExcelUploadEntity.DEPARTMENT = Getdepartmentid(ExcelUploadEntity.departmentname);
}
if (ExcelUploadEntity.designationname != null)
{
ExcelUploadEntity.DESIGNATION = Getdesigid(ExcelUploadEntity.designationname);
}
//if (ExcelUploadEntity.bloodgroup != null)
//{
// ExcelUploadEntity.BLOOD_GROUP = Getbloodgid(ExcelUploadEntity.bloodgroup);
//}
var bsicinfo = new TBL_EMP_BASICINFO
{
DESIGNATION = ExcelUploadEntity.DESIGNATION,
JOINING_DATE = ExcelUploadEntity.JOINING_DATE,
EMPLOYEE_CODE = ExcelUploadEntity.EMPLOYEE_CODE,
EMPLOYEE_FIRSTNAME = ExcelUploadEntity.EMPLOYEE_FIRSTNAME,
EMPLOYEE_MIDDLENAME = ExcelUploadEntity.EMPLOYEE_MIDDLENAME,
EMPLOYEE_LASTNAME = ExcelUploadEntity.EMPLOYEE_LASTNAME,
DATE_OF_BIRTH = ExcelUploadEntity.DATE_OF_BIRTH,
AGE = ExcelUploadEntity.AGE,
SEX = ExcelUploadEntity.SEX,
MATERIAL_STATUS = ExcelUploadEntity.MATERIAL_STATUS,
WEDDING_ANNIVERSARY = ExcelUploadEntity.WEDDING_ANNIVERSARY,
REPORTING_TO = ExcelUploadEntity.REPORTING_TO,
GRADE = ExcelUploadEntity.GRADE,
DIVISION = ExcelUploadEntity.DIVISION,
SUBDIVISION = ExcelUploadEntity.SUBDIVISION,
SECTION = ExcelUploadEntity.SECTION,
BLOOD_GROUP = ExcelUploadEntity.BLOOD_GROUP,
HEIGHT = ExcelUploadEntity.HEIGHT,
WEIGHT = ExcelUploadEntity.WEIGHT,
MEDICLAIM_NUMBER = ExcelUploadEntity.MEDICLAIM_NUMBER,
ESIC_NO = ExcelUploadEntity.ESIC_NO,
PF_UNID_NUMBER = ExcelUploadEntity.PF_UNID_NUMBER,
INDUCTION = ExcelUploadEntity.INDUCTION,
IDENTIFICATION_MARK = ExcelUploadEntity.IDENTIFICATION_MARK,
LAST_MAJOR_ILLNESS_SURGERY = ExcelUploadEntity.LAST_MAJOR_ILLNESS_SURGERY,
ALLERGY_HISTORY = ExcelUploadEntity.ALLERGY_HISTORY,
PHYSICAL_DISABILITY = ExcelUploadEntity.PHYSICAL_DISABILITY,
HIRING_TYPE = ExcelUploadEntity.HIRING_TYPE,
CV_TYPE = ExcelUploadEntity.CV_TYPE,
YEAR_OF_EXPERIENCE = ExcelUploadEntity.YEAR_OF_EXPERIENCE,
EXIT_DATE = ExcelUploadEntity.EXIT_DATE,
EXIT_TYPE = ExcelUploadEntity.EXIT_TYPE,
REFERENCE = ExcelUploadEntity.REFERENCE,
DEPARTMENT = ExcelUploadEntity.DEPARTMENT,
FULL_N_FINAL_STATUS = ExcelUploadEntity.FULL_N_FINAL_STATUS,
MOTHERTOUNGE = ExcelUploadEntity.MOTHERTOUNGE,
WORKLOCATION = ExcelUploadEntity.WORKLOCATION,
RELIGION = ExcelUploadEntity.RELIGION,
STATUS = ExcelUploadEntity.STATUS,
EMPIMG = ExcelUploadEntity.EMPIMG
};
_UOW.EMP_BASICINFORepository.Insert(bsicinfo);
_UOW.Save();
TBL_EMP_TRANSFER_DETAILS tr = new TBL_EMP_TRANSFER_DETAILS();
tr.EMPLOYEE_ID = Convert.ToDecimal(bsicinfo.ID);
tr.DESIGNATION_ID = ExcelUploadEntity.DESIGNATION;
tr.WORK_LOCATION = ExcelUploadEntity.WORKLOCATION;
tr.DIVISION = ExcelUploadEntity.DIVISION;
tr.SUB_DIVISION = ExcelUploadEntity.SUBDIVISION;
tr.SECTION = ExcelUploadEntity.SECTION;
tr.DEPARTMENT = ExcelUploadEntity.DEPARTMENT;
tr.REPORTINGPERNAME = ExcelUploadEntity.REPORTING_TO;
//tr.REPORTING_PERSON = Convert.ToDecimal(ExcelUploadEntity.REPORTING_TO);
tr.FROM_DATE = ExcelUploadEntity.JOINING_DATE;
tr.TO_DATE = ExcelUploadEntity.EXIT_DATE;
tr.STATUS = ExcelUploadEntity.STATUS;
_UOW.TRANSFER_DETAILSMASTERRepository.Insert(tr);
_UOW.Save();
if (ExcelUploadEntity.Account != null)
{
foreach (var item in ExcelUploadEntity.Account)
{
TBL_EMP_SALARYACCOUNTDETAILS sal = new TBL_EMP_SALARYACCOUNTDETAILS();
sal.EMPLOYEE_ID = Convert.ToDecimal(bsicinfo.ID);
sal.ACCOUNTNO = item.ACCOUNTNO;
sal.IFSCCODE = item.IFSCCODE;
sal.BRANCH = item.BRANCH;
sal.BANKNAME = item.BANKNAME;
sal.CTC = item.CTC;
_UOW.SALARYACCOUNTDETAILSRepository.Insert(sal);
_UOW.Save();
}
}
if (ExcelUploadEntity.Relationship != null)
{
foreach (var item in ExcelUploadEntity.Relationship)
{
TBL_EMP_RELATIONSHIP_DETAILS rel = new TBL_EMP_RELATIONSHIP_DETAILS();
rel.EMPLOYEE_ID = Convert.ToDecimal(bsicinfo.ID);
rel.RELATIVE_NAME = item.RELATIVE_NAME;
rel.RELATIONSHIP = item.RELATIONSHIP;
rel.DATE_OF_BIRTH = item.DATE_OF_BIRTH;
_UOW.RELATIONSHIP_DETAILSRepository.Insert(rel);
_UOW.Save();
}
}
if (ExcelUploadEntity.Communication != null)
{
foreach (var item in ExcelUploadEntity.Communication)
{
TBL_EMP_COMMUNICATION_DETAILS rel = new TBL_EMP_COMMUNICATION_DETAILS();
rel.EMPLOYEE_ID = Convert.ToDecimal(bsicinfo.ID);
rel.PERMANENT_ADDRESS = item.PERMANENT_ADDRESS;
rel.MOBILE_NUMBER = item.MOBILE_NUMBER;
rel.PANCARD_NUMBER = item.PANCARD_NUMBER;
rel.EMERGENCY_CONTACT_NUMBER = item.EMERGENCY_CONTACT_NUMBER;
rel.OFFICIAL_MOBILE_NUMBER = item.OFFICIAL_MOBILE_NUMBER;
rel.OFFICIAL_EMAIL = item.OFFICIAL_EMAIL;
rel.PERSONAL_EMAIL = item.PERSONAL_EMAIL;
rel.AADHAR_NUMBER = item.AADHAR_NUMBER;
//rel.DATE_OF_BIRTH = item.DATE_OF_BIRTH;
_UOW.EMP_COMMUNICATION_DETAILSRepository.Insert(rel);
_UOW.Save();
}
}
if (ExcelUploadEntity.qualification != null)
{
foreach (var item in ExcelUploadEntity.qualification)
{
TBL_EMP_QUALIFICATION_DETAILS qual = new TBL_EMP_QUALIFICATION_DETAILS();
qual.EMPLOYEE_ID = Convert.ToDecimal(bsicinfo.ID);
qual.EXAM_DEGREE_TYPE = item.EXAM_DEGREE_TYPE;
qual.END_DATE = item.END_DATE;
_UOW.EMP_QUALIFICATION_DETAILSRepository.Insert(qual);
_UOW.Save();
}
}
if (ExcelUploadEntity.Employment != null)
{
foreach (var item in ExcelUploadEntity.Employment)
{
TBL_EMP_EMPLOYMENT_RECORD qual = new TBL_EMP_EMPLOYMENT_RECORD();
qual.EMPLOYEE_ID = Convert.ToDecimal(bsicinfo.ID);
qual.ORGANISATION_NAME = item.ORGANISATION_NAME;
_UOW.EMPLOYMENT_RECORDRepository.Insert(qual);
_UOW.Save();
}
}
return(Convert.ToInt32(bsicinfo.ID));
}