public async Task <IActionResult> Edit(long id, [Bind("Id,CreatedDate,TotalDay,RemainDay,CreatedId,LeaveTypeId,EmployeeInfoId")] EmployeeLeaveInfo employeeLeaveInfo)
{
if (id != employeeLeaveInfo.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
//_context.Update(employeeLeaveInfo);
//await _context.SaveChangesAsync();
await employeeLeaveInfoRepository.Update(employeeLeaveInfo);
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeLeaveInfoExists(employeeLeaveInfo.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["EmployeeInfoId"] = new SelectList(employeeInfoRepository.GetEmployeeInfoList(), "Id", "Id", employeeLeaveInfo.EmployeeInfoId);
ViewData["LeaveTypeId"] = new SelectList(leaveTypeRepository.GetLeaveTypeList(), "Id", "Id", employeeLeaveInfo.LeaveTypeId);
return(View(employeeLeaveInfo));
}
public List <EmployeeLeaveInfo> ShowAllLeaveStatus()
{
const string query = @"SELECT e.Id,e.Reason, CONVERT(NVARCHAR,e.StartDate, 100) AS[StartDate],CONVERT(NVARCHAR,e.EndDate, 100) AS[EndDate],e.TotalDay, e.Status,CONVERT(NVARCHAR,e.EntryDate, 100) AS[EntryDate], a.EmployeeName,a.Email,p.LeaveTypeName
FROM EmployeeLeaveRequest e
INNER JOIN Employee a ON e.EmployeeId = a.Id
INNER JOIN LeaveType p ON e.LeaveTypeId = p.Id";
try
{
var command = new SqlCommand(query, Connection);
Connection.Open();
SqlDataReader reader = command.ExecuteReader();
var employeeLeaveInfo = new List <EmployeeLeaveInfo>();
int serial = 1;
while (reader.Read())
{
var employeeLeave = new EmployeeLeaveInfo
{
Id = serial,
EmployeeName = reader["EmployeeName"].ToString(),
Email = reader["Email"].ToString(),
LeaveTypeName = reader["LeaveTypeName"].ToString(),
Reason = reader["Reason"].ToString(),
StartDate = reader["StartDate"].ToString(),
EndDate = reader["EndDate"].ToString(),
TotalDay = (int)reader["TotalDay"],
EntryDate = reader["EntryDate"].ToString(),
Status = reader["Status"].ToString()
};
employeeLeaveInfo.Add(employeeLeave);
serial++;
}
reader.Close();
return(employeeLeaveInfo);
}
catch (Exception exception)
{
throw new Exception("Unable to connect Server", exception);
}
finally
{
Connection.Close();
}
}
public List <EmployeeLeaveInfo> ShowAllLeaveStatus()
{
string query = @"SELECT e.Id, CONVERT(NVARCHAR,e.StartDate, 100) AS[StartDate],CONVERT(NVARCHAR,e.EndDate, 100) AS[EndDate],e.TotalDay, e.Status,CONVERT(NVARCHAR,e.EntryDate, 100) AS[EntryDate], a.EmployeeName,a.Email,p.LeaveTypeName
FROM tb_EmployeeLeave e
INNER JOIN tb_Employee a ON e.EmployeeId = a.Id
INNER JOIN tb_LeaveType p ON e.LeaveTypeId = p.Id";
try
{
SqlCommand command = new SqlCommand(query, con);
con.Open();
SqlDataReader reader = command.ExecuteReader();
List <EmployeeLeaveInfo> employeeLeaveInfo = new List <EmployeeLeaveInfo>();
int serial = 1;
while (reader.Read())
{
EmployeeLeaveInfo employeeLeave = new EmployeeLeaveInfo();
employeeLeave.Id = serial;
employeeLeave.EmployeeName = reader["EmployeeName"].ToString();
employeeLeave.Email = reader["Email"].ToString();
employeeLeave.LeaveTypeName = reader["LeaveTypeName"].ToString();
employeeLeave.TotalDay = (int)reader["TotalDay"];
employeeLeave.StartDate = reader["StartDate"].ToString();
employeeLeave.EndDate = reader["EndDate"].ToString();
employeeLeave.EntryDate = reader["EntryDate"].ToString();
employeeLeave.Status = reader["Status"].ToString();
employeeLeaveInfo.Add(employeeLeave);
serial++;
}
reader.Close();
return(employeeLeaveInfo);
}
catch (Exception exception)
{
throw new Exception("Unable to connect Server", exception);
}
finally
{
con.Close();
}
}
public async Task <IActionResult> Create([Bind("Id,CreatedDate,TotalDay,RemainDay,CreatedId,LeaveTypeId,EmployeeInfoId")] EmployeeLeaveInfoViewModel employeeLeaveInfo)
{
if (ModelState.IsValid)
{
EmployeeLeaveInfo dd = new EmployeeLeaveInfo()
{
CreatedDate = employeeLeaveInfo.CreatedDate,
TotalDay = employeeLeaveInfo.TotalDay,
RemainDay = employeeLeaveInfo.RemainDay,
CreatedId = employeeLeaveInfo.CreatedId,
EmployeeInfoId = employeeLeaveInfo.EmployeeInfoId,
LeaveTypeId = employeeLeaveInfo.LeaveTypeId
};
//_context.Add(employeeLeaveInfo);
//await _context.SaveChangesAsync();
await employeeLeaveInfoRepository.Save(dd);
return(RedirectToAction(nameof(Index)));
}
ViewData["EmployeeInfoId"] = new SelectList(employeeInfoRepository.GetEmployeeInfoList(), "Id", "Id", employeeLeaveInfo.EmployeeInfoId);
ViewData["LeaveTypeId"] = new SelectList(leaveTypeRepository.GetLeaveTypeList(), "Id", "Id", employeeLeaveInfo.LeaveTypeId);
return(View(employeeLeaveInfo));
}
public async Task Update(EmployeeLeaveInfo ot)
{
context.Update(ot);
await context.SaveChangesAsync();
}
public async Task Save(EmployeeLeaveInfo ot)
{
context.Add(ot);
await context.SaveChangesAsync();
}
public async Task Delete(EmployeeLeaveInfo ot)
{
context.Remove(ot);
await context.SaveChangesAsync();
}