Comments by JasonTsoum77 (Top 57 by date)

Hi OriginalGriff, Thnx for your response I try it but it didn't work ,I just found the problem which is in DateTime format, I try it with your query and I change time1 and time2 to
time1=Convert.ToString(TextBox1.Text); and time2= Convert.ToString(TextBox2.Text) and when I put 1-2-2014 and 2-2-2014 it works, but I want to retrieve the date from caledar thnx again

Hi Mike yes I see that something is going wrong , thnx to Maciej code I update my code and now it works prefect here it is
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand sqlCommand = new SqlCommand("UPDATE P1 SET P1.price = P2.price - (P2.price * 5/100) FROM Products AS P1 INNER JOIN Products AS P2 ON P1.Id = P2.Id WHERE DATEDIFF(m, P1.[date], GETDATE()) > 12 AND P1.var=1", conn);
conn.Open();
using (SqlDataReader read = sqlCommand.ExecuteReader())
{
while (read.Read())
{
string name = read["name"].ToString();


}
int var = 0;

read.Close();
conn.Close();
}

Thnx for your response

It worked!!!!!!!!!!!!!!!!!!!!!!!
many many many thnx my friend Maciej for your help!!!!!!!
I try to find a solution for these many days!!!
Thnx again my friend for your valuable help!

I must generate a new table?
or just I must import as a query the code this code?

thnx in for your help!!!!

Yes i have it like a flag , i set it to 0 when a discount happens, in order to avoid new discound if the page loads again

thnx for your help the problem was in (trims) from textbox i receinve a string without a trim
but from my sql table i receive a string with spaces for some reason that i don't know.

Thnx for your help again!!!!

thnx for your help i will modify my code as you show me

Thnx for your response and your help my friend, your solution is also
works!!!

Perfect it works!!!
thnx my friend for your help!!!

Thnx for your help

Thnx for your help, Now I will try it!

Great it works I have to change '<' compare to '>' because i want the old products but with your solution it works,
now the only think that i have is to add a discount for the products in column price.

Thnx again for your help my friend

I have read the documentation tried it but they didn't work in string price, I don't know where is the wrong because I tried with simple strings like
string s = "0123456";
s.remove(0,3);
e.t.c.
and they work properly, I thing that here because I retreiving html is something going wrong and these functions that you refer in your reply (trim,regax) they didn't work.

Anyway thnx for your response.

Thaks again for your help!

Hi Tadit, yes from the toolbox I add the labels but they didn't work I added protected global::System.Web.UI.WebControls.Label L1; because in .cs
I use "namespace FurSiteMs.PDT".

But Finally it worked I delete the whole form and I import every item step by step and once a time.
It is very stupid because the is exactly the same with the previous one (i compare it with beyond compare to see if there are any differences).
Anyway the problem solved with this anorthodox way.

Thnx for your time and your help!

Hi Tadit sorry for my late response I try it, I delete the current labels from aspx,cs and designer.cs and I create news like:
protected global::System.Web.UI.WebControls.Label L1;
but still nothing vs returns "L1 does not exist to the current context".
today I will try to delete the whole form and recreate it step by step to see where is the wrong.

Iam not very experince developer with vs and asp.net/c# but i see that vs has a little problem on handling namespaces...

I will late you know what will be happened.

Thnx for your help

Hi Sergey first of all thnx for your time and your response!

I know that my code is for a simple file and not for the whole folder i think i mention it at the beginning of my question.
I need somenthing like that in order to upload pictures for specific items in a website where i implement but I see from your post that is very difficult, i sarch in the internet but i didn't find anything to help me, so i decided to change strategy I will try to upload multiple files and create a folder(where the pictures will be upload it) at the same time on my site, I will let you now if this will be work.

Thanks again for your help

Hey! Tadit still nothing with my issue i clean my project i rebuid it but "label.text" still not recognised, in another project where i have similar issue it worked with clean and rebuild it. The final solution which i will try is to recreate the whole project

Ok I will try it and I will inform you
thnx for your help and your time Tadit

Oh i'm sorry here it is
StreamReader stIn = new StreamReader(req.GetResponse().GetResponseStream());
strResponse = stIn.ReadToEnd();
stIn.Close();

// sanity check
Label2.Text = strResponse;

// If response was SUCCESS, parse response string and output details
if (strResponse.StartsWith("SUCCESS"))
{
PDTHolder pdt = PDTHolder.Parse(strResponse);
Label1.Text = string.Format("Thank you {0} {1} [{2}] for your payment of {3} {4}!",
pdt.PayerFirstName, pdt.PayerLastName, pdt.PayerEmail, pdt.GrossTotal, pdt.Currency);
}
else
{
Label1.Text = "please retry";
}

Yes I'm using but I also try it without membership to see why it's not working but
is not working

<%@Page Language="C#" AutoEventWireup="true" CodeBehind="PDTSuccess.aspx.cs" Inherits="FurSiteMs.PDT.PDTSuccess" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
Thanks for choosing our products , we will be huppy to visit one of our shops! <br />
<asp:Label ID="Label1" runat="server" Text="Label">

