protected void Page_Load(object sender, EventArgs e) { if (this.IsPostBack == false) { LblCustomerAccountNo.Text = Session["CustomerId"].ToString(); LblOrderId.Text = Session["OrderId"].ToString(); LblEmailId.Text = Session["EmailId"].ToString(); LblTransactionId.Text = Session["TransactionId"].ToString(); } SqlConnection ObjConnection = new SqlConnection(Common.C_ConnectionString); ObjConnection.Open(); SqlCommand ObjCommand = new SqlCommand(); ObjCommand.Connection = ObjConnection; ObjCommand.CommandText = "OrderMasterDetails"; ObjCommand.CommandType = CommandType.StoredProcedure; ObjCommand.Parameters.AddWithValue("@OrderId", Convert.ToInt32(LblOrderId.Text)); SqlDataAdapter ObjDataAdapter = new SqlDataAdapter(ObjCommand); DataSet dsOrderMasterDetails = new DataSet(); ObjDataAdapter.Fill(dsOrderMasterDetails); if (dsOrderMasterDetails.Tables[0].Rows.Count > 0) { DataRow dr = dsOrderMasterDetails.Tables[0].Rows[0]; LblFirstname.Text = dr["Firstname"].ToString(); LblAddress.Text = dr["Address"].ToString(); LblCity.Text = dr["City"].ToString(); LblState.Text = dr["State"].ToString(); Phoneno = dr["Phoneno"].ToString(); Date = Convert.ToDateTime(dr["OrderDate"]); Lblmob.Text = Phoneno.ToString(); LblOrderDate.Text = Date.ToString(); Pincode = Convert.ToInt32(dr["Pincode"]); LblPincode.Text = Pincode.ToString(); LblPaymentType.Text = dr["PaymentOption"].ToString(); //Label TotalAmt = (Label)GvShopingList.FooterRow.FindControl("LblTotal"); // double data5 = Convert.ToDouble(TotalAmt.Text); Tot = Convert.ToDouble(dr["TotalAmt"]); LblTotalAmt.Text = Tot.ToString(); } DataSet dsOrderDetailbyOrderId = COrderMasterDetailServices.OrderMasterDetailListbyOrderId_Pro(Convert.ToInt32(LblOrderId.Text)); GvShopingList.DataSource = dsOrderDetailbyOrderId; GvShopingList.DataBind(); //Label Total = (Label)GvShopingList.FooterRow.FindControl("LblTotal"); //LblTotal.Text = (Total.Text); //double data5 = Convert.ToDouble(TotalAmt.Text); // LblTotal // SqlConnection Connection = new SqlConnection(Common.C_ConnectionString); //ObjConnection1.Open(); SqlCommand ObjCommand1 = new SqlCommand(); ObjCommand1.Connection = ObjConnection; ObjCommand1.CommandText = "CreditcardMasterDetails"; ObjCommand1.CommandType = CommandType.StoredProcedure; ObjCommand1.Parameters.AddWithValue("@TransactionId", Convert.ToInt32(LblTransactionId.Text)); SqlDataAdapter ObjDataAdapter1 = new SqlDataAdapter(ObjCommand1); DataSet dsCreditcardMasterDetails = new DataSet(); ObjDataAdapter1.Fill(dsCreditcardMasterDetails); if (dsCreditcardMasterDetails.Tables[0].Rows.Count > 0) { DataRow dr = dsCreditcardMasterDetails.Tables[0].Rows[0]; LblCard.Text = dr["Card"].ToString(); LblCardHolderName.Text = dr["CardHolderName"].ToString(); Date = Convert.ToDateTime(dr["PaymentDate"]); LblPaymentDate.Text = Date.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { //if (Request.QueryString["Oid"] == null || Request.QueryString["Oid"] = "") //{ // Response.Redirect("OrderMaster.aspx"); // return; //} TxtInvoiceDate.Text = System.DateTime.Now.ToString(); TxtFinaldeliveryDate.Text = System.DateTime.Now.AddDays(7).ToString(); //int intTrId= Convert.ToInt32(Request.QueryString["Tid"]); LblOrderId.Text = (Request.QueryString["Oid"]).ToString(); //LblTransactionId.Text = intTrId.ToString(); //if (ds.Tables[0].Rows.Count > 0) //{ // DataRow dr = ds.Tables[0].Rows[0]; // m_InvoiceId = Convert.ToInt32(dr["InvoiceId"]); DataSet ds = CInvoiceServices.InvoiceData(Convert.ToInt32(LblOrderId.Text)); if (ds.Tables[0].Rows.Count > 0) { ; } { //DataRow dr = dsInvoiceMasterDataDispaly.Tables[0].Rows[0]; // LblOrderId.Text = (dr["OrderId"]).ToString(); //LblOrderId.Text = dsInvoiceMasterDataDispaly.Tables[0].Rows[0]["OrderId"].ToString(); LblOrderId.Text = ds.Tables[0].Rows[0]["OrderId"].ToString(); LblOrderDate.Text = ds.Tables[0].Rows[0]["OrderDate"].ToString(); LblCustomerAccountNo.Text = ds.Tables[0].Rows[0]["CustomerId"].ToString(); LblEmailId.Text = ds.Tables[0].Rows[0]["EmailId"].ToString(); LblFirstname.Text = ds.Tables[0].Rows[0]["Firstname"].ToString(); LblAddress.Text = ds.Tables[0].Rows[0]["Shp_Address"].ToString(); LblCity.Text = ds.Tables[0].Rows[0]["Shp_City"].ToString(); LblPincode.Text = ds.Tables[0].Rows[0]["shp_pincode"].ToString(); LblState.Text = ds.Tables[0].Rows[0]["Shp_State"].ToString(); LblPhone.Text = ds.Tables[0].Rows[0]["shp_phoneno"].ToString(); LblTransactionId.Text = ds.Tables[0].Rows[0]["TransactionId"].ToString(); LblPaymentDate.Text = ds.Tables[0].Rows[0]["PaymentDate"].ToString(); LblCardHolderName.Text = ds.Tables[0].Rows[0]["CardHolderName"].ToString(); LblCard.Text = ds.Tables[0].Rows[0]["Card"].ToString(); LblTotalAmt.Text = ds.Tables[0].Rows[0]["Expr1"].ToString(); LblPaymentType.Text = ds.Tables[0].Rows[0]["PaymentOption"].ToString(); } ////// COrderMaster ObjOrderId = new COrderMaster(intOrderId); ////// if (ObjOrderId.IsExit == true) ////// { ////// } DataSet dsOrderDetailbyOrderId = COrderMasterDetailServices.OrderMasterDetailListbyOrderId_Pro(Convert.ToInt32(LblOrderId.Text)); GvShopingList.DataSource = dsOrderDetailbyOrderId; GvShopingList.DataBind(); ////// LblOrderId.Text = intOrderId.ToString(); ////// DataSet dsCreditcardMasterDetailsbyOrderId = CCreditcardServices.CreditcardMasterDetailsbyOrderId(Convert.ToInt32(LblOrderId.Text)); ////////// DataSet dsCreditcardMasterDetailsbyOrderId = CCreditcardServices.CreditcardMasterDetailsbyOrderId(Convert.ToInt32(LblOrderId.Text)); //CCreditcardServices ObjOderId1 = new CCreditcardMaster(Convert.ToInt32(LblOrderId.Text)); //if (ObjOrderId.IsExit == true) //{ // LblTransactionId.Text = ObjOrderId1.TransactionId.ToString(); // LblCardHolderName.Text = ObjOrderId1.Cardholdarname; //LblCard.Text = ObjOrderId; //LblPaymentType.Text = ObjTransactionId.expirydate; //LblPaymentDate.Text=Obj //} }