public async Task <IActionResult> Edit(Employee_Salary employee_Salary)
{
ResponseHelper objHelper = new ResponseHelper();
if (!ModelState.IsValid)
{
objHelper.Status = StatusCodes.Status424FailedDependency;
objHelper.Message = "Invalid Model State";
return(BadRequest(objHelper));
}
try
{
if (employee_SalaryRepository.Exists(employee_Salary))
{
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Data already available";
return(Ok(objHelper));
}
await employee_SalaryRepository.Update(employee_Salary);
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Saved Successfully";
return(Ok(objHelper));
}
catch
{
objHelper.Status = StatusCodes.Status500InternalServerError;
objHelper.Message = "Get Unsuccessful";
return(StatusCode(StatusCodes.Status500InternalServerError, objHelper));
}
}
public async Task Update(Employee_Salary entity)
{
try
{
var vList = adbContext.employee_salary.Where(x => x.Emp_Salary_Id == entity.Emp_Salary_Id && x.Emp_Id == entity.Emp_Id).FirstOrDefault();
if (vList != null)
{
vList.Emp_Id = entity.Emp_Id;
vList.Company_Id = entity.Company_Id;
vList.Dept_Id = entity.Dept_Id;
vList.Desig_Id = entity.Desig_Id;
vList.ApprisalFrom = entity.ApprisalFrom;
vList.ApprisalTo = entity.ApprisalTo;
//vList.Salary = Crypt.EncryptString(entity.Salary);
vList.Reporting_Id = entity.Reporting_Id;
vList.isActive = entity.isActive;
vList.UpdatedBy = entity.UpdatedBy;
vList.UpdatedOn = DateTime.Now;
adbContext.employee_salary.Update(vList);
await Task.FromResult(adbContext.SaveChanges());
}
else
{
throw new Exception("Data Not Available");
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task Insert(Employee_Salary entity)
{
try
{
entity.Salary = Crypt.EncryptString(entity.Salary);
entity.AddedOn = DateTime.Now;
adbContext.employee_salary.Add(entity);
await Task.FromResult(adbContext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public bool Exists(Employee_Salary entity)
{
try
{
int intCount = 0;
if (entity.Emp_Salary_Id > 0) //Update Validation
{
intCount = adbContext.employee_salary.Where(w => w.Emp_Salary_Id != entity.Emp_Salary_Id && w.Emp_Id == entity.Emp_Id && w.Company_Id == entity.Company_Id && w.Salary == entity.Salary).Count();
}
else //Insert Validation
{
intCount = adbContext.employee_salary.Where(w => w.Company_Id == entity.Company_Id && w.Emp_Id == entity.Emp_Id && w.Salary == entity.Salary).Count();
}
return(intCount > 0 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult AddEmployee(String token, String employeeJson)
{
var tokenLifetime = int.Parse(ConfigurationManager.AppSettings["tokenLifetime"]);
var session = db.Session_Tokens.FirstOrDefault((p) => (p.SessionToken == token && DbFunctions.DiffHours(DateTime.Now, p.Timestamp) < tokenLifetime));
if (session != null)
{
var employee = db.Employee_Info.FirstOrDefault((p) => (p.CompanyId == session.CompanyId && p.EmployeeId == session.EmployeeId && p.IsAdmin == "y"));
if (employee != null)
{
try {
var newEmployee = new JavaScriptSerializer().Deserialize <EmployeeDataModel>(employeeJson);
var dbEmployee = db.Employee_Info.FirstOrDefault((p) => (p.CompanyId == newEmployee.companyId && p.EmployeeId == newEmployee.employeeId));
if (dbEmployee == null)
{
var e = new Employee_Info {
CompanyId = newEmployee.companyId,
EmployeeId = newEmployee.employeeId,
EmployeeName = newEmployee.name,
DOJ = newEmployee.date,
DOL = null,
IsAdmin = newEmployee.isAdmin,
Password = newEmployee.password
};
db.Employee_Info.Add(e);
if (newEmployee.salary.FirstOrDefault((p) => (p.name == "Basic" && p.type == "#" && p.value > 0)) != null)
{
for (int i = 0; i < newEmployee.salary.Length; i++)
{
if ((newEmployee.salary[i].type == "#") || (newEmployee.salary[i].type == "%" && newEmployee.salary[i].value <= 100))
{
var s = new Employee_Salary {
CompanyId = newEmployee.companyId,
EmployeeId = newEmployee.employeeId,
AdjustmentName = newEmployee.salary[i].name,
AdjustmentType = newEmployee.salary[i].type,
AdjustmentValue = newEmployee.salary[i].value
};
db.Employee_Salary.Add(s);
}
else
{
return(Ok(new Message {
data = null,
message = "Salary data model contains invalid data"
}));
}
}
for (int i = 0; i < newEmployee.personal.Length; i++)
{
if ((newEmployee.personal[i].name.Length != 0) && (newEmployee.personal[i].value.Length != 0))
{
var p = new Personal_Details {
CompanyId = newEmployee.companyId,
EmployeeId = newEmployee.employeeId,
Name = newEmployee.personal[i].name,
Value = newEmployee.personal[i].value
};
db.Personal_Details.Add(p);
}
else
{
return(Ok(new Message {
data = null,
message = "Personal data model contains invalid data"
}));
}
}
db.SaveChangesAsync();
return(Ok(new Message {
data = null,
message = "Success"
}));
}
else
{
return(Ok(new Message {
data = null,
message = "Basic pay not found"
}));
}
}
else
{
return(Ok(new Message {
data = null,
message = "Employee already exists"
}));
}
} catch (System.ArgumentException) {
return(Ok(new Message {
data = null,
message = "JSON format is invalid"
}));
}
}
else
{
return(Ok(new Message {
data = null,
message = "You do not have permission to perform this operation"
}));
}
}
else
{
return(Ok(new Message {
data = null,
message = "Session Token is invalid"
}));
}
}
