public JsonResult GetCutOff(string Month, string Year)
{
List <SummaryReportSelector> t = new List <SummaryReportSelector>();
string conn = ConfigurationManager.ConnectionStrings["kalingaPPDO"].ConnectionString;
using (SqlConnection cn = new SqlConnection(conn))
{
string myQuery = "SELECT * FROM Dropdown_AttendanceCutOff WHERE CutOff LIKE @Month AND CutOff LIKE @Year";
SqlCommand cmd = new SqlCommand()
{
CommandText = myQuery,
CommandType = CommandType.Text
};
cmd.Parameters.AddWithValue("@Year", "%" + Year + "%");
cmd.Parameters.AddWithValue("@Month", "%" + Month + "%");
cmd.Connection = cn;
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
int counter = 0;
while (dr.Read())
{
SummaryReportSelector tsData = new SummaryReportSelector()
{
empAttendanceMainID = dr["empAttendanceMainID"].ToString(),
CutoffDate = dr["CutOff"].ToString(),
};
t.Add(tsData);
counter++;
}
}
}
return(Json(t, JsonRequestBehavior.AllowGet));
}
private void btnReports_Click(object sender, EventArgs e)
{
var summary = new SummaryReportSelector();
summary.mainForm = this;
summary.ShowDialog();
//tabControl1.SelectedIndex = (int)TabControlEnums.Reports;
}
