public static ViewAttendanceByDate_EL ViewAttendanceByDateInput()
{
Console.WriteLine("Enter the date (mm/dd/yy) to view attedance:");
ViewAttendanceByDate_EL vtbd = new ViewAttendanceByDate_EL();
vtbd.AttendanceDate = DateTime.Parse(Console.ReadLine());
return(vtbd);
}
public static void ViewAttendanceByDate(ViewAttendanceByDate_EL e)
{
//write code to view Attendance of employees of a particular project for a particular date.
//take attendance from attendance table for the dates during which the project works.
using (SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-8HC3KF0;Initial Catalog=ALMS;Integrated Security=True;"))
{
SqlDataReader rd;
SqlCommand cmd = new SqlCommand
{
CommandText = "ViewAttendanceByDate",
Connection = con,
CommandType = CommandType.StoredProcedure,
};
//passing values to sql parameter
cmd.Parameters.AddWithValue("@AttendanceDate", e.AttendanceDate);
try
{
con.Open();
using (rd = cmd.ExecuteReader())
{
while (rd.Read())
{
Console.WriteLine("EmpId:{0} AttendanceDate:{1} AttendanceStatus:{2}", rd["EmpId"], rd["AttendanceDate"], rd["AttendanceStatus"]);
}
}
rd.Close();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
}
