public void InvoiceDetails(string strInvoice)
{
DataTable objDataTable = new DataTable();
tblSubOrder objSuborder = new tblSubOrder();
objDataTable = objSuborder.GetProductFullInfo(strInvoice);
if (objDataTable.Rows.Count > 0)
{
spanOrderId.InnerHtml = objDataTable.Rows[0][tblSubOrder.ColumnNames.AppSubOrderNo].ToString();
spanBillingName.InnerHtml = objDataTable.Rows[0][tblOrder.ColumnNames.AppBillReceiverName].ToString();
divBillingAddress.InnerHtml = "<b>Address : </b>" + objDataTable.Rows[0][tblOrder.ColumnNames.AppBillReceiverAddress].ToString();
divBillingMobile.InnerHtml = "<b>Mobile : </b>" + objDataTable.Rows[0][tblOrder.ColumnNames.AppBillReceiverContactNo1].ToString();
divBillingMobile1.InnerHtml = "<b>Mobile 2 : </b>" + objDataTable.Rows[0][tblOrder.ColumnNames.AppBillReceiverContactNo2].ToString();
divBillingEmail.InnerHtml = "<b>Email : </b>" + objDataTable.Rows[0][tblOrder.ColumnNames.AppBillRecevierEmail].ToString();
spanShippingName.InnerHtml = objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverName].ToString();
divShippingAddress.InnerHtml = "<b>Address : </b>" + objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverAddress].ToString();
divShippingMobile.InnerHtml = "<b>Mobile : </b>" + objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverContactNo1].ToString();
divShippingMobile1.InnerHtml = "<b>Mobile 2 : </b>" + objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverContactNo2].ToString();
divShippingEmail.InnerHtml = "<b>Email : </b>" + objDataTable.Rows[0][tblOrder.ColumnNames.AppRecevierEmail].ToString();
// spanGrandTotal.InnerHtml = objDataTable.Compute("sum(appTotal)", "").ToString();
ImgPhoto.Src = strServerURL + "admin/" + objDataTable.Rows[0][tblProductImage.ColumnNames.AppNormalImage].ToString();
spanProduct.InnerHtml = objDataTable.Rows[0][tblProduct.ColumnNames.AppProductName].ToString();
spanSku.InnerHtml = objDataTable.Rows[0][tblProductDetail.ColumnNames.AppSKUNo].ToString();
spancolor.InnerHtml = objDataTable.Rows[0][tblColor.ColumnNames.AppColorName].ToString();
divcolor.Style.Add("background-color", objDataTable.Rows[0][tblColor.ColumnNames.AppColorCode].ToString());
spanSize.InnerHtml = objDataTable.Rows[0][tblSize.ColumnNames.AppSize].ToString();
spanQty.InnerHtml = objDataTable.Rows[0][tblSubOrder.ColumnNames.AppQty].ToString();
spanPrice.InnerHtml = objDataTable.Rows[0][tblSubOrder.ColumnNames.AppSellingPrice].ToString();
spanTotal.InnerHtml = objDataTable.Rows[0]["appTotal"].ToString();
spanStatus.InnerHtml = objDataTable.Rows[0][tblOrderStatus.ColumnNames.AppOrderStatus].ToString();
spanPreferedTime.InnerHtml = objDataTable.Rows[0][tblOrder.ColumnNames.AppPreferedTime].ToString();
}
//dgvGridView.DataSource = objDataTable;
//dgvGridView.DataBind();
objSuborder = null;
objDataTable = null;
mpeProductinvoice.Show();
}