Exemplo n.º 1
0
    protected void ButOderDetail_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow gvRow in GvshoppingList.Rows)
        {
            //Label CartId = (Label)gvRow.FindControl("LblCartId");
            HiddenField CartId = (HiddenField)gvRow.FindControl("hidcartId");
            int         Cart1  = Convert.ToInt32(CartId.Value);

            HiddenField ProductId1 = (HiddenField)gvRow.FindControl("hidProductId");
            int         ProductId  = Convert.ToInt32(ProductId1.Value);

            HiddenField SizeId1 = (HiddenField)gvRow.FindControl("hidSizeId");
            int         SizeId  = Convert.ToInt32(SizeId1.Value);

            //Label Productname = (Label)gvRow.FindControl("LblProductId");
            //string data1 = (Productname.Text).ToString();
            //Label SizeDec = (Label)gvRow.FindControl("LblSize");

            //string data6 =(SizeDec.Text).ToString();
            Label  Qty          = (Label)gvRow.FindControl("LblQty");
            int    data2        = Convert.ToInt32(Qty.Text);
            Label  Price        = (Label)gvRow.FindControl("LblPrice");
            double data3        = Convert.ToDouble(Price.Text);
            Label  LineTotalAmt = (Label)gvRow.FindControl("LblTotal");
            double data4        = Convert.ToDouble(LineTotalAmt.Text);
            Label  TotalAmt     = (Label)GvshoppingList.FooterRow.FindControl("LblTotalAmt");
            double data5        = Convert.ToDouble(TotalAmt.Text);
            int    d1           = Convert.ToInt32(LblOrderId.Text);

            int intReturnValue = COrderMasterDetailServices.OrderMasterDetailInsert
                                     (Convert.ToInt32(d1),
                                     Convert.ToInt32(ProductId),
                                     Convert.ToInt32(SizeId),
                                     Convert.ToInt32(data2),
                                     Convert.ToDouble(data3),
                                     Convert.ToDouble(data4),
                                     Convert.ToDouble(data5));
            int intReturnValues     = CPurchseMasterServices.SellEnteryInsert(Convert.ToInt32(ProductId), Convert.ToInt32(data2), Convert.ToDouble(data3));
            int intReturnValuescart = CCartMasterrServices.CartDelete(Convert.ToInt32(Cart1));
            ButOder.Visible = false;
        }
        Response.Redirect("CreditcardMaster.aspx");
    }
    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();
        }
    }
Exemplo n.º 3
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
        //}
    }