protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if ((Request.QueryString["id"] != "") && (Request.QueryString["id"] != null))
{
try
{
DataRow objDataRow = MatrimonialSales.GetInvoice(Request.QueryString["id"]).Rows[0];
L_CoustmerName_1.Text = objDataRow["Name"].ToString();
L_CoustmerAddress_.Text = objDataRow["Name"].ToString();
L_Price_1.Text = objDataRow["Amount"].ToString();
L_Price_2.Text = objDataRow["Amount"].ToString();
L_Price_3.Text = objDataRow["Amount"].ToString();
L_PlanName.Text = objDataRow["PlanName"].ToString();
L_LifeTime.Text = objDataRow["Duration"].ToString();
DateTime dateTemp = Convert.ToDateTime(objDataRow["DateOfParches"]);
L_Date.Text = dateTemp.Day.ToString() + ":" + dateTemp.Month.ToString() + ":" + dateTemp.Year.ToString();
L_SelNo.Text = objDataRow["SerialNo"].ToString();
}
catch (Exception)
{
Server.Transfer("~/Extras/ErrorReport.aspx");
}
}
else
{
Server.Transfer("~/Extras/ErrorReport.aspx?id=405");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable objDataTable = MatrimonialSales.GetSalesReport();
DB2Excel objExport = new DB2Excel();
objExport.Export(objDataTable, DB2Excel.ExportFormat.Excel, "Query_Results_." + DateTime.Now.ToShortDateString() + ".xls");
Server.Transfer("~/Admin/Protected/SaleReport.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
//onmouseover="this.bgColor='gold';" onmouseout="this.bgColor='#FFFFFF';"
if (!IsPostBack)
{
this.Title = "Matrimonial Sales Report";
DataTable objDataTable = MatrimonialSales.GetSalesReport();
//>1
if (objDataTable != null)
{
LiteralControl objLiteralControl;
TableCell objTableCell;
DateTime dateTemp;
//Loading Coloum Contans
foreach (DataRow objDataRow in objDataTable.Rows)
{
TableRow objTableRow = new TableRow();
Table_View.Rows.Add(objTableRow);
//Coloum 1
HyperLink newHyperLink = new HyperLink();
newHyperLink.NavigateUrl = "~/MyProfile/" + objDataRow["MatrimonialID"].ToString() + ".aspx";
newHyperLink.Text = objDataRow["Name"].ToString();
newHyperLink.Target = "_Blank";
newHyperLink.NavigateUrl = "~/Member/PrintProfile.aspx?id=" + Server.UrlEncode(objDataRow["MatrimonialID"].ToString());
objTableCell = new TableCell();
objTableCell.Controls.Add(newHyperLink);
objTableCell.HorizontalAlign = HorizontalAlign.Center;
objTableCell.VerticalAlign = VerticalAlign.Middle;
objTableRow.Cells.Add(objTableCell);
//Coloum 2 Message
objLiteralControl = new LiteralControl(objDataRow["Address"].ToString());
objTableCell = new TableCell();
objTableCell.Controls.Add(objLiteralControl);
objTableRow.Cells.Add(objTableCell);
//Coloum 3 Message
objLiteralControl = new LiteralControl(objDataRow["Amount"].ToString());
objTableCell = new TableCell();
objTableCell.Controls.Add(objLiteralControl);
objTableRow.Cells.Add(objTableCell);
//Coloum 4 Message
dateTemp = Convert.ToDateTime(objDataRow["DateOfParches"]);
objLiteralControl = new LiteralControl(dateTemp.Day.ToString() + ":" + dateTemp.Month.ToString() + ":" + dateTemp.Year.ToString());
objTableCell = new TableCell();
objTableCell.Controls.Add(objLiteralControl);
objTableRow.Cells.Add(objTableCell);
//Coloum 5
newHyperLink = new HyperLink();
newHyperLink.Attributes.Add("style", "cursor: pointer;");
newHyperLink.Text = "Invoice";
newHyperLink.Attributes.Add("onclick", "newWindow('invoice.aspx?id=" + objDataRow["MatrimonialID"].ToString() + "','','790','500')");
objTableCell = new TableCell();
objTableCell.Controls.Add(newHyperLink);
objTableCell.HorizontalAlign = HorizontalAlign.Center;
objTableCell.VerticalAlign = VerticalAlign.Middle;
objTableRow.Cells.Add(objTableCell);
// Link To Delete The SStory
}
}
}
}
protected string DrowChart()
{
//Creating Data XML
string strRetrun = "<table><tr><td>";
string strXML = null;
string[] strAColour = { "AFD8F8", "F6BD0F", "8BBA00", "FF8E46", "008E8E", "D64646", "8E468E", "588526", "B3AA00", "008ED6", "9D080D", "A186BE" };
switch (ChartType)
{
case "1":
this.objDataTable = MatrimonialSales.GetMatrimonialUserStatis();
strXML = "";
strXML += "<graph caption='Matrimonial Member Ratio' xAxisName='' yAxisName='' decimalPrecision='0' formatNumberScale='0'>";
strXML += "<set name='Paid Members' value='" + objDataTable.Rows[0]["PAIDMEMBERS"].ToString() + "' color='F6BD0F'/>";
strXML += "<set name='Free Members' value='" + objDataTable.Rows[0]["ACTIVE"].ToString() + "' color='588526'/>";
strXML += "<set name='Inactive Members' value='" + objDataTable.Rows[0]["INACTIVE"].ToString() + "' color='9D080D'/>";
strXML += "</graph>";
//Pie Digram
strRetrun += FusionCharts.RenderChart("../../Chart/Chart3DPie.swf", "", strXML, "MatrimonialSiteStatics_1", "350", "350", false, false);
strRetrun += "</td><td>";
strXML = "";
strXML += "<graph caption='Matrimonial Male Female Ratio' xAxisName='' yAxisName='' decimalPrecision='0' formatNumberScale='0'>";
strXML += "<set name='Male Members' value='" + this.objDataTable.Rows[0]["MALE"].ToString() + "' color='008E8E'/>";
strXML += "<set name='Female Members' value='" + this.objDataTable.Rows[0]["FEMALE"].ToString() + "' color='9D080D'/>";
strXML += "</graph>";
strRetrun += FusionCharts.RenderChart("../../Chart/Chart3DPie.swf", "", strXML, "MatrimonialSiteStatics_2", "350", "350", false, false);
break;
case "2":
//Members Registrade as paid members
strXML = "";
this.objDataTable = MatrimonialSales.GetUserStatis(MatrimonialSales.DetailsType.PaidMember);
strXML += "<graph caption='Matrimonial Sales' xAxisName='Month' yAxisName='Paid Members Registerd' decimalPrecision='0' formatNumberScale='0'>";
for (int intIncreminenter = 11; intIncreminenter >= 0; --intIncreminenter)
{
DataRow objDataRow = this.objDataTable.Rows[intIncreminenter];
strXML += "<set name='" + objDataRow["Index_Name"].ToString().Substring(0, 3) + "' value='" + objDataRow["Member_Count"].ToString() + "' color='" + strAColour[intIncreminenter] + "'/>";
}
strXML += "</graph>";
//Paid user 3D
//3D Chart
strRetrun = FusionCharts.RenderChart("../../Chart/Chart3DBlock.swf", "", strXML, "myNext", "600", "300", false, false);
break;
case "3":
// Total Members Details
strXML = "";
this.objDataTable = MatrimonialSales.GetUserStatis(MatrimonialSales.DetailsType.TotalUser);
strXML += "<graph caption='Matrimonial Sales' xAxisName='Month' yAxisName='Members Joined' decimalPrecision='0' formatNumberScale='0'>";
for (int intIncreminenter = 11; intIncreminenter >= 0; --intIncreminenter)
{
DataRow objDataRow = this.objDataTable.Rows[intIncreminenter];
strXML += "<set name='" + objDataRow["Index_Name"].ToString().Substring(0, 3) + "' value='" + objDataRow["Member_Count"].ToString() + "' color='" + strAColour[intIncreminenter] + "'/>";
}
strXML += "</graph>";
//Paid user 3D
//3D Chart
strRetrun = FusionCharts.RenderChart("../../Chart/Chart2DBlock.swf", "", strXML, "myNext", "600", "300", false, false);
break;
case "4":
strXML = "";
this.objDataTable = MatrimonialSales.GetUserStatis(MatrimonialSales.DetailsType.Sales); //.GetSalesStatis();
strXML += "<graph caption='Matrimonial Sales' xAxisName='Month' yAxisName='Sales in Rs' decimalPrecision='0' formatNumberScale='0'>";
for (int intIncreminenter = 11; intIncreminenter >= 0; --intIncreminenter)
{
DataRow objDataRow = this.objDataTable.Rows[intIncreminenter];
strXML += "<set name='" + objDataRow["Index_Name"].ToString().Substring(0, 3) + "' value='" + objDataRow["Member_Count"].ToString() + "' color='" + strAColour[intIncreminenter] + "'/>";
}
strXML += "</graph>";
//// Line Graph
strRetrun = FusionCharts.RenderChart("../../Chart/ChartLine.swf", "", strXML, "Matrimonial_Sailes", "600", "300", false, false);
break;
case "5":
break;
}
strRetrun += "</td></tr></table>";
return(strRetrun);
}
