public void BetweenDate(int id, string fromdate, string todate) { using (var db = DBConnection.CreateConnection()) { db.Open(); var sql = "dbo.GET_BETWEEN_DATE"; var cmd = new SqlCommand(sql, db); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@EMP_ID", id)); cmd.Parameters.Add(new SqlParameter("@FROM_DATE", fromdate)); cmd.Parameters.Add(new SqlParameter("@TO_DATE", todate)); var reader = cmd.ExecuteReader(); if (!reader.HasRows) { return; } while (reader.Read()) { var item = new AttendanceItem(); item.FNAME = (string)reader["FIRST_NAME"]; item.TIMEIN = (string)reader["CLOCK_IN"]; item.TIMEOUT = (string)reader["CLOCK_OUT"]; item.DATE = (string)reader["LOG_DATE"]; StaticSortedListAttendance.staticSortedList.Add(item); } db.Close(); } }
public void GetUserAttendance(int empid) { using (var db = DBConnection.CreateConnection()) { db.Open(); var sql = "dbo.GET_ATTENDANCE"; var cmd = new SqlCommand(sql, db); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@EMP_ID", empid)); var reader = cmd.ExecuteReader(); if (!reader.HasRows) { return; } while (reader.Read()) { var item = new AttendanceItem(); item.LOG_ID = (int)reader["LOG_ID"]; item.FNAME = (string)reader["FIRST_NAME"]; item.TIMEIN = (string)reader["TIME_IN"]; item.TIMEOUT = (string)reader["TIME_OUT"]; item.DATE = (string)reader["LOG_DATE"]; StaticAttendanceList.staticAttendanceList.Add(item); } db.Close(); } }
public List <AttendanceItem> GetAttendance() { List <AttendanceItem> itemList = new List <AttendanceItem>(); using (var db = DBConnection.CreateConnection()) { db.Open(); var sql = "dbo.GET_ATTENDANCE"; var cmd = new SqlCommand(sql, db); var reader = cmd.ExecuteReader(); if (!reader.HasRows) { return(null); } while (reader.Read()) { var item = new AttendanceItem(); item._LOG_ID = (int)reader["LOG_ID"]; item._EMP_ID = (int)reader["EMP_ID"]; item._TIME_IN = (string)reader["TIME_IN"]; item._TIME_OUT = (string)reader["TIME_OUT"]; item._DATE = (string)reader["DATE"]; itemList.Add(item); } db.Close(); return(itemList); } }