public bool Add(Cliente unC) { if (unC == null || !Cliente.Validar(unC)) { return(false); } SqlConnection cn = new Conexion().CrearConexion(); SqlCommand cmdCli = new SqlCommand(@"INSERT INTO Cliente VALUES ( @Ci, @Password, @Rol, @Nombre, @Celular, @Email, @FechaNacimiento)" , cn); cmdCli.Parameters.AddWithValue("@Ci", unC.Ci); cmdCli.Parameters.AddWithValue("@Password", unC.Password); cmdCli.Parameters.AddWithValue("@Rol", unC.Rol); cmdCli.Parameters.AddWithValue("@Nombre", unC.Nombre); cmdCli.Parameters.AddWithValue("@Celular", unC.Celular); cmdCli.Parameters.AddWithValue("@Email", unC.Email); cmdCli.Parameters.AddWithValue("@FechaNacimiento", unC.FechaNacimiento); SqlTransaction trn = null; try { if (new Conexion().AbrirConexion(cn)) { trn = cn.BeginTransaction(); cmdCli.Transaction = trn; int filas = cmdCli.ExecuteNonQuery(); } return(false); } catch (SqlException ex) { trn.Rollback(); return(false); } catch (Exception ex) { trn.Rollback(); return(false); } finally { new Conexion().CerrarConexion(cn); } }