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(); } }
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 //} }