protected void CreateUser_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["lrbdConnectionString"].ConnectionString); connection.Open(); SqlCommand command = new SqlCommand("SELECT * FROM CustomerMaster WHERE username='******'", connection); SqlDataReader reader = command.ExecuteReader(); //while (reader.Read()) //{ if (reader.Read()) { ErrorMessage.Text = reader["username"].ToString() + " User already exist"; } else { Lrbd.BusinessEntity.CustomerBase objcu = new Lrbd.BusinessEntity.CustomerBase(); objcu.username = UserName.Text; objcu.password = Password.Text; objcu.name = Name.Text; objcu.email = Email.Text; objcu.phone = Phone.Text; Lrbd.Business.Customer objcustomer = new Lrbd.Business.Customer(); objcustomer.CreateCustomer(objcu); Response.Redirect("Login.aspx"); } //} connection.Close(); //ErrorMessage.Text = result.Errors.FirstOrDefault(); }
protected void Button1_Click(object sender, EventArgs e) { Lrbd.Business.Customer objcu = new Lrbd.Business.Customer(); Lrbd.BusinessEntity.CustomerBase objcust = new Lrbd.BusinessEntity.CustomerBase(); objcust.username = Username.Text; objcust.password = Password.Text; objcust.name = Name.Text; objcust.email = Email.Text; objcust.phone = Phone.Text; objcu.CreateCustomer(objcust); Response.Redirect("Customerlisting.aspx"); }