public void addTR(int id)
{
MyContext _context = new MyContext();
TR_Leave _tr = new TR_Leave();
_tr.Leave_Data_Id = id;
_tr.Leave_Status_Id = 1;
_context.TR_Leaves.Add(_tr);
_context.SaveChanges();
}
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;
}
