protected void btnExport_Click(object sender, EventArgs e)
{
GridViewExport objExport = new GridViewExport();
objExport.ExportGridView(hdnExport.Value);
}
protected void btnExport_Click(object sender, EventArgs e)
{
string str = "";
string strParameter = "";
GridViewExport objExport = new GridViewExport();
strParameter = strParameter + getchkList(chkModelCodeList, "Model");
strParameter = strParameter + getchkList(chkCategory, "Category");
strParameter = strParameter + getchkList(chkClutchType, "ClutchType");
strParameter = strParameter + getchkList(chkSpecialList, "Special");
str = str + "<table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr><td style='font-size:small;font-weight:bold;'>Report For:</td><td style='font-size:small;font-weight:bold;'>Budget Report</td></tr>";
str = str + "</table>";
str = str + strParameter;
str = str + "<br/><table width='50%' border='1' cellpadding='0' cellspacing='0'>";
if (rdoData.SelectedValue == "0")
{
str = str + "<tr><td style='font-size:small;font-weight:bold;'>" + rdoData.SelectedItem.Text.ToString() + "</td></tr>";
str = str + "<tr><td >Place:</td>";
if (rdoAlwar.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoAlwar.Text.ToString() + "</td>";
}
else if (rdoBhopal.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoBhopal.Text.ToString() + "</td>";
}
else if (rdoAllPlace.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoAllPlace.Text.ToString() + "</td>";
}
str = str + "</tr>";
}
else if (rdoData.SelectedValue == "1")
{
str = str + "<tr><td style='font-size:small;font-weight:bold;'>" + rdoData.SelectedItem.Text.ToString() + "</td></tr>";
str = str + "<tr><td >Engine:</td>";
if (rdoAlwarEngine.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoAlwarEngine.Text.ToString() + "</td>";
}
else if (rdoSimpsonEngine.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoSimpsonEngine.Text.ToString() + "</td>";
}
else if (rdoBothEngine.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoBothEngine.Text.ToString() + "</td>";
}
str = str + "</tr>";
}
else
{
str = str + "<tr><td style='font-size:small;font-weight:bold;'>" + rdoData.SelectedItem.Text.ToString() + "</td></tr>";
}
str = str + "<tr><td >Year:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoYear.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td></tr>";
str = str + "</table><br/>";
hdnExport.Value = str + hdnExport.Value;
objExport.ExportGridView(hdnExport.Value);
}
/*******************************Exporting Record Into Excel*****************************************/
protected void Button1_Click(object sender, EventArgs e)
{
string str = "";
string strParameter = "";
GridViewExport objExport = new GridViewExport();
strParameter = getchkList(chkDefectCode, "GroupName");
str = str + "<table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr><td style='font-size:small;font-weight:bold;'>Report For:</td><td style='font-size:small;font-weight:bold;'>Defect Group Wise ACR Detail</td></tr>";
str = str + "<tr><td >Item Group:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + strParameter + "</td></tr>";
str = str + "<tr><td >From Date:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + txtFromDate.Text.ToString() + "</td>";
//str = str + "<td style='font-size:small;font-weight:bold;'>" + drpFromYear.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td>";
str = str + " <td>To Date:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + txtToDate.Text.ToString() + "</td></tr>";
//str = str + "<td style='font-size:small;font-weight:bold;'>" + drpToYear.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td>";
if (rdoData.SelectedValue == "0")
{
str = str + "<tr><td style='font-size:small;font-weight:bold;'>" + rdoData.SelectedItem.Text.ToString() + "</td></tr>";
str = str + "<tr><td >Place:</td>";
if (rdoAlwar.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoAlwar.Text.ToString() + "</td>";
}
else if (rdoBhopal.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoBhopal.Text.ToString() + "</td>";
}
else if (rdoAllPlace.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoAllPlace.Text.ToString() + "</td>";
}
str = str + "</tr>";
}
else if (rdoData.SelectedValue == "1")
{
str = str + "<tr><td style='font-size:small;font-weight:bold;'>" + rdoData.SelectedItem.Text.ToString() + "</td></tr>";
str = str + "<tr><td >Engine:</td>";
if (rdoAlwarEngine.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoAlwarEngine.Text.ToString() + "</td>";
}
else if (rdoSimpsonEngine.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoSimpsonEngine.Text.ToString() + "</td>";
}
else if (rdoBothEngine.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoBothEngine.Text.ToString() + "</td>";
}
str = str + "</tr>";
}
else
{
str = str + "<tr><td style='font-size:small;font-weight:bold;'>" + rdoData.SelectedItem.Text.ToString() + "</td></tr>";
}
str = str + "<tr><td >Problem Type:</td>";
if (rdoPrimary.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoPrimary.Text.ToString() + "</td>";
}
else if (rdoConsequences.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoConsequences.Text.ToString() + "</td>";
}
else if (rdoAllProblem.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoAllProblem.Text.ToString() + "</td>";
}
str = str + "<td >Year:</td>";
if (rdoFirst.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoFirst.Text.ToString() + "</td>";
}
else if (rdoSecond.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoSecond.Text.ToString() + "</td>";
}
else if (rdoBothYear.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoBothYear.Text.ToString() + "</td></tr>";
}
str = str + "</table><br/>";
hdnExport.Value = str + hdnExport.Value;
objExport.ExportGridView(hdnExport.Value);
}
protected void btnExport_Click(object sender, EventArgs e)
{
string str = "";
string strParameter = "";
GridViewExport objExport = new GridViewExport();
strParameter = strParameter + getchkList(chkModelCodeList, "Model");
strParameter = strParameter + getchkList(chkCategory, "Category");
strParameter = strParameter + getchkList(chkClutchType, "ClutchType");
strParameter = strParameter + getchkList(chkSpecialList, "Special");
str = str + "<table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr><td style='font-size:small;font-weight:bold;'>Report For:</td><td style='font-size:small;font-weight:bold;'>Production</td></tr>";
str = str + "</table><br/>";
str = str + strParameter;
hdnExport.Value = str + hdnExport.Value;
objExport.ExportGridView(hdnExport.Value);
}
protected void btnExport_Click(object sender, EventArgs e)
{
string str = "";
string strParameter = "";
GridViewExport objExport = new GridViewExport();
strParameter = strParameter + getchkList(chkModelCodeList, "Model");
strParameter = strParameter + getchkList(chkCategory, "Category");
strParameter = strParameter + getchkList(chkClutchType, "ClutchType");
strParameter = strParameter + getchkList(chkSpecialList, "Special");
str = str + "<table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr><td style='font-size:small;font-weight:bold;'>Report For:</td><td style='font-size:small;font-weight:bold;'>Failure Per 1000 Tractors</td></tr>";
str = str + "<tr><td style='font-size:small;font-weight:bold;'>" + rdoReportType.SelectedItem.Text.ToString() + "</td></tr>";
str = str + "</table>";
str = str + strParameter;
str = str + "<br/><table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr>";
str = str + "<td >Item Group:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpItemGroup.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td></tr>";
str = str + "</table>";
str = str + getchkList(Chkitemlist, "Item");
str = str + "<br/><table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr>";
str = str + "<td >From Month:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpFromMonth.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td>";
str = str + " <td>To Month:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpToMonth.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td>";
str = str + "<tr><td >Problem Type:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoProblemType.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td></tr>";
str = str + "</table><br/>";
hdnExport.Value = str + hdnExport.Value;
objExport.ExportGridView(hdnExport.Value);
}
/*******************************Exporting Record Into Excel*****************************************/
protected void Button1_Click(object sender, EventArgs e)
{
string str = "";
string strParameter = "";
GridViewExport objExport = new GridViewExport();
str = str + "<table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr><td style='font-size:small;font-weight:bold;'>Report For:</td><td style='font-size:small;font-weight:bold;'>Chassis Wise ACR Detail</td></tr>";
str = str + "<tr><td > Chassis:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + txtChassisNo.Text.ToString() + "</td></tr>";
if (rdoData.SelectedValue == "0")
{
str = str + "<tr><td style='font-size:small;font-weight:bold;'>" + rdoData.SelectedItem.Text.ToString() + "</td></tr>";
str = str + "<tr><td >Place:</td>";
if (rdoAlwar.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoAlwar.Text.ToString() + "</td>";
}
else if (rdoBhopal.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoBhopal.Text.ToString() + "</td>";
}
else if (rdoAllPlace.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoAllPlace.Text.ToString() + "</td>";
}
str = str + "</tr>";
}
else if (rdoData.SelectedValue == "1")
{
str = str + "<tr><td style='font-size:small;font-weight:bold;'>" + rdoData.SelectedItem.Text.ToString() + "</td></tr>";
str = str + "<tr><td >Engine:</td>";
if (rdoAlwarEngine.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoAlwarEngine.Text.ToString() + "</td>";
}
else if (rdoSimpsonEngine.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoSimpsonEngine.Text.ToString() + "</td>";
}
else if (rdoBothEngine.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoBothEngine.Text.ToString() + "</td>";
}
str = str + "</tr>";
}
else
{
str = str + "<tr><td style='font-size:small;font-weight:bold;'>" + rdoData.SelectedItem.Text.ToString() + "</td></tr>";
}
str = str + "<tr><td >Problem Type:</td>";
if (rdoPrimary.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoPrimary.Text.ToString() + "</td>";
}
else if (rdoConsequences.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoConsequences.Text.ToString() + "</td>";
}
else if (rdoAllProblem.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoAllProblem.Text.ToString() + "</td>";
}
str = str + "<td >Year:</td>";
if (rdoFirst.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoFirst.Text.ToString() + "</td>";
}
else if (rdoSecond.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoSecond.Text.ToString() + "</td>";
}
else if (rdoBothYear.Checked)
{
str = str + "<td style='font-size:small;font-weight:bold;'>" + rdoBothYear.Text.ToString() + "</td></tr>";
}
str = str + "</table><br/>";
hdnExport.Value = str + hdnExport.Value;
objExport.ExportGridView(hdnExport.Value);
}
protected void btnExport_Click(object sender, EventArgs e)
{
string str = "";
string strParameter = "";
GridViewExport objExport = new GridViewExport();
strParameter = strParameter + getchkList(chkModelCodeList, "Model");
strParameter = strParameter + getchkList(chkCategory, "Category");
strParameter = strParameter + getchkList(chkClutchType, "ClutchType");
strParameter = strParameter + getchkList(chkSpecialList, "Special");
strParameter = strParameter + getchkList(chkRegion, "Region");
str = str + "<table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr><td style='font-size:small;font-weight:bold;'>Report For:</td><td style='font-size:small;font-weight:bold;'> Tractor Under Warranty</td></tr>";
str = str + "</table>";
str = str + strParameter;
str = str + "<br/><table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr><td >From Period:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpFromMonth.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpFromYear.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td>";
str = str + " <td>To Period:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpToMonth.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpToYear.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td></tr>";
str = str + "</table><br/>";
hdnExport.Value = str + hdnExport.Value;
objExport.ExportGridView(hdnExport.Value);
}
protected void Button1_Click(object sender, EventArgs e)
{
GridViewExport objExport = new GridViewExport();
hdnExport.Value = strValue + hdnExport.Value;
objExport.ExportGridView(hdnExport.Value);
}
protected void btnExport_Click(object sender, EventArgs e)
{
string str = "";
string strParameter = "";
GridViewExport objExport = new GridViewExport();
strParameter = strParameter + getchkList(chkModelCodeList, "Model");
strParameter = strParameter + getchkList(chkCategory, "Category");
strParameter = strParameter + getchkList(chkClutchType, "ClutchType");
strParameter = strParameter + getchkList(chkSpecialList, "Special");
str = str + "<table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr><td style='font-size:small;font-weight:bold;'>Report For:</td><td style='font-size:small;font-weight:bold;'>Sales Summary</td></tr>";
str = str + "</table>";
str = str + strParameter;
str = str + "<br/><table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr><td >From Period:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpFromMonth.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpFromYear.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td>";
str = str + " <td>To Period:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpToMonth.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpToYear.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td>";
str = str + "<td >Region:</td>";
str = str + "<td style='font-size:small;font-weight:bold;'>" + drpRegion.SelectedItem.Text.ToString().Replace("Select All", "All") + "</td></tr>";
str = str + "</table><br/>";
hdnExport.Value = str + hdnExport.Value;
//hdnExport.Value = objExport.RemoveComponent("id=ctl00_ContentPlaceHolder1_chk", "checkbox ", hdnExport.Value);
objExport.ExportGridView(hdnExport.Value);
}
protected void btnExport_Click(object sender, EventArgs e)
{
string str = "";
string strParameter = "";
GridViewExport objExport = new GridViewExport();
strParameter = strParameter + getchkList(chkModelCodeList, "Model");
strParameter = strParameter + getchkList(chkCategory, "Category");
strParameter = strParameter + getchkList(chkClutchType, "ClutchType");
strParameter = strParameter + getchkList(chkSpecialList, "Special");
str = str + "<table width='50%' border='1' cellpadding='0' cellspacing='0'>";
str = str + "<tr><td style='font-size:small;font-weight:bold;'>Report For:</td><td style='font-size:small;font-weight:bold;'>Sales</td></tr>";
str = str + "</table><br/>";
str = str + strParameter;
hdnExport.Value = str + hdnExport.Value;
//hdnExport.Value = objExport.RemoveComponent("id=ctl00_ContentPlaceHolder1_chk", "checkbox ", hdnExport.Value);
objExport.ExportGridView(hdnExport.Value);
}
