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; }