private void LoadInventory()
{
List <StockInventoryItem> lstKVA = new List <StockInventoryItem>();
List <StockVoltages> lstStockVoltages;
rblWindings.Items.Clear();
rblWindings.DataSource = StockInventoryItem.GetAllItems().Select(r => r.Windings).Distinct().ToList().OrderBy(e => e);
rblWindings.DataBind();
rblWindings.SelectedIndex = 0;
ddVoltage.Items.Clear();
lstStockVoltages = StockVoltages.GetAllItems().Where(s => s.Windings == rblWindings.Items[0].Text).ToList();
lstStockVoltages.Insert(0, new StockVoltages());
ddVoltage.DataSource = lstStockVoltages;
ddVoltage.DataTextField = "StockVoltageDisplay";
ddVoltage.DataValueField = "StockVoltage";
ddVoltage.DataBind();
ddKVA.Items.Clear();
lstKVA.Insert(0, new StockInventoryItem());
ddKVA.DataSource = lstKVA;
ddKVA.DataTextField = "sKVA";
ddKVA.DataValueField = "KVA";
ddKVA.DataBind();
}
private bool DownloadInventoryCSV()
{
int iInternal = Convert.ToInt32(Session["Internal"]);
string sRepID = Session["RepID"].ToString();
int iAgentNo = Utility.GetAgentNoFromRepID(Convert.ToInt32(sRepID));
bool bAll = rbAllAgentInventory.Checked;
bool bSearch = rbSearchAvailability.Checked;
bool bAgent = rbSelectAgentInventory.Checked;
string sKVA = ddKVA.SelectedItem.Text == "ALL" ? "0" : ddKVA.SelectedItem.Text;
string sCategory = StockVoltages.GetCategory(ddVoltage.SelectedItem.Text, rblWindings.SelectedItem.Text);
string sWinding = rblWindings.SelectedItem.Text == "Aluminum" ? "Al" : "Cu";
string sAgentWarehouse = ddlAgentsWithWarehouse.SelectedItem.Text;
InventoryReportCSV irCDV = new InventoryReportCSV(iInternal, sRepID, iAgentNo, bAll, bSearch, bAgent,
sKVA, sCategory, sWinding, sAgentWarehouse, Response, false);
return(irCDV.DownloadInventoryCSV());
}
protected void rblWindings_SelectedIndexChanged(object sender, EventArgs e)
{
List <StockInventoryItem> lstKVA = new List <StockInventoryItem>();
List <StockVoltages> lstStockVltgs;
ddVoltage.Items.Clear();
lstStockVltgs = StockVoltages.GetAllItems().Where(s => s.Windings == rblWindings.Items[rblWindings.SelectedIndex].Text).ToList();
lstStockVltgs.Insert(0, new StockVoltages());
ddVoltage.DataSource = lstStockVltgs;
ddVoltage.DataTextField = "StockVoltageDisplay";
ddVoltage.DataValueField = "StockVoltage";
ddVoltage.DataBind();
ddKVA.Items.Clear();
lstKVA.Insert(0, new StockInventoryItem());
ddKVA.DataSource = lstKVA;
ddKVA.DataTextField = "sKVA";
ddKVA.DataValueField = "KVA";
ddKVA.DataSource = lstKVA;
ddKVA.DataBind();
lblNoInventoryData.Text = "";
}
/// <summary>
/// Preview the selected report with the selected options.
/// </summary>
/// <param name="sTarget"></param>
protected void Preview(string sTarget)
{
string sRptName = "";
string sUserName = Session["UserName"].ToString();
string sAgentName = "";
int iInternal = Convert.ToInt32(Session["Internal"]);
string sAgent = "";
string sAgentCode = "";
string sError;
if (sTarget == "Performance")
{
sRptName = "PerformancePDF";
}
else if (sTarget == "Gift Card")
{
sRptName = "GiftCardPromotionPDF";
}
else if (sTarget == "Agent Stock Prices")
{
sRptName = "AgentStockPricesPDF";
}
else if (sTarget == "Pending Approvals")
{
sRptName = "AdminPendingApprovals";
}
else if (sTarget == "M1 Customer Sales")
{
sRptName = "M1CustSales";
}
else if (sTarget == "Quote Status")
{
sRptName = "QuoteStatusPDF";
}
else if (sTarget == "Inventory")
{
sRptName = "InventoryPDF";
}
else if (sTarget == "Agent Dashboard")
{
sRptName = "AgentDashboard";
}
else
{
return;
}
string sRedirect = "";
if (pnlCriteria.Visible == true)
{
if (ValidateDateRange() == true)
{
string sRepID = "";
// 0 = Current Rep - Always this choice if not Admin.
if (rblAll.SelectedValue == "0" || rblAll.Visible == false)
{
sRepID = Session["RepID"].ToString();
}
// 1 = All Reps.
else
{
sRepID = "0";
}
string sDateFrom = txtFrom.Text.ToString();
string sDateTo = txtTo.Text.ToString();
if (sTarget == "M1 Customer Sales")
{
string sProductCat = rblProductCat.SelectedValue;
if (ddlAgents.Visible == true)
{
sRepID = ddlAgents.SelectedValue;
}
else
{
sRepID = Session["MGMAgentNo"].ToString();
}
sRepID = string.IsNullOrEmpty(sRepID) ? "-1" : sRepID;
lblAgentReqd.Visible = false;
// If no rep selected, show Agent required and exit.
if (sRepID == "-1")
{
lblAgentReqd.Visible = true;
return;
}
sRedirect = "~/" + sRptName + ".aspx?AgentNo=" + sRepID + "&DateFrom=" + sDateFrom +
"&DateTo=" + sDateTo + "&ProductCat=" + sProductCat;
}
else if (sTarget == "Performance")
{
sRedirect = "~/" + sRptName + ".aspx?DateFrom=" + sDateFrom +
"&DateTo=" + sDateTo + "&RepID=" + sRepID + "&UserName="******"Quote Status")
{
sRedirect = "~/" + sRptName + ".aspx?DateFrom=" + sDateFrom +
"&DateTo=" + sDateTo + "&UserName="******"Inventory")
{
if (ddlAgentsWithWarehouse.Visible == true)
{
sRepID = ddlAgentsWithWarehouse.SelectedValue;
}
else
{
sRepID = "-1";// Session["MGMAgentNo"].ToString();
}
if (rbSelectAgentInventory.Checked)
{
sRepID = string.IsNullOrEmpty(sRepID) ? "-1" : sRepID;
lblAgentReqd.Visible = false;
// If no rep selected, show Agent required and exit.
if (sRepID == "-1")
{
lblAgentReqd.Visible = true;
return;
}
}
sAgentName = ddlAgentsWithWarehouse.Items[ddlAgentsWithWarehouse.SelectedIndex].ToString();
sRedirect = "~/" + sRptName + ".aspx?Agent=" + sRepID + "&Name=" + Server.UrlEncode(sAgentName) + "&All=" +
(rbAllAgentInventory.Checked ? "true" : "false") + "&KVA=0&VoltageCat=ALL&VoltageDisp=&Windings=&Searching=false";
if (rbSearchAvailability.Checked)
{
sRedirect = "~/" + sRptName + ".aspx?Agent=" + sRepID + "&Name=" + Server.UrlEncode(sAgentName) +
"&All=true&KVA=" + (ddKVA.SelectedItem.Text == "ALL" ? "0" : ddKVA.SelectedItem.Text) +
"&VoltageCat=" + StockVoltages.GetCategory(ddVoltage.SelectedItem.Text, rblWindings.SelectedItem.Text) +
"&VoltageDisp=" + ddVoltage.SelectedItem.Text +
"&Windings=" + (rblWindings.SelectedItem.Text == "Aluminum" ? "Al" : "Cu") +
"&Searching=true";
}
}
else if (sTarget == "Agent Dashboard")
{
int _iStartDate = Convert.ToInt32(ddlDistributorDashboardFromYear.SelectedItem.ToString());
int _iEndDate = Convert.ToInt32(ddlDistributorDashboardToYear.SelectedItem.ToString());
if (_iEndDate - _iStartDate + 1 > 6)
{
lblNotEnoughDataDashboard.Text = "Maximum 6 Years Time Span.";
return;
}
if (Convert.ToInt32(Session["Internal"]) == 1)
{
sAgent = Agent.GetAgentCode(Convert.ToInt32(ddlAgents.SelectedItem.Value), ddlAgents.SelectedItem.Text);
}
else
{
sAgent = Agent.GetAgentCode(Agent.GetMGMAgentNo(Session["RepName"].ToString()), Session["RepName"].ToString());
}
if (sAgent == "")
{
lblNotEnoughDataDashboard.Text = "Agent information not found.";
return;
}
sAgentName = Session["RepName"].ToString();
if (ddlAgents.Visible)
{
if ((ddlAgents.SelectedItem.Value == "-1") && (iInternal == 1))
{
lblInventoryExternal.ForeColor = System.Drawing.Color.Red;
lblInventoryExternal.Text = "Agent Required";
lblInventoryExternal.Visible = true;
return;
}
sAgent = ddlAgents.SelectedItem.Value;
sAgentName = ddlAgents.SelectedItem.Text;
}
if (Convert.ToInt32(Session["Internal"]) == 1)
{
sAgentCode = Agent.GetAgentCode(Convert.ToInt32(sAgent), ddlAgents.SelectedItem.Text);
}
else
{
sAgentCode = Agent.GetAgentCode(Convert.ToInt32(sAgent), sAgentName);
}
AgentDashboardPDF adPDF = new AgentDashboardPDF(new DateTime(Convert.ToInt32(ddlDistributorDashboardFromYear.SelectedItem.ToString()), 1, 1),
new DateTime(Convert.ToInt32(ddlDistributorDashboardToYear.SelectedItem.ToString()), 12, 31),
sAgentName == "All Agents" ? "All Agents" : sAgentCode, sAgentName, sAgent, "");
if (!adPDF.IsThereData)
{
lblNotEnoughDataDashboard.Text = "Not enough Data to generate Dashboard";
return;
}
else
{
if (WebConfigurationManager.AppSettings["SaveAgentDashboard"] != null &&
WebConfigurationManager.AppSettings["SaveAgentDashboard"].ToString() == "1")
{
string sURL = "Agent Dashboard - [" + sAgentName.Replace("&", "and") + "," + ddlDistributorDashboardFromYear.SelectedItem.ToString() + "," +
ddlDistributorDashboardToYear.SelectedItem.ToString() + "]" + ".pdf";
sURL = sURL.Replace("&", "and");
if (WebConfigurationManager.AppSettings["LocalMachine"] != null &&
Convert.ToBoolean(WebConfigurationManager.AppSettings["LocalMachine"]) == true)
{
if (WebConfigurationManager.AppSettings["LocalMachinePath"] == null)
{
lblDSRNoResults.Text = "No Path Setting";
return;
}
adPDF.FileName = WebConfigurationManager.AppSettings["LocalMachinePath"] + sURL;
adPDF.CreatePDF(out sError);
if (WebConfigurationManager.AppSettings["LocalWebSiteURL"] == null)
{
lblDSRNoResults.Text = "Redirect Failed.";
return;
}
ResponseHelper.Redirect(WebConfigurationManager.AppSettings["LocalWebSiteURL"] + sURL, "_blank", "");
}
else
{
adPDF.FileName = "C:\\MGMQuotation\\pdfs\\" + sURL;
adPDF.CreatePDF(out sError);
ResponseHelper.Redirect("https://MGMQuotation.MGMTransformer.com//MGMQuotation//pdfs//" + sURL, "_blank", "");
}
}
else
{
sRedirect = "~/" + sRptName + ".aspx?YearFrom=" + ddlDistributorDashboardFromYear.SelectedItem.ToString() +
"&YearTo=" + ddlDistributorDashboardToYear.SelectedItem.ToString() + "&AgentNo=" + sAgent +
"&AgentName=" + sAgentName.Replace("&", "88");
}
}
}
else
{
sRedirect = "~/" + sRptName + ".aspx?DateFrom=" + sDateFrom +
"&DateTo=" + sDateTo + "&RepID=" + sRepID;
}
}
}
else
{
sRedirect = "~/" + sRptName + ".aspx";
}
// open PDF.
ResponseHelper.Redirect(sRedirect, "_blank", "");
}