My Issue is service still processing data ,but web method which i call call service method is aborted
private void Search(string time_milliseconds) { string fromdate = txtfrom.Text.Trim(); string todate = txtto.Text.Trim(); int dept = Convert.ToInt32(ddlResponsibleDept.SelectedValue.ToString()); int groupnm = Convert.ToInt32(ddlGroup.SelectedValue.ToString()); string classs = ddlClass.SelectedItem.ToString(); int contractor = Convert.ToInt32(ddlContractor.SelectedValue.ToString()); int areaobsevation = 0; int severity = Convert.ToInt32(ddlseverity.SelectedValue.ToString()); int createdby = 1; int area = Convert.ToInt32(ddlArea.SelectedValue.ToString()); int areaOfObservation = Convert.ToInt32(ddlAreaofObservation.SelectedValue.ToString()); time_millisecond = DateTime.Now.Millisecond.ToString(); DataTable data = new DataTable(); CESC_BBGS_GEN_MOB_APP_SERVICE_WS.CESC_BBGS_GEN_MOB_APP_SERVICE df = new CESC_BBGS_GEN_MOB_APP_SERVICE_WS.CESC_BBGS_GEN_MOB_APP_SERVICE(); data = df.BBGS_Get_Safety_Mis_Report(fromdate, todate, dept, areaOfObservation, classs, contractor, areaobsevation, area, severity, createdby, time_millisecond, groupnm); if (data.Rows.Count > 0) { txtNoofpeople.Text = data.Rows[0]["Noofpeopleobservedatsite"].ToString(); txtGPHr.Text = data.Rows[0]["Obs_Hr_GP"].ToString(); lblTotalMarks.Text = data.Rows[0]["Total_Cal"].ToString(); lblYesTotalMarks.Text = data.Rows[0]["TotalCalForYes"].ToString(); txtUAHr.Text = data.Rows[0]["Obs_Hr_UA"].ToString(); txtPeopleWorkingsafely.Text = data.Rows[0]["Obs_Per_working_safely"].ToString(); txtIssueclosed.Text = data.Rows[0]["Per_Issueclosed"].ToString(); grdobservationrpt.DataSource = data; grdobservationrpt.DataBind(); } else { grdobservationrpt.DataSource = null; grdobservationrpt.DataBind(); } }
-------------------------Service Method------------------------------------
[WebMethod(CacheDuration = 60, Description = "Return MIS Report")] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public DataTable BBGS_Get_Safety_Mis_Report(string fromdt, string todt, int dept, int group, string claass, int contractor, int areaobservation, int area, int Severity, int createdby, string time_millisecond, int ObsAreaId) { DataTable Dt = new DataTable("mytable"); // DataTable DtReport = new DataTable(); string RetValue = string.Empty; var data = string.Empty; try {
using (SqlConnection con = new SqlConnection(strConnString)) { using (SqlCommand cmd = new SqlCommand("VVS_BBGS_Get_Safety_ObservationDetailsReports", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FromDate", SqlDbType.NVarChar).Value = fromdt; cmd.Parameters.Add("@ToDate", SqlDbType.NVarChar).Value = todt; cmd.Parameters.Add("@Dept", SqlDbType.Int).Value = dept; cmd.Parameters.Add("@GroupID", SqlDbType.Int).Value = group; cmd.Parameters.Add("@classs", SqlDbType.NVarChar).Value = claass; cmd.Parameters.Add("@ContractorID", SqlDbType.Int).Value = contractor; cmd.Parameters.Add("@AreaOfObserv", SqlDbType.Int).Value = areaobservation; cmd.Parameters.Add("@AreaID", SqlDbType.Int).Value = area; cmd.Parameters.Add("@SeverityID", SqlDbType.Int).Value = Severity; cmd.Parameters.Add("@CreatedBy", SqlDbType.Int).Value = createdby; cmd.Parameters.Add("@time_millSecond", SqlDbType.NVarChar).Value = time_millisecond; cmd.Parameters.Add("@GroupNo", SqlDbType.Int).Value = ObsAreaId; cmd.CommandTimeout = 0;
SqlDataAdapter adp = new SqlDataAdapter(cmd); adp.Fill(Dt); }
} } catch(Exception ex) {
} if (Dt.Rows.Count > 0) {
return Dt; } else { return Dt; } }