Hi,
I am using the ajax popup for inserting some details. When you click on a Save button on the web page, a window pops up (ajax Modal popup) and once you enter the fields in the popup and click submit button in the popup, all the fields in the webpage and the popup window should be inserted into a sql table. I wrote a sql stored stored procedure for this.
This is the way i did but the details are not being inserted into the SQL table.
public void InsertSearchDetails()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = (ConfigurationManager.AppSettings["Gulfcoast"]);
conn.Open();
SqlCommand cmd = new SqlCommand("SP_InsertInvestigationSearchDetails",conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rl_name", SqlDbType.NVarChar).Value = txtSearchName.Text.Trim();
cmd.Parameters.Add("@rl_description", SqlDbType.NVarChar).Value = txtDesc.Text.Trim();
cmd.Parameters.Add("@rl_criteria1", SqlDbType.NVarChar).Value = Criteria.Text.Trim();
if (Criteria1.Text != "")
{
cmd.Parameters.Add("@rl_criteria2", SqlDbType.NVarChar).Value = Criteria1.Text.Trim();
}
cmd.Parameters.Add("@rl_type", SqlDbType.NVarChar).Value = Type.SelectedValue.ToString();
cmd.Parameters.Add("@rl_reg", SqlDbType.NVarChar).Value = register.Text.Trim();
cmd.Parameters.Add("@rl_cashier", SqlDbType.NVarChar).Value = Cashier.SelectedValue.ToString();
cmd.Parameters.Add("rl_evenodd", SqlDbType.NVarChar).Value = AnyEven.SelectedValue.ToString();
cmd.Parameters.Add("rl_cat1", SqlDbType.NVarChar).Value = Category1.SelectedValue.ToString();
cmd.Parameters.Add("rl_cat2", SqlDbType.NVarChar).Value = Category2.SelectedValue.ToString();
cmd.Parameters.Add("rl_exp", SqlDbType.NVarChar).Value = Expressions.SelectedValue.ToString();
cmd.Parameters.Add("rl_value", SqlDbType.NVarChar).Value = Value.Text.Trim();
cmd.Parameters.Add("rl_value1", SqlDbType.NVarChar).Value = Value1.Text.Trim();
cmd.Parameters.Add("rl_exp1", SqlDbType.NVarChar).Value = CompareQnty.SelectedValue.ToString();
if (((QtyValue1.Visible == true) && (QtyValue1.Text == "")) || (QtyValue1.Visible == false))
{
cmd.Parameters.Add("rl_qty1", SqlDbType.Int).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("rl_qty1", SqlDbType.Int).Value = Convert.ToInt32(QtyValue1.Text.Trim());
}
if (((QtyValue2.Visible == true) && (QtyValue2.Text == "")) || (QtyValue2.Visible == false))
{
cmd.Parameters.Add("rl_qty2", SqlDbType.Int).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("rl_qty2", SqlDbType.Int).Value = Convert.ToInt32(QtyValue2.Text.Trim());
}
cmd.Parameters.Add("@rl_createdDate", DateTime.Now);
cmd.Parameters.Add("@rl_updatedDate", DateTime.Now);
cmd.ExecuteNonQuery();
}
Here is my stpored procedure:
USE [Gulfcoast]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SP_InsertInvestigationSearchDetails]
@rl_id uniqueidentifier,
@rl_name nvarchar(250),
@rl_description nvarchar(555),
@rl_criteria1 nvarchar(155),
@rl_criteria2 nvarchar(155),
@rl_reg nvarchar(5),
@rl_cashier nvarchar(50),
@rl_type nvarchar(50),
@rl_evenodd nvarchar(50),
@rl_quantity nvarchar(50),
@rl_cat1 nvarchar(50),
@rl_cat2 nvarchar(50),
@rl_exp nvarchar(10),
@rl_value nvarchar(50),
@rl_exp1 nvarchar(10),
@rl_value1 nvarchar(50),
@rl_qty1 int = 0,
@rl_qty2 int = 0,
@rl_rule_type nvarchar(100),
@rl_createdDate datetime,
@rl_updatedDate datetime
AS
BEGIN
Declare @ruleName nvarchar(250)
set @ruleName = replace(replace(replace(@rl_name,' ','<>'),'><',''),'<>',' ');
If NOT EXISTS (select * from ExceptionRuleDetail where rl_name = ltrim(rtrim(@ruleName)))
begin
Insert into ExceptionRuleDetail(rl_id, rl_name, rl_description, rl_rule_type, rl_register, rl_type,
rl_criteria1, rl_criteria2, rl_category1, rl_category2,rl_amount,rl_amount_comparison,rl_amount_dollar_value1,
rl_amount_dollar_value2,rl_quantity,rl_quantity_comparison,rl_quantity_dollar_value1,rl_quantity_dollar_value2,rl_createdDate,rl_updatedDate)
values (@rl_id, ltrim(rtrim(@ruleName)), @rl_description, @rl_rule_type,@rl_reg, @rl_type, @rl_criteria1,
@rl_criteria2,@rl_cat1,@rl_cat2,@rl_evenodd,@rl_exp,@rl_value,@rl_value1,@rl_quantity,@rl_exp1,@rl_qty1,@rl_qty2,@rl_createdDate,@rl_updatedDate)
return 0
end
else
begin
return 1
end
END
Can someone please help me out with this?