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