public IActionResult Delete(int?id)
{
if (id == null)
{
return(NotFound());
}
var employee = _context.Employees.FirstOrDefault(m => m.Id == id);
if (employee == null)
{
return(NotFound());
}
foreach (var emp in _context.Employees)
{
if (emp.ManagerId == id)
{
emp.ManagerId = 1;
}
}
_context.Employees.Remove(employee);
_context.SaveChanges();
return(RedirectToAction("Index"));;
}
public ActionResult Delete(int id)
{
var obj = context.EmpPromotions.Find(id);
context.EmpPromotions.Remove(obj);
context.SaveChanges();
return(Json("OK"));
}
public ActionResult Edit(JobTitle job)
{
if (ModelState.IsValid)
{
context.JobTitles.AddOrUpdate(job);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(job));
}
public ActionResult Create([Bind(Include = "Id,Name,StartDate,EndDate,Status")] Training training)
{
if (ModelState.IsValid)
{
db.Trainings.Add(training);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(training));
}
public ActionResult Edit(JobTitle job)
{
if (ModelState.IsValid)
{
//AddOrUpdate -> using System.Data.Entity.Migrations;
context.JobTitles.AddOrUpdate(job);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(job));
}
public ActionResult Edit(Employee obj)
{
if (ModelState.IsValid)
{
context.Employees.AddOrUpdate(obj);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(obj));
}
public ActionResult Create([Bind(Include = "Id,Name,Description")] Position position)
{
if (ModelState.IsValid)
{
db.Positions.Add(position);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(position));
}
public ActionResult Delete(int id)
{
var job = context.JobTitles.Find(id);
if (job != null)
{
context.JobTitles.Remove(job);
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "EmployeeId,FirstName,LastName,DateBirthday,INN")] Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public JsonResult EnableMenu(string WebMenuAccess, Guid IdRole)
{
AccessModels am = new AccessModels();
am.Id = Guid.NewGuid();
am.UserAccountRoles_Id = IdRole;
am.UserAccountAccess_EnumId = 0;
am.WebMenuAccess = WebMenuAccess;
db.Access.Add(am);
db.SaveChanges();
return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(Department d)
{
if (ModelState.IsValid)
{
Department obj = context1.Departments.Single(x => x.DepartmentID == d.DepartmentID);
obj.Name = d.Name;
obj.GroupName = d.GroupName;
obj.ModifiedDate = d.ModifiedDate;
context1.SaveChanges();
return(RedirectToAction("Departments"));
}
return(View(d));
}
private static void OnboardEmployee(HrContext hrContext, Person person, DateTime birthDate, string sex, string ssn)
{
if (person == null)
{
Debug.WriteLine("Person 22781 not found");
}
Employee employee = new Employee()
{
BusinessEntityId = person.BusinessEntityId,
BirthDate = birthDate,
Gender = sex,
NationalIdNumber = ssn,
LoginId = string.Format($"adventure-works\\{person.FirstName.ToLower()}.{person.LastName.ToLower()}"),
JobTitle = "Software Intern",
MaritalStatus = "S",
HireDate = DateTime.Today,
SalariedFlag = true,
VacationHours = 40,
SickLeaveHours = 16,
CurrentFlag = true
};
hrContext.Employee.Add(employee);
try
{
hrContext.SaveChanges();
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
}
}
private static Person CreatePerson(HrContext context, string firstName, string lastName, string personType)
{
BusinessEntity be = new BusinessEntity();
//{
// ModifiedDate = DateTime.UtcNow
//};
context.BusinessEntity.Add(be);
Person person = new Person
{
BusinessEntityId = be.BusinessEntityId,
PersonType = personType,
FirstName = firstName,
LastName = lastName
};
context.Person.Add(person);
try
{
context.SaveChanges();
}
catch (Exception e)
{
Debug.WriteLine("CreatePerson exception: " + e.Message);
}
return(person);
}
public ActionResult DeleteConfirmed(int id)
{
Note note = db.Notes.Find(id);
db.Notes.Remove(note);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
Employee employee = db.Employees.Find(id);
db.Employees.Remove(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(int id)
{
var photoToDel = context.Photos.Find(id);
string photoDest = photoToDel.PhotoPath.Substring(1);
string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, photoDest);
FileInfo file = new FileInfo(path);
if (file.Exists)
{
file.Delete();
}
context.Photos.Remove(photoToDel);
context.SaveChanges();
return(Json("OK"));
}
public void SetChangesForEmployee(int employeeId, int positionId, int projectId, string lastName, string middleName, string firstName, DateTime dateOfBirth, Gender gender, string nationality, string nID)
{
var employee = _dbContext.Employees.Find(employeeId);
var position = _dbContext.Positions.Find(positionId);
var project = _dbContext.Projects.Find(projectId);
employee.Position = position;
employee.Project = project;
employee.FirstName = firstName;
employee.MiddleName = middleName;
employee.LastName = lastName;
employee.DateOfBirth = dateOfBirth;
employee.Gender = gender;
employee.Nationality = nationality;
employee.NationalIdentificationNumber = nID;
_dbContext.SaveChanges();
}
public void Add(PersonAddress newPersonAddress)
{
_context.Add(newPersonAddress);
_context.SaveChanges();
}
public void Add(ContractOrganizatoricalAssignment coa)
{
_context.Add(coa);
_context.SaveChanges();
}
public ActionResult Edit(JobTitle j)
{
context.JobTitles.AddOrUpdate(j);
context.SaveChanges();
return(RedirectToAction("Index"));
}
//public IRepository<T> Repository<T>() where T : BaseEntity
//{
// if (repositories.Keys.Contains(typeof(T)) == true)
// {
// return repositories[typeof(T)] as IRepository<T>;
// }
// IRepository<T> repo = new GenericRepository<T>(entities);
// repositories.Add(typeof(T), repo);
// return repo;
//}
public void Save()
{
entities.SaveChanges();
}
public void Add(PersonIdentity newPersonIdentity)
{
_context.Add(newPersonIdentity);
_context.SaveChanges();
}
public void Add(ContractInsurance contractInsurance)
{
_context.Add(contractInsurance);
_context.SaveChanges();
}
public bool SaveChanges()
{
return(context.SaveChanges() > 0);
}
public JsonResult GeneratePayroll(string ids)
{
if (string.IsNullOrEmpty(ids))
{
return(Json(new { status = "404" }, JsonRequestBehavior.AllowGet));
}
else
{
string[] arrID = ids.Split(',');
if (arrID.Length > 0)
{
bool isValid = false;
string empID = null;
for (int a = 0; a < arrID.Length; a++)
{
Guid attID = new Guid(arrID[a]);
//Approved Checked
bool isValidAtt = db.Attendance.Where(x => x.Id == attID).Select(x => x.Approved.HasValue).Single(); //return false jika Approved = NULL
if (!isValidAtt)
{
isValid = false;
break;
}
else
{
isValid = db.Attendance.Where(x => x.Id == attID).Select(x => x.Approved.Value).Single();
if (!isValid)
{
break;
}
}
//Same Employee Checked
string userID = db.Attendance.Where(x => x.Id == attID).Select(x => x.UserAccounts_Id).Single().ToString();
if (a == 0)
{
empID = userID;
}
else
{
isValid = (empID == userID) ? true : false;
}
}
if (!isValid)
{
return(Json(new { status = "405" }, JsonRequestBehavior.AllowGet));
}
else
{
Guid _attID = new Guid(arrID[0]);
Guid employeeID = db.Attendance.Where(x => x.Id == _attID).Select(x => x.UserAccounts_Id).Single();
PayrollModels pRoll = new PayrollModels();
pRoll.Id = Guid.NewGuid();
pRoll.Timestamp = DateTime.Now;
pRoll.Employee_UserAccounts_Id = employeeID;
pRoll.Amount = 0;
Common.Master m = new Common.Master();
pRoll.No = m.GetLastHexNo("payroll").ToString("00000");
pRoll.hasPayment = false;
db.Payroll.Add(pRoll);
db.SaveChanges();
for (int i = 0; i < arrID.Length; i++)
{
Guid attID = new Guid(arrID[i]);
PayrollItemModels pi = new PayrollItemModels();
pi.Id = Guid.NewGuid();
pi.Payrolls_Id = pRoll.Id;
pi.RefId = attID;
pi.Description = string.Empty;
int hours = db.Attendance.Where(x => x.Id == attID).Select(x => x.Workshifts_DurationMinutes.Value).Single() / 60;
decimal payRate = db.Attendance.Where(x => x.Id == attID).Select(x => x.AttendancePayRates_Amount.Value).FirstOrDefault();
pi.Amount = hours * payRate;
pi.Notes = string.Empty;
db.PayrollItem.Add(pi);
db.SaveChanges();
using (var ctx = new HrContext())
{
int result = ctx.Database.ExecuteSqlCommand("UPDATE Attendances SET PayrollItems_Id='" + pi.Id + "' WHERE Id='" + attID + "'");
}
}
decimal total_amount = db.PayrollItem.Where(x => x.Payrolls_Id == pRoll.Id).Select(x => x.Amount).Sum();
int update_amount = db.Database.ExecuteSqlCommand("UPDATE Payrolls SET Amount=" + total_amount + " WHERE Id='" + pRoll.Id + "'");
return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { status = "404" }, JsonRequestBehavior.AllowGet));
}
} //end ids is not null/empty
} //end generate payroll
public void Add(Contract newContract)
{
_context.Add(newContract);
_context.SaveChanges();
}
public void Add(ContractFiscality contractFiscality)
{
_context.Add(contractFiscality);
_context.SaveChanges();
}
public void Add(Person newPerson)
{
_context.Add(newPerson);
_context.SaveChanges();
}
public void Add(ContractPeriod contractPeriod)
{
_context.Add(contractPeriod);
_context.SaveChanges();
}
public void Add(ContractWorkProgram contractWorkProgram)
{
_context.Add(contractWorkProgram);
_context.SaveChanges();
}
