/// <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;
}
}
