HI
I have 2 table in database
1-Estate_free Table
2-Black_list Table
in Register.aspx users can insert their information and when click on insertButton it insert their data into Estate_free table
below is code
protected void insertButton_Click1(object sender, ImageClickEventArgs e)
{
SqlCommand _cmd = new SqlCommand("InsertFreeState1", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
_cmd.Parameters.AddWithValue("@Transfer", ddlTran.SelectedItem.Text);
_cmd.Parameters.AddWithValue("@Type", ddltype.SelectedItem.Text);
_cmd.Parameters.AddWithValue("@Name", txtname.Text);
_cmd.Parameters.AddWithValue("@Mobile", Txtmob.Text);
_cmd.Parameters.AddWithValue("@Tell", Txttell.Text);
_cmd.Parameters.AddWithValue("@id", Convert.ToInt32(ViewState["Id"]));
_cmd.Parameters.Add("@Result", SqlDbType.NVarChar, 120);
_cmd.Parameters["@Result"].Direction = ParameterDirection.Output;
object o = _cmd.ExecuteScalar();
int ID = (o != null && o != DBNull.Value) ? Convert.ToInt32(o) : 0;
if (ID > 0)
{
ViewState["Id"] = ID.ToString();
}
int result = Convert.ToInt32(_cmd.ExecuteScalar());
_cn.Close();
string resultMessage = _cmd.Parameters["@Result"].Value.ToString();
LBLERROR.Text = resultMessage;
}
SP
create procedure [dbo].[InsertFreeState2]
@Name nvarchar(40)
,@mobile varchar(20)
,@Tell varchar(15)
,@Transfer nvarchar(20)
,@Type nvarchar(20)
,@id int =0
,@Result NVARCHAR(120) OUTPUT
AS BEGIN
IF ((NOT EXISTS(SELECT id FROM Estate_free WHERE (Mobil = @Mobile or Tell=@Tell))) AND (NOT EXISTS(SELECT id FROM Black_List WHERE Mobile = @Mobile or Tell=@Tell)))
begin
IF EXISTS(SELECT id FROM Estate_free WHERE id = @id AND @id > 0 )
BEGIN
UPDATE Estate_free
SET
Name=@Name
,Mobil=@mobile
,Tell=@Tell
,Transfer=@Transfer
,Type=@Type
WHERE ID=@id
SELECT @id
SET @Result = 'you have been registered.'
END
ELSE
BEGIN
INSERT INTO Estate_free(Name,Mobil,Tell,Transfer,Type)
VALUES(@Name,@Mobile,@Tell,@Transfer,@Type)
SET @Result = 'you have been registered.'
END
END
ELSE
begin
SET @Result = 'you can just register 1 Time '
END
END
in above SP I define that if users tell or Mobile number was in Estate_free ro Black_list table it doesn't insert data into database and show 'You can just register 1 Time'
and if there wasn't their mobile or Tell in those table it insert their data into Estate_free table and show 'You have been registered'
problem is that when I enter data in database with new mobile number it didn't insert data in database and show 'you can just register 1 Time'
I mean it never insert data in database
what should i do?
Best Regards