public async Task <IActionResult> Details([Bind("StartDate,EndDate,note,Days")] JoinEmployee_Leave JoinEmployee_Leave) { if (ModelState.IsValid) { _context.Add(JoinEmployee_Leave); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(JoinEmployee_Leave)); }
public static List <JoinEmployee_Leave> TablesColumnsDisplay() { List <JoinEmployee_Leave> EL = new List <JoinEmployee_Leave>(); string connection = "Data Source=(localdb)\\mssqllocaldb;Initial Catalog=ICONEXTContext-1;Integrated Security=True"; using (SqlConnection sqlconn = new SqlConnection(connection)) { using (SqlCommand sqlcomm = new SqlCommand("select employee.Title,employee.Name,employee.Surname,employee.Nickname,employee.Position,employee.Tel,employee.Email,employee.Active, Leave.StartDate,Leave.EndDate,Leave.note,Leave.Days from employee full join Leave on employee.ID=Leave.ID")) { using (SqlDataAdapter SDA = new SqlDataAdapter()) { sqlcomm.Connection = sqlconn; sqlconn.Open(); SDA.SelectCommand = sqlcomm; SqlDataReader SDR = sqlcomm.ExecuteReader(); while (SDR.Read()) { JoinEmployee_Leave ELOBJ = new JoinEmployee_Leave(); ELOBJ.Title = SDR["Title"].ToString(); ELOBJ.Name = SDR["Name"].ToString(); ELOBJ.Surname = SDR["Surname"].ToString(); ELOBJ.Nickname = SDR["Nickname"].ToString(); ELOBJ.Position = SDR["Position"].ToString(); ELOBJ.Tel = SDR["Tel"].ToString(); ELOBJ.Email = SDR["Email"].ToString(); ELOBJ.Active = SDR["Active"].ToString(); ELOBJ.StartDate = SDR["StartDate"].ToString(); ELOBJ.EndDate = SDR["EndDate"].ToString(); ELOBJ.note = SDR["note"].ToString(); ELOBJ.Days = SDR["Days"].ToString(); EL.Add(ELOBJ); } } return(EL); } } }