// Translation Method public void Translation(EmployeeDataContext instanceDataModel) { if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_AR) == true) { instanceDataModel.employNameEN = TranslatorGoogleClass.Translate(instanceDataModel.employeeName, Constants.LAN_AR, Constants.LAN_EN); instanceDataModel.employeeNameAR = instanceDataModel.employeeName; instanceDataModel.employeePhoneCC = MethodesClass.ConcatonatePhoneWithCc(instanceDataModel.employeePhone, instanceDataModel.employeeCCName); if (instanceDataModel.employeeAddress != null) { instanceDataModel.employeeAddressEN = TranslatorGoogleClass.Translate(instanceDataModel.employeeAddress, Constants.LAN_AR, Constants.LAN_EN); instanceDataModel.employeeAddressAR = instanceDataModel.employeeAddress; instanceDataModel.employeePhoneCC = MethodesClass.ConcatonatePhoneWithCc(instanceDataModel.employeePhone, instanceDataModel.employeeCCName); } } else { instanceDataModel.employeeNameAR = TranslatorGoogleClass.Translate(instanceDataModel.employeeName, Constants.LAN_EN, Constants.LAN_AR); instanceDataModel.employNameEN = instanceDataModel.employeeName; instanceDataModel.employeePhoneCC = MethodesClass.ConcatonatePhoneWithCc(instanceDataModel.employeePhone, instanceDataModel.employeeCCName); if (instanceDataModel.employeeAddress != null) { instanceDataModel.employeeAddressAR = TranslatorGoogleClass.Translate(instanceDataModel.employeeAddress, Constants.LAN_EN, Constants.LAN_AR); instanceDataModel.employeeAddressEN = instanceDataModel.employeeAddress; instanceDataModel.employeePhoneCC = MethodesClass.ConcatonatePhoneWithCc(instanceDataModel.employeePhone, instanceDataModel.employeeCCName); } } }
public EmployeeData SearchByPhoneEmployee(EmployeeDataContext instanceDataModel) { EmployeeData employeeData; string queryUpdate = Constants.SelectQuery + " WHERE [employeePhoneCC] = N'" + MethodesClass.ConcatonatePhoneWithCc(instanceDataModel.employeePhone, instanceDataModel.employeeCCName) + "' and [employeeId] != N'" + instanceDataModel.employeeId + "'"; DataTable dtEmployee = GetanythingThroughQuery(queryUpdate); employeeData = CustOneEmployee(dtEmployee, 0); return(employeeData); }
public void Translation(EmployeeDataContext instanceDataModel) { if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_AR) == true) { instanceDataModel.employeeNameEN = TranslatorGoogleClass.Translate(instanceDataModel.employeeName, Constants.LAN_AR, Constants.LAN_EN); instanceDataModel.employeeNameAR = instanceDataModel.employeeName; if (instanceDataModel.employeeNationality != null) { instanceDataModel.employeeNationalityEN = TranslatorGoogleClass.Translate(instanceDataModel.employeeNationality, Constants.LAN_AR, Constants.LAN_EN); instanceDataModel.employeeNationalityAR = instanceDataModel.employeeNationality; } else { instanceDataModel.employeeNationalityEN = " "; instanceDataModel.employeeNationalityAR = " "; } if (instanceDataModel.employeeMaritalStatus != null) { instanceDataModel.employeeMaritalStatusEN = TranslatorGoogleClass.Translate(instanceDataModel.employeeMaritalStatus, Constants.LAN_AR, Constants.LAN_EN); instanceDataModel.employeeMaritalStatusAR = instanceDataModel.employeeMaritalStatus; } else { instanceDataModel.employeeMaritalStatusEN = " "; instanceDataModel.employeeMaritalStatusAR = " "; } if (instanceDataModel.employeeMilitaryStatus != null) { instanceDataModel.employeeMilitaryStatusEN = TranslatorGoogleClass.Translate(instanceDataModel.employeeMilitaryStatus, Constants.LAN_AR, Constants.LAN_EN); instanceDataModel.employeeMilitaryStatusAR = instanceDataModel.employeeMilitaryStatus; } else { instanceDataModel.employeeMilitaryStatusEN = " "; instanceDataModel.employeeMilitaryStatusAR = " "; } instanceDataModel.employeeFirstPhoneWithCC = MethodesClass.ConcatonatePhoneWithCc(instanceDataModel.employeeFirstPhone, instanceDataModel.employeeFirstCountryCodeName); if (instanceDataModel.employeeSecondPhone != null) { instanceDataModel.employeeSecondPhoneWithCC = MethodesClass.ConcatonatePhoneWithCc(instanceDataModel.employeeSecondPhone, instanceDataModel.employeeSecondCountryCodeName); } else { instanceDataModel.employeeSecondPhoneWithCC = " "; instanceDataModel.employeeSecondCountryCode = " "; instanceDataModel.employeeSecondCountryCodeName = " "; instanceDataModel.employeeSecondPhone = " "; } if (instanceDataModel.employeeAdressDetails != null) { instanceDataModel.employeeAdressDetailsEN = TranslatorGoogleClass.Translate(instanceDataModel.employeeAdressDetails, Constants.LAN_AR, Constants.LAN_EN); instanceDataModel.employeeAdressDetailsAR = instanceDataModel.employeeAdressDetails; } else { instanceDataModel.employeeAdressDetailsEN = " "; instanceDataModel.employeeAdressDetailsAR = " "; } } else { instanceDataModel.employeeNameAR = TranslatorGoogleClass.Translate(instanceDataModel.employeeName, Constants.LAN_EN, Constants.LAN_AR); instanceDataModel.employeeNameEN = instanceDataModel.employeeName; if (instanceDataModel.employeeNationality != null) { instanceDataModel.employeeNationalityAR = TranslatorGoogleClass.Translate(instanceDataModel.employeeNationality, Constants.LAN_EN, Constants.LAN_AR); instanceDataModel.employeeNationalityEN = instanceDataModel.employeeNationality; } else { instanceDataModel.employeeNationalityEN = " "; instanceDataModel.employeeNationalityAR = " "; } if (instanceDataModel.employeeMaritalStatus != null) { instanceDataModel.employeeMaritalStatusAR = TranslatorGoogleClass.Translate(instanceDataModel.employeeMaritalStatus, Constants.LAN_EN, Constants.LAN_AR); instanceDataModel.employeeMaritalStatusEN = instanceDataModel.employeeMaritalStatus; } else { instanceDataModel.employeeMaritalStatusEN = " "; instanceDataModel.employeeMaritalStatusAR = " "; } if (instanceDataModel.employeeMilitaryStatus != null) { instanceDataModel.employeeMilitaryStatusAR = TranslatorGoogleClass.Translate(instanceDataModel.employeeMilitaryStatus, Constants.LAN_EN, Constants.LAN_AR); instanceDataModel.employeeMilitaryStatusEN = instanceDataModel.employeeMilitaryStatus; } else { instanceDataModel.employeeMilitaryStatusEN = " "; instanceDataModel.employeeMilitaryStatusAR = " "; } instanceDataModel.employeeFirstPhoneWithCC = MethodesClass.ConcatonatePhoneWithCc(instanceDataModel.employeeFirstPhone, instanceDataModel.employeeFirstCountryCodeName); if (instanceDataModel.employeeSecondPhone != null) { instanceDataModel.employeeSecondPhoneWithCC = MethodesClass.ConcatonatePhoneWithCc(instanceDataModel.employeeSecondPhone, instanceDataModel.employeeSecondCountryCodeName); } else { instanceDataModel.employeeSecondPhoneWithCC = " "; instanceDataModel.employeeSecondCountryCode = " "; instanceDataModel.employeeSecondCountryCodeName = " "; instanceDataModel.employeeSecondPhone = " "; } if (instanceDataModel.employeeAdressDetails != null) { instanceDataModel.employeeAdressDetailsAR = TranslatorGoogleClass.Translate(instanceDataModel.employeeAdressDetails, Constants.LAN_EN, Constants.LAN_AR); instanceDataModel.employeeAdressDetailsEN = instanceDataModel.employeeAdressDetails; } else { instanceDataModel.employeeAdressDetailsEN = " "; instanceDataModel.employeeAdressDetailsAR = " "; } } }