public Details LogoutGet(int id)
{
string Query = @"select * from tbl_logout where dateId='" + id + "'";
SqlConnection connection = new SqlConnection(connectionStrings);
connection.Open();
SqlCommand command = new SqlCommand(Query, connection);
SqlDataReader reader = command.ExecuteReader();
int mydateId = 0;
Details LogoutDetails =new Details();
Details LoginDetails=new Details();
while (reader.Read())
{
LogoutDetails.LogoutRemark = reader["remarks"].ToString();
LogoutDetails.LogoutTime = reader["logout_time"].ToString();
}
reader.Close();
connection.Close();
return LogoutDetails;
}
public List<Details> GetAttendanceID(int stuffId, string firstDate, string lastDate)
{
string Query = @"select * from tbl_attendance where userId='" + stuffId + "' and date between '"+DateTime.Parse(firstDate)+"' and '"+DateTime.Parse(lastDate)+"' order by date asc";
//string Query = @"select * from tbl_attendance where userId='" + stuffId + "' ";
SqlConnection connection = new SqlConnection(connectionStrings);
connection.Open();
SqlCommand command = new SqlCommand(Query, connection);
SqlDataReader reader = command.ExecuteReader();
int mydateId = 0;
List<Details> detailsList=new List<Details>();
while (reader.Read())
{
Details aDetails=new Details();
aDetails.dateId = Int32.Parse(reader["Id"].ToString());
aDetails.Date = reader["date"].ToString();
aDetails.Holiday =int.Parse( reader["holiday"].ToString());
aDetails.HolidayRemark = reader["holidayRemark"].ToString();
detailsList.Add(aDetails);
}
reader.Close();
connection.Close();
return detailsList;
}