/// <summary> /// Fetch PreOrder Data based on the dropdown selection /// </summary> private void GetDatabyDate_Project_Buyer_PMDL() { objWorkFlow = new WorkFlow(); DataTable dt = new DataTable(); DataTable dtAllReceiptStatus = new DataTable(); if (ddlProjectFrom.SelectedValue != "Select" && ddlProjectTo.SelectedValue != "Select") { objWorkFlow.ProjectFrom = ddlProjectFrom.SelectedValue; objWorkFlow.ProjectTo = ddlProjectTo.SelectedValue; } else { objWorkFlow.ProjectFrom = ""; objWorkFlow.ProjectTo = "ZZZZZZ"; } if (ddlBuyerFrom.SelectedValue != "Select" && ddlBuyerTo.SelectedValue != "Select") { objWorkFlow.BuyerFrom = ddlBuyerFrom.SelectedValue; objWorkFlow.BuyerTo = ddlBuyerTo.SelectedValue; } else { objWorkFlow.BuyerFrom = "00000"; objWorkFlow.BuyerTo = "99999"; } if (ddlPMDLDocFrom.SelectedValue != "Select" && ddlPMDLDocTo.SelectedValue != "Select") { if (ddlPMDLDocFrom.SelectedValue.Contains(",") || ddlPMDLDocTo.SelectedValue.Contains(",")) { if (ddlPMDLDocFrom.SelectedValue.Contains(",")) { string[] PMDLFrom = ddlPMDLDocFrom.SelectedValue.Split('\''); objWorkFlow.PMDLFrom = PMDLFrom[0]; } else { objWorkFlow.PMDLFrom = ddlPMDLDocFrom.SelectedValue; } if (ddlPMDLDocFrom.SelectedValue.Contains(",")) { string[] PMDLTo1 = ddlPMDLDocTo.SelectedValue.Split(','); string[] PMDLTo = PMDLTo1[PMDLTo1.Length - 1].Split('\''); objWorkFlow.PMDLTo = PMDLTo[1]; } else { objWorkFlow.PMDLTo = ddlPMDLDocFrom.SelectedValue; } } else { objWorkFlow.PMDLFrom = ddlPMDLDocFrom.SelectedValue; objWorkFlow.PMDLTo = ddlPMDLDocTo.SelectedValue; } } else { objWorkFlow.PMDLFrom = ""; objWorkFlow.PMDLTo = "ZZZZZZ"; } if (txtDateFrom.Text != "" && txtDateTo.Text != "") { objWorkFlow.DateFrom = txtDateFrom.Text; objWorkFlow.DateTo = txtDateTo.Text; dt = objWorkFlow.GetPreOrderDocumentTracking_byProject_Buyer_Date_PMDL(); } else { dt = objWorkFlow.GetPreOrderDocumentTracking_byProject_Buyer_PMDL(); } foreach (DataRow dr in dt.Rows) { if (dr["ReceiptNo"].ToString() != null && dr["ReceiptNo"].ToString() != "") { string sReceiptNumber = dr["ReceiptNo"].ToString(); string ReceiptStatus = objWorkFlow.GetReceiptStatus(sReceiptNumber); dr["ReceiptStatus"] = ReceiptStatus; } } if (dt.Rows.Count > 0) { gvData.Visible = true; lblChild.Visible = true; lblParent.Visible = true; lblNoRecord.Visible = false; gvData.DataSource = dt; gvData.RowDataBound += new GridViewRowEventHandler(gvData_RowDataBound); gvData.DataBind(); } else { gvData.Visible = false; lblChild.Visible = false; lblParent.Visible = false; lblNoRecord.Visible = true; } }