public List<ResponseEmployee> addDetails(string fname, string lname, string email, string phone, string password)
{
List<ResponseEmployee> objResult = new List<ResponseEmployee>();
ResponseEmployee objEmp = new ResponseEmployee();
try
{
objEmp.result = "success";
objEmp.FirstName = fname;
objEmp.FirstName = fname;
objEmp.LastNAme = lname;
objEmp.Email = email;
objEmp.Phone = phone;
objEmp.Password = password;
objResult.Add(objEmp);
tbUserDetail obj = new tbUserDetail();
obj.userFirstName = objEmp.FirstName;
obj.userLastName = objEmp.LastNAme;
obj.userEmail = objEmp.Email;
obj.userPhone = objEmp.Phone;
obj.userPassword = objEmp.Password;
dc.tbUserDetails.Add(obj);
dc.SaveChanges();
return objResult;
}
catch (Exception ex)
{
objEmp.result = "fail";
objResult.Add(objEmp);
return objResult;
}
}
public ResponseEmployee EmployeeDetails(int EmployeeId, int userId, string userName, int concernId)
{
ResponseEmployee responseEmployee = new ResponseEmployee();
using (var command = _context.Database.Connection.CreateCommand())
{
command.CommandText = ("usp_EventManagement_EmployeeDetailsById @employeeId,@concernId");
command.Parameters.Add(new SqlParameter("employeeId", EmployeeId));
command.Parameters.Add(new SqlParameter("concernId", concernId));
_context.Database.Connection.Open();
using (var result = command.ExecuteReader())
{
if (result.HasRows)
{
while (result.Read())
{
responseEmployee.EmployeeCode = Convert.ToString(result[0]);
responseEmployee.FirstName = Convert.ToString(result[1]);
responseEmployee.LastName = Convert.ToString(result[2]);
responseEmployee.NickName = Convert.ToString(result[3]);
responseEmployee.EmployeeEmail = Convert.ToString(result[4]);
responseEmployee.ContactNumber = Convert.ToString(result[5]);
responseEmployee.EmergencyNumber = Convert.ToInt32(result[6]);
responseEmployee.PermanentAddress = Convert.ToString(result[7]);
responseEmployee.PresentAddress = Convert.ToString(result[8]);
responseEmployee.DateOfBirth = Convert.ToDateTime(result[9]);
responseEmployee.PassportNumber = Convert.ToString(result[10]);
responseEmployee.PassportExpiratationDate = Convert.ToDateTime(result[11]);
responseEmployee.NIDNumber = Convert.ToString(result[12]);
responseEmployee.VisaNumber = Convert.ToString(result[13]);
responseEmployee.VisaExpirationDate = Convert.ToDateTime(result[14]);
responseEmployee.EmployeeEntitlement = Convert.ToString(result[15]);
responseEmployee.MonthlySalary = Convert.ToDecimal(result[16]);
responseEmployee.RatePerHour = Convert.ToDecimal(result[17]);
responseEmployee.IsActive = Convert.ToString(result[18]);
responseEmployee.CreatorName = Convert.ToString(result[19]);
responseEmployee.CreationDate = Convert.ToDateTime(result[20]);
}
}
}
_context.Database.Connection.Close();
}
return(responseEmployee);
}
public IEnumerable <ResponseEmployee> Employees(int userId, string userName, int ConcernId, int Page)
{
List <ResponseEmployee> ResponseEmployeeList = new List <ResponseEmployee>();
using (var command = _context.Database.Connection.CreateCommand())
{
command.CommandText = ("usp_EventManagement_EmployeeIndexByConcernId @concernId,@Page");
command.Parameters.Add(new SqlParameter("concernId", ConcernId));
command.Parameters.Add(new SqlParameter("Page", Page));
_context.Database.Connection.Open();
using (var result = command.ExecuteReader())
{
if (result.HasRows)
{
while (result.Read())
{
ResponseEmployee responseEmployee = new ResponseEmployee();
responseEmployee.SerialNumber = Convert.ToInt32(result[0]);
responseEmployee.FirstName = Convert.ToString(result[1]);
responseEmployee.LastName = Convert.ToString(result[2]);
responseEmployee.EmployeeEntitlement = Convert.ToString(result[3]);
responseEmployee.MonthlySalary = Convert.ToDecimal(result[4]);
responseEmployee.ContactNumber = Convert.ToString(result[5]);
responseEmployee.EmployeeCode = Convert.ToString(result[6]);
responseEmployee.EmployeeId = Convert.ToInt32(result[7]);
responseEmployee.NumberOfRow = Convert.ToInt32(result[8]);
responseEmployee.EmployeeImage = Convert.ToString(result[9]);
responseEmployee.PassportImage = Convert.ToString(result[10]);
responseEmployee.PassportNumber = Convert.ToString(result[11]);
ResponseEmployeeList.Add(responseEmployee);
}
}
}
}
return(ResponseEmployeeList);
}
private static async Task RunAsync()
{
bool isRunning = true;
string commandsString = string.Join("\n", commands);
while (isRunning)
{
Console.WriteLine("Please enter your command from list:");
Console.WriteLine($"{commandsString}\n");
string command = Console.ReadLine();
isRunning = command.ToLower() != "exit";
if (!isRunning)
{
break;
}
if (!commands.Select(c => c.ToLower()).Contains(command.ToLower()))
{
Console.WriteLine($"Command {command} isn't valid command name \n");
continue;
}
switch (command.ToLower())
{
case "get employee for name":
Dictionary <string, string> nameParameters = new Dictionary <string, string>();
Console.WriteLine("Enter First Name");
string firstName = Console.ReadLine();
nameParameters.Add("firstName", firstName);
Console.WriteLine("Enter Last Name");
string lastName = Console.ReadLine();
nameParameters.Add("lastName", lastName);
Console.WriteLine("Enter Midle Name");
string midleName = Console.ReadLine();
nameParameters.Add("midleName", midleName);
Console.WriteLine("Geting employee...\n");
Response result = await Get("GetEmployeeForName", nameParameters);
Console.WriteLine($"{result.Message}\n");
if (result.IsSuccess)
{
ResponseEmployee employee = result.ResponseEmployee;
Console.WriteLine($"Name: {employee.FirstName} {employee.LastName} {employee.MidleName}");
Console.WriteLine($"Average Salary: {employee.AverageSalary}\n\n");
}
break;
case "get employees with salaries below the specified level":
Dictionary <string, string> salariesParameters = new Dictionary <string, string>();
Console.WriteLine("Enter salaries");
string salaries = Console.ReadLine();
salariesParameters.Add("salaries", salaries);
Console.WriteLine("Geting employee...\n");
Response resultSalaries = await Get("GetEmployeesWithSalariesBelowTheSpecifiedLevel", salariesParameters);
Console.WriteLine($"{resultSalaries.Message}\n");
if (resultSalaries.IsSuccess)
{
List <ResponseEmployee> employees = resultSalaries.ResponseEmployees;
foreach (ResponseEmployee employee in employees)
{
Console.WriteLine($"Name: {employee.FirstName} {employee.LastName} {employee.MidleName}");
Console.WriteLine($"Average Salary: {employee.AverageSalary}\n\n");
}
}
break;
case "get total monthly salary of the five highest paid employees":
Dictionary <string, string> totalMonthlySalaryParameters = new Dictionary <string, string>();
Console.WriteLine("Geting total monthly salary of the five highest paid employees...\n");
Response totalMonthlySalaryResult = await Get("GetTotalMonthlySalaryOfTheFiveHighestPaidEmployees", totalMonthlySalaryParameters);
Console.WriteLine($"{totalMonthlySalaryResult.Message}\n");
if (totalMonthlySalaryResult.IsSuccess)
{
Console.WriteLine($"Total Monthly Salary Of The Five Highest Paid Employees: {totalMonthlySalaryResult.TotalMonthlySalary}\n\n");
}
break;
case "create employee with attribute":
Console.WriteLine("\nCreating employes with attribute...\n");
Response createEmployeeWithAttributeResult = await PostAsync("CreateEmployeeWithAttribute", false);
Console.WriteLine($"{createEmployeeWithAttributeResult.Message}\n");
if (createEmployeeWithAttributeResult.IsSuccess)
{
Console.WriteLine($"Average Salary: {createEmployeeWithAttributeResult.AverageSalary}\n\n");
}
break;
case "create employees":
Console.WriteLine("\nCreating employes...\n");
Response createResult = await PostAsync("CreateEmployees", true);
Console.WriteLine($"{createResult.Message}\n");
break;
default:
break;
}
continue;
}
}
public List<ResponseEmployee> deleteuser(string id)
{
int uid = Convert.ToInt32(id);
List<ResponseEmployee> objResult = new List<ResponseEmployee>();
ResponseEmployee objEmp = new ResponseEmployee();
try
{
var delEmp = (from a in dc.tbUserDetails
where a.userId == uid
select a).FirstOrDefault();
dc.tbUserDetails.Remove(delEmp);
dc.SaveChanges();
objEmp.result = "success";
objResult.Add(objEmp);
return objResult;
}
catch
{
objEmp.result = "fail";
objResult.Add(objEmp);
return objResult;
}
}
public List<ResponseEmployee> updateUser(ResponseEmployee objPass, string UserId)
{
int uid = Convert.ToInt32(UserId);
List<ResponseEmployee> objResult = new List<ResponseEmployee>();
ResponseEmployee objResponsePass = new ResponseEmployee();
if (objPass == null)
{
objResponsePass.result = "fail";
objResult.Add(objResponsePass);
return objResult;
}
try
{
if (UserId == null)
{
objResponsePass.result = "fail";
objResult.Add(objResponsePass);
return objResult;
}
else
{
objResponsePass.Email = objPass.Email;
objResponsePass.Phone = objPass.Phone;
objResponsePass.FirstName = objPass.FirstName;
objResponsePass.LastNAme = objPass.LastNAme;
objResponsePass.Password = objPass.Password;
objResponsePass.result = "success";
objResult.Add(objResponsePass);
tbUserDetail newtbemp = (from a in dc.tbUserDetails
where a.userId == uid
select a).FirstOrDefault();
newtbemp.userFirstName = objResponsePass.FirstName;
newtbemp.userLastName = objResponsePass.LastNAme;
newtbemp.userEmail = objResponsePass.Email;
newtbemp.userPhone = objResponsePass.Phone;
newtbemp.userPassword = objResponsePass.Password;
dc.SaveChanges();
return objResult;
}
}
catch (Exception ex)
{
objResponsePass.result = "fail";
objResult.Add(objResponsePass);
return objResult;
}
}
public List<ResponseEmployee> getUserByID(string id)
{
int uid = Convert.ToInt32(id);
List<ResponseEmployee> objResult = new List<ResponseEmployee>();
ResponseEmployee objEmp = new ResponseEmployee();
try
{
var editEmp = (from a in dc.tbUserDetails
where a.userId == uid
select a).SingleOrDefault();
objEmp.Id = editEmp.userId;
objEmp.FirstName = editEmp.userFirstName;
objEmp.LastNAme = editEmp.userLastName;
objEmp.Phone = editEmp.userPhone;
objEmp.Password = editEmp.userPassword;
objEmp.Email = editEmp.userEmail;
objEmp.result = "success";
objResult.Add(objEmp);
return objResult;
}
catch
{
objEmp.result = "fail";
objResult.Add(objEmp);
return objResult;
}
}
public List<ResponseEmployee> getAll()
{
List<ResponseEmployee> objResult = new List<ResponseEmployee>();
ResponseEmployee objEmp = new ResponseEmployee();
try
{
var editEmp = (from a in dc.tbUserDetails
select a).ToList();
foreach (tbUserDetail item in editEmp)
{
objEmp = new ResponseEmployee();
objEmp.Id = item.userId;
objEmp.FirstName = item.userFirstName;
objEmp.LastNAme = item.userLastName;
objEmp.Phone = item.userPhone;
objEmp.Password = item.userPassword;
objEmp.Email = item.userEmail;
objEmp.result = "true";
objResult.Add(objEmp);
}
return objResult;
}
catch
{
objEmp.result = "fail";
objResult.Add(objEmp);
return objResult;
}
}
