public EmployeeData SearchByNameEmployee(EmployeeDataContext instanceDataModel)
{
EmployeeData employeeData;
string queryUpdate;
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
queryUpdate = Constants.SelectQuery
+ " WHERE [employeeNameEN] = N'" + instanceDataModel.employeeName.Trim() + "'";
}
else
{
queryUpdate = Constants.SelectQuery
+ " WHERE [employeeNameAR] = N'" + instanceDataModel.employeeName.Trim() + "'";
}
DataTable dtEmployee = GetanythingThroughQuery(queryUpdate);
employeeData = EmployeeCasting.CustOneEmployee(dtEmployee, 0);
return(employeeData);
}
public HttpResponseMessage GetAllEmployee([FromUri] EmployeeDataContext instanceDataModel)
{
List <EmployeeData> dtEmployees;
try
{
if (instanceDataModel == null || instanceDataModel.language == null)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.EMPLOYEE_NULL_ERROR, data = Messages.EMPTY }));
}
dtEmployees = employeeDB.GetAllEmployee(instanceDataModel.language);
if (dtEmployees.Count > 0)
{
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.SUCCEDED_STATUS, msg = Messages.SUCCEDED_EN_MESSAGES, data = dtEmployees }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.SUCCEDED_STATUS, msg = Messages.SUCCEDED_MESSAGES, data = dtEmployees }));
}
}
else
{
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.GETALL_EMPLOYEE_EN_ERROR, data = Messages.EMPTY }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.GETALL_EMPLOYEE_ERROR, data = Messages.EMPTY }));
}
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.GETALL_EMPLOYEE_ERROR, data = Messages.EMPTY }));
}
}
public List <EmployeeData> GetAllEmployee(EmployeeDataContext paging)
{
List <EmployeeData> EmployeesData;
DataTable dtEmployees;
string queryString;
int PagNum = MethodesConvertalClass.ConvertToInt(paging.pageNumber);
int PagSize = MethodesConvertalClass.ConvertToInt(paging.pageSize);
if (ValedationClass.IsValidCompareToStrings(paging.language.ToString(), Constants.LAN_EN) == true)
{
queryString = Constants.SelectEnQuery + "ORDER BY [employeeId] OFFSET " + (PagNum - 1) * PagSize + " ROWS FETCH NEXT " + PagSize + " ROWS ONLY";
dtEmployees = GetanythingThroughQuery(queryString);
EmployeesData = EmployeeCasting.CustEnEmployeesData(dtEmployees);
return(EmployeesData);
}
queryString = Constants.SelectArQuery + "ORDER BY [employeeId] OFFSET " + (PagNum - 1) * PagSize + " ROWS FETCH NEXT " + PagSize + " ROWS ONLY";
dtEmployees = GetanythingThroughQuery(queryString);
EmployeesData = EmployeeCasting.CustArEmployeesData(dtEmployees);
return(EmployeesData);
}
public ActionResult Employee()
{
var connect = ConnectionMultiplexer.Connect(cacheConnectionString);
mydbcontext = new EmployeeDataContext();
IDatabase Rediscache = connect.GetDatabase();
if (string.IsNullOrEmpty(Rediscache.StringGet("EmployeeDetails")))
{
var liemp = mydbcontext.Employee.ToList();
var emplist = JsonConvert.SerializeObject(liemp);
Rediscache.StringSet("EmployeeDetails", emplist, TimeSpan.FromMinutes(2));
return(View(liemp));
}
else
{
var detail = JsonConvert.DeserializeObject <List <Employee> >(Rediscache.StringGet("EmployeeDetails"));
return(View(detail));
}
}
public ActionResult Validate()
{
String userName = Request["user_name"];
String password = Request["password"];
EmployeeDataContext loginObject = new EmployeeDataContext();
var login = (from logintable in loginObject.tblLogins
join employee in loginObject.tblEmployees
on logintable.employee_id equals employee.employee_id
where logintable.username == userName && logintable.user_password == password
select employee).FirstOrDefault();
if (login != null)
{
switch (login.employee_role)
{
case "cse":
Response.Redirect("/profile/Cse");
break;
case "branchmanager":
Response.Redirect("/profile/Branchmanager");
break;
case "admin":
Response.Redirect("/profile/Admin");
break;
}
}
else
{
Response.Redirect("/login");
}
return(Content("Exception Occues"));
}
public HomeController(EmployeeDataContext ctx)
{
context = ctx;
}
public AccountController(IAccount account, ILogger <AccountController> Logger, SignInManager <Account> signInManager, UserManager <Account> userManager, EmployeeDataContext context)
{
// _roleManager = roleManager;
_account = account;
_signInManager = signInManager;
_userManager = userManager;
logger = Logger;
_context = context;
}
public GradeService(EmployeeDataContext context)
{
_context = context;
}
public Repository(EmployeeDataContext context)
{
this.context = context;
}
public SkillRepository(EmployeeDataContext employeeDataContext) : base(employeeDataContext)
{
}
public AuthRepository(EmployeeDataContext context)
{
_context = context;
}
public HttpResponseMessage AddEmployee([FromBody] EmployeeDataContext instanceDataModel)
{
try
{
if (instanceDataModel == null || instanceDataModel.language == null)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.EMPLOYEE_NULL_ERROR, data = Messages.EMPTY }));
}
string isValid = employeeValid.IsValidEmployee(instanceDataModel);
if (ValedationClass.IsValidCompareToStrings(isValid, true.ToString()) == true)
{
EmployeeData isDubleName = employeeDB.SearchByNameEmployee(instanceDataModel);
if (isDubleName != null)
{
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.NAME_EN_IS_EXIST, data = Messages.EMPTY }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.NAME_IS_EXIST, data = Messages.EMPTY }));
}
}
else
{
EmployeeData isDublePhone = employeeDB.SearchByPhoneEmployee(instanceDataModel);
if (isDublePhone != null)
{
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.PHONE_EN_IS_EXIST, data = Messages.EMPTY }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.PHONE_IS_EXIST, data = Messages.EMPTY }));
}
}
else
{
//Translation
employeeValid.Translation(instanceDataModel);
int isAdd = employeeDB.AddEmployee(instanceDataModel);
if (isAdd > 0)
{
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.SUCCEDED_STATUS, msg = Messages.SUCCEDED_EN_MESSAGES, data = Messages.EMPTY }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.SUCCEDED_STATUS, msg = Messages.SUCCEDED_MESSAGES, data = Messages.EMPTY }));
}
}
else
{
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.ADD_EMPLOYEE_EN_ERROR, data = Messages.EMPTY }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.ADD_EMPLOYEE_ERROR, data = Messages.EMPTY }));
}
}
}
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = isValid, data = Messages.EMPTY }));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.ADD_EMPLOYEE_ERROR, data = Messages.EMPTY }));
}
}
public EmployeeSkillRepo(EmployeeDataContext employeeDataContext)
{
_employeeDataContext = employeeDataContext;
}
public DatasetsController(EmployeeDataContext context)
{
_context = context;
}
public EmployeeController(EmployeeDataContext employeeData, ILogger <EmployeeController> logger)
{
this.employeeData = employeeData;
this.logger = logger;
}
public UserService(EmployeeDataContext context)
{
_context = context;
}
public int AddEmployee(EmployeeDataContext instanceDataModel)
{
int isAdded;
string queryInsert;
string queryValues;
//if (instanceDataModel.employeeAdressDetails != null)
//{
queryInsert = "INSERT INTO [dbo].[Employees]"
+ "([employeeNameAR]"
+ ",[employeeNameEN]"
+ ",[employeeImagePath]"
+ ",[employeeBirthDate]"
+ ",[employeeEmail]"
+ ",[employeeNationalityAR]"
+ ",[employeeNationalityEN]"
+ ",[employeeCardBankNumber]"
+ ",[employeeGender]"
+ ",[employeeMaritalStatusAR]"
+ ",[employeeMaritalStatusEN]"
+ ",[employeeMilitaryStatusAR]"
+ ",[employeeMilitaryStatusEN]"
+ ",[employeeLicenseNumber]"
+ ",[employeeLicenseExpireDate]"
+ ",[employeeIdentityNumber]"
+ ",[employeeIdentityExpireDate]"
+ ",[employeePassportNumber]"
+ ",[employeePassportExpireDate]"
+ ",[employeeEducation]"
+ ",[employeeContractStartDate]"
+ ",[employeeContractEndDate]"
+ ",[employeeResidenceNumber]"
+ ",[employeeResidenceExpireDate]"
+ ",[employeeInsuranceNumber]"
+ ",[employeeJobDegree]"
+ ",[employeeJobStatus]"
+ ",[employeeJobId]"
+ ",[employeeSectorId]"
+ ",[employeeBranchId]"
+ ",[employeeCountry]"
+ ",[employeeCity]"
+ ",[employeeRegion]"
+ ",[employeeAdressDetailsAR]"
+ ",[employeeAdressDetailsEN]"
+ ",[employeeFirstCountryCode]"
+ ",[employeeFirstCountryCodeName]"
+ ",[employeeFirstPhone]"
+ ",[employeeFirstPhoneWithCC]"
+ ",[employeeSecondCountryCode]"
+ ",[employeeSecondCountryCodeName]"
+ ",[employeeSecondPhone]"
+ ",[employeeSecondPhoneWithCC]"
+ ",[employeeNotes])";
queryValues = " " + "VALUES(N'" + instanceDataModel.employeeNameAR.Trim()
+ "',N'" + instanceDataModel.employeeNameEN.Trim()
+ "',N'" + instanceDataModel.employeeImagePath.Trim()
+ "',N'" + instanceDataModel.employeeBirthDate.Trim()
+ "',N'" + instanceDataModel.employeeEmail.Trim()
+ "',N'" + instanceDataModel.employeeNationalityAR.Trim()
+ "',N'" + instanceDataModel.employeeNationalityEN.Trim()
+ "',N'" + instanceDataModel.employeeCardBankNumber
+ "',N'" + instanceDataModel.employeeGender.Trim()
+ "',N'" + instanceDataModel.employeeMaritalStatusAR.Trim()
+ "',N'" + instanceDataModel.employeeMaritalStatusEN.Trim()
+ "',N'" + instanceDataModel.employeeMilitaryStatusAR.Trim()
+ "',N'" + instanceDataModel.employeeMilitaryStatusEN.Trim()
+ "',N'" + instanceDataModel.employeeLicenseNumber
+ "',N'" + instanceDataModel.employeeLicenseExpireDate.Trim()
+ "',N'" + instanceDataModel.employeeIdentityNumber
+ "',N'" + instanceDataModel.employeeIdentityExpireDate.Trim()
+ "',N'" + instanceDataModel.employeePassportNumber
+ "',N'" + instanceDataModel.employeePassportExpireDate.Trim()
+ "',N'" + instanceDataModel.employeeEducation.Trim()
+ "',N'" + instanceDataModel.employeeContractStartDate.Trim()
+ "',N'" + instanceDataModel.employeeContractEndDate.Trim()
+ "',N'" + instanceDataModel.employeeResidenceNumber
+ "',N'" + instanceDataModel.employeeResidenceExpireDate.Trim()
+ "',N'" + instanceDataModel.employeeInsuranceNumber
+ "',N'" + instanceDataModel.employeeJobDegree.Trim()
+ "',N'" + instanceDataModel.employeeJobStatus.Trim()
+ "',N'" + instanceDataModel.employeeJobId
+ "',N'" + instanceDataModel.employeeSectorId
+ "',N'" + instanceDataModel.employeeBranchId
+ "',N'" + instanceDataModel.employeeCountry.Trim()
+ "',N'" + instanceDataModel.employeeCity.Trim()
+ "',N'" + instanceDataModel.employeeRegion.Trim()
+ "',N'" + instanceDataModel.employeeAdressDetailsAR.Trim()
+ "',N'" + instanceDataModel.employeeAdressDetailsEN.Trim()
+ "',N'" + instanceDataModel.employeeFirstCountryCode.Trim()
+ "',N'" + instanceDataModel.employeeFirstCountryCodeName.Trim()
+ "',N'" + instanceDataModel.employeeFirstPhone.Trim()
+ "',N'" + instanceDataModel.employeeFirstPhoneWithCC.Trim()
+ "',N'" + instanceDataModel.employeeSecondCountryCode.Trim()
+ "',N'" + instanceDataModel.employeeSecondCountryCodeName.Trim()
+ "',N'" + instanceDataModel.employeeSecondPhone.Trim()
+ "',N'" + instanceDataModel.employeeSecondPhoneWithCC.Trim()
+ "',N'" + instanceDataModel.employeeNotes.Trim()
+ "')";
isAdded = ExecuteNonQuery(queryInsert + queryValues);
return(isAdded);
//}
//queryInsert = "INSERT INTO [dbo].[tbEmployees]"
// + "([employeeNameAR]"
// + ",[employNameEN]"
// + ",[employeePhoneCC]"
// + ",[employeeCountryCode]"
// + ",[employeeCCName]"
// + ",[employeePhone]"
// + ",[employeePhoto]"
// + ",[emmployeeArchiveStatus])";
//queryValues = " " + "VALUES(N'" + instanceDataModel.employeeNameAR.Trim()
// + "',N'" + instanceDataModel.employNameEN.Trim()
// + "',N'" + instanceDataModel.employeePhoneCC.Trim()
// + "',N'" + instanceDataModel.employeeCountryCode.Trim()
// + "',N'" + instanceDataModel.employeeCCName.Trim()
// + "',N'" + instanceDataModel.employeePhone.Trim()
// + "',N'" + instanceDataModel.employeePhoto.Trim()
// + "',N'" + instanceDataModel.emmployeeArchiveStatus
// + "')";
//isAdded = ExecuteNonQuery(queryInsert + queryValues);
//return isAdded;
}
public int UpdateEmployee(EmployeeDataContext instanceDataModel)
{
int isUpdated;
String queryUpdate;
if (instanceDataModel.employeeImagePath != null)
{
queryUpdate = Constants.UpdateQuery
+ "SET [employeeNameAR] = N'" + instanceDataModel.employeeNameAR.Trim()
+ "',[employeeNameEN] = N'" + instanceDataModel.employeeNameEN.Trim()
+ "',[employeeImagePath] = N'" + instanceDataModel.employeeImagePath.Trim()
+ "',[employeeBirthDate] = N'" + instanceDataModel.employeeBirthDate.Trim()
+ "',[employeeEmail] = N'" + instanceDataModel.employeeEmail.Trim()
+ "',[employeeNationalityAR] = N'" + instanceDataModel.employeeNationalityAR.Trim()
+ "',[employeeNationalityEN] = N'" + instanceDataModel.employeeNationalityEN.Trim()
+ "',[employeeCardBankNumber] = N'" + instanceDataModel.employeeCardBankNumber.Trim()
+ "',[employeeGender] = N'" + instanceDataModel.employeeGender.Trim()
+ "',[employeeMaritalStatusAR] = N'" + instanceDataModel.employeeMaritalStatusAR.Trim()
+ "',[employeeMaritalStatusEN] = N'" + instanceDataModel.employeeMaritalStatusEN.Trim()
+ "',[employeeMilitaryStatusAR] = N'" + instanceDataModel.employeeMilitaryStatusAR.Trim()
+ "',[employeeMilitaryStatusEN] = N'" + instanceDataModel.employeeMilitaryStatusEN.Trim()
+ "',[employeeLicenseNumber] = N'" + instanceDataModel.employeeLicenseNumber.Trim()
+ "',[employeeLicenseExpireDate] = N'" + instanceDataModel.employeeLicenseExpireDate.Trim()
+ "',[employeeIdentityNumber] = N'" + instanceDataModel.employeeIdentityNumber.Trim()
+ "',[employeeIdentityExpireDate] = N'" + instanceDataModel.employeeIdentityExpireDate.Trim()
+ "',[employeePassportNumber] = N'" + instanceDataModel.employeePassportNumber.Trim()
+ "',[employeePassportExpireDate] = N'" + instanceDataModel.employeePassportExpireDate.Trim()
+ "',[employeeEducation] = N'" + instanceDataModel.employeeEducation.Trim()
+ "',[employeeContractStartDate] = N'" + instanceDataModel.employeeContractStartDate.Trim()
+ "',[employeeContractEndDate] = N'" + instanceDataModel.employeeContractEndDate.Trim()
+ "',[employeeResidenceNumber] = N'" + instanceDataModel.employeeResidenceNumber.Trim()
+ "',[employeeResidenceExpireDate] = N'" + instanceDataModel.employeeResidenceExpireDate.Trim()
+ "',[employeeInsuranceNumber] = N'" + instanceDataModel.employeeInsuranceNumber.Trim()
+ "',[employeeJobDegree] = N'" + instanceDataModel.employeeJobDegree.Trim()
+ "',[employeeJobStatus] = N'" + instanceDataModel.employeeJobStatus.Trim()
+ "',[employeeJobId] = N'" + instanceDataModel.employeeJobId
+ "',[employeeSectorId] = N'" + instanceDataModel.employeeSectorId
+ "',[employeeBranchId] = N'" + instanceDataModel.employeeBranchId
+ "',[employeeCountry] = N'" + instanceDataModel.employeeCountry.Trim()
+ "',[employeeCity] = N'" + instanceDataModel.employeeCity.Trim()
+ "',[employeeRegion] = N'" + instanceDataModel.employeeRegion.Trim()
+ "',[employeeAdressDetailsAR] = N'" + instanceDataModel.employeeAdressDetailsAR.Trim()
+ "',[employeeAdressDetailsEN] = N'" + instanceDataModel.employeeAdressDetailsEN.Trim()
+ "',[employeeFirstCountryCode] = N'" + instanceDataModel.employeeFirstCountryCode.Trim()
+ "',[employeeFirstCountryCodeName] = N'" + instanceDataModel.employeeFirstCountryCodeName.Trim()
+ "',[employeeFirstPhone] = N'" + instanceDataModel.employeeFirstPhone.Trim()
+ "',[employeeFirstPhoneWithCC] = N'" + instanceDataModel.employeeFirstPhoneWithCC.Trim()
+ "',[employeeSecondCountryCode] = N'" + instanceDataModel.employeeSecondCountryCode.Trim()
+ "',[employeeSecondCountryCodeName] = N'" + instanceDataModel.employeeSecondCountryCodeName.Trim()
+ "',[employeeSecondPhone] = N'" + instanceDataModel.employeeSecondPhone.Trim()
+ "',[employeeSecondPhoneWithCC] = N'" + instanceDataModel.employeeSecondPhoneWithCC.Trim()
+ "',[employeeNotes] = N'" + instanceDataModel.employeeNotes.Trim()
+ "' WHERE [employeeId] = N'" + instanceDataModel.employeeId + "'";
isUpdated = ExecuteNonQuery(queryUpdate);
return(isUpdated);
}
else
{
queryUpdate = Constants.UpdateQuery
+ "SET [employeeNameAR] = N'" + instanceDataModel.employeeNameAR.Trim()
+ "',[employeeNameEN] = N'" + instanceDataModel.employeeNameEN.Trim()
+ "',[employeeBirthDate] = N'" + instanceDataModel.employeeBirthDate.Trim()
+ "',[employeeEmail] = N'" + instanceDataModel.employeeEmail.Trim()
+ "',[employeeNationalityAR] = N'" + instanceDataModel.employeeNationalityAR.Trim()
+ "',[employeeNationalityEN] = N'" + instanceDataModel.employeeNationalityEN.Trim()
+ "',[employeeCardBankNumber] = N'" + instanceDataModel.employeeCardBankNumber.Trim()
+ "',[employeeGender] = N'" + instanceDataModel.employeeGender.Trim()
+ "',[employeeMaritalStatusAR] = N'" + instanceDataModel.employeeMaritalStatusAR.Trim()
+ "',[employeeMaritalStatusEN] = N'" + instanceDataModel.employeeMaritalStatusEN.Trim()
+ "',[employeeMilitaryStatusAR] = N'" + instanceDataModel.employeeMilitaryStatusAR.Trim()
+ "',[employeeMilitaryStatusEN] = N'" + instanceDataModel.employeeMilitaryStatusEN.Trim()
+ "',[employeeLicenseNumber] = N'" + instanceDataModel.employeeLicenseNumber.Trim()
+ "',[employeeLicenseExpireDate] = N'" + instanceDataModel.employeeLicenseExpireDate.Trim()
+ "',[employeeIdentityNumber] = N'" + instanceDataModel.employeeIdentityNumber.Trim()
+ "',[employeeIdentityExpireDate] = N'" + instanceDataModel.employeeIdentityExpireDate.Trim()
+ "',[employeePassportNumber] = N'" + instanceDataModel.employeePassportNumber.Trim()
+ "',[employeePassportExpireDate] = N'" + instanceDataModel.employeePassportExpireDate.Trim()
+ "',[employeeEducation] = N'" + instanceDataModel.employeeEducation.Trim()
+ "',[employeeContractStartDate] = N'" + instanceDataModel.employeeContractStartDate.Trim()
+ "',[employeeContractEndDate] = N'" + instanceDataModel.employeeContractEndDate.Trim()
+ "',[employeeResidenceNumber] = N'" + instanceDataModel.employeeResidenceNumber.Trim()
+ "',[employeeResidenceExpireDate] = N'" + instanceDataModel.employeeResidenceExpireDate.Trim()
+ "',[employeeInsuranceNumber] = N'" + instanceDataModel.employeeInsuranceNumber.Trim()
+ "',[employeeJobDegree] = N'" + instanceDataModel.employeeJobDegree.Trim()
+ "',[employeeJobStatus] = N'" + instanceDataModel.employeeJobStatus.Trim()
+ "',[employeeJobId] = N'" + instanceDataModel.employeeJobId
+ "',[employeeSectorId] = N'" + instanceDataModel.employeeSectorId
+ "',[employeeBranchId] = N'" + instanceDataModel.employeeBranchId
+ "',[employeeCountry] = N'" + instanceDataModel.employeeCountry.Trim()
+ "',[employeeCity] = N'" + instanceDataModel.employeeCity.Trim()
+ "',[employeeRegion] = N'" + instanceDataModel.employeeRegion.Trim()
+ "',[employeeAdressDetailsAR] = N'" + instanceDataModel.employeeAdressDetailsAR.Trim()
+ "',[employeeAdressDetailsEN] = N'" + instanceDataModel.employeeAdressDetailsEN.Trim()
+ "',[employeeFirstCountryCode] = N'" + instanceDataModel.employeeFirstCountryCode.Trim()
+ "',[employeeFirstCountryCodeName] = N'" + instanceDataModel.employeeFirstCountryCodeName.Trim()
+ "',[employeeFirstPhone] = N'" + instanceDataModel.employeeFirstPhone.Trim()
+ "',[employeeFirstPhoneWithCC] = N'" + instanceDataModel.employeeFirstPhoneWithCC.Trim()
+ "',[employeeSecondCountryCode] = N'" + instanceDataModel.employeeSecondCountryCode.Trim()
+ "',[employeeSecondCountryCodeName] = N'" + instanceDataModel.employeeSecondCountryCodeName.Trim()
+ "',[employeeSecondPhone] = N'" + instanceDataModel.employeeSecondPhone.Trim()
+ "',[employeeSecondPhoneWithCC] = N'" + instanceDataModel.employeeSecondPhoneWithCC.Trim()
+ "',[employeeNotes] = N'" + instanceDataModel.employeeNotes.Trim()
+ "' WHERE [employeeId] = N'" + instanceDataModel.employeeId + "'";
isUpdated = ExecuteNonQuery(queryUpdate);
return(isUpdated);
}
}
public EmployeesModel(EmployeeDataContext dataContext)
{
_dataContext = dataContext;
}
public string IsValidEmployee(EmployeeDataContext instanceDataModel)
{
if (instanceDataModel != null)
{
if (instanceDataModel.language == null || instanceDataModel.language == " ")
{
return(Messages.LANG_ERROR);
}
else if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_AR) == true)
{
if (ValedationClass.IsValidNameAr(instanceDataModel.employeeName) == false)
{
return(Messages.NAME_AR_ERROR);
}
//employeeNationality
if (instanceDataModel.employeeNationality != null)
{
if (ValedationClass.IsValidTextAr(instanceDataModel.employeeNationality) == false)
{
return(Messages.NATIONALITY_AR_ERROR);
}
}
//FIRST PHONE
if (ValedationClass.IsValidPhone(instanceDataModel.employeeFirstPhone, instanceDataModel.employeeFirstCountryCode, instanceDataModel.employeeFirstCountryCodeName) == false)
{
return(Messages.PHONE_AR_ERROR);
}
//SECOND PHONE
if (instanceDataModel.employeeSecondPhone != null)
{
if (ValedationClass.IsValidPhone(instanceDataModel.employeeSecondPhone, instanceDataModel.employeeSecondCountryCode, instanceDataModel.employeeSecondCountryCodeName) == false)
{
return(Messages.PHONE_AR_ERROR);
}
}
if (instanceDataModel.employeeImagePath != null)
{
if (ValedationClass.IsValidImage(instanceDataModel.employeeImagePath) == false)
{
return(Messages.IMG_AR_ERROR);
}
}
if (instanceDataModel.employeeBirthDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeBirthDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.DATE_AR_ERROR);
}
}
//employeeEmail
if (instanceDataModel.employeeEmail != null)
{
if (ValedationClass.IsValidEmail(instanceDataModel.employeeEmail) == false)
{
return(Messages.EMAIL_AR_ERROR);
}
}
//employeeCardBankNumber
if (instanceDataModel.employeeCardBankNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeeCardBankNumber) == false || instanceDataModel.employeeCardBankNumber.Length > 24)
{
return(Messages.BANK_CARD_AR_ERROR);
}
}
//employeeGender here
if (instanceDataModel.employeeGender != null)
{
if (instanceDataModel.employeeGender == "1")
{
instanceDataModel.employeeGender = Constants.male_AR;
if (ValedationClass.IsValidGender(instanceDataModel.employeeGender) == false)
{
return(Messages.GENDER_AR_ERROR);
}
}
else if (instanceDataModel.employeeGender == "2")
{
instanceDataModel.employeeGender = Constants.female_AR;
if (ValedationClass.IsValidGender(instanceDataModel.employeeGender) == false)
{
return(Messages.GENDER_AR_ERROR);
}
}
else
{
return(Messages.GENDER_AR_ERROR);
}
}
//employeeMaritalStatus
if (instanceDataModel.employeeMaritalStatus != null)
{
if (instanceDataModel.employeeMaritalStatus == "1")
{
instanceDataModel.employeeMaritalStatus = Constants.SINGLE_AR;
}
else if (instanceDataModel.employeeMaritalStatus == "2")
{
instanceDataModel.employeeMaritalStatus = Constants.MARID_AR;
}
else
{
return(Messages.Marital_AR_ERROR);
}
}
//employeeMilitaryStatus
if (instanceDataModel.employeeMilitaryStatus != null)
{
if (instanceDataModel.employeeMilitaryStatus == "1")
{
instanceDataModel.employeeMilitaryStatus = Constants.MILITARY_COMPLETED_AR;
}
else if (instanceDataModel.employeeMilitaryStatus == "2")
{
instanceDataModel.employeeMilitaryStatus = Constants.MILITARY_UNCOMPLETED_AR;
}
else if (instanceDataModel.employeeMilitaryStatus == "3")
{
instanceDataModel.employeeMilitaryStatus = Constants.MILITARY_MOAFA_AR;
}
else
{
return(Messages.MILITARY_AR_ERROR);
}
}
//employeeLicenseNumber
if (instanceDataModel.employeeLicenseNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeeLicenseNumber) == false || instanceDataModel.employeeLicenseNumber.Length > 24)
{
return(Messages.LICENCE_AR_ERROR);
}
}
//employeeLicenseExpireDate
if (instanceDataModel.employeeLicenseExpireDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeLicenseExpireDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.LICENCE_DATE_AR_ERROR);
}
if (Convert.ToDateTime(instanceDataModel.employeeLicenseExpireDate) < Convert.ToDateTime(MethodesClass.DateNow()))
{
return(Messages.DATENow_AR_ERROR);
}
}
//employeeIdentityNumber
if (instanceDataModel.employeeIdentityNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeeIdentityNumber) == false || instanceDataModel.employeeIdentityNumber.Length > 24)
{
return(Messages.IDENTITY_AR_ERROR);
}
}
//employeeIdentityExpireDate
if (instanceDataModel.employeeIdentityExpireDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeIdentityExpireDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.IDENTITY_DATE_AR_ERROR);
}
if (Convert.ToDateTime(instanceDataModel.employeeIdentityExpireDate) < Convert.ToDateTime(MethodesClass.DateNow()))
{
return(Messages.DATENow_AR_ERROR);
}
}
//employeePassportNumber
if (instanceDataModel.employeePassportNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeePassportNumber) == false || instanceDataModel.employeePassportNumber.Length > 24)
{
return(Messages.PASSPORT_AR_ERROR);
}
}
//employeePassportExpireDate
if (instanceDataModel.employeePassportExpireDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeePassportExpireDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.PASSPORT_DATE_AR_ERROR);
}
if (Convert.ToDateTime(instanceDataModel.employeePassportExpireDate) < Convert.ToDateTime(MethodesClass.DateNow()))
{
return(Messages.DATENow_AR_ERROR);
}
}
//employeeContractStartDate
if (instanceDataModel.employeeContractStartDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeContractStartDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.CONTRACT_DATE_AR_ERROR);
}
}
//employeeContractEndDate
if (instanceDataModel.employeeContractEndDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeContractEndDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.CONTRACT_DATE_AR_ERROR);
}
if (Convert.ToDateTime(instanceDataModel.employeeContractEndDate) < Convert.ToDateTime(MethodesClass.DateNow()))
{
return(Messages.DATENow_AR_ERROR);
}
}
//employeeResidenceNumber
if (instanceDataModel.employeeResidenceNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeeResidenceNumber) == false || instanceDataModel.employeeResidenceNumber.Length > 24)
{
return(Messages.RESEDENCE_AR_ERROR);
}
}
//employeeResidenceExpireDate
if (instanceDataModel.employeeResidenceExpireDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeResidenceExpireDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.RESEDENCE_DATE_AR_ERROR);
}
if (Convert.ToDateTime(instanceDataModel.employeeResidenceExpireDate) < Convert.ToDateTime(MethodesClass.DateNow()))
{
return(Messages.DATENow_AR_ERROR);
}
}
//employeeInsuranceNumber
if (instanceDataModel.employeeInsuranceNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeeInsuranceNumber) == false || instanceDataModel.employeeInsuranceNumber.Length > 24)
{
return(Messages.INSURANCE_AR_ERROR);
}
}
//employeeAdressDetails
if (instanceDataModel.employeeAdressDetails != null)
{
if (ValedationClass.IsValidTextAr(instanceDataModel.employeeAdressDetails) == false)
{
return(Messages.ADRESS_AR_ERROR);
}
}
return(true.ToString());
}
else if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
if (ValedationClass.IsValidNameEn(instanceDataModel.employeeName) == false)
{
return(Messages.NAME_EN_ERROR);
}
if (instanceDataModel.employeeAdressDetails != null)
{
if (ValedationClass.IsValidTextEn(instanceDataModel.employeeAdressDetails) == false)
{
return(Messages.ADRESS_EN_ERROR);
}
}
if (ValedationClass.IsValidPhone(instanceDataModel.employeeFirstPhone, instanceDataModel.employeeFirstCountryCode, instanceDataModel.employeeFirstCountryCodeName) == false)
{
return(Messages.PHONE_EN_ERROR);
}
//SECOND PHONE
if (instanceDataModel.employeeSecondPhone != null)
{
if (ValedationClass.IsValidPhone(instanceDataModel.employeeSecondPhone, instanceDataModel.employeeSecondCountryCode, instanceDataModel.employeeSecondCountryCodeName) == false)
{
return(Messages.PHONE_EN_ERROR);
}
}
if (instanceDataModel.employeeImagePath != null)
{
if (ValedationClass.IsValidImage(instanceDataModel.employeeImagePath) == false)
{
return(Messages.IMG_EN_ERROR);
}
}
//employeeNationality
if (instanceDataModel.employeeNationality != null)
{
if (ValedationClass.IsValidTextEn(instanceDataModel.employeeNationality) == false)
{
return(Messages.NATIONALITY_EN_ERROR);
}
}
//----------------------------------------------------------------------------
if (instanceDataModel.employeeBirthDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeBirthDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.DATE_EN_ERROR);
}
}
//employeeEmail
if (instanceDataModel.employeeEmail != null)
{
if (ValedationClass.IsValidEmail(instanceDataModel.employeeEmail) == false)
{
return(Messages.EMAIL_EN_ERROR);
}
}
//employeeCardBankNumber
if (instanceDataModel.employeeCardBankNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeeCardBankNumber) == false || instanceDataModel.employeeCardBankNumber.Length > 24)
{
return(Messages.BANK_CARD_EN_ERROR);
}
}
//employeeGender here
if (instanceDataModel.employeeGender != null)
{
if (instanceDataModel.employeeGender == "1")
{
instanceDataModel.employeeGender = Constants.male_AR;
if (ValedationClass.IsValidGender(instanceDataModel.employeeGender) == false)
{
return(Messages.GENDER_EN_ERROR);
}
}
else if (instanceDataModel.employeeGender == "2")
{
instanceDataModel.employeeGender = Constants.female_AR;
if (ValedationClass.IsValidGender(instanceDataModel.employeeGender) == false)
{
return(Messages.GENDER_EN_ERROR);
}
}
else
{
return(Messages.GENDER_EN_ERROR);
}
}
//employeeMaritalStatus
if (instanceDataModel.employeeMaritalStatus != null)
{
if (instanceDataModel.employeeMaritalStatus == "1")
{
instanceDataModel.employeeMaritalStatus = Constants.SINGLE_EN;
}
else if (instanceDataModel.employeeMaritalStatus == "2")
{
instanceDataModel.employeeMaritalStatus = Constants.MARID_EN;
}
else
{
return(Messages.Marital_EN_ERROR);
}
}
//employeeMilitaryStatus
if (instanceDataModel.employeeMilitaryStatus != null)
{
if (instanceDataModel.employeeMilitaryStatus == "1")
{
instanceDataModel.employeeMilitaryStatus = Constants.MILITARY_COMPLETED_EN;
}
else if (instanceDataModel.employeeMilitaryStatus == "2")
{
instanceDataModel.employeeMilitaryStatus = Constants.MILITARY_UNCOMPLETED_EN;
}
else if (instanceDataModel.employeeMilitaryStatus == "3")
{
instanceDataModel.employeeMilitaryStatus = Constants.MILITARY_MOAFA_EN;
}
else
{
return(Messages.MILITARY_EN_ERROR);
}
}
//employeeLicenseNumber
if (instanceDataModel.employeeLicenseNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeeLicenseNumber) == false || instanceDataModel.employeeLicenseNumber.Length > 24)
{
return(Messages.LICENCE_EN_ERROR);
}
}
//employeeLicenseExpireDate
if (instanceDataModel.employeeLicenseExpireDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeLicenseExpireDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.LICENCE_DATE_EN_ERROR);
}
if (Convert.ToDateTime(instanceDataModel.employeeLicenseExpireDate) < Convert.ToDateTime(MethodesClass.DateNow()))
{
return(Messages.DATENow_EN_ERROR);
}
}
//employeeIdentityNumber
if (instanceDataModel.employeeIdentityNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeeIdentityNumber) == false || instanceDataModel.employeeIdentityNumber.Length > 24)
{
return(Messages.IDENTITY_EN_ERROR);
}
}
//employeeIdentityExpireDate
if (instanceDataModel.employeeIdentityExpireDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeIdentityExpireDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.IDENTITY_DATE_EN_ERROR);
}
if (Convert.ToDateTime(instanceDataModel.employeeIdentityExpireDate) < Convert.ToDateTime(MethodesClass.DateNow()))
{
return(Messages.DATENow_EN_ERROR);
}
}
//employeePassportNumber
if (instanceDataModel.employeePassportNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeePassportNumber) == false || instanceDataModel.employeePassportNumber.Length > 24)
{
return(Messages.PASSPORT_EN_ERROR);
}
}
//employeePassportExpireDate
if (instanceDataModel.employeePassportExpireDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeePassportExpireDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.PASSPORT_DATE_EN_ERROR);
}
if (Convert.ToDateTime(instanceDataModel.employeePassportExpireDate) < Convert.ToDateTime(MethodesClass.DateNow()))
{
return(Messages.DATENow_EN_ERROR);
}
}
//employeeContractStartDate
if (instanceDataModel.employeeContractStartDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeContractStartDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.CONTRACT_DATE_EN_ERROR);
}
}
//employeeContractEndDate
if (instanceDataModel.employeeContractEndDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeContractEndDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.CONTRACT_DATE_EN_ERROR);
}
if (Convert.ToDateTime(instanceDataModel.employeeContractEndDate) < Convert.ToDateTime(MethodesClass.DateNow()))
{
return(Messages.DATENow_EN_ERROR);
}
}
//employeeResidenceNumber
if (instanceDataModel.employeeResidenceNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeeResidenceNumber) == false || instanceDataModel.employeeResidenceNumber.Length > 24)
{
return(Messages.RESEDENCE_EN_ERROR);
}
}
//employeeResidenceExpireDate
if (instanceDataModel.employeeResidenceExpireDate != null)
{
if (ValedationClass.IsValiDateTime(instanceDataModel.employeeResidenceExpireDate, ConstansValuesClass.formatDate) == false)
{
return(Messages.RESEDENCE_DATE_EN_ERROR);
}
if (Convert.ToDateTime(instanceDataModel.employeeResidenceExpireDate) < Convert.ToDateTime(MethodesClass.DateNow()))
{
return(Messages.DATENow_EN_ERROR);
}
}
//employeeInsuranceNumber
if (instanceDataModel.employeeInsuranceNumber != null)
{
if (ValedationClass.IsValidNumber(instanceDataModel.employeeInsuranceNumber) == false || instanceDataModel.employeeInsuranceNumber.Length > 24)
{
return(Messages.INSURANCE_EN_ERROR);
}
}
//------------------------------------------------------------------------------
return(true.ToString());
}
else
{
return(Messages.LANG_ERROR);
}
}
else
{
return(Messages.LIST_ERROR);
}
}
public FacultyService(EmployeeDataContext context)
{
_context = context;
}
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 = " ";
}
}
}
public SqlEmployeeData(EmployeeDataContext employeeDataContext)
{
_employeeDataContext = employeeDataContext;
}
protected BaseRepository(EmployeeDataContext employeeDataContext)
{
EmployeeDataContext = employeeDataContext;
DbSet = employeeDataContext.Set <T>();
}
public HttpResponseMessage GetEmployee([FromUri] EmployeeDataContext instanceDataModel)
{
try
{
if (instanceDataModel == null || instanceDataModel.language == null)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.EMPLOYEE_NULL_ERROR, data = Messages.EMPTY }));
}
if (instanceDataModel.filterStatus == true)
{
if ((ValedationClass.IsValidNameAr(instanceDataModel.textSearch) || ValedationClass.IsValidNameEn(instanceDataModel.textSearch)) == true)
{
EmployeeData dtEmployees = employeeDB.GetEmployee(instanceDataModel.textSearch, instanceDataModel.language);
if (dtEmployees != null)
{
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.SUCCEDED_STATUS, msg = Messages.SUCCEDED_EN_MESSAGES, data = dtEmployees }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.SUCCEDED_STATUS, msg = Messages.SUCCEDED_MESSAGES, data = dtEmployees }));
}
}
else
{
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.NAME_NOT_EN_EXIST, data = Messages.EMPTY }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.NAME_NOT_EXIST, data = Messages.EMPTY }));
}
}
}
else
{
if (ValedationClass.IsValidNumber(instanceDataModel.textSearch) == true)
{
EmployeeData dtEmployees = employeeDB.GetEmployee(instanceDataModel.textSearch, instanceDataModel.language);
if (dtEmployees != null)
{
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.SUCCEDED_STATUS, msg = Messages.SUCCEDED_EN_MESSAGES, data = dtEmployees }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.SUCCEDED_STATUS, msg = Messages.SUCCEDED_MESSAGES, data = dtEmployees }));
}
}
else
{
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.PHONE_EN_NOT_EXIST, data = Messages.EMPTY }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.PHONE_NOT_EXIST, data = Messages.EMPTY }));
}
}
}
else
{
if (ValedationClass.IsValidCompareToStrings(instanceDataModel.language.ToString(), Constants.LAN_EN) == true)
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.CORRECT_EN_NAME_AND_PHONE, data = Messages.EMPTY }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.CORRECT_NAME_AND_PHONE, data = Messages.EMPTY }));
}
}
}
}
else
{
return(GetAllEmployee(instanceDataModel));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.OK, new { status = Constants.FAILED_STATUS, msg = Messages.EMPTY_EMPLOYEE_ERROR, data = Messages.EMPTY }));
}
}
public EmployeeController(EmployeeDataContext _employeeDataContext)
{
this.employeeDataContext = _employeeDataContext;
}
public DepartmentService(EmployeeDataContext context)
{
_context = context;
}
public Example()
{
InitializeComponent();
DataContext = new EmployeeDataContext();
}
public RoleService(EmployeeDataContext context)
{
_context = context;
}
//private EmployeeRepository db = new EmployeeRepository();
public EmployeeController(EmployeeDataContext context)
{
_context = context;
}
// private IState _state;
public UserController(IUser user, IDepartment dept, IGrade grade, RoleManager <Role> roleM, UserManager <Account> userM, SignInManager <Account> signInM, EmployeeDataContext context)
{
_dept = dept;
roleManager = roleM;
userManager = userM;
signInManager = signInM;
_user = user;
_context = context;
_grade = grade;
// _state = state;
}
