protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
StudentAttendance stdattend = new StudentAttendance();
GridViewAttendance.DataSource = stdattend.GetAttendance(CalendarAttendanceDate.SelectedDate.Date.ToString("yyyy-MM-dd"), Session["UserID"].ToString());
GridViewAttendance.DataBind();
}
public void loadAttendancelist()
{
List <UsersModel> list = Logic.ViewAttendance();
GridViewAttendance.DataSource = list;
GridViewAttendance.DataBind();
//if (list.Count != 0)
//{
// int totalRecords = list.Count();
// int pageSize = 5;
// int totalPages = totalRecords / pageSize;
// if (totalRecords % 5 > 0)
// {
// totalPages += 1;
// }
// StringBuilder sb = new StringBuilder();
// for (int i = 0; i < totalPages; i++)
// {
// int pageNo = i + 1;
// sb.Append("<a style=\"color: #FFFFFF\" href=\"ViewUsers.aspx?StartIndex=" + pageSize * i + "\">" + pageNo.ToString() + "</a> ");
// int GridPagingNumber = pageSize * i;
// Session["GridPagingNumber"] = GridPagingNumber;
// }
// Literal.Text = "Page: " + sb.ToString();
// GridViewAttendance.DataSource = list.Skip(StartIndex).Take(5);
// GridViewAttendance.DataBind();
//}
//else
//{
// lblNoData.Text = "There are no Users.";
// Literal.Text = " ";
//}
}
protected void viewAttendance(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["MyDbConn"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("ViewallRecordsHR", conn);
cmd.CommandType = CommandType.StoredProcedure;
DateTime FVA = Convert.ToDateTime(FromVA.Text);
DateTime TVA = Convert.ToDateTime(toVA.Text);
string EVA = EmpVA.Text;
cmd.Parameters.Add(new SqlParameter("@user_name", Session["Username"].ToString()));
cmd.Parameters.Add(new SqlParameter("@from", FVA));
cmd.Parameters.Add(new SqlParameter("@to", TVA));
cmd.Parameters.Add(new SqlParameter("@e", EVA));
conn.Open();
cmd.ExecuteNonQuery();
GridViewAttendance.EmptyDataText = "No Records Found";
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
if (ds.Tables.Count == 0)
{
GridViewAttendance.Visible = false;
Response.Write("no records");
}
else
{
GridViewAttendance.DataSource = ds;
GridViewAttendance.DataBind();
GridViewAttendance.Visible = true;
}
conn.Close();
}