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));
}
public int CreateCommunicationDetails(CommunicationDetailsEntities CommunicationDetailsEntities)
{
if (CommunicationDetailsEntities != null)
{
var CommunicationDetails = _UOW.EMP_COMMUNICATION_DETAILSRepository.GetAll().ToList().Where(x => x.EMPLOYEE_ID == CommunicationDetailsEntities.EMPLOYEE_ID).FirstOrDefault();
if (CommunicationDetails != null)
{
if (CommunicationDetailsEntities.PERMANENT_ADDRESS != "" && CommunicationDetailsEntities.PERMANENT_ADDRESS != null)
{
CommunicationDetails.PERMANENT_ADDRESS = CommunicationDetailsEntities.PERMANENT_ADDRESS;
}
if (CommunicationDetailsEntities.PERMANENT_ADDRESS_CITY != "" && CommunicationDetailsEntities.PERMANENT_ADDRESS_CITY != null)
{
CommunicationDetails.PERMANENT_ADDRESS_CITY = CommunicationDetails.PERMANENT_ADDRESS_CITY;
}
if (CommunicationDetailsEntities.PERMANENT_ADDRESS_STATE != null)
{
CommunicationDetails.PERMANENT_ADDRESS_STATE = CommunicationDetailsEntities.PERMANENT_ADDRESS_STATE;
}
if (CommunicationDetailsEntities.PERMANENT_ADDRESS_PIN != null)
{
CommunicationDetails.PERMANENT_ADDRESS_PIN = CommunicationDetailsEntities.PERMANENT_ADDRESS_PIN;
}
if (CommunicationDetailsEntities.MAILING_ADDRESS != null && CommunicationDetailsEntities.MAILING_ADDRESS != "")
{
CommunicationDetails.MAILING_ADDRESS = CommunicationDetailsEntities.MAILING_ADDRESS;
}
if (CommunicationDetailsEntities.MAILING_ADDRESS_CITY != null && CommunicationDetailsEntities.MAILING_ADDRESS_CITY != "")
{
CommunicationDetails.MAILING_ADDRESS_CITY = CommunicationDetailsEntities.MAILING_ADDRESS_CITY;
}
if (CommunicationDetailsEntities.MAILING_ADDRESS_STATE != null)
{
CommunicationDetails.MAILING_ADDRESS_STATE = CommunicationDetailsEntities.MAILING_ADDRESS_STATE;
}
if (CommunicationDetailsEntities.MAILING_ADDRESS_PIN != null)
{
CommunicationDetails.MAILING_ADDRESS_PIN = CommunicationDetailsEntities.MAILING_ADDRESS_PIN;
}
if (CommunicationDetailsEntities.PHONE_NUMBER != "" && CommunicationDetailsEntities.PHONE_NUMBER != null)
{
CommunicationDetails.PHONE_NUMBER = CommunicationDetailsEntities.PHONE_NUMBER;
}
if (CommunicationDetailsEntities.MOBILE_NUMBER != "" && CommunicationDetailsEntities.MOBILE_NUMBER != null)
{
CommunicationDetails.MOBILE_NUMBER = CommunicationDetailsEntities.MOBILE_NUMBER;
}
if (CommunicationDetailsEntities.PASSPORT_NUMBER != null && CommunicationDetailsEntities.PASSPORT_NUMBER != "")
{
CommunicationDetails.PASSPORT_NUMBER = CommunicationDetailsEntities.PASSPORT_NUMBER;
}
if (CommunicationDetailsEntities.EMERGENCY_CONTACT_NUMBER != "" && CommunicationDetailsEntities.EMERGENCY_CONTACT_NUMBER != null)
{
CommunicationDetails.EMERGENCY_CONTACT_NUMBER = CommunicationDetailsEntities.EMERGENCY_CONTACT_NUMBER;
}
if (CommunicationDetailsEntities.RELATIONSHIP != "" && CommunicationDetailsEntities.RELATIONSHIP != null)
{
CommunicationDetails.RELATIONSHIP = CommunicationDetailsEntities.RELATIONSHIP;
}
if (CommunicationDetailsEntities.VALIDITY != null)
{
var VALdate = DateTime.ParseExact(CommunicationDetailsEntities.VALIDITY, "dd/MM/yyyy", CultureInfo.InvariantCulture);
CommunicationDetails.PASSPORT_VALIDITY = VALdate;
}
if (CommunicationDetailsEntities.DRIVING_LICENCE_NUMBER != null && CommunicationDetailsEntities.DRIVING_LICENCE_NUMBER != "")
{
CommunicationDetails.DRIVING_LICENCE_NUMBER = CommunicationDetailsEntities.DRIVING_LICENCE_NUMBER;
}
if (CommunicationDetailsEntities.PANCARD_NUMBER != null && CommunicationDetailsEntities.PANCARD_NUMBER != "")
{
CommunicationDetails.PANCARD_NUMBER = CommunicationDetailsEntities.PANCARD_NUMBER;
}
if (CommunicationDetailsEntities.AADHAR_NUMBER != "" && CommunicationDetailsEntities.AADHAR_NUMBER != "")
{
CommunicationDetails.AADHAR_NUMBER = CommunicationDetailsEntities.AADHAR_NUMBER;
}
if (CommunicationDetailsEntities.PERSONAL_EMAIL != "" && CommunicationDetailsEntities.PERSONAL_EMAIL != "")
{
CommunicationDetails.PERSONAL_EMAIL = CommunicationDetailsEntities.PERSONAL_EMAIL;
}
if (CommunicationDetailsEntities.OFFICIAL_EMAIL != "" && CommunicationDetailsEntities.OFFICIAL_EMAIL != "")
{
CommunicationDetails.OFFICIAL_EMAIL = CommunicationDetailsEntities.OFFICIAL_EMAIL;
}
if (CommunicationDetailsEntities.OFFICIAL_MOBILE_NUMBER != null && CommunicationDetailsEntities.OFFICIAL_MOBILE_NUMBER != "")
{
CommunicationDetails.OFFICIAL_MOBILE_NUMBER = CommunicationDetailsEntities.OFFICIAL_MOBILE_NUMBER;
}
_UOW.EMP_COMMUNICATION_DETAILSRepository.Update(CommunicationDetails);
_UOW.Save();
}
else
{
var VALdate = (DateTime?)null;
//DateTime joiningdate = Convert.ToDateTime(BasicinfoEntities.JOININGDATE);
if (CommunicationDetailsEntities.VALIDITY != null)
{
VALdate = DateTime.ParseExact(CommunicationDetailsEntities.VALIDITY, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
var CommunicationDetail = new TBL_EMP_COMMUNICATION_DETAILS
{
EMPLOYEE_ID = CommunicationDetailsEntities.EMPLOYEE_ID,
PERMANENT_ADDRESS = CommunicationDetailsEntities.PERMANENT_ADDRESS,
PERMANENT_ADDRESS_CITY = CommunicationDetailsEntities.PERMANENT_ADDRESS_CITY,
PERMANENT_ADDRESS_STATE = CommunicationDetailsEntities.PERMANENT_ADDRESS_STATE,
PERMANENT_ADDRESS_PIN = CommunicationDetailsEntities.PERMANENT_ADDRESS_PIN,
MAILING_ADDRESS = CommunicationDetailsEntities.MAILING_ADDRESS,
MAILING_ADDRESS_CITY = CommunicationDetailsEntities.MAILING_ADDRESS_CITY,
MAILING_ADDRESS_PIN = CommunicationDetailsEntities.MAILING_ADDRESS_PIN,
MAILING_ADDRESS_STATE = CommunicationDetailsEntities.MAILING_ADDRESS_STATE,
MOBILE_NUMBER = CommunicationDetailsEntities.MOBILE_NUMBER,
PHONE_NUMBER = CommunicationDetailsEntities.PHONE_NUMBER,
EMERGENCY_CONTACT_NUMBER = CommunicationDetailsEntities.EMERGENCY_CONTACT_NUMBER,
RELATIONSHIP = CommunicationDetailsEntities.RELATIONSHIP,
PASSPORT_NUMBER = CommunicationDetailsEntities.PASSPORT_NUMBER,
PASSPORT_VALIDITY = VALdate,
DRIVING_LICENCE_NUMBER = CommunicationDetailsEntities.DRIVING_LICENCE_NUMBER,
PANCARD_NUMBER = CommunicationDetailsEntities.PANCARD_NUMBER,
AADHAR_NUMBER = CommunicationDetailsEntities.AADHAR_NUMBER,
PERSONAL_EMAIL = CommunicationDetailsEntities.PERSONAL_EMAIL,
OFFICIAL_EMAIL = CommunicationDetailsEntities.OFFICIAL_EMAIL,
OFFICIAL_MOBILE_NUMBER = CommunicationDetailsEntities.OFFICIAL_MOBILE_NUMBER
};
_UOW.EMP_COMMUNICATION_DETAILSRepository.Insert(CommunicationDetail);
_UOW.Save();
}
}
return(Convert.ToInt32(CommunicationDetailsEntities.ID));
}