<br /><br />

PDT Response<br />
<asp:Label ID="Label2" runat="server" Text="Label">
</div>
</form>
</body>
</html>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace FurSiteMs.PDT
{
public partial class PDTSuccess
{

///

/// form1 control.
///

/// <remarks>
/// Auto-generated field.
/// To modify move field declaration from designer file to code-behind file.
///
protected global::System.Web.UI.HtmlControls.HtmlForm form1;

///

/// Label1 control.
///

/// <remarks>
/// Auto-generated field.
/// To modify move field declaration from designer file to code-behind file.
///
protected global::System.Web.UI.WebControls.Label Label1;

///

/// Label2 control.
///

/// <remarks>
/// Auto-generated field.
/// To modify move field declaration from designer file to code-behind file.
///
protected global::System.Web.UI.WebControls.Label Label2;
}
}

Hi Tradit I tried it but still nothing (in the designer.cs it already have it)
I delete it and I create it again but still nothing.

Hi I don'y know if i'm doing something wrong but i can't find the option with right click on aspx file convert to web application . I'm using Visual studio 2012 so i thing there is the problem.
Any idea how can i do this in vs2012

Hi I don'y know if i'm doing something wrong but i can't find the option with right click on aspx file convert to web application . I'm using Visual studio 2012 so i thing there is the problem.
Any idea how can i do this in vs2012

It works properly now thnx for your help and your response

Thnx for your response and your help ..it's really annoying-brute force the language localization in asp web site i thought it will be easier but....

thnx for your response and your help it worked

It worked thnx for your resonse and your help,
I will try the second solution you gave me in order to avoid sql injection
thnx

Exactly.

I remove ToUpper() but still nothing
it seems that it makes a refresh but still remains in login page without redirect to admin.aspx

I have try with many senarions like
1)
<allow users="Admin">
<deny users="?">
2)
<deny users="?">
3)
<allow users="Administrator">
<deny users="*">

and many many others but it didn't worked I don't know what else i should try.

How i should modify the web.config?

Yes I have set,

thnx for your response

Yes, alternative is any way to handle this html controls behind with c# code
I mean is any way to set value="product1" and value="100" with c# code?
(These are html controls)

Thnx for your response

It worked thank you very much for your help and your response!!! Azee

It worked!!! Thank you very much for your help

Hi Azee thank you for your response and your help
I remove (while loop) but now it didn't send nothing!
what else i shooul try?

thank you again for your help!

it workded!!!! Thank you for your help

well i try it but i receive null reference exception
here is my whole code

----------------------------------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Net.Mail;
using System.Net;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;


public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Btn_SendMail_Click(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
string asql = "SELECT quantity from products";
int val = Convert.ToInt32(Request.QueryString["quantity"]);
try
{
con.Open();
SqlCommand query = new SqlCommand(asql, con);

foreach (ListViewDataItem item in ListView1.Items)
{
int quantity = Convert.ToInt32(ListView1.DataKeys[item.DisplayIndex]["quantity"].ToString());
if (quantity < 5)
{
MailMessage mailObj = new MailMessage(
"from", "to", "Product low quantity", "your product has low quantity");

SmtpClient SMTPServer = new SmtpClient("localhost");
try
{
SMTPServer.UseDefaultCredentials = false;
SMTPServer.Host = "smtp.gmail.com";
SMTPServer.Port = 587;
SMTPServer.Credentials = new NetworkCredential("email", "password");
SMTPServer.EnableSsl = true;
SMTPServer.Send(mailObj);
}
catch (Exception ex)
{
// Label1.Text = ex.ToString();
}



}
}

}
finally
{
con.Close();
}//end of reduce quantity
}

}
----------------------------------------------------

yes but how can i retrieve it to c# from asp

yes

i try but it is very confusing
how can i parse my data frpm my shopping cart (id,name,price) to paypal checkout

i try but it is very confusing
how can i parse my data frpm my shopping cart (id,name,price) to paypal checkout

yes i have tried because i suspend something like that but all the variables had the correct values.
I tried the following solution from Karn Singh and that solved the problem.
It was very strange problem because when i tried it seperetally my code worked properly.

Thnx for your response

It works!!!! thank you very much Karn for your help and your response!!!

well here is the whole project i have a shopping cart (cart.aspx) where i collect the products for selling when the customer push the button finish i redirect to another form (finish.aspx) where the customer choose the pay method and the (product quantity must be reduced).
My problem is I import the code that i post in finish.aspx and for some reason the product quantity reduces two times , for example if the customer select quantity 2 in my database it reduces quantity 4.
It is very strange problem and i haven't see anything else like this...thnx for your resoinse

for example in infoproducts.aspx
when i prees the button next then :
Response.Redirect("finish.aspx?ID=" + Request.QueryString["Id"] + "&quant=" + Request.QueryString["quant"]);

No i'm retrievig it from another form (inforproduct.aspx) where the page send
"id" and "quantity" from the product.
i try debug mode with brakes and quantity has the correct value, but always reduses x2
thnx! for your response

Thank you for your help

Thank you for your help