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();
        }
    }
예제 #2
0
    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
        //}
    }