private DataTable BindGridViewBySearch(ML_SanitizationReport objML_SanitizationReport)
{
DataTable dtSanitizationSGP125TData = new DataTable("GridSearch");
try
{
DataSet ds = null;
objBusinessClass = new BusinessLayer.BusinessClass();
if (objML_SanitizationReport.ReportType == "")
{
}
ds = objBusinessClass.GetSCSanitizationReportBySeacrh(objML_SanitizationReport);
if (ds.Tables.Count > 0)
{
dtSanitizationSGP125TData = ds.Tables[0];
}
}
catch (Exception ex)
{
Exception exc = ex;
}
return(dtSanitizationSGP125TData);
}
private void FillObjectToForm(long lngId, bool IsEditFlag = true)
{
objBusinessClass = new BusinessLayer.BusinessClass();
try
{
if (ViewState["ReportType"] != null && ViewState["grdSanitizationReportId"] != null)
{
string ReportType = ML_Common.string2string(ViewState["ReportType"].ToString());
lngId = ML_Common.string2Long(ViewState["grdSanitizationReportId"].ToString());
// string ReportType = ML_Common.GetDropDownValue(ddlReportTypeSearch, true);
ML_SanitizationReport objML_SanitizationReport = objBusinessClass.GetSCSanitizationResultByReportTypeandId(lngId, ReportType);
if (objML_SanitizationReport != null)
{
//ViewState["SanitizationResultId"] = objML_SanitizationReport.SanitizationResultId;
//ViewState["SanitizationStartDate"] = objML_SanitizationReport.SanitizationStartDate;
//ViewState["SanitizationEndDate"] = objML_SanitizationReport.SanitizationEndDate;
//FillGridForData();
ShowReport(objML_SanitizationReport.Id, objML_SanitizationReport.ReportType);
}
//UpdatePanelGridResult.Update();
}
}
catch (Exception ex)
{
Exception exc = ex;
}
}
private DataTable BindGridViewByResult(ML_SanitizationReport objML_SanitizationReport)
{
DataTable dtSanitizationSGP125TResult = new DataTable("GridSearch");
try
{
objBusinessClass = new BusinessLayer.BusinessClass();
DataSet ds = null;// objBusinessClass.GetSanitizationSGP125TResultBySeacrh(objML_SanitizationReport);
if (ds.Tables.Count > 0)
{
dtSanitizationSGP125TResult = ds.Tables[0];
}
}
catch (Exception ex)
{
Exception exc = ex;
}
return(dtSanitizationSGP125TResult);
}
private void FillGrid()
{
try
{
DataTable DtList = null;
ML_SanitizationReport objML_SanitizationReportSearch = new ML_SanitizationReport();
if (ddlReportTypeSearch.SelectedIndex > 0 && !string.IsNullOrEmpty(txtFromDateSearch.Text) && !string.IsNullOrEmpty(txtToDateSearch.Text))
{
objML_SanitizationReportSearch.ReportType = ML_Common.GetDropDownValue(ddlReportTypeSearch, true);
objML_SanitizationReportSearch.TagStatus = null;
DateTime FromDateSearch = ML_Common.ToDateTimeSafe(txtFromDateSearch.Text);
DateTime ToDateSearch = ML_Common.ToDateTimeSafe(txtToDateSearch.Text);
var FromTimeSearch = TimeSpan.Parse("00:00:00");
var FromFullDt = FromDateSearch + FromTimeSearch; // 2010-06-26 01:16:50
var ToTimeSearch = TimeSpan.Parse("23:59:59");
var ToFullDt = ToDateSearch + ToTimeSearch; // 2010-06-26 01:16:50
var From24Hour = FromFullDt.ToString("MM/dd/yyyy HH:mm:ss", CultureInfo.CurrentCulture);
var To24Hour = ToFullDt.ToString("MM/dd/yyyy HH:mm:ss", CultureInfo.CurrentCulture);
objML_SanitizationReportSearch.FromDate = ML_Common.ToDateTimeSafeNull(From24Hour.ToString());
objML_SanitizationReportSearch.ToDate = ML_Common.ToDateTimeSafeNull(To24Hour.ToString());
DtList = BindGridViewBySearch(objML_SanitizationReportSearch);
}
if (DtList != null)
{
//DtList = (DataTable)ViewState["grdSanitizationReportTM"];
if (DtList.Rows.Count > 0)
{
grdSanitizationReport.DataSource = DtList;
grdSanitizationReport.DataBind();
}
else
{
DtList.Rows.Add(DtList.NewRow());
grdSanitizationReport.DataSource = DtList;
grdSanitizationReport.DataBind();
int TotalColumns = grdSanitizationReport.Rows[0].Cells.Count;
grdSanitizationReport.Rows[0].Cells.Clear();
grdSanitizationReport.Rows[0].Cells.Add(new TableCell());
grdSanitizationReport.Rows[0].Cells[0].ColumnSpan = TotalColumns;
grdSanitizationReport.Rows[0].Cells[0].Text = "No Record Found";
}
UpdatePanelGrid.Update();
}
}
catch (Exception ex)
{
Exception exc = ex;
}
}
