public ActionResult DeleteConfirmed(int id)
{
EmployeeAttendence employeeAttendence = _dbContext.EmployeeAttendences.Find(id);
_dbContext.EmployeeAttendences.Remove(employeeAttendence);
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,InTime,OutTime,WorkHours,OverTimeHours,EmployeeId,EmployeeFullName,Status,AttendenceId")] EmployeeAttendence employeeAttendence)
{
if (ModelState.IsValid)
{
_dbContext.Entry(employeeAttendence).State = EntityState.Modified;
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AttendenceId = new SelectList(_dbContext.Attendences, "Id", "Id", employeeAttendence.AttendenceId);
return(View(employeeAttendence));
}
public async Task <SaveEmployeeAttendenceResponse> UpdateAsync(int id, EmployeeAttendence employeeAttendence)
{
var existingEmployeeAttendence = await _employeeAttendenceRepository.FindByIdAsync(id);
if (existingEmployeeAttendence == null)
{
return(new SaveEmployeeAttendenceResponse("Employee not found."));
}
///Authorized By NiNiWinMay(Table Joining) 23.6.2019
///
existingEmployeeAttendence.Attendences.date = employeeAttendence.Attendences.date;
existingEmployeeAttendence.Attendences.start_time = employeeAttendence.Attendences.start_time;
existingEmployeeAttendence.Attendences.end_time = employeeAttendence.Attendences.end_time;
existingEmployeeAttendence.Attendences.attendenceType = employeeAttendence.Attendences.attendenceType;
existingEmployeeAttendence.Attendences.remark = employeeAttendence?.Attendences?.remark;
existingEmployeeAttendence.Attendences.Employees.employee_No = employeeAttendence?.Attendences?.Employees.employee_No;
existingEmployeeAttendence.Attendences.Employees.employee_Name = employeeAttendence?.Attendences?.Employees.employee_Name;
existingEmployeeAttendence.Attendences.Employees.email = employeeAttendence?.Attendences?.Employees.email;
existingEmployeeAttendence.Attendences.Employees.dob = employeeAttendence.Attendences.Employees.dob;
existingEmployeeAttendence.Attendences.Employees.nrc = employeeAttendence?.Attendences?.Employees.nrc;
existingEmployeeAttendence.Attendences.Employees.phone_no_work = employeeAttendence?.Attendences?.Employees.phone_no_work;
existingEmployeeAttendence.Attendences.Employees.phone_no_personal = employeeAttendence?.Attendences?.Employees.phone_no_personal;
existingEmployeeAttendence.Attendences.Employees.gender = employeeAttendence?.Attendences?.Employees.gender;
existingEmployeeAttendence.Attendences.Employees.marital_status = employeeAttendence?.Attendences?.Employees.marital_status;
existingEmployeeAttendence.Attendences.Employees.nationality = employeeAttendence?.Attendences?.Employees.nationality;
existingEmployeeAttendence.Attendences.Employees.religion = employeeAttendence?.Attendences?.Employees.religion;
existingEmployeeAttendence.Attendences.Employees.permanent_address = employeeAttendence?.Attendences?.Employees.permanent_address;
existingEmployeeAttendence.Attendences.Employees.education_background = employeeAttendence?.Attendences?.Employees.education_background;
existingEmployeeAttendence.Attendences.Employees.joined_date = employeeAttendence.Attendences.Employees.joined_date;
existingEmployeeAttendence.Attendences.Employees.employee_state = employeeAttendence?.Attendences?.Employees.employee_state;
existingEmployeeAttendence.Attendences.Employees.Addresses.line_1 = employeeAttendence?.Attendences?.Employees.Addresses.line_1;
existingEmployeeAttendence.Attendences.Employees.Addresses.line_2 = employeeAttendence?.Attendences?.Employees.Addresses.line_2;
existingEmployeeAttendence.Attendences.Employees.Addresses.region = employeeAttendence?.Attendences?.Employees.Addresses.region;
existingEmployeeAttendence.Attendences.Employees.Addresses.country = employeeAttendence?.Attendences?.Employees.Addresses.country;
existingEmployeeAttendence.locations.lotitude = employeeAttendence.locations?.lotitude;
existingEmployeeAttendence.locations.longitude = employeeAttendence.locations?.longitude;
existingEmployeeAttendence.locations.remark = employeeAttendence.locations?.remark;
try
{
_employeeAttendenceRepository.Update(existingEmployeeAttendence);
await _unitOfWork.CompleteAsync();
return(new SaveEmployeeAttendenceResponse(existingEmployeeAttendence));
}
catch (Exception ex)
{
// Do some logging stuff
return(new SaveEmployeeAttendenceResponse($"An error occurred when saving the Department: {ex.Message}"));
}
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmployeeAttendence employeeAttendence = _dbContext.EmployeeAttendences.Find(id);
if (employeeAttendence == null)
{
return(HttpNotFound());
}
return(View(employeeAttendence));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmployeeAttendence employeeAttendence = _dbContext.EmployeeAttendences.Find(id);
if (employeeAttendence == null)
{
return(HttpNotFound());
}
ViewBag.AttendenceId = new SelectList(_dbContext.Attendences, "Id", "Id", employeeAttendence.AttendenceId);
return(View(employeeAttendence));
}
public async Task <SaveEmployeeAttendenceResponse> SaveAsync(EmployeeAttendence employeeAttendence)
{
try
{
await _employeeAttendenceRepository.AddAsync(employeeAttendence);
await _unitOfWork.CompleteAsync();
return(new SaveEmployeeAttendenceResponse(employeeAttendence));
}
catch (Exception ex)
{
// Do some logging stuff
return(new SaveEmployeeAttendenceResponse($"An error occurred when saving the Department: {ex.Message}"));
}
}
public async Task <IActionResult> PostAsync([FromBody] EmployeeAttendence employeeAttendence)
{ //get data form _departmentService by id
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorMessages()));
}
//otherwise data save in database
var result = await _employeeAttendenceService.SaveAsync(employeeAttendence);
//if result is not success show error Message
if (!result.Success)
{
return(BadRequest(result.Message));
}
return(Ok());
}
public ActionResult Create(EmployeeAttendence employeeAttendence)
{
if (ModelState.IsValid)
{
var employees = _dbContext.Contacts.ToList();
var viewModel = Mapper.Map <IEnumerable <EmployeeAttendence> >(employees);
foreach (var employee in viewModel)
{
_dbContext.EmployeeAttendences.Add(employeeAttendence);
_dbContext.SaveChanges();
}
return(RedirectToAction("Index"));
}
ViewBag.AttendenceId = new SelectList(_dbContext.Attendences, "Id", "Id", employeeAttendence.AttendenceId);
return(View(employeeAttendence));
}
public async Task <IActionResult> PutAsync(int id, [FromBody] EmployeeAttendence resource)
{ // if Model is invalid show error message by using ModelState
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorMessages()));
}
//get data form EmployeeAttendenceResource by id using AutoMapper
//var employeeattendence=_mapper.Map<SaveEmployeeAttendenceResource,EmployeeAttendence>(resource);
//update data by id
var result = await _employeeAttendenceService.UpdateAsync(id, resource);
//if update data is null
if (result == null)
{
return(BadRequest(result));
}
//get result data from SaveDepartmentResource after update data using automapper
var roleResource = _mapper.Map <EmployeeAttendence, EmployeeAttendenceResource>(result.EmployeeAttendence);
//show data
return(Ok(roleResource));
}
public void Update(EmployeeAttendence employeeAttendence)
{
_context.EmployeeAttendences.Update(employeeAttendence);
}
public void Remove(EmployeeAttendence employeeAttendence)
{
_context.EmployeeAttendences.Remove(employeeAttendence);
}
// add new Department Item
public async Task AddAsync(EmployeeAttendence employeeAttendence)
{
await _context.EmployeeAttendences.AddAsync(employeeAttendence);
}
/// <summary>
/// Creates a success response.
/// </summary>
/// <param name="employee">Saved shipping.</param>
/// <returns>Response.</returns>
public SaveEmployeeAttendenceResponse(EmployeeAttendence employeeAttendence) : this(true, string.Empty, employeeAttendence)
{
EmployeeAttendence = employeeAttendence;
}
private SaveEmployeeAttendenceResponse(bool success, string message, EmployeeAttendence employeeAttendence) : base(success, message)
{
EmployeeAttendence = employeeAttendence;
}
public ActionResult Save(string employeeName, string inTimeVal, string outTimeVal, Guid AttendenceId, string attendenceTypeVal, DateTime date, Guid empidval, string command)
{
string messageToClient = string.Empty;
if (ModelState.IsValid)
{
try
{
if (command == "Submit")
{
int overTimeCalHr = 0;
int th = 0;
EmployeeAttendence employeeAttendence = new EmployeeAttendence();
EmployeeSalary employeeSalary = new EmployeeSalary();
EmployeeSalaryDetail retriveEmployeeSalaryDetail = _dbContext.EmployeeSalaryDetails.Where(es => es.ContactId == empidval).FirstOrDefault();
if (inTimeVal == "")
{
}
else
{
DateTime i = Convert.ToDateTime(inTimeVal);
if (outTimeVal == "")
{
}
else
{
DateTime o = Convert.ToDateTime(outTimeVal);
//hour calculation
int inTime = i.Hour;
int outTime = o.Hour;
if (inTime == outTime)
{
inTime = 0;
outTime = 0;
}
if (inTime > 12)
{
int newInTime = 24 - inTime;
th = newInTime + outTime;
}
else
{
th = outTime - inTime;
}
if (retriveEmployeeSalaryDetail != null)
{
if (retriveEmployeeSalaryDetail.OverTimeCal != null)
{
DateTime overtimeCal = Convert.ToDateTime(retriveEmployeeSalaryDetail.OverTimeCal);
overTimeCalHr = overtimeCal.Hour;
//work hour and overtime hour Cal
// retriving overtime and subtracting frm total hr
if (th > overTimeCalHr)
{
int otHrcal = th - overTimeCalHr;
employeeAttendence.WorkHours = overTimeCalHr;
employeeSalary.WorkHours = overTimeCalHr;
employeeAttendence.OverTimeHours = otHrcal;
employeeSalary.OverTimeHours = otHrcal;
}
else
{
employeeAttendence.WorkHours = th;
employeeSalary.WorkHours = th;
employeeAttendence.OverTimeHours = 0;
employeeSalary.OverTimeHours = 0;
}
}
}
//total Hours Cal
int im = i.Minute;
int om = o.Minute;
int t = im + om;
if (im == om)
{
employeeAttendence.TotalTime = Convert.ToString(th);
}
else if (im > om)
{
employeeAttendence.TotalTime = Convert.ToString(th);
}
else if (t > 60)
{
int totalhour = th + 1;
int min = t - 60;
employeeAttendence.TotalTime = totalhour + " : " + min;
}
else
{
employeeAttendence.TotalTime = th + " : " + t;
}
}
}
employeeAttendence.AttendenceId = AttendenceId;
employeeAttendence.EmployeeId = empidval;
employeeAttendence.FullName = employeeName;
employeeAttendence.AttendenceType = attendenceTypeVal;
employeeAttendence.Date = date;
employeeAttendence.InTime = inTimeVal;
employeeAttendence.OutTime = outTimeVal;
employeeAttendence.Status = true;
_dbContext.EmployeeAttendences.Add(employeeAttendence);
//emp salary
Salary salary = _dbContext.Salary.Where(s => s.Date == date).FirstOrDefault();
employeeSalary.FullName = employeeName;
employeeSalary.RatePerHour = retriveEmployeeSalaryDetail.RatePerHour;
employeeSalary.RatePerHourOvertime = retriveEmployeeSalaryDetail.RatePerHourOvertime;
employeeSalary.Date = date;
employeeSalary.SalaryId = salary.Id;
_dbContext.EmployeeSalaries.Add(employeeSalary);
_dbContext.SaveChanges();
}
else
{
int overTimeCalHr = 0;
int th = 0;
EmployeeAttendence employeeAttendence = _dbContext.EmployeeAttendences.Where(ea => ea.AttendenceId == AttendenceId && ea.FullName == employeeName).FirstOrDefault();
Salary salary = _dbContext.Salary.Where(s => s.Date == date).FirstOrDefault();
EmployeeSalary employeeSalary = _dbContext.EmployeeSalaries.Where(es => es.SalaryId == salary.Id && es.FullName == employeeName).FirstOrDefault();
if (inTimeVal == "")
{
}
else
{
DateTime i = Convert.ToDateTime(inTimeVal);
if (outTimeVal == "")
{
}
else
{
DateTime o = Convert.ToDateTime(outTimeVal);
//hour calculation
int inTime = i.Hour;
int outTime = o.Hour;
if (inTime == outTime)
{
inTime = 0;
outTime = 0;
}
if (inTime > 12)
{
int newInTime = 24 - inTime;
th = newInTime + outTime;
}
else
{
th = outTime - inTime;
}
EmployeeSalaryDetail retriveEmployeeSalaryDetail = _dbContext.EmployeeSalaryDetails.Where(es => es.ContactId == empidval).FirstOrDefault();
if (retriveEmployeeSalaryDetail != null)
{
if (retriveEmployeeSalaryDetail.OverTimeCal != null)
{
DateTime overtimeCal = Convert.ToDateTime(retriveEmployeeSalaryDetail.OverTimeCal);
overTimeCalHr = overtimeCal.Hour;
//work hour and overtime hour Cal
// retriving overtime and subtracting frm total hr
if (th > overTimeCalHr)
{
int otHrcal = th - overTimeCalHr;
employeeAttendence.WorkHours = overTimeCalHr;
employeeSalary.WorkHours = overTimeCalHr;
employeeAttendence.OverTimeHours = otHrcal;
employeeSalary.OverTimeHours = otHrcal;
}
else
{
employeeAttendence.WorkHours = th;
employeeSalary.WorkHours = th;
employeeAttendence.OverTimeHours = 0;
employeeSalary.OverTimeHours = 0;
}
}
}
//total Hours Cal
int im = i.Minute;
int om = o.Minute;
int t = im + om;
if (im == om)
{
employeeAttendence.TotalTime = Convert.ToString(th);
}
else if (im > om)
{
employeeAttendence.TotalTime = Convert.ToString(th);
}
else if (t > 60)
{
int totalhour = th + 1;
int min = t - 60;
employeeAttendence.TotalTime = totalhour + " : " + min;
}
else
{
employeeAttendence.TotalTime = th + " : " + t;
}
//emp salary
employeeSalary.FullName = employeeName;
employeeSalary.RatePerHour = retriveEmployeeSalaryDetail.RatePerHour;
employeeSalary.RatePerHourOvertime = retriveEmployeeSalaryDetail.RatePerHourOvertime;
employeeSalary.Date = date;
employeeSalary.SalaryId = salary.Id;
_dbContext.Entry(employeeSalary).State = EntityState.Modified;
_dbContext.SaveChanges();
}
}
employeeAttendence.AttendenceId = AttendenceId;
employeeAttendence.EmployeeId = empidval;
employeeAttendence.FullName = employeeName;
employeeAttendence.AttendenceType = attendenceTypeVal;
employeeAttendence.InTime = inTimeVal;
employeeAttendence.OutTime = outTimeVal;
employeeAttendence.Status = true;
_dbContext.Entry(employeeAttendence).State = EntityState.Modified;
}
_dbContext.SaveChanges();
return(Json(new { success = true }));
}
catch (DbUpdateException dbex)
{
// var error = new ModelStateException(dbex);
// Log4NetHelper.Log(String.Format("Cannot Create Deparment {0} ", viewModel.Id), LogLevel.ERROR, "Department", viewModel.Id, User.Identity.Name, dbex);
var msg = new ModelStateException(dbex);
TempData["MessageToClient"] = msg;
messageToClient = msg.ToString();
}
catch (Exception ex)
{
// Log4NetHelper.Log(String.Format("Cannot Create Deparment {0} ", viewModel.Id), LogLevel.ERROR, "Department", viewModel.Id, User.Identity.Name, ex);
var msg = new ModelStateException(ex);
TempData["MessageToClient"] = msg;
}
}
ViewBag.CompanyId = new SelectList(_dbContext.Companyies, "Id", "CompanyName");
return(View());
}
