//[ScriptMethod(ResponseFormat = ResponseFormat.Json)] //public List<RevenueEntities> MPL1Data(string Fromdate, string Fromtime, string Todate, string Totime) public string MPL1Data(string strGraph, string Fromdate, string Fromtime, string Todate, string Totime) { DataTable table = new DataTable(); ApplicationResult objResult = new ApplicationResult(); TempratureTrendBL objTempTrendBL = new TempratureTrendBL(); DateTime dtFromDateTime = DateTime.ParseExact(Fromdate + " " + Fromtime, "dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); DateTime dtToDateTime = DateTime.ParseExact(Todate + " " + Totime, "dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); //DateTime dtFromDateTime = Convert.ToDateTime("28/10/2018 12:10:20"); //DateTime dtToDateTime = Convert.ToDateTime("30/10/2018 12:10:20"); objResult = objTempTrendBL.GetALl_TemperatureTrendData(dtFromDateTime, dtToDateTime, strGraph); if (objResult != null) { if (objResult.ResutlDs.Tables.Count > 0) { table = objResult.ResutlDs.Tables[0]; } } string strJsonResult = JsonConvert.SerializeObject(table, Newtonsoft.Json.Formatting.Indented); //return JsonConvert.SerializeObject(objResult.ResutlDs.Tables[0]); string j = JsonConvert.SerializeObject(objResult.ResutlDs.Tables[0]); return(j); }
public void BindReportData() { try { ApplicationResult objResult = new ApplicationResult(); DateTime dtFromDateTime = DateTime.ParseExact(txtFromDate.Text + " " + txtFromTime.Text, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); DateTime dtToDateTime = DateTime.ParseExact(txtToDate.Text + " " + txtToTime.Text, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture); int intGraphId = Convert.ToInt32(ddlPasteuriser.SelectedValue.ToString()); // objResult = new MilkReceptionBL().MilkReception_SelectAll(dtFromDateTime, dtToDateTime, Convert.ToInt32(ddlShiftNo.SelectedValue), Convert.ToInt32(ddlTankerID.SelectedValue), Convert.ToDouble(ddlReceptionLineNo.SelectedValue), Convert.ToDouble(ddlSILONo.SelectedValue)); objResult = new TempratureTrendBL().GetALl_TemperatureTrendDataReport(dtFromDateTime, dtToDateTime, intGraphId); //ViewState["DataTableMilkStorage"] = objResult.ResutlDs.Tables[0]; gvTrendData.DataSource = null; gvTrendData.DataBind(); gvTrendData.DataSource = objResult.ResultDt; gvTrendData.DataBind(); //gvTotalQty.DataSource = objResult.ResutlDs.Tables[1]; //gvTotalQty.DataBind(); if (gvTrendData.Rows.Count > 1) { imgbtnPDF.Visible = imgbtnExcel.Visible = divNo.Visible = true; divNo.Visible = false; if (Convert.ToInt32(ddlPasteuriser.SelectedValue.ToString()) == 1) { lblHeader1.Text = "MPL-1 Temperature Report"; lblHeader2.Text = "MPL-1 Temperature Report"; } else if (Convert.ToInt32(ddlPasteuriser.SelectedValue.ToString()) == 2) { lblHeader1.Text = "MPL-2 Temperature Report"; lblHeader2.Text = "MPL-2 Temperature Report"; } else if (Convert.ToInt32(ddlPasteuriser.SelectedValue.ToString()) == 3) { lblHeader1.Text = "CPL Temperature Report"; lblHeader2.Text = "CPL Temperature Report"; } else if (Convert.ToInt32(ddlPasteuriser.SelectedValue.ToString()) == 4) { lblHeader1.Text = "Curd Temperature Report"; lblHeader2.Text = "Curd Temperature Report"; } else if (Convert.ToInt32(ddlPasteuriser.SelectedValue.ToString()) == 5) { lblHeader1.Text = "BM Temperature Report"; lblHeader2.Text = "BM Temperature Report"; } else if (Convert.ToInt32(ddlPasteuriser.SelectedValue.ToString()) == 6) { lblHeader1.Text = "MPLBM Temperature Report"; lblHeader2.Text = "MPLBM Temperature Report"; } } else { imgbtnPDF.Visible = imgbtnExcel.Visible = divNo.Visible = false; divNo.Visible = true; gvTrendData.DataSource = null; gvTrendData.DataBind(); // ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", //"<script>alert('No Record Found.');</script>"); } } catch (Exception ex) { log.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>"); } }