protected void btn_ok_Click(object sender, EventArgs e)
{
User_Property_Tbl_Dealer u = new User_Property_Tbl_Dealer();
u.d_name = txt_dealer_name.Text;
u.d_email_address = txt_dealer_email.Text;
u.d_location = txt_dealer_location.Text;
u.d_contact = txt_contact_no.Text;
if (btn_ok.Text == "Add")
{
int i = Insert_Logic.Insert_Dealer(u);
clear();
if (i == 1)
{
lbl_msg.Text = "Successfully Inserted";
lbl_msg.ForeColor = System.Drawing.Color.Green;
}
else
{
lbl_msg.Text = "Duplicate Data";
lbl_msg.ForeColor = System.Drawing.Color.Red;
}
mpe.Show();
}
else
{
u.d_id = id;
int ii = Update_Logic.Update_Dealer(u);
if (ii == 1)
{
lbl_msg.Text = "Updated";
Response.Redirect("manage_dealer.aspx");
}
else
{
lbl_msg.Text = "Duplicate Data ...!!";
}
mpe.Show();
}
//if (i == 1)
// Response.Write("data successfully inserted");
//else
// Response.Write("data successfully not inserted");
}
public static int Insert_Dealer(User_Property_Tbl_Dealer up)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insert_tbl_dealer_sp";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Create_Parameter.Convert_String("@d_name", up.d_name));
cmd.Parameters.Add(Create_Parameter.Convert_String("@d_email_address", up.d_email_address));
cmd.Parameters.Add(Create_Parameter.Convert_String("@d_location", up.d_location));
cmd.Parameters.Add(Create_Parameter.Convert_String("@d_contact_no", up.d_contact));
return(Create_Command.Execute_Non_Query(cmd));
}