public ActionResult EmployeeUpdate(Employees emp)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
Employees e = db.Employees.Find(emp.EmployeeId);
e.FirstName = emp.FirstName;
e.Lastname = emp.Lastname;
e.DepartmentId = emp.DepartmentId;
e.TaskId = emp.TaskId;
e.DistrictId = emp.DistrictId;
// e.Districts = emp.Districts.CityId;
e.DateOfBirth = emp.DateOfBirth;
e.StartDay = emp.StartDay;
e.EndDay = emp.EndDay;
e.PlaceOfBirth = emp.PlaceOfBirth;
e.MobilePhone = emp.MobilePhone;
e.Mail = emp.Mail;
e.Address = emp.Address;
e.Nationality = emp.Nationality;
e.Salary = emp.Salary;
e.EmployeeCode = emp.EmployeeCode;
e.Gender = emp.Gender;
e.IdentyNumber = emp.IdentyNumber;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult NewEmployeeAdd()
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
List <SelectListItem> deger = (from x in db.Departments.ToList()
select new SelectListItem
{
Text = x.DepartmentName,
Value = x.DepartmentId.ToString()
}).ToList();
ViewBag.deger = deger;
List <SelectListItem> tasks = (from x in db.Tasks.ToList()
select new SelectListItem
{
Text = x.TaskName,
Value = x.TaskId.ToString()
}).ToList();
ViewBag.tasks = tasks;
List <SelectListItem> district = (from x in db.Districts.ToList()
select new SelectListItem
{
Text = x.DistrictName,
Value = x.DistrictId.ToString()
}).ToList();
ViewBag.district = district;
return(View());
}
}
public ActionResult Index()
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
//Toplam Çalışanlar
var EmployeeAll = db.Employees.Count();
ViewBag.EmployeeAll = EmployeeAll;
//Makineler departmanında çalışanlar
var departmentById = db.Employees.Count(x => x.DepartmentId == db.Departments.Where(z => z.DepartmentId == 2).Select(y => y.DepartmentId).FirstOrDefault());
ViewBag.departmentById = departmentById;
//Bugün izinli çalışanlar
var permissionByDay = db.Permissions.Where(x => x.StartDay.Value.Day <= DateTime.Now.Day && x.EndDay.Value.Day >= DateTime.Now.Day).Select(y => y.PermissionId).Count();
ViewBag.permissionByDay = permissionByDay;
//İzin günü yaklaşan çalışanlar
var permissionByDayEmp = db.Permissions.Where(x => x.StartDay.Value.Day >= DateTime.Now.Day).Select(y => y.PermissionId).Count();
ViewBag.permissionByDayEmp = permissionByDayEmp;
//İzin günü bitecek çalışanlar
var permissionEndDayEmp = db.Permissions.Where(x => x.EndDay.Value.Day >= DateTime.Now.Day).Select(y => y.PermissionId).Count();
ViewBag.permissionEndDayEmp = permissionEndDayEmp;
//Günü yaklaşan ödemeler
var paymentByDay = db.Payments.Where(x => x.Date.Value.Day >= DateTime.Now.Day && x.Date.Value.Year == DateTime.Now.Year && x.Date.Value.Month == DateTime.Now.Month).Select(y => y.PaymentId).Count();
ViewBag.paymentByDay = paymentByDay;
}
return(View());
}
// GET: Task
public ActionResult Index()
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var degerler = db.Tasks.Include("Employees").ToList();
return(View(degerler));
}
}
// GET: Department
public ActionResult Index()
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var departments = db.Departments.Include("Employees").ToList();
return(View(departments));
}
}
public ActionResult GetAll()
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var degerler = db.Permissions.Include("Employees").ToList();
return(View(degerler));
}
}
// GET: Employees
public ActionResult Index()
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var degerler = db.Employees.Include("Tasks").Include("Departments").Include("Districts").ToList();
return(View(degerler));
}
}
public ActionResult ContactGet(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var con = db.Contacts.Find(id);
return(View("ContactGet", con));
}
}
public ActionResult PermissionGet(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var per = db.Permissions.Find(id);
return(View("PermissionGet", per));
}
}
public ActionResult TaskGet(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var task = db.Tasks.Find(id);
return(View("TaskGet", task));
}
}
public ActionResult NewTaskAdd(Tasks task)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
db.Tasks.Add(task);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult PaymentGet(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var pay = db.Payments.Find(id);
return(View("PaymentGet", pay));
}
}
public ActionResult NewEmployeeAdd(Employees emp)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
db.Employees.Add(emp);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult DepartmentGet(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var dep = db.Departments.Find(id);
return(View("DepartmentGet", dep));
}
}
public ActionResult NewDepartmentAdd(Departments dep)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
db.Departments.Add(dep);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult PaymentAdd(Payments pay)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
db.Employees.Find(pay.EmployeeId);
db.Payments.Add(pay);
db.SaveChanges();
return(RedirectToAction("Index", new { id = pay.EmployeeId }));
}
}
public ActionResult PaymentAdd(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
}
return(View(new Payments {
EmployeeId = id
}));
}
public ActionResult DepartmentUpdate(Departments dep)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var e = db.Departments.Find(dep.DepartmentId);
e.DepartmentName = dep.DepartmentName;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult DepartmentDelete(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var dep = db.Departments.Find(id);
db.Departments.Remove(dep);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult ContactAdd(Contacts con)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
db.Employees.Find(con.EmployeeId);
db.Contacts.Add(con);
db.SaveChanges();
return(RedirectToAction("Index", new { id = con.EmployeeId }));
}
}
public ActionResult EmployeeDelete(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var emp = db.Employees.Find(id);
db.Employees.Remove(emp);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult PermissionAdd(Permissions per)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
db.Employees.Find(per.EmployeeId);
db.Permissions.Add(per);
db.SaveChanges();
return(RedirectToAction("Index", new { id = per.EmployeeId }));
}
}
public ActionResult TaskDelete(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var task = db.Tasks.Find(id);
db.Tasks.Remove(task);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult TaskUpdate(Tasks task)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var e = db.Tasks.Find(task.TaskId);
e.TaskName = task.TaskName;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult PaymentDelete(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var pay = db.Payments.Find(id);
string paym = pay.EmployeeId.ToString();
db.Payments.Remove(pay);
db.SaveChanges();
return(RedirectToAction("Index", new { id = paym }));
}
}
// GET: Contact
public ActionResult Index(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var degerler = db.Contacts.Where(x => x.EmployeeId == id).ToList();
var empName = db.Employees.Where(x => x.EmployeeId == id).Select(y => y.FirstName)
.FirstOrDefault();
ViewBag.empName = empName;
return(View(degerler));
}
}
public ActionResult PermissionDelete(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var per = db.Permissions.Find(id);
string perm = per.EmployeeId.ToString();
db.Permissions.Remove(per);
db.SaveChanges();
return(RedirectToAction("Index", new { id = perm }));
}
}
public ActionResult ContactDelete(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var con = db.Contacts.Find(id);
string cont = con.EmployeeId.ToString();
db.Contacts.Remove(con);
db.SaveChanges();
return(RedirectToAction("Index", new { id = cont }));
}
}
public ActionResult DepartmentDetail(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var degerler = db.Employees.Where(x => x.DepartmentId == id).ToList();
var totalEmp = db.Employees.Count(x => x.DepartmentId == id).ToString();
ViewBag.totalEmp = totalEmp;
var departmentName = db.Departments.Where(x => x.DepartmentId == id).Select(y => y.DepartmentName)
.FirstOrDefault();
ViewBag.departmentName = departmentName;
return(View(degerler));
}
}
// GET: Permissions
public ActionResult Index(int id)
{
using (TekaTeknikEntities db = new TekaTeknikEntities())
{
var degerler = db.Permissions.Where(x => x.EmployeeId == id).ToList();
var perName = db.Employees.Where(x => x.EmployeeId == id).Select(y => y.FirstName)
.FirstOrDefault();
ViewBag.perName = perName;
var totalPerm = db.Permissions.Count(x => x.EmployeeId == id).ToString();
ViewBag.totalPerm = "İzin aldığı toplam gün sayısı " + totalPerm;
return(View(degerler));
}
}
