private void Btn_Approved_Click(object sender, RoutedEventArgs e) { MyContext _context = new MyContext(); Leave_Data _leave = new Leave_Data(); var get = _context.Leave_Datas.Max(u => u.Id); MessageBox.Show("" + get + ""); }
public bool addRequest(string NIK, DateTime StartDate, DateTime EndDate, int crnt, int lst) { MyContext _contex = new MyContext(); Leave_Data leave_data = new Leave_Data(); Employee _employee = new Employee(); TR_Leave _tr = new TR_Leave(); var result = 0; var getEmp = _contex.Employees.Find(NIK); string _name = "" + getEmp.First_Name + " " + getEmp.Last_Name + ""; leave_data.NIK = getEmp.NIK; leave_data.Name = _name; leave_data.StartDate = Convert.ToDateTime(StartDate); leave_data.EndDate = Convert.ToDateTime(EndDate); leave_data.Type_Leave_ID = 1; leave_data.CreateAt = DateTime.Now; leave_data.Manager_Id = getEmp.Manager_Id; var get = _contex.Employees.Find(NIK); get.Current_Leave_Before = get.Current_Leave_Request; get.Last_Year_Before = get.Last_Year_Request; get.Current_Leave_Request = crnt; get.Last_Year_Request = lst; _contex.Leave_Datas.Add(leave_data); result = _contex.SaveChanges(); var getMax = _contex.Leave_Datas.Max(u => u.Id); addTR(getMax); if (result > 0) { MessageBox.Show("Add Leave Request Successful!"); } else { MessageBox.Show("Add Leave Request Failed!"); } return(false); }
public History(string NIK) { InitializeComponent(); setNIK(NIK); TR_Leave _tr = new TR_Leave(); MyContext _context = new MyContext(); Leave_Data _data = new Leave_Data(); var get = _context.TR_Leaves.Join(_context.Leave_Datas, p => p.Leave_Data_Id, s => s.Id, (p, s) => new { Id = p.Id, sDate = s.StartDate, eDate = s.EndDate, type = s.Type_Leave_ID, status = p.Leave_Status_Id, _nik = s.NIK }).Where(u => u._nik == G_NIK).ToList(); DataGridHistory.ItemsSource = get; }