I wanted to populate the data from a query for all the dates selected in the parameters. so i wrote the below code. But when I am trying to create DataSet and Attaching the below business logic to it, Error message pops up saying data method invocation failed. Please help me with this.
[DataMethod(), AxSessionPermission(SecurityAction.Assert)]
public static DataTable AttendSummaryData(DateTime fDate, DateTime tDate)
{
AxaptaWrapper axSession = SessionManager.GetSession();
AxaptaObjectWrapper objEDPProcess = axSession.CreateAxaptaObject(“IGSEDPReportHelper”);
DataTable attendSummShrinkDT = new DataTable();
attendSummShrinkDT = CreateTableStructure();
DataTable dtASCAllRows = new DataTable();
dtASCAllRows = AxQuery.ExecuteQuery(String.Format(“Select * from {0}”, “IGS_AttendanceSummaryFinal”));
DataView dv = new DataView();
dv.Table = dtASCAllRows;
DataRow dr;
for (int intLoopCounter = 0; intLoopCounter < dv.Count; intLoopCounter++)
{
while (Convert.ToDateTime(fDate) <= Convert.ToDateTime(tDate))
{
//DateTime sDate = Convert.ToDateTime(StartDate);
dr = attendSummShrinkDT.NewRow();
dr[“fDate”] = fDate.ToShortDateString();
dr[“OrgID”] = Convert.ToString(dv[intLoopCounter][“OrgUnitID”]);
dr[“OrgName”] = Convert.ToString(dv[intLoopCounter][“OrgUnitName”]);
dr[“Location”] = Convert.ToString(dv[intLoopCounter][“Location”]);
dr[“Category”] = Convert.ToString(dv[intLoopCounter][“Category”]);
dr[“Supervisor”] = Convert.ToString(dv[intLoopCounter][“Supervisor”]);
dr[“EmplId”] = Convert.ToString(dv[intLoopCounter][“EmplId”]);
dr[“EmplName”] = Convert.ToString(dv[intLoopCounter][“EmplName”]);
attendSummShrinkDT.Rows.Add(dr);
fDate = fDate.AddDays(1);
}
}
return attendSummShrinkDT;
}
public static DataTable CreateTableStructure()
{
DataTable dtAtteSummShrinkStructure = new DataTable();
dtAtteSummShrinkStructure.Columns.Add(“OrgID”, typeof(string));
dtAtteSummShrinkStructure.Columns.Add(“OrgName”, typeof(string));
dtAtteSummShrinkStructure.Columns.Add(“Location”, typeof(string));
dtAtteSummShrinkStructure.Columns.Add(“Category”, typeof(string));
dtAtteSummShrinkStructure.Columns.Add(“Supervisor”, typeof(string));
dtAtteSummShrinkStructure.Columns.Add(“EmplId”, typeof(string));
dtAtteSummShrinkStructure.Columns.Add(“EmplName”, typeof(string));
dtAtteSummShrinkStructure.Columns.Add(“FDate”, typeof(DateTime));
return dtAtteSummShrinkStructure;
}